Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007059Openbravo ERP09. Financial managementpublic2009-01-21 16:322009-03-03 17:16
ReporterAinhoaPagola 
Assigned ToAinhoaPagola 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionFixed in Version 
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
Summary0007059: Impossible to create periods for a year
DescriptionWhen you are creating the periods for a year the application displays a "Warning" and it doesn't create the periods.

Here is the log:
ERROR org.openbravo.erpCommon.ad_process.PinstanceProcedure - SQL error in query: CALL C_YearPeriods(?)Exception:
java.sql.SQLException: ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:212)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:951)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:45)
        at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
        at org.openbravo.erpWindows.FiscalCalendar.Year.doPost(Year.java:375)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:245)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:369)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:83)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
11:28:15 [http-8080-11] ERROR org.openbravo.scheduling.ProcessRunner - @CODE=6575@ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

java.lang.Exception: @CODE=6575@ORA-06575: La función o el paquete C_YEARPERIODS tienen en un estado no válido

        at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:49)
        at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
        at org.openbravo.erpWindows.FiscalCalendar.Year.doPost(Year.java:375)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:245)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:369)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:83)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Steps To Reproduce1- As Openbravo Admin, go to Financial Management || Accounting || Setup || Fiscal Calendar || Calendar and select "BigBazaar Financial Calendar"
2- Go to year tab and create a new year, example "2009". Save it
3- Press the "Create Periods" button.
Proposed SolutionAinhoa, I think the problem is that you are using not-Oracle compatible code in the C_YearPeriods procedure. Please check the functions you are using inside this procedure are both Oracle and PostgreSQL compatible.
Additional Information
Tagscomsup_sprint4
Relationships
blocks defect 0007046pi closed AinhoaPagola Impossible to create periods for a year 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-21 16:32AinhoaPagolaNew Issue
2009-01-21 16:32AinhoaPagolaAssigned To => AinhoaPagola
2009-01-21 16:32AinhoaPagolaRegression testing => No
2009-01-21 16:32AinhoaPagolaIssue generated from0007046
2009-01-21 16:32AinhoaPagolaRelationship addedblocks 0007046
2009-01-21 16:33AinhoaPagolaStatusnew => scheduled
2009-01-21 16:33AinhoaPagolafix_in_branch => 2.40
2009-01-21 17:01svnbotCheckin
2009-01-21 17:01svnbotNote Added: 0012460
2009-01-21 17:01svnbotStatusscheduled => resolved
2009-01-21 17:01svnbotResolutionopen => fixed
2009-01-21 17:01svnbotsvn_revision => 12095
2009-01-23 11:32AinhoaPagolaTag Attached: comsup_sprint4
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0012460)
svnbot   
2009-01-21 17:01   
Repository: openbravo
Revision: 12095
Author: AinhoaPagola
Date: 2009-01-21 17:01:39 +0100 (Wed, 21 Jan 2009)

Fixes bug 0007059 Create periods fixed for Oracle

---
U branches/r2.40/src-db/database/model/functions/C_YEARPERIODS.xml
---

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