slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Mobile/PDA/Handhelds
Forum to discuss use of SalesLogix with mobile devices including SalesLogix mobile and other mobile solutions. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Mobile/PDA/Handhelds | New Thread

View: Search:

Author

Thread: Error messages auto generated by SLX Mobile Enterprise Server

Tammi Drawbaugh
Posts: 5

Error messages auto generated by SLX Mobile Enterprise Server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Apr 09 10:13 PM

This is for Blackberry mobile v5.1 (and we are using web v7.5). We are experiencing error messages for one person - such as below. I don't know what the user is doing yet - but I have to fix it. Can anyone tell me why the error message is being generated and/or how to fix it?

This is an automated e-mail generated by SalesLogix Mobile Enterprise Server.
An event occurred at 4/25/2009 11:57 AM .
Description: 11:57 AM,Error,Sync Runtime,,,Error in executing client to server table sync action :Error executing OleDB statement from OleStatementBuilder (insert into history (priority,result,completeddate,opportunityid,contactid,activityid,timeless,type,duration,userid,accountname,description,contactname,recurring,modifyuser,accountid,category,modifydate,username,createuser,completeduser,startdate,historyid,createdate,longnotes,opportunityname,originaldate,notes) values (null,null,'2009-04-25T16:50:00',null,null,null,'T',262148,0,'U6UJ9A00000E','Corporate Express Business Interiors, a Staples Company','derek majors reports liberty shool awarded
al jones working on lees summit sd',null,null,'U6UJ9A00000E','A6UJ9A0004IX',null,'2009-04-25T16:52:33','Gary Suse','U6UJ9A00000E','U6UJ9A00000E','2009-04-25T00:00:05','hGS02Z00006D','2009-04-25T16:52:33',null,null,'2009-04-25T00:00:05',null)) - The statement has been terminated. : String or binary data would be truncated.

Thanks!
Tammi

[Reply][Quote]

Steve Robertson
Posts: 146

Re: Error messages auto generated by SLX Mobile Enterprise Server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Apr 09 7:04 AM

Hi Tammi,

It looks like the user is entering too much data in the description field:

"derek majors reports liberty shool awarded al jones working on lees summit sd"

The text the user eneterd is 77 Characters long but the Description field in the History Table is only 64 characters. You could get the user to use the Notes field.

Cheers,

Steve

[Reply][Quote]

Tammi Drawbaugh
Posts: 5

Re: Error messages auto generated by SLX Mobile Enterprise Server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Apr 09 9:05 AM

Hi Steve - Thank you so much for the quick reply! I thought that was the case and looked at my "description field" as the notes section. When I tested that myself, I discovered that I could enter alot of data (via the web or BB and it would come across both directions). So I quickly realized that the "notes" and "description" aren't one in the same. This may sound stupid but...... I can't find a field called "description" on my BB. How can I find out excatly which field this would be that the user is entering the data into (short of calling the user). If I have someone look at the sql database would they be able to tell me which field this is (and then determine what I have re-named it)?

Thanks,
Tammi

[Reply][Quote]

Steve Robertson
Posts: 146

Re: Error messages auto generated by SLX Mobile Enterprise Server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Apr 09 9:22 AM

Hi Tammi,

It will be the field labeled as Regarding.

Cheers,

Steve

[Reply][Quote]

Tammi Drawbaugh
Posts: 5

Re: Error messages auto generated by SLX Mobile Enterprise Server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Apr 09 9:41 AM

Steve.....you are a saint!!! Thank you so much. I have looked at the users data and you are excatly right. Now I have a training issue to deal with.

I posted another thread on several other auto generated emails that I am looking for clarification on. Can you help with any of those by chance?

Thanks,
Tammi

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/2/2024 9:46:26 AM