Author |
Message
|
pbjonwheat |
Posted: Mon Mar 14, 2005 12:00 pm Post subject: query activity list using oracle on solaris |
|
|
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 |
|
 |
karthik |
Posted: Mon Mar 14, 2005 7:16 pm Post subject: |
|
|
 Centurion
Joined: 17 Oct 2003 Posts: 114
|
Is there any error occuring with accesing the list ?
Karthik. |
|
Back to top |
|
 |
pbjonwheat |
Posted: Wed Mar 16, 2005 8:56 am Post subject: |
|
|
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 |
|
 |
karthik |
Posted: Wed Mar 16, 2005 9:57 am Post subject: |
|
|
 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 |
|
 |
hos |
Posted: Thu Mar 17, 2005 9:21 am Post subject: |
|
|
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 |
|
 |
pbjonwheat |
Posted: Thu Mar 17, 2005 10:35 am Post subject: |
|
|
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 |
|
 |
pbjonwheat |
Posted: Thu Mar 17, 2005 10:37 am Post subject: |
|
|
Novice
Joined: 16 Nov 2004 Posts: 13
|
and yes, the execution server terminates abnormally. |
|
Back to top |
|
 |
hos |
Posted: Fri Mar 18, 2005 4:48 am Post subject: |
|
|
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 |
|
 |
|