SQL error while loading a process instance

[david.trattnig]

Hi,

I'd like to do following:

ProcessInstance pi = session.getGraphSession().loadProcessInstance(workflowId);
pi.signal();

but i get following errors at the loadProcessInstance operation:

ERROR [ceptionReporter: 72] Base table or view not found message from server: "Table 'jbpmtest.jbpm_dynprocess_node' doesn't exist"
ERROR [db.GraphSession: 221] org.hibernate.exception.SQLGrammarException: could not load an entity: [org.jbpm.graph.exe.ProcessInstance#318]

but the ProcessInstance with ID#318 definitely exists at the MySQL Database

MySQL version: 5.0
jBPM version: 3.0.2.

Thank you so much for any advice..

[hannes]

Did you directly take a look at the tables (MySql Query Browser)?
If there are things missing, perhaps hibernate itself could fix the ddl by adding: update to the hibernate.cfg.xml

[david.trattnig]

Thank you Hannes,

but i don't know what to update in the "hibernate.cfg.xml"..

Yes, i directly took a look at the table "jbpm_processinstance" where the process instance #318 is existing. The table "jbpmtest.jbpm_dynprocess_node" doesn't exist, that's true - but what is it for? There is no info at the source, web or anywhere else...

[david.trattnig]

solved this issue!
it was a company internal table - just inserted the hibernate property "hibernate.hbm2ddl.auto" and it worked.. thx guys