Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017879Openbravo ERPA. Platformpublic2011-07-04 23:062011-07-14 12:55
elopio 
alostale 
immediatecriticalalways
closedfixed 
5
pi 
3.0MP1 
Core
No
0017879: Error while activating the instance
I get an error while performing the online instance activation.

For postgresql the error is: org.hibernate.exception.GenericJDBCException: could not execute query
For oracle the error is: could not execute update query
Go to General Setup > Application > Instance activation
Click the Activate Online button.
Enter the system key, and click the Activate instance button.
Automated
related to defect 00177413.0MP1 closed jecharri Production fields are not shown in Product window when activating instance 
png oracle.png (18,790) 2011-07-04 23:06
https://issues.openbravo.com/file_download.php?file_id=4278&type=bug
png

png postgresql.png (31,937) 2011-07-04 23:06
https://issues.openbravo.com/file_download.php?file_id=4279&type=bug
png
Issue History
2011-07-04 23:06elopioNew Issue
2011-07-04 23:06elopioAssigned To => alostale
2011-07-04 23:06elopioFile Added: oracle.png
2011-07-04 23:06elopioModules => Core
2011-07-04 23:06elopioFile Added: postgresql.png
2011-07-04 23:06elopioTag Attached: Automated
2011-07-05 08:31alostaleRelationship addedrelated to 0017741
2011-07-05 08:33alostaleNote Added: 0038754
2011-07-05 09:18hgbotCheckin
2011-07-05 09:18hgbotNote Added: 0038757
2011-07-05 09:18hgbotStatusnew => resolved
2011-07-05 09:18hgbotResolutionopen => fixed
2011-07-05 09:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/325becdccad4b67778655f3d07b9f09b779c17e5 [^]
2011-07-06 02:43hudsonbotCheckin
2011-07-06 02:43hudsonbotNote Added: 0038879
2011-07-14 12:55psarobeStatusresolved => closed
2011-07-14 12:55psarobeFixed in Version => 3.0MP1

Notes
(0038754)
alostale   
2011-07-05 08:33   
Problem introduced by 0017741

When activating/deactivating the instance, the preference for showing/hiding production fields is changed.

The problem is this preference is distributed as part of core and not as instance data, so if core is not in development or there is not an active template an error is raised.

Here is the log:

20f4cad7 2011-07-05 06:25:49,849 [ajp-8009-2] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-20000: @20532@
ORA-06512: at "INT_FULL_ORACLE.AD_PREFERENCE_MOD_TRG", line 78
ORA-04088: error during execution of trigger 'INT_FULL_ORACLE.AD_PREFERENCE_MOD_TRG'

20f4cad7 2011-07-05 06:25:49,851 [ajp-8009-2] ERROR org.openbravo.erpCommon.ad_forms.InstanceManagement - Error Activating instance
org.hibernate.QueryTimeoutException: could not execute update query
(0038757)
hgbot   
2011-07-05 09:18   
Repository: erp/devel/pi
Changeset: 325becdccad4b67778655f3d07b9f09b779c17e5
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jul 05 09:18:16 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/325becdccad4b67778655f3d07b9f09b779c17e5 [^]

fixed bug 17879: Error while activating the instance

  Removed preference defined in core for hidding/showing production fields.
  This preference is now set as part of instance configuration.

---
M src-db/database/sourcedata/AD_PREFERENCE.xml
M src/org/openbravo/erpCommon/obps/ActiveInstanceProcess.java
---
(0038879)
hudsonbot   
2011-07-06 02:43   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f1c481b1a146 [^]

Maturity status: Test