Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009332Openbravo ERPY. DBSourceManagerpublic2009-06-04 10:192009-07-18 00:00
networkb 
marvintm 
immediatemajoralways
closedfixed 
5
2.40MP3 
main 
Core
No
0009332: DBSourceManager doesn't import the sequences
DBSourceManager export the sequences correctly but it can't create them because it doesn't have permission to do it.
1.- ant export.database (a database whith sequences)

2.- drop user bbdd.user cascade;

3.- ant create.database
Give permission to the bbdd.user

File: $OPENBRAVO_HOME/src-db/database/build.xml

Line 279

Add: grant create sequence to ${bbdd.user};

No tags attached.
Issue History
2009-06-04 10:19rafademiguelNew Issue
2009-06-04 10:19rafademiguelAssigned To => marvintm
2009-06-04 10:21networkbAssigned Tomarvintm => rafaroda
2009-06-04 10:21networkbPrioritynormal => immediate
2009-06-04 10:22networkbAssigned Torafaroda => networkb
2009-06-04 10:26networkbIssue Monitored: networkb
2009-06-04 10:40networkbReporterrafademiguel => networkb
2009-06-04 10:40networkbAssigned Tonetworkb => rafaroda
2009-06-04 11:27rafarodaNote Added: 0016941
2009-06-04 11:27rafarodaAssigned Torafaroda => marvintm
2009-06-04 11:30hgbotCheckin
2009-06-04 11:30hgbotNote Added: 0016942
2009-06-04 11:30hgbotStatusnew => resolved
2009-06-04 11:30hgbotResolutionopen => fixed
2009-06-04 11:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b814d9f2bdc0c70a3ac83133748b1485c3a1a0eb [^]
2009-06-22 11:09psarobeFixed in Version => main
2009-07-17 13:48plujanStatusresolved => closed
2009-07-18 00:00anonymoussf_bug_id0 => 2823342

Notes
(0016941)
rafaroda   
2009-06-04 11:27   
Antonio,

Could you please determine whether we should use sequences in Openbravo database and if DBSourceManager supports their management?

Thanks.
(0016942)
hgbot   
2009-06-04 11:30   
Repository: erp/devel/pi
Changeset: b814d9f2bdc0c70a3ac83133748b1485c3a1a0eb
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Jun 04 11:30:37 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b814d9f2bdc0c70a3ac83133748b1485c3a1a0eb [^]

Fixed issue 9332.

---
M src-db/database/build-create.xml
---