ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » query activity list using oracle on solaris

Post new topic  Reply to topic
 query activity list using oracle on solaris « View previous topic :: View next topic » 
Author Message
pbjonwheat
PostPosted: Mon Mar 14, 2005 12:00 pm    Post subject: query activity list using oracle on solaris Reply with quote

Novice

Joined: 16 Nov 2004
Posts: 13
I have a workflow system on solaris 8 using oracle 9.2.2 as the runtime database. I can create an activity list for the user ADMIN, however, I cannot access the activity list. There seems to be something that is hanging up oracle when trying to retrieve the activity list. Has anyone else experienced this? I have no problem creating and displaying the activity list in windows, using the db2 database.
Back to top
View user's profile Send private message
karthik
PostPosted: Mon Mar 14, 2005 7:16 pm    Post subject: Reply with quote

Centurion

Joined: 17 Oct 2003
Posts: 114
Is there any error occuring with accesing the list ?

Karthik.
Back to top
View user's profile Send private message
pbjonwheat
PostPosted: Wed Mar 16, 2005 8:56 am    Post subject: Reply with quote

Novice

Joined: 16 Nov 2004
Posts: 13
The activity list is getting created and I can see it in the database. However, when it tries to query the activity list, I eventually get a timeout error.

This is what I have in the system error log and the servlet log:
This is from the error log:

- 03/11/05 10:49:00 ORA-00932: inconsistent datatypes: expected %s got %s


- 03/11/05 10:49:00 ORA-00932: inconsistent datatypes: expected %s got %s


- 03/11/05 10:49:03 ORA-00932: inconsistent datatypes: expected %s got %s


- 03/11/05 10:49:03 ORA-00932: inconsistent datatypes: expected %s got %s


- 03/11/05 10:49:05 ORA-00932: inconsistent datatypes: expected %s got %s


This is from the servlet.log:

