Incorrect Size of CallerID in Stored Procedure

Metastorm · June 22, 2005

The information in this article applies to product: e-Work 6.1 6.5

Issue

When a user tries to connect to e-Work using Windows Single Sign-On and the web client, two messages are generated. The user receives the following error message:

Message:< \[psp\_validate\_session\] > : Your e-Work session has expired. You must log out and log back in.
Message:Failed to obtain list.

-AND-

A warning similar to the following is written to the Windows application event log:

Error encountered trying to invoke the following request - eFilterRequest. The following information is available - 225-1
This error occurs with the above-referenced versions of e-Work if the Caller ID exceeds 31 characters. The Caller ID is the web server's trusted account as specified in the authentication script, eSSO\_Web.js. If the web server and engine are on the same server, this is usually the account \\\\iwam\_. Hence, especially long domain and/or machine names may cause this 31 character limit to be exceeded.

In SQL Server Enterprise Manager, copy the e-Work stored procedure 'sp\_create\_session' into a text editor, e.g. Notepad.
Change '@p\;_CallerID VARCHAR(31)' to '@p\;_CallerID VARCHAR(250)' (without the single quotes).
Drop (delete) the existing sp\_create\_session stored procedure.
In Query Analyser, run the modified version of the stored procedure. Be sure to connect to the database as the owner of the stored procedures.