Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009332
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2009-06-04 10:192009-07-18 00:00
ReporternetworkbView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Versionmain
StatusclosedFix in branchFixed in SCM revisionb814d9f2bdc0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version1.5.0_15
OS VersionDatabase version10g Release 10.2.0.1.0Ant version1.7.0
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009332: DBSourceManager doesn't import the sequences

DescriptionDBSourceManager export the sequences correctly but it can't create them because it doesn't have permission to do it.
Steps To Reproduce1.- ant export.database (a database whith sequences)

2.- drop user bbdd.user cascade;

3.- ant create.database
Proposed SolutionGive permission to the bbdd.user

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

Line 279

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

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0016941)
rafaroda (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-06-04 10:19 rafademiguel New Issue
2009-06-04 10:19 rafademiguel Assigned To => marvintm
2009-06-04 10:21 networkb Assigned To marvintm => rafaroda
2009-06-04 10:21 networkb Priority normal => immediate
2009-06-04 10:22 networkb Assigned To rafaroda => networkb
2009-06-04 10:26 networkb Issue Monitored: networkb
2009-06-04 10:40 networkb Reporter rafademiguel => networkb
2009-06-04 10:40 networkb Assigned To networkb => rafaroda
2009-06-04 11:27 rafaroda Note Added: 0016941
2009-06-04 11:27 rafaroda Assigned To rafaroda => marvintm
2009-06-04 11:30 hgbot Checkin
2009-06-04 11:30 hgbot Note Added: 0016942
2009-06-04 11:30 hgbot Status new => resolved
2009-06-04 11:30 hgbot Resolution open => fixed
2009-06-04 11:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b814d9f2bdc0c70a3ac83133748b1485c3a1a0eb [^]
2009-06-22 11:09 psarobe Fixed in Version => main
2009-07-17 13:48 plujan Status resolved => closed
2009-07-18 00:00 anonymous sf_bug_id 0 => 2823342


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker