Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012573Openbravo ERPA. Platformpublic2010-03-05 11:412010-03-12 22:41
Reporternetworkb 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP12 
Target Version2.50MP14Fixed in Version2.50MP13 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012573: The release 2.50mp12 can not be installed on a oracle 10g
DescriptionThe 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 [^]
Steps To ReproduceInstall 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
Proposed SolutionChange 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

Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-05 11:41egoitzNew Issue
2010-03-05 11:41egoitzAssigned To => alostale
2010-03-05 11:41egoitzOBNetwork customer => Yes
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 [^]