Stalled transaction

[former_member540174]

A web dypro program is throwing a stalled transaction error. What does that mean?

Here is the output from our monitoring tool

Error at 06:17:52.495 (15 Feb 2008)
Frontends|Apps|WebDynproDispatcherServlet|URLs|WebDynpro spiritaero.com/cats~mgr~timevrfy/ManagerTimeVerificationApp (0 ms)
Application Name: WebDynproDispatcherServlet
Context Path: /webdynpro/dispatcher
Error Message: SAP Portal|Applications|CM|Errors|com.sapportals.wcm.repository.NameAlreadyExistsException: com.sapportals.wcm.repository.NameAlreadyExistsException
Method: service
Normalized URL: WebDynpro spiritaero.com/cats~mgr~timevrfy/ManagerTimeVerificationApp
Refering URL: https://my.web.spiritaero.com/irj/servlet/prt/portal/prteventname/navigate/prtroot/pcd!3aportal_content!2fspirit.spirit!2fspirit.portal!2fspirit.custom_development_content!2fspirit.portal_desktop!2fSpiritPortalDesktop!2fframeworkPages!2fspirit.frameworkpage!2fcom.sap.portal.innerpage?WebDynproNamespace=&WebDynproApplication=&DynamicParameter=sap.xss.menuhdr%3DSAPDEFAULT%26sap.xss.menusrv%3DZ_MANAGER_ADMIN_VERIFY%26sap.xss.menuargrp%3DZ_SPIRIT_MSS%26sap-cssversion%3D7.0.9.0.0%26sap.xss.menuarea%3DZ_MANAGER_ADMIN%26sap-wd-tstamp%3D1203077867234%26sap-wd-cltwndid%3DWID1203077758940&HistoryMode=0&windowId=WID1203077758940
Scheme: https
Server Name: sapwpp.web.spiritaero.com
Server Port: 443
Session ID: (J2EE3198900)ID0876787150DB00468165913225067279End
Thread Group Name: SAPEngine_Application_Thread[impl:3]_Group
Thread Name: SAPEngine_Application_Thread[impl:3]_22
Trace ID: 1203077911740:878410
Trace Type: ErrorSnapshot
URL: /webdynpro/dispatcher/spiritaero.com/cats~mgr~timevrfy/ManagerTimeVerificationApp
User ID: s0051955
Servlets|com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet (1 ms)
SAP J2EE|Web Dynpro|AppMgmt|com.sap.tc.webdynpro.clientserver.cal.ClientApplication|init (6 ms)
SAP J2EE|Web Dynpro|View|spiritaero.com.cats.mgr.comp.wdp.InternalSelectionView|wdDoInit (19 ms)
Backends|JCO-EP1-100@pwic637 (82 ms)
Backends|JCO-EP1-100@pwic637|JCO|ZHR_EMPL_ORG (82 ms)
Error Message: Stalled Transaction
Method: execute
SQL: SELECT "VAL" FROM "UME_BLOBS" WHERE "PID" = ? AND "PIDH" = ? AND "NAMESP" = ? AND "NAMESPH" = ? AND "ATTR" = ? AND "ATTRH" = ?

[Former Member]

looks like a bad select in the SQL statement. I.E. someone is running a report without defining the selection criteria.

As its a Z transaction running in a window its best to check that there are valid inputs for the report on the backend system

If its a report some of the fields might not be valid etc.

the SQL bit in red kinda gives it away

Regards

james

Edited by: James Ibbotson on Feb 15, 2008 5:13 PM