11-22-2011 03:49 AM
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.
12-20-2011 09:20 AM
Products: Sage SalesLogix
Applications: (Remove applications that do not apply.)
SalesLogix Web Client
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.
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'.
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.
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.
01-31-2013 01:44 PM
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?