Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007150Openbravo ERPA. Platformpublic2009-01-27 10:212009-04-21 11:04
ReporterAinhoaPagola 
Assigned Toanthony_wolski 
PriorityurgentSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Version 
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
Summary0007150: Can not use any procedure
DescriptionAny call to a stored procedure shows a warning message. The log is:

10:18:04 [ajp-8009-4] INFO org.openbravo.erpWindows.PurchaseOrder.Header - Call to HttpBaseServlet.service
10:18:04 [ajp-8009-4] INFO org.openbravo.erpWindows.PurchaseOrder.Header - *********************Base path: src-loc
10:18:04 [ajp-8009-4] INFO org.openbravo.erpWindows.PurchaseOrder.Header - *********************Base path: src-loc/design
10:18:04 [ajp-8009-4] ERROR org.openbravo.erpCommon.ad_process.PinstanceProcedure - SQL error in query: CALL null(?)Exception:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "NULL"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.openbravo.database.RDBMSIndependent.getCallableResult(RDBMSIndependent.java:88)
    at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:74)
    at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
    at org.openbravo.erpWindows.PurchaseOrder.Header.doPost(Header.java:355)
    at javax.servlet.http.HttpServlet.service(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
    at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
    at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
10:18:04 [ajp-8009-4] ERROR org.openbravo.scheduling.ProcessRunner - @CODE=0@ERROR: syntax error at or near "NULL"
java.lang.Exception: @CODE=0@ERROR: syntax error at or near "NULL"
    at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:79)
    at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
    at org.openbravo.erpWindows.PurchaseOrder.Header.doPost(Header.java:355)
    at javax.servlet.http.HttpServlet.service(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
    at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
    at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
10:18:04 [ajp-8009-4] INFO org.openbravo.scheduling.ProcessRunner - Process 7658CCBE675144149CC32955B8548076 threw an Exception:
java.lang.Exception: @CODE=0@ERROR: syntax error at or near "NULL"
    at org.openbravo.erpCommon.ad_process.PinstanceProcedure.execute(PinstanceProcedure.java:79)
    at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:85)
    at org.openbravo.erpWindows.PurchaseOrder.Header.doPost(Header.java:355)
    at javax.servlet.http.HttpServlet.service(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:65)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    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(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
    at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
    at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
Steps To ReproduceTry to complete a document.
For instance go to:
Procurement Management || Transactions || Purchase Order || Header
Fill the mandatory fields.
Click the complete button.
It is not even necessary to create lines for it.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-27 10:21AinhoaPagolaNew Issue
2009-01-27 10:21AinhoaPagolaAssigned To => rafaroda
2009-01-27 10:21AinhoaPagolasf_bug_id0 => 2539895
2009-01-27 10:21AinhoaPagolaRegression testing => No
2009-01-27 10:22AinhoaPagolaAssigned Torafaroda => anthony_wolski
2009-01-27 10:22AinhoaPagolaPrioritynormal => urgent
2009-01-27 10:22AinhoaPagolaStatusnew => scheduled
2009-01-27 11:55svnbotCheckin
2009-01-27 11:55svnbotNote Added: 0012679
2009-01-27 11:55svnbotStatusscheduled => resolved
2009-01-27 11:55svnbotResolutionopen => fixed
2009-01-27 11:55svnbotsvn_revision => 12307
2009-04-21 11:04psarobeStatusresolved => closed

Notes
(0012679)
svnbot   
2009-01-27 11:55   
Repository: openbravo
Revision: 12307
Author: anthony.wolski
Date: 2009-01-27 11:55:43 +0100 (Tue, 27 Jan 2009)

Fixes issue 0007150. Mis-named parameter variable fixed.

---
U trunk/src/org/openbravo/scheduling/ProcessBundle.java
---

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