So where to start ...... We are upgrading 7.5.3 web client to 8.1 .... Things through the development part are working great. We have managed to port customizations etc. and in the dev VM we have no issues..
Now once we move this exact same database from the dev VM onto the companies servers, (also VMs) then we start to see a very strange issue.
When we reset IIS, or rebuild, or the first time a user logs into the website, they get kicked back to the login page on each new entity/form they call. Just the first time! Once they have visited the location they can go back as many times as they like w/o ever being kicked to login.
IIS Settings are Identicale in Dev and the company server -- Swiftpage has tried to find the issue, no luck --
I am hoping someone else has come across this before and can point me in the right direction.. Have been there and tried almost every possibility, so please post all your suggestions in case I missed something
We are not even getting an error in the Event View, just the warning: here is the Event information, thanks for your help
============================================================================
Log Name: Application Source: Saleslogix Web Client Date: 7/10/2014 3:23:24 AM Event ID: 23 Task Category: None Level: Warning Keywords: Classic User: N/A Computer: SINMPY87.corp.go2uti.com Description: 2014-07-10 17:04:50,927 [9] WARN Global - SalesLogix Web Client unhandled exception [Saleslogix Error Id=SLXEF564AC4A6923528] { "slxErrorId": "SLXEF564AC4A6923528", "mitigation": "AjaxLoginRedirect (575)", "date": "2014-07-10T17:04:50", "utc": "2014-07-10T17:04:50", "message": "The authentication token is invalid.", "source": "Sage.SalesLogix.SLXConnectionInfo, Sage.SalesLogix, Version=8.1.0.1146, Culture=neutral, PublicKeyToken=null", "type": "Sage.Platform.Application.AuthTokenNullException", "stackTrace": " at Sage.SalesLogix.SLXConnectionInfo.FromAuthenticationToken(Object authToken)\r\n at Sage.SalesLogix.SLXDataService.DecryptAuthToken(Object authToken)\r\n at Sage.SalesLogix.SLXDataService.GetConnectionString()\r\n at Sage.Platform.Data.AbstractOleDbDataService.GetConnection()\r\n at Sage.Platform.Data.DataServiceConnectionProvider.GetConnection()\r\n at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()\r\n at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)\r\n at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)\r\n at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)\r\n at NHibernate.Cfg.Configuration.BuildSessionFactory()\r\n at Sage.Platform.Framework.SessionFactoryHolder.GetSessionFactory()\r\n at Sage.Platform.Framework.SessionFactoryHolder.CreateScopeSession()\r\n at Sage.Platform.Framework.SessionFactoryHolder.CreateSession()\r\n at Sage.Platform.Orm.SessionScopeWrapper..ctor(Boolean createNewScope)\r\n at Sage.Platform.Mashups.Processors.DefaultQueryExecutor.Execute(String query, Nullable`1 maximumResults, IDictionary`2 parameters, IList`1 aliases)\r\n at Sage.Platform.Mashups.Processors.QueryProcessor.OnProcessRecord(IRecord record, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Processors.InputProcessorBase.OnProcess(IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.<>c__DisplayClass5.< rocess>b__4()\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.PostProcess(Func`1 getResult)\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.Process(IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Mashup.Execute(String name, IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.GetData(Mashup mashup, String resultName, IDictionary`2 runtimeParams, SDataUri uri, Int64& totalResults, Int32& startIndex, Int32& itemsPerPage)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.InternalExecute(Mashup mashup, String resultName, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.GetQueriesExecute()\r\n at Invoke03c5d31ed1e543e9ad5fc01a9a46fd2e.Invoke(Object , IRequest )\r\n at Sage.Integration.Messaging.RequestTargetRegistration.RequestTargetInvoker.Invoke(IRequest request)\r\n at Sage.Integration.Messaging.Request.Process(RequestTargetInvoker invoker)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.Process(IRequest request)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.ProcessWorker(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Adapter.AdapterController.Process(IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest) at Sage.Integration.Messaging.MessagingService.OnHandleException(Exception ex, IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Web.SageIntegrationHandler.ProcessRequest(HttpContext context)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)", "targetSite": "Sage.SalesLogix.SLXConnectionInfo FromAuthenticationToken(System.Object)", "hashCode": "350D5E69-03A5C182-FC4BE365", "pid": 4908, "identity": { "name": "admin", "isAuthenticated": true, "authenticationType": "Forms" }, "version": "8.1.0.1146", "logger": { "level": "WARN", "location": "Sage.Platform.Diagnostics.ErrorHelper.LogException(:0)", "name": "Global", "message": "SalesLogix Web Client unhandled exception [Saleslogix Error Id=SLXEF564AC4A6923528]" }, "request": { "looksLikeAjax": true, "isLocal": false, "method": "GET", "url": "http://sinmpy87:3333/SlxClient/slxdata.ashx/$app/mashups/-/mashups('RemindersAndAlarms')/$queries/execute?_includeContent=false&_resultName=GetCounts&_beforeDate=2014-07-10T17:04:48Z&_timelessBeforeDate=2014-07-09T23:59:59Z&_userId=ADMIN &format=json&_t=1405011888056", "referrer": "http://sinmpy87:3333/SlxClient/Lead.aspx?entityid=Q6UJ9A015V4D&modeid=Detail", "ipAddress": "10.10.93.227", "userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0", "userLanguages": "en-us; en;q=0.7; fr-fr;q=0.3" }, "browser": { "type": "Firefox30", "name": "Firefox", "version": "30.0", "majorVersion": 30, "minorVersion": 0.0, "platform": "WinNT" }, "server": { "machineName": "SINMPY87", "timeZone": "UTC", "commandLine": "C:\\Windows\\SysWOW64\\inetsrv\\w3wp.exe -ap \"UTISLXPool\" -v \"v4.0\" -l \"webengine4.dll\" -a \\\\.\\pipe\\iisipmfe6a9810-d4e8-4031-9e13-b08a4cae053e -h \"C:\\inetpub\\temp\\apppools\\UTISLXPool\\UTISLXPool.config\" -w \"\" -m 0", "versionString": "Microsoft Windows NT 6.3.9600.0", "is64BitOperatingSystem": true, "host": { "siteName": "Saleslogix", "applicationId": "/LM/W3SVC/2/ROOT/SlxClient", "applicationPhysicalPath": "C:\\inetpub\\wwwroot\\SlxClient\\", "applicationVirtualPath": "/SlxClient", "isDebuggingEnabled": false, "isHosted": true, "maxConcurrentRequestsPerCPU": 5000, "maxConcurrentThreadsPerCPU": 0 }, "logonUser": { "name": "CORP\\WebDLL", "authenticationType": "Forms", "impersonationLevel": "Impersonation", "isAnonymous": false, "isGuest": false, "isSystem": false } } } Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> < rovider Name="Saleslogix Web Client" /> <EventID Qualifiers="0">5001</EventID> <Level>3</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2014-07-10T17:04:50.000000000Z" /> <EventRecordID>24820</EventRecordID> <Channel>Application</Channel> <Computer>SINMPY87.corp.go2uti.com</Computer> <Security /> </System> <EventData> <Data>2014-07-10 17:04:50,927 [9] WARN Global - SalesLogix Web Client unhandled exception [Saleslogix Error Id=SLXEF564AC4A6923528] { "slxErrorId": "SLXEF564AC4A6923528", "mitigation": "AjaxLoginRedirect (575)", "date": "2014-07-10T17:04:50", "utc": "2014-07-10T17:04:50", "message": "The authentication token is invalid.", "source": "Sage.SalesLogix.SLXConnectionInfo, Sage.SalesLogix, Version=8.1.0.1146, Culture=neutral, PublicKeyToken=null", "type": "Sage.Platform.Application.AuthTokenNullException", "stackTrace": " at Sage.SalesLogix.SLXConnectionInfo.FromAuthenticationToken(Object authToken)\r\n at Sage.SalesLogix.SLXDataService.DecryptAuthToken(Object authToken)\r\n at Sage.SalesLogix.SLXDataService.GetConnectionString()\r\n at Sage.Platform.Data.AbstractOleDbDataService.GetConnection()\r\n at Sage.Platform.Data.DataServiceConnectionProvider.GetConnection()\r\n at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()\r\n at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)\r\n at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)\r\n at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)\r\n at NHibernate.Cfg.Configuration.BuildSessionFactory()\r\n at Sage.Platform.Framework.SessionFactoryHolder.GetSessionFactory()\r\n at Sage.Platform.Framework.SessionFactoryHolder.CreateScopeSession()\r\n at Sage.Platform.Framework.SessionFactoryHolder.CreateSession()\r\n at Sage.Platform.Orm.SessionScopeWrapper..ctor(Boolean createNewScope)\r\n at Sage.Platform.Mashups.Processors.DefaultQueryExecutor.Execute(String query, Nullable`1 maximumResults, IDictionary`2 parameters, IList`1 aliases)\r\n at Sage.Platform.Mashups.Processors.QueryProcessor.OnProcessRecord(IRecord record, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Processors.InputProcessorBase.OnProcess(IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.<>c__DisplayClass5.< rocess>b__4()\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.PostProcess(Func`1 getResult)\r\n at Sage.Platform.Mashups.Processors.ProcessorBase.Process(IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Mashup.Execute(String name, IDictionary`2 results, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.GetData(Mashup mashup, String resultName, IDictionary`2 runtimeParams, SDataUri uri, Int64& totalResults, Int32& startIndex, Int32& itemsPerPage)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.InternalExecute(Mashup mashup, String resultName, IDictionary`2 runtimeParams)\r\n at Sage.Platform.Mashups.Web.SData.MashupExecuteRequestHandler.GetQueriesExecute()\r\n at Invoke03c5d31ed1e543e9ad5fc01a9a46fd2e.Invoke(Object , IRequest )\r\n at Sage.Integration.Messaging.RequestTargetRegistration.RequestTargetInvoker.Invoke(IRequest request)\r\n at Sage.Integration.Messaging.Request.Process(RequestTargetInvoker invoker)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.Process(IRequest request)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.ProcessWorker(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Adapter.AdapterController.Process(IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest) at Sage.Integration.Messaging.MessagingService.OnHandleException(Exception ex, IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Web.SageIntegrationHandler.ProcessRequest(HttpContext context)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)", "targetSite": "Sage.SalesLogix.SLXConnectionInfo FromAuthenticationToken(System.Object)", "hashCode": "350D5E69-03A5C182-FC4BE365", "pid": 4908, "identity": { "name": "admin", "isAuthenticated": true, "authenticationType": "Forms" }, "version": "8.1.0.1146", "logger": { "level": "WARN", "location": "Sage.Platform.Diagnostics.ErrorHelper.LogException(:0)", "name": "Global", "message": "SalesLogix Web Client unhandled exception [Saleslogix Error Id=SLXEF564AC4A6923528]" }, "request": { "looksLikeAjax": true, "isLocal": false, "method": "GET", "url": "http://sinmpy87:3333/SlxClient/slxdata.ashx/$app/mashups/-/mashups('RemindersAndAlarms')/$queries/execute?_includeContent=false&_resultName=GetCounts&_beforeDate=2014-07-10T17:04:48Z&_timelessBeforeDate=2014-07-09T23:59:59Z&_userId=ADMIN &format=json&_t=1405011888056", "referrer": "http://sinmpy87:3333/SlxClient/Lead.aspx?entityid=Q6UJ9A015V4D&modeid=Detail", "ipAddress": "10.10.93.227", "userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0", "userLanguages": "en-us; en;q=0.7; fr-fr;q=0.3" }, "browser": { "type": "Firefox30", "name": "Firefox", "version": "30.0", "majorVersion": 30, "minorVersion": 0.0, "platform": "WinNT" }, "server": { "machineName": "SINMPY87", "timeZone": "UTC", "commandLine": "C:\\Windows\\SysWOW64\\inetsrv\\w3wp.exe -ap \"UTISLXPool\" -v \"v4.0\" -l \"webengine4.dll\" -a \\\\.\\pipe\\iisipmfe6a9810-d4e8-4031-9e13-b08a4cae053e -h \"C:\\inetpub\\temp\\apppools\\UTISLXPool\\UTISLXPool.config\" -w \"\" -m 0", "versionString": "Microsoft Windows NT 6.3.9600.0", "is64BitOperatingSystem": true, "host": { "siteName": "Saleslogix", "applicationId": "/LM/W3SVC/2/ROOT/SlxClient", "applicationPhysicalPath": "C:\\inetpub\\wwwroot\\SlxClient\\", "applicationVirtualPath": "/SlxClient", "isDebuggingEnabled": false, "isHosted": true, "maxConcurrentRequestsPerCPU": 5000, "maxConcurrentThreadsPerCPU": 0 }, "logonUser": { "name": "CORP\\WebDLL", "authenticationType": "Forms", "impersonationLevel": "Impersonation", "isAnonymous": false, "isGuest": false, "isSystem": false } } }</Data> </EventData> </Event>
==================================================================
|