Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005825Openbravo ERPY. DBSourceManagerpublic2008-11-05 09:302009-04-22 00:00
marvintm 
marvintm 
highmajorrandom
closedfixed 
5
 
 
Core
No
0005825: Update.database sometimes gives an error: function temp_findinarray(integer[], integer) does not exist
When an update.database is done in PostgreSQL, sometimes the following error appears:

/home/elopio/openbravo/source/branches/modularity/build.xml:441: The following error occurred while executing this line: /home/elopio/openbravo/source/branches/modularity/build.xml:351: The following error occurred while executing this line: /home/elopio/openbravo/source/branches/modularity/src-db/database/build.xml:247: org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist

The cause for this error is that an incorrect version of the PostgreSQL driver is being used.
Update.database in PostgreSQL.
We will remove the incorrect .jar file from the branch so that this doesn't happen again.
dbsm_migrate
Issue History
2008-11-05 09:30marvintmNew Issue
2008-11-05 10:03svnbotCheckin
2008-11-05 10:03svnbotNote Added: 0009985
2008-11-05 10:03svnbotStatusnew => resolved
2008-11-05 10:03svnbotResolutionopen => fixed
2008-11-05 10:03svnbotsvn_revision => 9674
2008-11-28 12:54jpabloaeAssigned To => marvintm
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-04-21 11:07psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777909

Notes
(0009985)
svnbot   
2008-11-05 10:03   
Repository: openbravo
Revision: 9674
Author: marvintm
Date: 2008-11-05 10:03:51 +0100 (Wed, 05 Nov 2008)

Fixed issue 5825. Now the correct version of the PostgreSQL driver should always be used.

---
D branches/modularity/lib/runtime/jdbc3-postgresql.jar
A branches/modularity/lib/runtime/postgresql-jdbc3-8.2.jar
U branches/modularity/src-trl/.classpath
U branches/modularity/src-wad/.classpath
---

https://dev.openbravo.com/websvn/openbravo/?rev=9674&sc=1 [^]