statement = getLOBData()

[anil0207]

Hi All,

We are using HPSM 7.11 with Windows 2003.
And DB as SQL 2005.

Everything was working fine till the time we added some fields in probsummary table.
After this addition all / some of the users started getting error as statement = getLOBData()
This error is coming when the user is trying to open, update, create new any Incident.

We tried reverting the change so we mapped the new fields in probsummary with n1 table.
Still this error is coming, and its not permanently coming, its coming now and then to different set of users.

After log off and log in the error is going off but again its coming.

No clue at all WHY??
All suggestions are Welcome.

Thanks,
Surabhi

[bharathjt]

Hi Surabhi,
Try running a trace by adding the debug parameters in SC.ini (or) start a listener port with the debug parameters and a specific log
step 1: Start a listener from the command prompt

scenter -listener:<a portno> -RTM:3 -debugdbquery:999 -sqldebug:1 -sqlreuseablesql:0 -log:debug.log

step 2 : connect SC through the Listener Port and Try reproducing the issue till it occurs. Then stop the listener. Goto the RUN folder and analyze the log file.

I hope the log file will help
cheers,
Bharath