2005-03-16 15:28:47.906 Servlet.Engine.Transports : 3: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/Logon.jsp
2005-03-16 15:28:47.906 Servlet.Engine.Transports : 3: Forwarding request to /Logon.jsp
2005-03-16 15:28:47.910 Servlet.Engine.Transports : 3: Charset for en is ISO-8859-1
2005-03-16 15:28:47.912 Servlet.Engine.Transports : 3: sendResponse done.
2005-03-16 16:35:43.93 Servlet.Engine.Transports : 0: Charset for en is ISO-8859-1
2005-03-16 16:35:48.42 Servlet.Engine.Transports : 1: logon called.
2005-03-16 16:35:48.43 Servlet.Engine.Transports : 1: userID: ADMIN
2005-03-16 16:35:48.43 Servlet.Engine.Transports : 1: mode: null
2005-03-16 16:35:48.43 Servlet.Engine.Transports : 1: Locating system '' in group ''.
2005-03-16 16:35:48.43 Servlet.Engine.Transports : 1: Logging on for userid ADMIN
2005-03-16 16:35:48.176 Servlet.Engine.Transports : 1: Logon: ADMIN OK
2005-03-16 16:35:48.176 Servlet.Engine.Transports : 1: User agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
2005-03-16 16:35:48.176 Servlet.Engine.Transports : 1: Session timeout: 1800s
2005-03-16 16:35:48.177 Servlet.Engine.Transports : 1: Timezone: server offset=-480[min], client offset=-420[min]
2005-03-16 16:35:48.177 Servlet.Engine.Transports : 1: valueBound called.
2005-03-16 16:35:48.177 Servlet.Engine.Transports : 1: SessionTable: Adding http(uw8gHOiQcpUYAFX4cP3cN2T) = wf(UwAAAAEAB4AQAAAAAAAAAABT)
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: valueBound done.
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: Accept-Language: en-us
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: Locale: en_US
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: logon done.
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: queryLists called.
2005-03-16 16:35:48.178 Servlet.Engine.Transports : 1: queryProcessTemplateLists called.
2005-03-16 16:35:48.213 Servlet.Engine.Transports : 1: queryProcessTemplateLists done.
2005-03-16 16:35:48.214 Servlet.Engine.Transports : 1: queryProcessInstanceLists called.
2005-03-16 16:35:48.249 Servlet.Engine.Transports : 1: queryProcessInstanceLists done.
2005-03-16 16:35:48.249 Servlet.Engine.Transports : 1: queryWorkLists called.
2005-03-16 16:35:48.285 Servlet.Engine.Transports : 1: queryWorkLists done.
2005-03-16 16:35:48.285 Servlet.Engine.Transports : 1: queryActivityInstanceLists called.
2005-03-16 16:35:48.302 Servlet.Engine.Transports : 1: queryActivityInstanceLists done.
2005-03-16 16:35:48.303 Servlet.Engine.Transports : 1: queryLists done.
2005-03-16 16:35:48.303 Servlet.Engine.Transports : 1: queryWorkItems called (useCache=false).
2005-03-16 16:35:48.501 Servlet.Engine.Transports : 1: queryWorkItems done.
2005-03-16 16:35:48.502 Servlet.Engine.Transports : 1: queryActivityInstanceLists called.
2005-03-16 16:35:48.517 Servlet.Engine.Transports : 1: queryActivityInstanceLists done.
2005-03-16 16:35:48.518 Servlet.Engine.Transports : 1: sendResponse for 'logon' called.
2005-03-16 16:35:48.518 Servlet.Engine.Transports : 1: Redirecting request to http://*/MQWFClient/servlet/Main?command=queryWorkItems&id=TAAAAAEAAkAAAAAAAAAAAABM&useCache=true
2005-03-16 16:35:48.519 Servlet.Engine.Transports : 1: sendResponse done.
2005-03-16 16:35:48.650 Servlet.Engine.Transports : 1: queryWorkItems called (useCache=true).
2005-03-16 16:35:48.651 Servlet.Engine.Transports : 1: queryWorkItems done.
2005-03-16 16:35:48.652 Servlet.Engine.Transports : 1: queryActivityInstanceLists called.
2005-03-16 16:35:48.668 Servlet.Engine.Transports : 1: queryActivityInstanceLists done.
2005-03-16 16:35:48.668 Servlet.Engine.Transports : 1: sendResponse for 'queryWorkItems' called.
2005-03-16 16:35:48.669 Servlet.Engine.Transports : 1: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/ListViewer.jsp
2005-03-16 16:35:48.669 Servlet.Engine.Transports : 1: Forwarding request to /forms/ListViewer.jsp
2005-03-16 16:35:48.670 Servlet.Engine.Transports : 1: Charset for en is ISO-8859-1
2005-03-16 16:35:48.683 Servlet.Engine.Transports : 1: sendResponse done.
2005-03-16 16:35:53.832 Servlet.Engine.Transports : 2: queryLists called.
2005-03-16 16:35:53.832 Servlet.Engine.Transports : 2: queryProcessTemplateLists called.
2005-03-16 16:35:53.878 Servlet.Engine.Transports : 2: queryProcessTemplateLists done.
2005-03-16 16:35:53.879 Servlet.Engine.Transports : 2: queryProcessInstanceLists called.
2005-03-16 16:35:53.917 Servlet.Engine.Transports : 2: queryProcessInstanceLists done.
2005-03-16 16:35:53.918 Servlet.Engine.Transports : 2: queryWorkLists called.
2005-03-16 16:35:53.954 Servlet.Engine.Transports : 2: queryWorkLists done.
2005-03-16 16:35:53.954 Servlet.Engine.Transports : 2: queryActivityInstanceLists called.
2005-03-16 16:35:53.972 Servlet.Engine.Transports : 2: queryActivityInstanceLists done.
2005-03-16 16:35:53.972 Servlet.Engine.Transports : 2: queryLists done.
2005-03-16 16:35:53.973 Servlet.Engine.Transports : 2: queryActivityInstanceLists called.
2005-03-16 16:35:53.989 Servlet.Engine.Transports : 2: queryActivityInstanceLists done.
2005-03-16 16:35:53.989 Servlet.Engine.Transports : 2: sendResponse for 'queryLists' called.
2005-03-16 16:35:53.990 Servlet.Engine.Transports : 2: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/ListViewer.jsp
2005-03-16 16:35:53.990 Servlet.Engine.Transports : 2: Forwarding request to /forms/ListViewer.jsp
2005-03-16 16:35:54.21 Servlet.Engine.Transports : 2: sendResponse done.
2005-03-16 16:35:56.892 Servlet.Engine.Transports : 2: createList called.
2005-03-16 16:35:56.892 Servlet.Engine.Transports : 2: createList done.
2005-03-16 16:35:56.892 Servlet.Engine.Transports : 2: sendResponse for 'createList' called.
2005-03-16 16:35:56.893 Servlet.Engine.Transports : 2: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/ListPropertiesViewer.jsp
2005-03-16 16:35:56.893 Servlet.Engine.Transports : 2: Forwarding request to /forms/ListPropertiesViewer.jsp
2005-03-16 16:35:58.719 Servlet.Engine.Transports : 2: sendResponse done.
2005-03-16 16:36:07.773 Servlet.Engine.Transports : 3: createPersistentList called.
2005-03-16 16:36:08.47 Servlet.Engine.Transports : 3: createPersistentList done.
2005-03-16 16:36:08.48 Servlet.Engine.Transports : 3: queryActivityInstances called (useCache=false).
2005-03-16 16:36:08.48 Servlet.Engine.Transports : 3: queryActivityInstanceLists called.
2005-03-16 16:39:08.296 Servlet.Engine.Transports : 3: doGet (createPersistentList): com.ibm.workflow.servlet.client.ClientException: FMC00014E Timeout occurred
com.ibm.workflow.api.FmcException:
FMC38009E MQSeries Workflow API Error :
API Return Code : 14
Error Origin : /projects/fmc/drvl/lbld/v350/solaris/src/fmcjclis.cxx, line 2965
Error Message : FMC00014E Timeout occurred
Nested Exception : None
at com.ibm.workflow.api.loc.ActivityInstanceListImpl.queryActivityInstances(ActivityInstanceListImpl.java:47)
at com.ibm.workflow.servlet.client.SessionContextImpl.setActivities(Unknown Source)
at com.ibm.workflow.servlet.client.SessionContextProxy.setActivities(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.queryActivityInstanceLists(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.queryActivityInstances(Unknown Source)
at com.ibm.workflow.servlet.client.RequestContext.mostRecentList(Unknown Source)
at com.ibm.workflow.servlet.client.DefaultViewer.mostRecentList(Unknown Source)
at com.ibm.workflow.servlet.client.DefaultViewer.createPersistentListResponse(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.workflow.servlet.client.Util.invoke(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.render(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.execute(Unknown Source)
at com.ibm.workflow.servlet.client.ApplicationContextImpl.dispatch(Unknown Source)
at com.ibm.workflow.servlet.client.Main.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1073)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:598)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:206)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:80)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:214)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:623)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:447)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
2005-03-16 16:39:08.297 Servlet.Engine.Transports : 3: handleError com.ibm.workflow.servlet.client.ClientException: FMC00014E Timeout occurred
2005-03-16 16:39:08.299 Servlet.Engine.Transports : 3: sendResponse for 'createPersistentList' called.
2005-03-16 16:39:08.300 Servlet.Engine.Transports : 3: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/Error.jsp
2005-03-16 16:39:08.300 Servlet.Engine.Transports : 3: Forwarding request to /forms/Error.jsp
2005-03-16 16:39:08.302 Servlet.Engine.Transports : 3: sendResponse done.
2005-03-16 16:39:26.521 Servlet.Engine.Transports : 0: createList called.
2005-03-16 16:39:26.522 Servlet.Engine.Transports : 0: createList done.
2005-03-16 16:39:26.522 Servlet.Engine.Transports : 0: sendResponse for 'createList' called.
2005-03-16 16:39:26.522 Servlet.Engine.Transports : 0: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/ListPropertiesViewer.jsp
2005-03-16 16:39:26.522 Servlet.Engine.Transports : 0: Forwarding request to /forms/ListPropertiesViewer.jsp
2005-03-16 16:39:26.525 Servlet.Engine.Transports : 0: sendResponse done.
2005-03-16 16:39:31.103 Servlet.Engine.Transports : 0: queryLists called.
2005-03-16 16:39:31.104 Servlet.Engine.Transports : 0: queryProcessTemplateLists called.
2005-03-16 16:39:31.179 Servlet.Engine.Transports : 0: queryProcessTemplateLists done.
2005-03-16 16:39:31.179 Servlet.Engine.Transports : 0: queryProcessInstanceLists called.
2005-03-16 16:39:31.233 Servlet.Engine.Transports : 0: queryProcessInstanceLists done.
2005-03-16 16:39:31.234 Servlet.Engine.Transports : 0: queryWorkLists called.
2005-03-16 16:39:31.274 Servlet.Engine.Transports : 0: queryWorkLists done.
2005-03-16 16:39:31.274 Servlet.Engine.Transports : 0: queryActivityInstanceLists called.
2005-03-16 16:42:31.345 Servlet.Engine.Transports : 0: doGet (queryLists): com.ibm.workflow.servlet.client.ClientException: FMC00014E Timeout occurred
com.ibm.workflow.api.FmcException:
FMC38009E MQSeries Workflow API Error :
API Return Code : 14
Error Origin : /projects/fmc/drvl/lbld/v350/solaris/src/fmcjclis.cxx, line 2965
Error Message : FMC00014E Timeout occurred
Nested Exception : None
at com.ibm.workflow.api.loc.ActivityInstanceListImpl.queryActivityInstances(ActivityInstanceListImpl.java:47)
at com.ibm.workflow.servlet.client.SessionContextImpl.setActivities(Unknown Source)
at com.ibm.workflow.servlet.client.SessionContextProxy.setActivities(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.queryActivityInstanceLists(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.queryLists(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.queryLists(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.workflow.servlet.client.Util.invoke(Unknown Source)
at com.ibm.workflow.servlet.client.BuiltinHandler.execute(Unknown Source)
at com.ibm.workflow.servlet.client.ApplicationContextImpl.dispatch(Unknown Source)
at com.ibm.workflow.servlet.client.Main.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1073)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:598)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:206)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:80)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:214)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:623)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:457)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
2005-03-16 16:42:31.361 Servlet.Engine.Transports : 0: handleError com.ibm.workflow.servlet.client.ClientException: FMC00014E Timeout occurred
2005-03-16 16:42:31.363 Servlet.Engine.Transports : 0: sendResponse for 'queryLists' called.
2005-03-16 16:42:31.363 Servlet.Engine.Transports : 0: Opening /opt/WebSphere/AppServer/installedApps/*/MQWF_Web_Client_FMC.ear/fmcohcli.war/forms/Error.jsp
2005-03-16 16:42:31.363 Servlet.Engine.Transports : 0: Forwarding request to /forms/Error.jsp
2005-03-16 16:42:31.365 Servlet.Engine.Transports : 0: sendResponse done.
Back to top
View user's profile Send private message
karthik
PostPosted: Wed Mar 16, 2005 9:57 am    Post subject: Reply with quote

Centurion

Joined: 17 Oct 2003
Posts: 114
It might be a general timeout error , where the query is not able to bring the result in the specified timeout period of 3 min. But to make sure i think you can try to add a filter to the activitylist , like OWNER = CURRENT_USER or some other to narrow down the result.

If it still does not work , i think you should increase your timeout.

Thanks
Karthik
Back to top
View user's profile Send private message
hos
PostPosted: Thu Mar 17, 2005 9:21 am    Post subject: Reply with quote

Chevalier

Joined: 03 Feb 2002
Posts: 470
Hi,
do you see abnormal execution server terminations in MQWF error.log?
Obviously the server cannot use the list for queries that you created.
Make sure that you are on the latest SP level. MQWF 3.5 GA had a bug in the activity list implementation.
Back to top
View user's profile Send private message
pbjonwheat
PostPosted: Thu Mar 17, 2005 10:35 am    Post subject: Reply with quote

Novice

Joined: 16 Nov 2004
Posts: 13
hi hos, we are on just the 3.5 and have not applied any service packs because this is the only environment that the user can test on and i would hate for something to break!
Back to top
View user's profile Send private message
pbjonwheat
PostPosted: Thu Mar 17, 2005 10:37 am    Post subject: Reply with quote

Novice

Joined: 16 Nov 2004
Posts: 13
and yes, the execution server terminates abnormally.
Back to top
View user's profile Send private message
hos
PostPosted: Fri Mar 18, 2005 4:48 am    Post subject: Reply with quote

Chevalier

Joined: 03 Feb 2002
Posts: 470
You can open a PMR if the server terminates abnormally. However they will tell you to apply maintenance first.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » query activity list using oracle on solaris
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.