Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004738Openbravo ERP08. Project and service managementpublic2008-08-28 11:292008-11-25 23:38
Reporteriperdomo 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.23-gentoo-r9
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004738: Problem compiling ExpenseSOrder_data.xsql afer uuid merge due to_number() function
DescriptionTrying to compile the application you'll get error due to to_number function calls.

 [java] 16916 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql processed
     [java] 16922 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java]
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
     [java] SELECT BOM_PriceStd(p.M_Product_ID,pv.M_PriceList_Version_ID) AS PriceStd,
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
     [java] BOM_PriceList(p.M_Product_ID,pv.M_PriceList_Version_ID) AS PriceList,
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
     [java] BOM_PriceLimit(p.M_Product_ID,pv.M_PriceList_Version_ID) AS PriceLimit,
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
     [java] p.C_UOM_ID,pv.ValidFrom
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
     [java] FROM M_Product p, M_ProductPrice pp, M_Pricelist pl, M_PriceList_Version pv
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
     [java] WHERE p.M_Product_ID=pp.M_Product_ID
     [java] at org.openbravo.data.Sqlc.query(Unknown Source)
     [java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
     [java] AND pp.M_PriceList_Version_ID=pv.M_PriceList_Version_ID
     [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
     [java] AND pv.M_PriceList_ID=pl.M_PriceList_ID
     [java] AND pv.IsActive='Y'
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
     [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
     [java] AND p.M_Product_ID = TO_NUMBER(?)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] AND pl.M_PriceList_ID = TO_NUMBER(?)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] AND pl.C_Currency_ID = TO_NUMBER(?)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.main(Unknown Source)
     [java] ORDER BY pv.ValidFrom DESC
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java] 16930 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT C_Currency_ID
     [java] FROM M_PriceList
     [java] WHERE M_PriceList_ID = TO_NUMBER(?)
     [java] Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java] org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
     [java] at org.openbravo.data.Sqlc.query(Unknown Source)
     [java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
     [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.main(Unknown Source)
     [java] 16934 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] select c_currency_convert(TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),null, TO_NUMBER(?),TO_NUMBER(?)) from dual
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: function c_currency_convert(numeric, numeric, numeric, timestamp without time zone, unknown, numeric, numeric) does not exist
     [java] org.postgresql.util.PSQLException: ERROR: function c_currency_convert(numeric, numeric, numeric, timestamp without time zone, unknown, numeric, numeric) does not exist
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
     [java] at org.openbravo.data.Sqlc.query(Unknown Source)
     [java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
     [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.main(Unknown Source)
Steps To Reproduce
Proposed SolutionRemove to_number() call for column ids
Additional Information
TagsUUID project
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-28 11:29iperdomoNew Issue
2008-08-28 11:29iperdomoAssigned To => cromero
2008-08-28 11:29iperdomosf_bug_id0 => 2080259
2008-08-28 11:29iperdomoRegression testing => No
2008-08-28 11:30iperdomoTag Attached: UUID project
2008-08-28 11:41iperdomoStatusnew => scheduled
2008-08-28 11:41iperdomoAssigned Tocromero => shuehner
2008-08-28 11:41iperdomofix_in_branch => trunk
2008-08-28 12:39svnbotCheckin
2008-08-28 12:39svnbotNote Added: 0008774
2008-08-28 12:39svnbotStatusscheduled => resolved
2008-08-28 12:39svnbotResolutionopen => fixed
2008-08-28 12:39svnbotsvn_revision => 6621
2008-11-25 23:38psarobeStatusresolved => closed

Notes
(0008774)
svnbot   
2008-08-28 12:39   
Repository: openbravo
Revision: 6621
Author: huehner
Date: 2008-08-28 12:39:19 +0200 (Thu, 28 Aug 2008)

Fixed issue 4738
Remove some TO_NUMBER calls where the new datatype is now VARCHAR2(32) and not
NUMBER anymore

---
U branches/r2.5x/src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Amount_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Product_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/ad_callouts/SL_Project_PriceList_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/ad_forms/DocOrder_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice_data.xsql
U branches/r2.5x/src/org/openbravo/erpCommon/utility/Alert_data.xsql
---

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