Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007046Openbravo ERP09. Financial managementpublic2009-01-21 11:422009-04-21 12:36
Reportervmromanos 
Assigned ToAinhoaPagola 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionpiFixed 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
Summary0007046: 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
depends on backport 0007059 closed AinhoaPagola Impossible to create periods for a year 
blocks defect 0006772 closed vmromanos Periods for 2009 are not opened in sample data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-21 11:42vmromanosNew Issue
2009-01-21 11:42vmromanosAssigned To => AinhoaPagola
2009-01-21 11:42vmromanossf_bug_id0 => 2525986
2009-01-21 11:42vmromanosRegression testing => No
2009-01-21 11:43vmromanosRelationship addedblocks 0006772
2009-01-21 12:43AinhoaPagolaStatusnew => acknowledged
2009-01-21 14:31rafarodaStatusacknowledged => scheduled
2009-01-21 14:31rafarodafix_in_branch => trunk
2009-01-21 16:32AinhoaPagolaIssue cloned0007059
2009-01-21 16:32AinhoaPagolaRelationship addeddepends on 0007059
2009-01-21 16:37svnbotCheckin
2009-01-21 16:37svnbotNote Added: 0012459
2009-01-21 16:37svnbotStatusscheduled => resolved
2009-01-21 16:37svnbotResolutionopen => fixed
2009-01-21 16:37svnbotsvn_revision => 12094
2009-01-23 11:32AinhoaPagolaTag Attached: comsup_sprint4
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0012459)
svnbot   
2009-01-21 16:37   
Repository: openbravo
Revision: 12094
Author: AinhoaPagola
Date: 2009-01-21 16:37:00 +0100 (Wed, 21 Jan 2009)

Fixes bug 0007046 create period function fixed for Oracle

---
U trunk/src-db/database/model/functions/C_YEARPERIODS.xml
---

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