Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012573Openbravo ERPA. Platformpublic2010-03-05 11:412010-03-12 22:41
networkb 
alostale 
immediatecriticalalways
closedfixed 
5
2.50MP12 
2.50MP142.50MP13 
Core
No
0012573: The release 2.50mp12 can not be installed on a oracle 10g
The release 2.50mp12 can not be installed on a oracle 10g
wich is a supported database.
http://wiki.openbravo.com/wiki/ERP/2.50/Openbravo_environment_installation#Oracle_database [^]
Install the application on a oracle 10g database
You get the following error:

  [java] 1980 [main] INFO org.openbravo.wad.Wad - Updating table identifiers
     [java] 3927 [main] INFO org.openbravo.wad.Wad - Re-generating audit trail infrastructure
     [java] 3932 [main] ERROR org.openbravo.wad.WadData - SQL error in query: CALL AD_Create_Audit_Triggers(null)Exception:java.sql.SQLException: ORA-06575: La función o el paquete AD_CREATE_AUDIT_TRIGGERS tienen en un estado no válido
     [java]
     [java] Exception in thread "main" java.lang.Exception: javax.servlet.ServletException: @CODE=6575@ORA-06575: La función o el paquete AD_CREATE_AUDIT_TRIGGERS tienen en un estado no válido
     [java]
     [java] at org.openbravo.wad.Wad.main(Wad.java:428)
     [java] Caused by: javax.servlet.ServletException: @CODE=6575@ORA-06575: La función o el paquete AD_CREATE_AUDIT_TRIGGERS tienen en un estado no válido
     [java]
     [java] at org.openbravo.wad.WadData.updateAuditTrail(WadData.java:836)
     [java] at org.openbravo.wad.Wad.main(Wad.java:374)

BUILD FAILED
/home/openbravo/Apps/open250mp12ora/build.xml:333: The following error occurred while executing this line:
/home/openbravo/Apps/open250mp12ora/src/build.xml:393: Java returned: 1
Change the type of the code variable on the procedure
AD_CREATE_AUDIT_TRIGGERS
that actually is CLOB.
this procedure is not compiled on the oracle 10g database

No tags attached.
Issue History
2010-03-05 11:41egoitzNew Issue
2010-03-05 11:41egoitzAssigned To => alostale
2010-03-05 11:45networkbReporteregoitz => networkb
2010-03-05 15:41alostaleSeveritymajor => critical
2010-03-05 15:41alostaleReproducibilityhave not tried => always
2010-03-05 15:42alostaleNote Added: 0025086
2010-03-05 16:11hgbotCheckin
2010-03-05 16:11hgbotNote Added: 0025088
2010-03-05 16:11hgbotStatusnew => resolved
2010-03-05 16:11hgbotResolutionopen => fixed
2010-03-05 16:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b449a41b19229f6bbf8f40c52a1c3adc61ea2e9e [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-11 10:29jpabloaeFixed in Version => 2.50MP13
2010-03-11 10:32jpabloaeStatusresolved => closed
2010-03-12 00:00anonymoussf_bug_id0 => 2969006
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025399

Notes
(0025086)
alostale   
2010-03-05 15:42   
Error(211,1): PL/SQL: Statement ignored
Error(211,18): PLS-00382: el tipo de la expresión no es correcto

is the error that appears when compiling the procedure.

The problem is that Oracle 10g does not support "execute immediate clob" (but Oracle 11g does).
(0025088)
hgbot   
2010-03-05 16:11   
Repository: erp/devel/pi
Changeset: b449a41b19229f6bbf8f40c52a1c3adc61ea2e9e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Mar 05 16:14:51 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b449a41b19229f6bbf8f40c52a1c3adc61ea2e9e [^]

fixed bug 12573: The release 2.50mp12 cannot be installed on a oracle 10g

---
M src-db/database/model/postscript-Oracle.sql
---
(0025399)
hudsonbot   
2010-03-12 22:41   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/b449a41b1922 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]