Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000176 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | major | have not tried | 2008-04-30 11:47 | 2009-03-18 11:01 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40alpha | SCM revision | 3889 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000176: QA-CLEANUP When importing taxes I get an error about a missing column | |||||||
| Description | When 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 Reproduce | 1. 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0000040) plujan (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-04-30 11:47 | plujan | New Issue | |
| 2008-04-30 11:47 | plujan | Assigned To | => cromero |
| 2008-04-30 11:47 | plujan | Assigned To | cromero => alostale |
| 2008-04-30 11:47 | plujan | Status | new => @40@ |
| 2008-04-30 11:47 | plujan | Status | @40@ => scheduled |
| 2008-04-30 11:50 | alostale | Status | scheduled => resolved |
| 2008-04-30 11:50 | alostale | Resolution | open => fixed |
| 2008-04-30 12:16 | plujan | Status | resolved => scheduled |
| 2008-04-30 12:16 | plujan | Note Added: 0000040 | |
| 2008-05-02 13:27 | psarobe | Status | scheduled => closed |
| 2009-03-18 11:01 | anonymous | sf_bug_id | 0 => 2691224 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |