Error update Address record in CRM 2018 R3

This question has suggested answer(s)
CRM Address Error Message.gif

When I update and address record, whether it is under a company or a person, it gives me the attached error messages.  If I click on the Address tab to continue it refreshes the screen and the address shows correctly.  Any thoughts on why we are getting this.  We recently upgraded to CRM 2018 R3 - on premise.

All Replies
  • Any address or just one ?

  • What does the SQL log say? Is there an custom code in the address screen?

    Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm


  • It happens on all addresses, but only when I make a change.

  • Could you post an extract from the SQL logfile please.

    Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm

  • Jan 2 2019 9:29:35.719 5136 4620 1 fqopen,time,sql,errormsg 16 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:36.375 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:36.828 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:37.282 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:37.719 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:38.172 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:38.610 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:38.641 5136 6240 3 fselectsql,time,sql 46 select  (SELECT CASE WHEN (COUNT(*) > 1) then 'yes' ELSE 'no' END FROM address_link WHERE AdLi_AddressId = Addr_AddressId  AND ADLI_deleted IS NULL and adli_type IS NULL) as addr_IsMultiLinked,  vSummaryPerson.* from vSummaryPerson where Pers_PersonId=21033 AND  (comp_secterr is null OR (comp_secterr>=-2147483638 AND comp_secterr<=-2041200297) OR (comp_secterr>=-2041200296 AND comp_secterr<=-1649630095) OR (Comp_PrimaryUserId=78) OR (comp_CreatedBy=78) OR (comp_secterr>=-1649630093 AND comp_secterr<=-1490764468) OR (comp_secterr>=-1649630094 AND comp_secterr<=-1014167597) OR (comp_secterr>=-1014167596 AND comp_secterr<=-630428799) OR (comp_secterr>=-630428797 AND comp_secterr<=-612528444)) AND (pers_secterr is null OR (pers_secterr>=-2041200296 AND pers_secterr<=-1649630095) OR (pers_secterr>=-2147483638 AND pers_secterr<=-2041200297) OR (pers_CreatedBy=78) OR (Pers_PrimaryUserId=78) OR (pers_secterr>=-1649630094 AND pers_secterr<=-1014167597) OR (pers_secterr>=-1649630093 AND pers_secterr<=-1490764468) OR (pers_secterr>=-630428797 AND pers_secterr<=-612528444) OR (pers_secterr>=-1014167596 AND pers_secterr<=-630428799))

    Jan 2 2019 9:29:38.907 5136 6240 3 execsql,time,sql 0 UPDATE Users SET User_RecentList=N'Company"Flavorchem Inc.","Centre For Probe Development And Commercialization","Sterimax Inc",Intertek,"Aevitas Inc.","ExVivo Labs Inc.","La Corporation d''Entretien Prédictif","SGS Canada Inc.","SGS ILC Micro-Chem Inc.","Virox Technologies Inc.","University of Western Ontario","ani Pharmaceuticals, Inc.","University of Waterloo","Suncor Energy","SGS Environmental Services (London)","Deb Worldwide Healthcare Inc.","S.C Johnson & Sons"200X1X8316,200X1X10304,200X1X10571,200X1X7384,200X1X8071,200X1X12909,200X1X11953,200X1X7024,200X1X7709,200X1X11218,200X1X6587,200X1X6733,200X1X6551,200X1X12141,200X1X7967,200X1X8285,200X1X5139Lead"2016 Q4 HALO Challenge"192X44X3640Opportunity"Solvents (Chromasolv)","Syringe Filters","Agilent caps and vials, columns,",consumables,Standards,"HPLC Columns"260X7X459,260X7X638,260X7X405,260X7X400,260X7X390,260X7X387Person"Ivan Serafimovski","Amanpreet Kaur","Jeevan Arumugam","Hei-Yin (John) Chow","Peter Holt-Hindle","Brian amsden","Robert Zhang","Ivan Serafimovski","Luc Beaudet","Ronghua Liu","Shilpa Chitre","Kirsten Rickert","Ron Gold","Sarah Awan","Son Le","Megan Kelman"220X2X21033,220X2X41050,220X2X27813,220X2X40958,220X2X36120,220X2X38579,220X2X41300,220X2X35815,220X2X10975,220X2X26011,220X2X33606,220X2X36603,220X2X35562,220X2X35011,220X2X13017,220X2X39760' WHERE User_UserID=78

    Jan 2 2019 9:29:38.907 5136 6240 3 fselectsql,time,sql 0 select usrc_UserRecordsId from UserRecords  WITH (NOLOCK)  where usrc_EntityId = 13 and usrc_RecordId = 21033 and usrc_UserId = 78 and  usrc_Type = N'Favourites'

    Jan 2 2019 9:29:38.938 5136 6240 3 fqopen,time,sql 15 select * from vPersonPhoneCaption WHERE PLink_RecordId=21033 ORDER BY capt_order, Plink_Type

    Jan 2 2019 9:29:38.985 5136 6240 3 fqopen,time,sql 31 select * from vPersonEmailCaption WHERE ELink_RecordId=21033 ORDER BY capt_order, Elink_Type

    Jan 2 2019 9:29:39.000 5136 6240 3 fselectsql,time,sql 16 SELECT * FROM UserContacts  WITH (NOLOCK)  WHERE Ucnt_UserId = 78 AND Ucnt_PersonId = 21033 AND UCnt_Deleted is NULL

    Jan 2 2019 9:29:39.094 5136 6240 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo  WITH (NOLOCK)  where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Opportunity' or  WkRl_Entity = N'Opportunity') AND (WkRl_Channel = 10 OR COALESCE(WkRl_Channel, 0) = 0) AND  WkRl_RuleType = N'New' ORDER BY WkRl_Order

    Jan 2 2019 9:29:39.110 5136 6240 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo  WITH (NOLOCK)  where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Lead' or  WkRl_Entity = N'Lead') AND (WkRl_Channel = 10 OR COALESCE(WkRl_Channel, 0) = 0) AND  WkRl_RuleType = N'New' ORDER BY WkRl_Order

    Jan 2 2019 9:29:39.188 5136 6240 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers  WITH (NOLOCK)  WHERE User_UserID = 78 AND (User_EmarketingUserId is not null)

    Jan 2 2019 9:29:39.407 5136 6240 3 fselectsql,time,sql 172 SELECT CObj_TableId, Cobj_TargetTable, Bord_Name FROM Custom_Screenobjects INNER JOIN Custom_Tables on CObj_CustomTableIdFK = bord_tableId WHERE  cobj_name = N'ReportsTabGroup' AND  cobj_type = N'TabGroup' AND CObj_Deleted IS NULL

    Jan 2 2019 9:29:39.422 5136 6240 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers  WITH (NOLOCK)  WHERE User_UserID = 78 AND (user_per_admin=3)

    Jan 2 2019 9:29:39.625 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:40.063 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:40.500 5136 4620 3 fselectsql,time,sql 0 select * from vSummaryCompany  WITH (NOLOCK)  where Comp_CompanyId=12598

    Jan 2 2019 9:29:40.516 5136 4620 1 fqopen,time,sql,errormsg 15 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:40.813 5136 6836 3 fqopen,time,sql 0 SELECT DISTINCT table_name as name FROM vSystemViewsCatalog WHERE view_name = 'vCmliAllPersons'

    Jan 2 2019 9:29:41.016 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:41.204 5136 6836 3 fselectsql,time,sql 375 SELECT count(*) as fcount FROM vlistcommunication, vCmliAllPersons  WITH (NOLOCK)  WHERE (((comm_secterr is null OR (comm_secterr>=-630428797 AND comm_secterr<=-612528444) OR (comm_secterr>=-1014167596 AND comm_secterr<=-630428799) OR (comm_secterr>=-1649630094 AND comm_secterr<=-1014167597) OR (comm_secterr>=-1649630093 AND comm_secterr<=-1490764468) OR (comm_CreatedBy=78) OR (CmLi_Comm_UserId=78) OR (comm_secterr>=-2041200296 AND comm_secterr<=-1649630095) OR (comm_secterr>=-2147483638 AND comm_secterr<=-2041200297)) AND (comp_secterr is null OR (comp_secterr>=-2147483638 AND comp_secterr<=-2041200297) OR (comp_secterr>=-2041200296 AND comp_secterr<=-1649630095) OR (Comp_PrimaryUserId=78) OR (comp_CreatedBy=78) OR (comp_secterr>=-1649630093 AND comp_secterr<=-1490764468) OR (comp_secterr>=-1649630094 AND comp_secterr<=-1014167597) OR (comp_secterr>=-1014167596 AND comp_secterr<=-630428799) OR (comp_secterr>=-630428797 AND comp_secterr<=-612528444)) AND (lead_secterr is null OR (lead_secterr>=-630428797 AND lead_secterr<=-612528444) OR (lead_secterr>=-1014167596 AND lead_secterr<=-630428799) OR (lead_CreatedBy=78) OR (lead_secterr>=-1649630094 AND lead_secterr<=-1014167597) OR (lead_secterr>=-1649630093 AND lead_secterr<=-1490764468) OR (lead_AssignedUserId=78) OR (lead_secterr>=-2041200296 AND lead_secterr<=-1649630095) OR (lead_secterr>=-2147483638 AND lead_secterr<=-2041200297)) AND (pers_secterr is null OR (pers_secterr>=-2041200296 AND pers_secterr<=-1649630095) OR (pers_secterr>=-2147483638 AND pers_secterr<=-2041200297) OR (pers_CreatedBy=78) OR (Pers_PrimaryUserId=78) OR (pers_secterr>=-1649630094 AND pers_secterr<=-1014167597) OR (pers_secterr>=-1649630093 AND pers_secterr<=-1490764468) OR (pers_secterr>=-630428797 AND pers_secterr<=-612528444) OR (pers_secterr>=-1014167596 AND pers_secterr<=-630428799)))) AND ( CmLi_Comm_PersonIdv=21033 and cmli_commLinkId = cmli_commLinkIdv  AND  comm_status = N'Pending' AND comm_type <> 'RecuMaster' AND  ((COALESCE(Comm_Private, N'') = N'') OR ((COALESCE(Comm_Private, N'') <> N'') AND (CmLi_Comm_UserId = 78)))

    )

    Jan 2 2019 9:29:41.266 5136 6836 3 fselectsql,time,sql 62 SELECT * FROM ( SELECT * , ROW_NUMBER() over(ORDER BY  comm_datetime DESC , Comm_Communicationid DESC ) AS rowranking  FROM vlistcommunication, vCmliAllPersons  WITH (NOLOCK)  WHERE (((comm_secterr is null OR (comm_secterr>=-630428797 AND comm_secterr<=-612528444) OR (comm_secterr>=-1014167596 AND comm_secterr<=-630428799) OR (comm_secterr>=-1649630094 AND comm_secterr<=-1014167597) OR (comm_secterr>=-1649630093 AND comm_secterr<=-1490764468) OR (comm_CreatedBy=78) OR (CmLi_Comm_UserId=78) OR (comm_secterr>=-2041200296 AND comm_secterr<=-1649630095) OR (comm_secterr>=-2147483638 AND comm_secterr<=-2041200297)) AND (comp_secterr is null OR (comp_secterr>=-2147483638 AND comp_secterr<=-2041200297) OR (comp_secterr>=-2041200296 AND comp_secterr<=-1649630095) OR (Comp_PrimaryUserId=78) OR (comp_CreatedBy=78) OR (comp_secterr>=-1649630093 AND comp_secterr<=-1490764468) OR (comp_secterr>=-1649630094 AND comp_secterr<=-1014167597) OR (comp_secterr>=-1014167596 AND comp_secterr<=-630428799) OR (comp_secterr>=-630428797 AND comp_secterr<=-612528444)) AND (lead_secterr is null OR (lead_secterr>=-630428797 AND lead_secterr<=-612528444) OR (lead_secterr>=-1014167596 AND lead_secterr<=-630428799) OR (lead_CreatedBy=78) OR (lead_secterr>=-1649630094 AND lead_secterr<=-1014167597) OR (lead_secterr>=-1649630093 AND lead_secterr<=-1490764468) OR (lead_AssignedUserId=78) OR (lead_secterr>=-2041200296 AND lead_secterr<=-1649630095) OR (lead_secterr>=-2147483638 AND lead_secterr<=-2041200297)) AND (pers_secterr is null OR (pers_secterr>=-2041200296 AND pers_secterr<=-1649630095) OR (pers_secterr>=-2147483638 AND pers_secterr<=-2041200297) OR (pers_CreatedBy=78) OR (Pers_PrimaryUserId=78) OR (pers_secterr>=-1649630094 AND pers_secterr<=-1014167597) OR (pers_secterr>=-1649630093 AND pers_secterr<=-1490764468) OR (pers_secterr>=-630428797 AND pers_secterr<=-612528444) OR (pers_secterr>=-1014167596 AND pers_secterr<=-630428799)))) AND ( CmLi_Comm_PersonIdv=21033 and cmli_commLinkId = cmli_commLinkIdv  AND  comm_status = N'Pending' AND comm_type <> 'RecuMaster' AND  ((COALESCE(Comm_Private, N'') = N'') OR ((COALESCE(Comm_Private, N'') <> N'') AND (CmLi_Comm_UserId = 78)))

    ) ) as A  WHERE rowranking > 0 and rowranking < 26

    Jan 2 2019 9:29:41.282 5136 6836 3 fselectsql,time,sql 0 select cobj_customcontent from custom_screenobjects  WITH (NOLOCK)  where  cobj_name = N'CommunicationList'

    Jan 2 2019 9:29:41.282 5136 6836 3 fselectsql,time,sql 0 select usrc_UserRecordsId from UserRecords  WITH (NOLOCK)  where usrc_EntityId = 13 and usrc_RecordId = 21033 and usrc_UserId = 78 and  usrc_Type = N'Favourites'

    Jan 2 2019 9:29:41.438 5136 6836 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo  WITH (NOLOCK)  where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Opportunity' or  WkRl_Entity = N'Opportunity') AND (WkRl_Channel = 10 OR COALESCE(WkRl_Channel, 0) = 0) AND  WkRl_RuleType = N'New' ORDER BY WkRl_Order

    Jan 2 2019 9:29:41.454 5136 6836 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo  WITH (NOLOCK)  where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Lead' or  WkRl_Entity = N'Lead') AND (WkRl_Channel = 10 OR COALESCE(WkRl_Channel, 0) = 0) AND  WkRl_RuleType = N'New' ORDER BY WkRl_Order

    Jan 2 2019 9:29:41.625 5136 6836 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers  WITH (NOLOCK)  WHERE User_UserID = 78 AND (User_EmarketingUserId is not null)

    Jan 2 2019 9:29:41.672 5136 6836 3 fselectsql,time,sql 0 SELECT CObj_TableId, Cobj_TargetTable, Bord_Name FROM Custom_Screenobjects INNER JOIN Custom_Tables on CObj_CustomTableIdFK = bord_tableId WHERE  cobj_name = N'ReportsTabGroup' AND  cobj_type = N'TabGroup' AND CObj_Deleted IS NULL

    Jan 2 2019 9:29:41.704 5136 6836 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers  WITH (NOLOCK)  WHERE User_UserID = 78 AND (user_per_admin=3)

    Jan 2 2019 9:29:41.907 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:42.344 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:42.782 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:43.219 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:43.672 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:44.110 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:44.547 5136 4620 1 fqopen,time,sql,errormsg 0 select * from Address_Link where AdLi_CompanyID = 12598 and AdLi_AddressId = undefined and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')

    Invalid column name 'undefined'

    Jan 2 2019 9:29:45.016 5136 4620 3 execsql,time,sql 15 UPDATE Address SET addr_idlocation=NULL,addr_locationdescription=NULL,addr_address1=N'4000, 585 8th Ave. SW',addr_address2=NULL,addr_address3=NULL,addr_address4=NULL,addr_city=N'Calgary',addr_state=N'AB',addr_postcode=N'T2P 1G1',addr_country=N'CA',addr_UpdatedBy=73,addr_TimeStamp='20190102 09:29:45',addr_UpdatedDate='20190102 09:29:45' WHERE (Addr_Addressid=46792)

    Jan 2 2019 9:29:45.047 5136 4620 3 execsql,time,sql 16 UPDATE Journal SET Jour_DBChangeType=1,Jour_IntegrationID=NULL,Jour_UpdatedBy=73,Jour_TimeStamp='20190102 09:29:45',Jour_UpdatedDate='20190102 09:29:45' WHERE (Jour_TableID = 1 AND Jour_RecordId IN (SELECT Addr_AddressId FROM Address WITH (NOLOCK)  WHERE Addr_Addressid=46792))

    Jan 2 2019 9:29:45.079 5136 4620 3 execsql,time,sql 16 INSERT INTO TableScriptsLogs(TLog_ScriptID,TLog_UserID,TLog_Function,TLog_Message,TLog_WhereClause,TLog_CreatedBy,TLog_CreatedDate,TLog_UpdatedBy,TLog_UpdatedDate,TLog_TimeStamp,TLog_ID)  VALUES (10009,73,N'UpdateRecord',N'addr_idlocation jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_locationdescription jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address1 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address2 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address3 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address4 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_city jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_state jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_postcode jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_country jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_idlocation jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_locationdescription jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address1 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address2 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address3 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_address4 jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_city jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_state jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_postcode jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    addr_country jscript error: [SafeCall Exception]: SQL Error Line: 2 Char: 282

    ',N'Comp_CompanyId=12598',73,'20190102 09:29:45',73,'20190102 09:29:45','20190102 09:29:45',2991)

  • is this system integrated into a Sage accounts system? It appears there is custom code in the Address Screen that is erroring rather than this being a standalone system.

    If there is no customisation done by yourselves it would be worth logging with your local Sage OpCo support.

    If you want to post the script code (maybe against fields) we can see if there is any advice to give.

    Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm

  • From the logs you appear to be integrated. Not knowing the target F&O system, it's difficult as i know Sage200 integration.

    That said.

    You appears to have custom address types. You haven't removed the standard ones have you ?

    The script that is failing is probably on the address_link table. Ensure this hasn't been customized. If it has then replace it with the vanilla script and see if the error persists. Also the field addr_idlocation is unknown to my as well which suggests another customisation. But the update is occuring correctly, it's just when the TLS fires the error occurs. Focus on the TLS script.

  • It is integrating with Sage 300. As far as I know there are no customizations made this the standard fields.

  • For anyone else looking at this post and having the same problem there is an article I found that fixed the problem.  It is a known problem that will be addressed in a future product update.

    Resolution

    This is a workaround until fix is available.

    Change AddressBoxLong Screen - Administration, Customisation, Under Secondary Entities, Address, Screens, AddressBoxLong (Address Entry Screen)

    Change Values("Addr_AddressId") to Values("Key3") for each CreateScript. By default each field has a create script associated with it.

    The script will now read as:

    if (Values("Act") == 240) {var AccpacQuery = eWare.CreateQueryObj("select * from Address_Link where AdLi_CompanyID = " + eWare.GetContextInfo('Company', 'Comp_CompanyId') + " and AdLi_AddressId = " + Values("Key3") + " and (AdLi_Type like 'AR%' or AdLi_Type like 'AP%')");AccpacQuery.SelectSql(); if (!AccpacQuery.eof) ReadOnly = true;}

    Select Update, and Save.

  • see above