Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 15
Registered: ‎02-08-2011

Random and Repeated Logouts/Signouts in SalesLogix v7.5.3 Web

Our users are randomly and repeatedly logged out of SalesLogix Web Client v7.5.3 .

 

At this time the following error messages are shown on the slx server:

- Application Error 1000 w3wp.exe

- Sage.SData.Service Exception caught during the processing of a message...

- ASP.NET Event code: 3005

- SalesLogix Web Client WARN NHibernate.Cahce.CahceFactory....

 

Running on Windows Server 2008 R2 SP2.

 

Known Issue?

 

Thanks slxuser2

 

Highlighted
Employee
Posts: 314
Registered: ‎05-19-2009

Re: Random and Repeated Logouts/Signouts in SalesLogix v7.5.3 Web

Products: Sage SalesLogix

Applications: (Remove applications that do not apply.)
Oracle
SalesLogix Web Client
SQL Server

Version: 7.5.4

Issue:

New users cannot log into the SalesLogix web client and/or existing users are routed to the login page after attempting to hit a page that they had not previously accessed.

Cause:

This can be caused if the AUTOINCREMENT flag has been set to a value of 'T' for the VIRTUALFILESYSTEM table in the SECTABLE defs table of the database. This flag is not a flag that can be set/changed via the SalesLogix GUI, but rather is sometimes updated manually for other tables when large data imports are taking place (SQL SSIS, etc) through the SalesLogix provider.

When set to 'T' this value causes the web application to be unable to write new VIRTUALFILESYSTEM table records containing user specific information. The AUTOINCREMENT value for the VIRTUALFILESYSTEM table should always be set to 'F'.

Special Considerations or Warnings:

Warning: New users will simply receive a notification that they were unable to login. Review of the application logs on the Web Server may report and error that reads as follows:

Event 1000, Application Error
Faulting application name: w3wp.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd2b
Faulting module name: ntdll.dll, version: 6.1.7600.16385, time stamp: 0x4a5bdb3b
Exception code: 0xc0000374
Fault offset: 0x000cdcbb
Faulting process id: 0xd44
Faulting application start time: 0x01ccb6a38b3d91d2
Faulting application path: C:\Windows\SysWOW64\inetsrv\w3wp.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: 87c1ec1a-2299-11e1-b7a7-000c29e6d032

Note: Type note information here.

 

Solution:

If this issue is encountered, and it is confirmed that the AUTOINCREMENT value in the SECTABLEDEFS table for the VIRTUALFILESYSTEM entry is set to 'T', the value should be manually updated via an SQL update statement as shown below. Note that there are multiple entries in the SECTABLEDEFS table for the VIRTUALFILESYSTEM table.

UPDATE sysdba.SECTABLEDEFS SET autoincrement = 'F' WHERE tablename = 'VIRTUALFILESYSTEM'

 

That's as a start.  You'll need to provide full error details for further help from the Community.

 

Thanks, Emma

Highlighted
Nickel Contributor
Posts: 90
Registered: ‎03-20-2009

Re: Random and Repeated Logouts/Signouts in SalesLogix v7.5.3 Web

One of our customers just asked about this being safe for v7.5.4.  Looking at the fix, I am assuming that there is no reason it would not be.  Any ill effects that anyone is aware of?

 

Jim

Jim Pemberton
Vice President of Engineering
Simplesoft Solutions, Inc
Award Winning Infor CRM Business Partner