RE: Help on "databaseManager,ERROR: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'moving.xpdlapplicationpackage' doesn't exist)"

Could anybody help me with the problem? 

Is the DODS in Shark configured to work with multiple databases? 

How to solve confliction in the two DODs used by Shark and my application
when running together? 

Thank you very much!

Best Regards,

He Wei

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Friday, July 29, 2005 10:30 AM
To: [email protected]
Subject: RE: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Hi ALL,

 

Regarding to the problem in my previous email, I found it is probably
because Shark is trying to look for the table (of shark) from the database
of my application.  The Shark is invoked from within my application, and
start a process. During the process execution, the process has a
javaclasstoolagent to invoke an application which will call my application
method. My Application is also using DODS to access its database. The
problem happens when my application start its DODs to access its database.
When my application complete and return to Shark, the Shark continues use my
DODs to access shark's database, the error will then occurs. Could you
please help me to solve the problem?

Thanks.

Best Regards,

He Wei

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Tuesday, July 26, 2005 10:28 AM
To: [email protected]
Subject: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Hello,

 

Could anybody please explain me what causes the error below (highlighted in
bold red)? Thank you.

He Wei

 

2005-07-25 16:25:23,765:
Process[key=1_Moving_MovingPalletProcess,mgrname=Moving#1#MovingPalletProces
s] - Activity[Id=1_1_Moving_MovingPalletProcess_Moving_Wor1_Act16, ba=null,
ActDefId=Moving_Wor1_Act16] is completed.

2005-07-25 16:25:23,765:
Process[key=1_Moving_MovingPalletProcess,mgrname=Moving#1#MovingPalletProces
s] - Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] is created

2005-07-25 16:25:23,765:
Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] - Executing tool [id=taskFulfillment]

2005.07.25 16:25:23: databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

2005-07-25 16:25:23,805:
Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] - failed to execute tool [id=taskFulfillment]

2005-07-25 16:25:23,805: Rollback of Shark transaction happened.

com.lutris.dods.builder.generator.query.DataObjectException: Unknown
SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.runQuer
y(XPDLApplicationPackageQuery.java:1033)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.getNext
DO(XPDLApplicationPackageQuery.java:1185)

    at
org.enhydra.shark.appmappersistence.DODSApplicationMappingMgr.getApplication
Map(DODSApplicationMappingMgr.java:711)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen
tManagerImpl.java:170)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j
ava:96)

    at
org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl.
java:67)

    at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269)

    at
org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212)

    at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157)

    at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816)

    at org.enhydra.shark.WfProcessImpl.queueNext(WfProcessImpl.java:997)

    at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:703)

    at org.enhydra.shark.WfProcessImpl.start(WfProcessImpl.java:365)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:571)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:531)

    at com.idsc.moving.app.APP.main(APP.java:82)

Caused by: java.sql.SQLException:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

    at
com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuild
er.java:2480)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.execute
Query(XPDLApplicationPackageQuery.java:1357)

    at
com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQue
ry.java:118)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.runQuer
y(XPDLApplicationPackageQuery.java:771)

    ... 15 more

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws