Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000176Openbravo ERP02. Master data managementpublic2008-04-30 11:472009-03-18 11:01
Reporterplujan 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40alpha 
Target VersionFixed in Version 
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
Summary0000176: QA-CLEANUP When importing taxes I get an error about a missing column
DescriptionWhen importing taxes, I get an error and no taxes are imported. The Log4j error is:
10:57:11 [http-8080-7] ERROR org.openbravo.erpCommon.ad_process.ImportTaxData - SQL error in query: INSERT INTO C_TaxCategory (C_TaxCategory_ID, AD_Client_ID, AD_Org_ID, IsActive,Created,CreatedBy,Updated,UpdatedBy, Name, Description, commodityCode) SELECT TO_NUMBER(?), AD_Client_ID, AD_Org_ID, 'Y',now(),CreatedBy,now(),UpdatedBy, TC_Name, TC_Description, TC_commodityCode FROM I_Tax WHERE I_Tax_ID = TO_NUMBER(?)Exception:java.sql.SQLException: ORA-00904: "COMMODITYCODE": identificador no válido
Steps To Reproduce1. Import some taxes. You can follow Importing testcases at http://wiki.openbravo.com/wiki/Acceptance_Testing [^]
2. When clicking on Import Taxes button, no tax is imported and an error is shown.
Insert TaxCategory - javax.servlet.ServletException: @CODE=904@ORA-00904: "COMMODITYCODE": identificador no válido
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-04-30 11:47plujanNew Issue
2008-04-30 11:47plujanAssigned To => cromero
2008-04-30 11:47plujanAssigned Tocromero => alostale
2008-04-30 11:47plujanStatusnew => @40@
2008-04-30 11:47plujanStatus@40@ => scheduled
2008-04-30 11:50alostaleStatusscheduled => resolved
2008-04-30 11:50alostaleResolutionopen => fixed
2008-04-30 12:16plujanStatusresolved => scheduled
2008-04-30 12:16plujanNote Added: 0000040
2008-05-02 13:27psarobeStatusscheduled => closed
2009-03-18 11:01anonymoussf_bug_id0 => 2691224

Notes
(0000040)
plujan   
2008-04-30 12:16   
New error message:
12:10:13 [http-8080-3] ERROR org.openbravo.erpCommon.ad_process.ImportTaxData - SQL error in query: UPDATE C_TaxCategory SET updated = now(), updatedBy = (SELECT updatedBy FROM I_Tax WHERE I_Tax_ID = TO_NUMBER(?)), description = COALESCE((SELECT TC_Description FROM I_Tax WHERE I_Tax_ID = TO_NUMBER(?)),description), WHERE C_TaxCategory_ID = TO_NUMBER(?)Exception:java.sql.SQLException: ORA-01747: especificación no válida de usuario.tabla.columna, tabla.columna o columna