Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010330Openbravo ERP07. Sales managementpublic2009-08-19 09:522009-08-21 00:00
Reporterarunkumar 
Assigned Tomtaal 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010330: 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038097 closed alostale DalConnectionProvider.getTransactionConnection with dbcp pool does not set db config query 
Attached Filesjpg posterror.JPG (174,207) 2009-08-19 09:52
https://issues.openbravo.com/file_download.php?file_id=1658&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-08-19 09:52arunkumarNew Issue
2009-08-19 09:52arunkumarAssigned To => rafaroda
2009-08-19 09:52arunkumarFile Added: posterror.JPG
2009-08-19 11:52arunkumarNote Added: 0019052
2009-08-19 12:53rafarodaAssigned Torafaroda => mtaal
2009-08-19 12:53rafarodaPriorityimmediate => urgent
2009-08-19 12:53rafarodaSeveritycritical => major
2009-08-19 12:53rafarodaStatusnew => scheduled
2009-08-20 09:23arunkumarNote Added: 0019089
2009-08-20 15:58hgbotCheckin
2009-08-20 15:58hgbotNote Added: 0019119
2009-08-20 15:58hgbotStatusscheduled => resolved
2009-08-20 15:58hgbotResolutionopen => fixed
2009-08-20 15:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7fab4d187a7cb667bf06f41f8feddf214a137546 [^]
2009-08-20 17:13arunkumarStatusresolved => closed
2009-08-20 17:13arunkumarNote Added: 0019129
2009-08-20 17:13arunkumarFixed in Version => pi
2009-08-21 00:00anonymoussf_bug_id0 => 2841483
2018-03-09 15:19alostaleRelationship addedrelated to 0038097

Notes
(0019052)
arunkumar   
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   
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   
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   
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.