Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 

Incorrect Size of CallerID in Stored Procedure

Last edited: 22 Jun 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 - <EException Class="ERuntimeException"><ErrorCollection><EError Class="EInternalError" Owner=""><PropertyList><Property Name="ErrorCode"><Value>225</Value></Property></PropertyList><ParameterList><Parameter Size="24" Type="string"><Value><![CDATA[ [psp_validate_session] ]]></Value></Parameter><Parameter Size="43" Type="string"><Value><![CDATA[ F71E2D4F-2241-4B2D-8C1D-0EB9098BC7DB ]]></Value></Parameter><Parameter Size="35" Type="string"><Value><![CDATA[ CORPORATEDOMAIN\IWAM_DEVELOPMENTEWORKSERVER ]]></Value></Parameter></ParameterList></EError></ErrorCollection><PropertyList><Property Name="Description"><Value><![CDATA[[sp_get_filter] [psp_validate_session] No entry exists in eSession with Session id = F71E2D4F-2241-4B2D-8C1D-0EB9098BC7DB and Caller id = CORPORATEDOMAIN\IWAM_DEVELOPMENTEWORKSERVER]]></Value></Property><Property Name="LineNumber"><Value>-1</Value></Property><Property Name="FileName"><Value><![CDATA[]]></Value></Property>
  • 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 <domain>\\iwam_<machine name>. Hence, especially long domain and/or machine names may cause this 31 character limit to be exceeded.

Resolution

  1.                                 In SQL Server Enterprise Manager, copy the e-Work stored procedure 'sp_create_session' into a text editor, e.g. Notepad.                                
  2.                                 Change '@p_CallerID VARCHAR(31)' to '@p_CallerID VARCHAR(250)' (without the single quotes).                                
  3.                                 Drop (delete) the existing sp_create_session stored procedure.                                
  4. 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.

Keywords: kb569


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!