Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007059 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2009-01-21 16:32 | 2009-03-03 17:16 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | AinhoaPagola | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 12095 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5 | |||
| OS Version | Ubuntu 8.04 | Database version | SE | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 12083 | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0007059: Impossible to create periods for a year | |||||||
| Description | When 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 Reproduce | 1- 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 Solution | Ainhoa, 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. | |||||||
| Tags | comsup_sprint4 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0012460) svnbot (reporter) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-01-21 16:32 | AinhoaPagola | New Issue | |
| 2009-01-21 16:32 | AinhoaPagola | Assigned To | => AinhoaPagola |
| 2009-01-21 16:32 | AinhoaPagola | Regression testing | => No |
| 2009-01-21 16:32 | AinhoaPagola | Issue generated from | 0007046 |
| 2009-01-21 16:32 | AinhoaPagola | Relationship added | blocks 0007046 |
| 2009-01-21 16:33 | AinhoaPagola | Status | new => scheduled |
| 2009-01-21 16:33 | AinhoaPagola | fix_in_branch | => 2.40 |
| 2009-01-21 17:01 | svnbot | Checkin | |
| 2009-01-21 17:01 | svnbot | Note Added: 0012460 | |
| 2009-01-21 17:01 | svnbot | Status | scheduled => resolved |
| 2009-01-21 17:01 | svnbot | Resolution | open => fixed |
| 2009-01-21 17:01 | svnbot | svn_revision | => 12095 |
| 2009-01-23 11:32 | AinhoaPagola | Tag Attached: comsup_sprint4 | |
| 2009-03-03 17:16 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |