Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006390Openbravo ERPA. Platformpublic2008-12-06 12:142009-04-21 11:06
Reporterjpabloae 
Assigned Topheenan 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionGentoo - 2.6.24
Product Versionpi 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006390: Rpt_Etiquetas_data.xsql does not compile
Description     [java] 7642 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/Rpt_Etiquetas_data.xsql processed
     [java] 7704 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] SELECT M_PRODUCT.M_PRODUCT_ID AS ID, COALESCE(M_PRODUCT_CUSTOMER.NAME, M_PRODUCT.NAME) AS NAME,
     [java] COALESCE(M_PRODUCT_CUSTOMER.DESCRIPTION, M_PRODUCT.DESCRIPTION) AS DESCRIPTION, COALESCE(M_PRODUCT_CUSTOMER.UPC, M_PRODUCT.UPC) AS UPC,
     [java] '' AS LOT, '' AS GUARANTEEDATE
     [java] FROM M_PRODUCT LEFT JOIN M_PRODUCT_CUSTOMER on M_PRODUCT.M_PRODUCT_ID = M_PRODUCT_CUSTOMER.M_PRODUCT_ID AND M_PRODUCT_CUSTOMER.C_BPARTNER_ID = ?
     [java] WHERE M_PRODUCT.M_PRODUCT_ID = ?
     [java]
     [java] Exception:java.sql.SQLException: ORA-12704: character set mismatch
     [java]
     [java] java.sql.SQLException: ORA-12704: character set mismatch
     [java]
     [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
     [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
     [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
     [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
     [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
     [java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
     [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
     [java] at org.openbravo.data.Sqlc.query(Sqlc.java:646)
     [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:513)
     [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)
Steps To Reproduce1. checkout trunk r11017.
2. configure using the setup-tool.
3. run install.source.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0006211 closed pheenan If you fill a field with the maximum length permited and one of the character is special it fails when saving 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-06 12:14jpabloaeNew Issue
2008-12-06 12:14jpabloaeAssigned To => rafaroda
2008-12-06 12:14jpabloaesf_bug_id0 => 2395157
2008-12-06 12:14jpabloaeOBNetwork customer => No
2008-12-06 12:14jpabloaeRegression testing => No
2008-12-07 08:38jpabloaeNote Added: 0011018
2008-12-07 09:34jpabloaeRelationship addedrelated to 0006211
2008-12-07 09:35jpabloaeNote Added: 0011019
2008-12-07 19:32pjuvaraAssigned Torafaroda => pheenan
2008-12-07 19:32pjuvaraNote Added: 0011020
2008-12-07 19:33pjuvaraPriorityimmediate => urgent
2008-12-08 11:25pheenanStatusnew => scheduled
2008-12-08 11:25pheenanfix_in_branch => trunk
2008-12-08 11:26pheenanStatusscheduled => resolved
2008-12-08 11:26pheenanFixed in Version => trunk
2008-12-08 11:26pheenansvn_revision => 11026
2008-12-08 11:26pheenanResolutionopen => fixed
2008-12-08 11:26pheenanNote Added: 0011023
2009-04-21 11:06psarobeStatusresolved => closed

Notes
(0011018)
jpabloae   
2008-12-07 08:38   
This affects also r2.3x and r2.40.
(0011019)
jpabloae   
2008-12-07 09:35   
Suggested fix:

Index: src-db/database/model/tables/M_PRODUCT_CUSTOMER.xml
===================================================================
--- src-db/database/model/tables/M_PRODUCT_CUSTOMER.xml (revision 11019)
+++ src-db/database/model/tables/M_PRODUCT_CUSTOMER.xml (working copy)
@@ -41,7 +41,7 @@
         <default/>
         <onCreateDefault/>
       </column>
- <column name="UPC" primaryKey="false" required="false" type="VARCHAR" size="30" autoIncrement="false">
+ <column name="UPC" primaryKey="false" required="false" type="NVARCHAR" size="30" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
(0011020)
pjuvara   
2008-12-07 19:32   
Phil,
please address this as soon as possible.
Paolo
(0011023)
pheenan   
2008-12-08 11:26   
Updated M_PRODUCT_CUSTOMER.UPC to nvarchar to match M_PRODUCT.UPC