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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007442
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminoralways2009-02-09 18:092009-04-21 10:54
ReportermiruritaView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionfixedFixed in Version2.50beta
StatusclosedFix in branchpiFixed in SCM revision13088
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007442: Import Orders process fails selecting paymentrule

DescriptionWhen paymentrule1 field of I_Order table is specified Import Order process fails.

Import Order error: javax.servlet.ServletException: @CODE=0@ERROR: column "amount" is of type numeric but expression is of type character varying

LOG
16:37:01 [http-8080-2] ERROR org.openbravo.erpCommon.ad_process.CDebtpaymentData - SQL error in query: INSERT INTO C_DEBT_PAYMENT (C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_BPARTNER_ID, C_CURRENCY_ID, PAYMENTRULE, ISPAID, AMOUNT, DATEPLANNED, ISMANUAL, ISVALID, CHANGESETTLEMENTCANCEL, CANCEL_PROCESSED, GENERATE_PROCESSED, GLITEMAMT, ISDIRECTPOSTING, STATUS, STATUS_INITIAL, C_ORDER_ID) VALUES ( ?, ?, ?, 'Y', TO_DATE(now()), ?, TO_DATE(now()), ?, ?, ?, ?, ?, ?, TO_DATE(?), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)Exception:org.postgresql.util.PSQLException: ERROR: column "amount" is of type numeric but expression is of type character varying
Steps To ReproduceFollow this test case:
http://wiki.openbravo.com/wiki/QA_test_plan_2.50/Test_cases [^]

with one modification:
- create one record more:
     Name: Paymentrule1
     Column: PaymentRule1
     Data type: constant
     Constant value: B

Then, go to Master Data Management -> Import Data -> Import Orders
Fill Price List field and press Import Orders button
Tagscommsup_sprint6
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0013402)
svnbot (reporter)
2009-02-12 12:26

 Repository: openbravo
Revision: 13088
Author: AinhoaPagola
Date: 2009-02-12 12:26:32 +0100 (Thu, 12 Feb 2009)

Fixes bug 0007442. Import orders process fails when selecting a paymentrule.

---
U trunk/src/org/openbravo/erpCommon/ad_process/CDebtpayment_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_process/ImportOrder.java
---

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

- Issue History
Date Modified Username Field Change
2009-02-09 18:09 mirurita New Issue
2009-02-09 18:09 mirurita Assigned To => rafaroda
2009-02-09 18:09 mirurita sf_bug_id 0 => 2582133
2009-02-09 18:09 mirurita Issue Monitored: mirurita
2009-02-09 18:09 mirurita Issue End Monitor: mirurita
2009-02-09 18:11 AinhoaPagola Assigned To rafaroda => AinhoaPagola
2009-02-11 11:33 AinhoaPagola Status new => scheduled
2009-02-11 11:33 AinhoaPagola fix_in_branch => trunk
2009-02-12 12:26 svnbot Checkin
2009-02-12 12:26 svnbot Note Added: 0013402
2009-02-12 12:26 svnbot Status scheduled => resolved
2009-02-12 12:26 svnbot Resolution open => fixed
2009-02-12 12:26 svnbot svn_revision => 13088
2009-02-13 10:43 AinhoaPagola Tag Attached: commsup_sprint6
2009-04-21 10:54 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker