[jboss-user] [jBPM] - Process fails to deploy

[Ivan Pazmino]

Ivan Pazmino [http://community.jboss.org/people/iapazmino] created the discussion

"Process fails to deploy"

To view the discussion, visit: http://community.jboss.org/message/556961#556961

--------------------------------------------------------------
I'm trying to deploy a simple process in a jbpm 3.2 installation over jboss 4.2 and an oracle 10g db.

the jbpm tables are empty, since this should be the first process. I have designed a small process with the eclipse's gpd plug in. when I try deploying it an exception is thrown at the server's log complaining it can't find the process definition for  tester, which is the name I gave to the test process.

13:19:31,970 ERROR [ProcessUploadServlet] Failed to deploy process tester org.jbpm.JbpmException: could not find process definition 'tester'
...


an blames the failure to a malformed sql command

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
 
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
 
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
...


before this exception is thrown the failing query is

13:19:31,963 INFO  [STDOUT] Hibernate: 
    /* named HQL query GraphSession.findLatestProcessDefinitionQuery */ select
        processdef0_.ID_ as ID1_4_,
        processdef0_.NAME_ as NAME3_4_,
        processdef0_.DESCRIPTION_ as DESCRIPT4_4_,
        processdef0_.VERSION_ as VERSION5_4_,
        processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_4_,
        processdef0_.STARTSTATE_ as STARTSTATE7_4_ 
    from
        JBPM_PROCESSDEFINITION processdef0_ 
    where
        processdef0_.NAME_=? 
    order by
        processdef0_.VERSION_ desc limit ?
13:19:31,970 WARN  [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000
13:19:31,970 ERROR [JDBCExceptionReporter] ORA-00933: SQL command not properly ended


this query won't return any values because the JBPM_PROCESSDEFINITION table is empty, but it complains on the query. any configuration I'm missing?

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/556961#556961]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100811/453ac74c/attachment.html