Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002414 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2007-12-27 11:39 | 2008-08-13 18:19 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | jpabloae | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40alpha-r2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002414: 'development.environment.id' leads to errors | |||||||
| Description | *Environment OS: Unbuntu 7.04 DB: Oracle XE 10g OB: Trunk source code revision 1875 Web browser: Firefox 2 *Steps 1. Launch 'create.database' Ant task. In 'database.postcreate.ORACLE' target: [sql] Executing commands [sql] Failed to execute: INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, SUPPORTUNITS, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_LEVEL, TAD_PARENT_VERSION, TAD_TRANSACTIONALRANGE, TAD_THEME) VALUES (0, 0, 0, 'Y', NOW(), 0, NOW(), 0, '?', 0, 20, 100, ${development.environment.id}, 'dev', 1, 'Default') [sql] java.sql.SQLException: Non supported SQL92 token at position: 310: development [sql] 3 of 4 SQL statements executed successfully Consequence: it is impossible to login. 'development.environment.id' that substituted 'developer.id' in revision 1855584 seems to be not properly taken while inserting data in AD_SYSTEM table. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0002865) rafaroda (viewer) 2008-01-02 15:46 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1892190 Originator: YES Correction: 'INSERT INTO AD_SYSTEM' SQL sentence works well. The problem is that 'Developer ID' typed in new setup wizards is not copied to the value of 'development.environment.id' variable inside 'Openbravo.properties' file. Furthermore, 'Developer ID' should be changed by 'Development environment ID'. Consequences: 1. Inside 'Openbravo.properties' file variable development.environment.id=1 and should be equal to your development environment ID. 2. Execute: SELECT CURRENTNEXTSYS FROM AD_SEQUENCE WHERE NAME='AD_Column'; Result is 100.000 and not your development environment ID multiplied by 100.000. |
|
(0002866) jpabloae (viewer) 2008-02-22 16:35 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1603191 Originator: NO Fixed in trunk, r2508. |
|
(0006003) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1858866 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-06-12 10:03 | jpabloae | Project | Openbravo ERP => @5@ |
| 2008-06-12 11:57 | jpabloae | Project | @5@ => Openbravo ERP |
| 2008-08-13 18:19 | plujan | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |