Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002414Openbravo ERPA. Platformpublic2007-12-27 11:392008-08-13 18:19
Reporterrafaroda 
Assigned Tojpabloae 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002414: '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.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-12 10:03jpabloaeProjectOpenbravo ERP => @5@
2008-06-12 11:57jpabloaeProject@5@ => Openbravo ERP
2008-08-13 18:19plujanStatusresolved => closed

Notes
(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 [^]
(0002865)
rafaroda   
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   
2008-02-22 16:35   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1603191
Originator: NO

Fixed in trunk, r2508.