WebGUI (IITS) Problem After Upgrade to EhP5 SP5 !!!

[Former Member]

Hi Expert,

I've just upgraded my ERP 6.0 to EhP5 SP5. During the testing of WebGUI (using IITS), and when calling the url (or testing WebGUI service from SICF), it takes long time to load the logon page! and when I try to logon (by pressing the logon button, it does nothing !!

I've found the following error on the developer trace files :

"*** ERROR => DB2 Call 'SQLExecute' Error: sqlcode = -952 : [IBM][CLI Driver] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014

[dbdb2cli.c 4981]

C {root-id=02000200000F02DFB98041A6F77D4213}_{conn-id=02000200000F02DFB98041A6F594813A}_1

C SQL cancelled (handle 0); setting sqlcode -89988; native sqlcode -952

C SQL cancelled; calling registered function at 80165898

M program canceled

M reason = soft cancel

M user = SAPSYS

M client = 000

M terminal = 10.2.10.118

M T33/U16671/M0

M report = CLUR_MIME_HANDLER=============CP

C rollback after cancel: re-create connection.

C Disconnecting from connection 0 ...

C *** ERROR => DB2 Call 'SQLEndTran' Error: sqlstate = 08003 : [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003

[dbdb2cli.c 4939]

C {root-id=02000200000F02DFB98041A6F77D4213}_{conn-id=02000200000F02DFB98041A6F594813A}_1"

Appreciate any hint ...

Thanking you in advance ...

Rgds,

Sheikh Saggaf

[former_member194364]

Hi Sheikh,

None of these DEV Trace entrys relate to the WEBGUI. The entrys normally lead with "W"

First would recommend to review a few WIKI's and notes:

See also WIKI: [ How to check the publishing Date of an Internet Service|http://wiki.sdn.sap.com/wiki/x/OYG8BQ]

Republish the core ITS Services, WEBGUI, SYSTEM and IAC if need be

See note [816973|https://service.sap.com/sap/support/notes/816973] ITS 7.00 - preclarification and basic problem analysis

-> Section 6."Make sure the service has been published:"

and the WIKI:

[How to activate, publish and test ITS services in the integrated ITS|http://wiki.sdn.sap.com/wiki/x/kmE]

After republishing then delete the Template and MIME Cache afterwards via transaction

/nSITSPMON -> Template and MIME Cache -> Select "System Wide"

for the MIME and Templates.

Then test the WEBGUI

transaction /nsicf > default host ->

sap -> bc -> gui -> sap -> its -> webgui

o Select Test service from context menu of the service node

i.e: Right Click -> Test Service

Regards,

Oisin

Edited by: Oisin ONidh on Dec 19, 2011 5:19 PM Adjust the URL Links

Edited by: Oisin ONidh on Dec 19, 2011 5:20 PM

[Former Member]

Hi,

The issue has been fixed by increasing the time-out parameter of HTTP service from SMICM trx-code.

Rgds,

Sheikh