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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010330
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2009-08-19 09:522009-08-21 00:00
ReporterarunkumarView Statuspublic 
Assigned Tomtaal 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision7fab4d187a7c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
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

0010330: Unable to Generate and Post Invoices in mass invoicing

DescriptionWhile trying to generate and post invoices using Mass Invoicing there comes an exception as invalid month

Steps To ReproducePrerequisite:

PI context should be installed with two modules
(1) Multiple business partner selector
(2) mass Invoicing

Login as Openbravo/openbravo in the role of Openbravo Admin.
Go to Sales Management || Transactions || Mass Invoicing || Mass Invoicing
Select the Organization as B2
Select the business partner "The Simpsons Ltd" by clicking the business partner + icon.
Select the template as TestB2
Enter the invoice date as 19-11-2009

Click Next button.

Another page will be displayed with "Previous" and "Generate" buttons in the bottom.

Click "Generate" button.

You will see an error message.(Please see the attached screenshot)
TagsNo tags attached.
Attached Filesjpg file icon posterror.JPG [^] (174,207 bytes) 2009-08-19 09:52

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0038097 closedalostale DalConnectionProvider.getTransactionConnection with dbcp pool does not set db config query 

-  Notes
(0019052)
arunkumar (viewer)
2009-08-19 11:52

 Error trace from the log file:

2480 »···at org.openbravo.scheduling.ProcessRequestData.update(ProcessRequestData.java:369)

32481 »···at org.openbravo.scheduling.ProcessMonitor.triggerFired(ProcessMonitor.java:84)

32482 »···at org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1793)

32483 »···at org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:310)

32484 »···at org.quartz.core.JobRunShell.run(JobRunShell.java:176)

32485 »···at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

32486 07:39:42 [ajp-8009-3] ERROR org.openbravo.erpCommon.businessUtility.TaxData - SQL error in query: SELECT C_GetTax(?, TO_DATE(?), ?, ?, ?, ?, ?, ?) AS TAX FROM DUALException:java.sql.SQLDataException: ORA-01843: not a valid month

32487

32488 07:39:42 [ajp-8009-3] ERROR org.openbravo.base.exception.OBException - javax.servlet.ServletException: @CODE=1843@ORA-01843: not a valid month

32489

32490 07:39:42 [ajp-8009-3] ERROR org.openbravo.erpCommon.businessUtility.TaxData - SQL error in query: SELECT C_GetTax(?, TO_DATE(?), ?, ?, ?, ?, ?, ?) AS TAX FROM DUALException:java.sql.SQLDataException: ORA-01843: not a valid month

32491

32492 07:39:42 [ajp-8009-3] ERROR org.openbravo.base.exception.OBException - javax.servlet.ServletException: @CODE=1843@ORA-01843: not a valid month

32493

32494 07:39:42 [ajp-8009-3] ERROR org.openbravo.erpCommon.businessUtility.TaxData - SQL error in query: SELECT C_GetTax(?, TO_DATE(?), ?, ?, ?, ?, ?, ?) AS TAX FROM DUALException:java.sql.SQLDataException: ORA-01843: not a valid month

32495

32496 07:39:42 [ajp-8009-3] ERROR org.openbravo.base.exception.OBException - javax.servlet.ServletException: @CODE=1843@ORA-01843: not a valid month

32497

32498 07:39:45 [DefaultQuartzScheduler_Worker-9] ERROR org.openbravo.scheduling.ProcessRequestData - SQL error in query: »··UPDATE AD_Process_Reques »SET Updated = NOW(), Updatedby = ?, AD_User_ID = ?, Status = ?, Channel = ?, »Previous_Fire_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS' »···Next_Fire_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), »···Scheduled_Finish = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), ntext = ? »···WHERE AD_Process_Request_ID = ?Exception:java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire ut string
(0019089)
arunkumar (viewer)
2009-08-20 09:23

 I have retested this issue. This is happening when we go with organizations like A2 , B2. I have reproduced this in the pi oracle context also.
(0019119)
hgbot (developer)
2009-08-20 15:58

 Repository: erp/devel/pi
Changeset: 7fab4d187a7cb667bf06f41f8feddf214a137546
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Aug 20 15:58:26 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7fab4d187a7cb667bf06f41f8feddf214a137546 [^]

fixes issue 10330: Unable to Generate and Post Invoices in mass invoicing

---
M src/org/openbravo/service/db/DalConnectionProvider.java
---
(0019129)
arunkumar (viewer)
2009-08-20 17:13

 As per the comments received from Martin, I understood that tax is must for generating mass invoice. Now the error message has been displayed if Tax is not there for the product.So I close the issue.

- Issue History
Date Modified Username Field Change
2009-08-19 09:52 arunkumar New Issue
2009-08-19 09:52 arunkumar Assigned To => rafaroda
2009-08-19 09:52 arunkumar File Added: posterror.JPG
2009-08-19 09:52 arunkumar OBNetwork customer => No
2009-08-19 11:52 arunkumar Note Added: 0019052
2009-08-19 12:53 rafaroda Assigned To rafaroda => mtaal
2009-08-19 12:53 rafaroda Priority immediate => urgent
2009-08-19 12:53 rafaroda Severity critical => major
2009-08-19 12:53 rafaroda Status new => scheduled
2009-08-20 09:23 arunkumar Note Added: 0019089
2009-08-20 15:58 hgbot Checkin
2009-08-20 15:58 hgbot Note Added: 0019119
2009-08-20 15:58 hgbot Status scheduled => resolved
2009-08-20 15:58 hgbot Resolution open => fixed
2009-08-20 15:58 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7fab4d187a7cb667bf06f41f8feddf214a137546 [^]
2009-08-20 17:13 arunkumar Status resolved => closed
2009-08-20 17:13 arunkumar Note Added: 0019129
2009-08-20 17:13 arunkumar Fixed in Version => pi
2009-08-21 00:00 anonymous sf_bug_id 0 => 2841483
2018-03-09 15:19 alostale Relationship added related to 0038097

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker