Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0006390
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformcriticalalways2008-12-06 12:142009-04-21 11:06
ReporterjpabloaeView Statuspublic 
Assigned Topheenan 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision11026
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version1.6.0_07
OS VersionGentoo - 2.6.24Database version10.2.0.4Ant version1.7.0
Product VersionpiSCM revision11017 
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
Summary

0006390: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0006211 closedpheenan If you fill a field with the maximum length permited and one of the character is special it fails when saving 

-  Notes
(0011018)
jpabloae (viewer)
2008-12-07 08:38

 This affects also r2.3x and r2.40.
(0011019)
jpabloae (viewer)
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 (viewer)
2008-12-07 19:32

 Phil,
please address this as soon as possible.
Paolo
(0011023)
pheenan (viewer)
2008-12-08 11:26

 Updated M_PRODUCT_CUSTOMER.UPC to nvarchar to match M_PRODUCT.UPC

- Issue History
Date Modified Username Field Change
2008-12-06 12:14 jpabloae New Issue
2008-12-06 12:14 jpabloae Assigned To => rafaroda
2008-12-06 12:14 jpabloae sf_bug_id 0 => 2395157
2008-12-06 12:14 jpabloae OBNetwork customer => No
2008-12-06 12:14 jpabloae Regression testing => No
2008-12-07 08:38 jpabloae Note Added: 0011018
2008-12-07 09:34 jpabloae Relationship added related to 0006211
2008-12-07 09:35 jpabloae Note Added: 0011019
2008-12-07 19:32 pjuvara Assigned To rafaroda => pheenan
2008-12-07 19:32 pjuvara Note Added: 0011020
2008-12-07 19:33 pjuvara Priority immediate => urgent
2008-12-08 11:25 pheenan Status new => scheduled
2008-12-08 11:25 pheenan fix_in_branch => trunk
2008-12-08 11:26 pheenan Status scheduled => resolved
2008-12-08 11:26 pheenan Fixed in Version => trunk
2008-12-08 11:26 pheenan svn_revision => 11026
2008-12-08 11:26 pheenan Resolution open => fixed
2008-12-08 11:26 pheenan Note Added: 0011023
2009-04-21 11:06 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker