Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Issue related To Complete Activity in SLX 8.1 with Update 03

Hi All,

 

We just migrated our SalesLogix from SLX7.0.1(LAN) to SLX8.1(Web,Mobile, LAN). Though most of the things are good. But we are encountering a strange issue with couple of our users,

 

i. They can schedule an Activity but whenever they are trying to complete the activity they are getting an error, Can't insert to History,

     The data in one or more fields has exceeded its limit. HTTP status: Internal Server Error (500).

 

ii. But If I do that from my system or someone else's system, things are working perfectly fine.

 

iii. But the users can create as well as complete there activity through MobileClient from the same system with Chrome browser. 

The event log entry is as under,

 

2014-10-20 09:07:42,608 [94] ERROR Global - Integration Messaging MessagingService unhandled exception [Saleslogix Error Id=SLX5480C6CD222A3A8]
{
"slxErrorId": "SLX5480C6CD222A3A8",
"mitigation": "AjaxMessagingServiceError (500)",
"date": "2014-10-20T09:07:42",
"utc": "2014-10-20T14:07:42",
"message": "The statement has been terminated. : String or binary data would be truncated.",
"source": "System.Data.OleDb.OleDbCommand, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
"type": "System.Data.OleDb.OleDbException",
"stackTrace": " at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()\r\n at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)\r\n at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)\r\n at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)",
"targetSite": "Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)",
"fullException": "Sage.Common.Syndication.DiagnosesException: could not insert: [Sage.SalesLogix.Activity.History#H0Z42A00BJ4R][SQL: INSERT INTO HISTORY (ACCOUNTID, ACCOUNTNAME, ATTACHMENT, CATEGORY, COMPLETEDDATE, COMPLETEDUSER, CONTACTID, CONTACTNAME, CREATEDATE, CREATEUSER, DESCRIPTION, DURATION, LEADID, LEADNAME, LONGNOTES, MODIFYDATE, MODIFYUSER, NOTES, OPPORTUNITYID, OPPORTUNITYNAME, ORIGINALDATE, PRIORITY, RESULT, RESULTCODE, STARTDATE, TICKETID, TICKETNUMBER, TIMELESS, TYPE, USERID, USERNAME, HISTORYID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> NHibernate.Exceptions.GenericADOException: could not insert: [Sage.SalesLogix.Activity.History#H0Z42A00BJ4R][SQL: INSERT INTO HISTORY (ACCOUNTID, ACCOUNTNAME, ATTACHMENT, CATEGORY, COMPLETEDDATE, COMPLETEDUSER, CONTACTID, CONTACTNAME, CREATEDATE, CREATEUSER, DESCRIPTION, DURATION, LEADID, LEADNAME, LONGNOTES, MODIFYDATE, MODIFYUSER, NOTES, OPPORTUNITYID, OPPORTUNITYNAME, ORIGINALDATE, PRIORITY, RESULT, RESULTCODE, STARTDATE, TICKETID, TICKETNUMBER, TIMELESS, TYPE, USERID, USERNAME, HISTORYID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.OleDb.OleDbException: The statement has been terminated. : String or binary data would be truncated.\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()\r\n at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)\r\n at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)\r\n at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n --- End of inner exception stack trace ---\r\n at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)\r\n at NHibernate.Action.EntityInsertAction.Execute()\r\n at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)\r\n at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)\r\n at NHibernate.Engine.ActionQueue.ExecuteActions()\r\n at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)\r\n at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)\r\n at NHibernate.Impl.SessionImpl.Flush()\r\n at Sage.SalesLogix.Activity.Entities.History.Save() in c:\\Users\\mmukherjee\\AppData\\Roaming\\Sage\\Platform\\Output\\implementation\\History.cs:line 1180\r\n at Sage.SalesLogix.Activity.Entities.History.Sage.Platform.Orm.Interfaces.IPersistentEntity.Save() in c:\\Users\\mmukherjee\\AppData\\Roaming\\Sage\\Platform\\Output\\implementation\\History.cs:line 1294\r\n at Sage.Platform.NHibernateRepository.NHibernateRepository.SaveImpl(Object instance)\r\n at Sage.Platform.NHibernateRepository.NHibernateRepository.Sage.Platform.Repository.IRepository.Save(Object instance)\r\n at Sage.Platform.EntityFactory.Save(Object instance)\r\n at Sage.Platform.SData.RequestHandlerBase`3.SaveEntity(TEntity entity)\r\n at Sage.Platform.SData.RequestHandlerBase`3.InternalPost(TFeedEntry entry, Nullable`1 uuid)\r\n at Sage.Platform.SData.RequestHandlerBase`3.InternalPost(TFeedEntry entry, IJobStatus status, Nullable`1 trackingId)\r\n at Sage.Platform.SData.RequestHandlerBase`3.<>c__DisplayClass19.<Post>b__18(IJobStatus status, Nullable`1 trackingId)\r\n at Sage.Platform.SData.RequestHandlerBase`3.PostAsyncJob(Action`2 action)\r\n at Sage.Platform.SData.RequestHandlerBase`3.Post(TFeedEntry entry)\r\n at Invoke2202c1096f1d4b8a86fae220935ab1d2.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)\r\n --- End of inner exception stack trace ---",
"hashCode": "FA95BF4E-972DB1B2-5DE0DC1C",
"pid": 5336,
"identity": {
"name": "rjohnson",
"isAuthenticated": true,
"authenticationType": "Forms"
},
"version": "8.1.0.1179",
"logger": {
"level": "ERROR",
"location": "Sage.Platform.Diagnostics.ErrorHelper.LogException(:0)",
"name": "Global",
"message": "Integration Messaging MessagingService unhandled exception [Saleslogix Error Id=SLX5480C6CD222A3A8]"
},
"request": {
"looksLikeAjax": true,
"isLocal": false,
"method": "POST",
"url": "http://slgx.hydroinc.com:3333/slxclient/slxdata.ashx/slx/dynamic/-/history?_includeContent=false&for...
"referrer": "http://slgx.hydroinc.com:3333/slxclient/Contact.aspx?entityid=C0Z42A0010ZE&modeid=Detail",
"ipAddress": "68.67.119.254",
"userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.104 Safari/537.36",
"userLanguages": "en-US; en;q=0.8"
},
"oleDbException": {
"errorCode": -2147217833,
"hresult": "0x80040E57",
"errors": [
{
"message": "The statement has been terminated. : String or binary data would be truncated.",
"nativeError": 0,
"sqlState": "",
"source": "SalesLogix OLE DB Provider"
}
]
},
"browser": {
"type": "Chrome38",
"name": "Chrome",
"version": "38.0",
"majorVersion": 38,
"minorVersion": 0.0,
"platform": "WinNT"
},
"server": {
"machineName": "SLGX",
"timeZone": "Central Standard Time",
"commandLine": "C:\\Windows\\SysWOW64\\inetsrv\\w3wp.exe -ap \"SalesLogix\" -v \"v4.0\" -l \"webengine4.dll\" -a \\\\.\\pipe\\iisipm5b8ff24a-c88e-436c-8805-8520523efd0c -h \"C:\\inetpub\\temp\\apppools\\SalesLogix\\SalesLogix.config\" -w \"\" -m 0",
"versionString": "Microsoft Windows NT 6.1.7601 Service Pack 1",
"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": "AVANTE\\WebDLL",
"authenticationType": "Forms",
"impersonationLevel": "Impersonation",
"isAnonymous": false,
"isGuest": false,
"isSystem": false
}
}
}

 

Any help in this regrd will be higahly appreciated.

 

Thanks

Malay

Highlighted
Copper Elite Contributor
Posts: 40
Registered: ‎03-31-2010

Re: Issue related To Complete Activity in SLX 8.1 with Update 03

We were experiencing the same issue and found that it had to do with picklists that were stored in offline data and the client side logic was using the text value when it was expecting to use the code value (smaller).

 

We eventually found a little 'Refresh Picklist Data' button on the General tab of the User Options in the webclient.  This seemed to fix the problem for the user/machine that was experiencing the problem.  We only use FireFox so I don't know about the other browsers.

 

 

James Sutton