x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 6 replies
  • Subscribers 74 subscribers
  • Views 541 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
willhoward

Update Record Error - Email PhoneEmailEntity UpdateRecrd jscript error

Posted By

Hi,

We are using 7.3SP3 and Sage 300 ERP 2014.

When standard users try to update company records they are receiving the below error;

I believe the issue is in the PhoneEmailEntity table script, however there are less than 210 lines in the table script so I'm a little lost.

Normal Sage Logs have not shown anything and I'm not sure which .config file needs customErrors turning off for more information.

To note we have not modified the PhoneEmailEntitiy table script.

Does anyone have any information on this particular error and how to resolve?

Thanks

  • 0

    Hi willhoward, any updates on this? We're also trying to look for relevant info on this but so far we'd had no such luck.

  • 0

    We've had another occurrence of this error. It seems to be standard user accounts that experience the issue.

    Turned logging up to max and got this in SQL logs;

    Jun 1 2017 15:05:16.637 2288 5480 3 execsql,time,sql 0 INSERT INTO TableScriptsLogs(TLog_ScriptID,TLog_UserID,TLog_Function,TLog_Message,TLog_WhereClause,TLog_CreatedBy,TLog_CreatedDate,TLog_UpdatedBy,TLog_UpdatedDate,TLog_TimeStamp) VALUES (10009,50,N'UpdateRecord',N'Email PhoneEmailEntity UpdateRecord jscript error: Server encountered an internal error. For more information, turn off customErrors in the server''s .config file. Line: 210 Char: 4

    ',N'Comp_CompanyID = 2016',50,'20170601 15:05:16',50,'20170601 15:05:16','20170601 15:05:16')

    To note, we use Sage 300 ERP 2014.

    I created a test Company record and had the user that's experiencing the issue, try and edit the phone/email details.

    The user did not get the error when editing that test companies phone/email details.

    It seems to be that any Company records that are sync into Sage 300 have an issue being updated by non admin accounts.

    Is this an issue with the Sage CRM/ERP Connector?

  • 0

    Hi Will

    Can you clarify - non admin accounts - do you mean Sage CRM non-admin users, or the Sage 300 account associated with the user in Admin/Users. In my 2017 Sage CRM/2017 Sage 300 system, a non admin CRM user can edit the phone number of a synced customer (but this user is using the ADMIN account to access Sage 300).

    Tom

  • 0

    Hi Tom,

    We've actually resolved the issue late yesterday evening. I hadn't had chance to come and close this question.

    It was a Sage 300 permissions issues.

  • 0

    Thanks for the update, Will! Now we know the reason why this issue is happening.

  • 0

    Willhoward, how did you fix this?

*Community Hub is the new name for Sage City