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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007046
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-01-21 11:422009-04-21 12:36
ReportervmromanosView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision12094
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabaseOracleJava version1.5
OS VersionUbuntu 8.04Database versionSEAnt version1.7
Product VersionpiSCM revision12083 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007046: 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.
Tagscomsup_sprint4
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0007059 closedAinhoaPagola Impossible to create periods for a year 
blocks defect 0006772 closedvmromanos Periods for 2009 are not opened in sample data 

-  Notes
(0012459)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2009-01-21 11:42 vmromanos New Issue
2009-01-21 11:42 vmromanos Assigned To => AinhoaPagola
2009-01-21 11:42 vmromanos sf_bug_id 0 => 2525986
2009-01-21 11:42 vmromanos Regression testing => No
2009-01-21 11:43 vmromanos Relationship added blocks 0006772
2009-01-21 12:43 AinhoaPagola Status new => acknowledged
2009-01-21 14:31 rafaroda Status acknowledged => scheduled
2009-01-21 14:31 rafaroda fix_in_branch => trunk
2009-01-21 16:32 AinhoaPagola Issue cloned 0007059
2009-01-21 16:32 AinhoaPagola Relationship added depends on 0007059
2009-01-21 16:37 svnbot Checkin
2009-01-21 16:37 svnbot Note Added: 0012459
2009-01-21 16:37 svnbot Status scheduled => resolved
2009-01-21 16:37 svnbot Resolution open => fixed
2009-01-21 16:37 svnbot svn_revision => 12094
2009-01-23 11:32 AinhoaPagola Tag Attached: comsup_sprint4
2009-04-21 12:36 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker