Phone Lines icon GFI Support

Articles in this section

See more

Error: "Incorrect syntax near 'xyz'. ;Unclosed quotation mark after the character string ''."" When Running UpdateUsers and Consolidating Users

Author: Luis Fernandes Updated

Overview

When running UpdateUsers, it shows a dialog with the error: Incorrect syntax near 'xyz.'; Unclosed quotation mark after the character string ''."

NOTE: The XYZ is any part of a folder name within the user's mailbox.

UpdateUsers's debug logging confirms that it is consolidating users:

MAUpdateUsers.log 2015-01-23,10:03:23,810,1,"#00001188","#00000004","info ","MAUpdateUsers",">Processing - 4368371bab786846b79498297eadbb73, -8224627602919139212, domain\userx" 2015-01-23,10:03:23,825,1,"#00001188","#00000004","info ","MAUpdateUsers"," Found more than one user with the same name." 2015-01-23,10:03:23,825,1,"#00001188","#00000004","info ","MAUpdateUsers"," Updating user 8 to 96." 2015-01-23,10:03:23,825,1,"#00001188","#00000004","info ","MAUpdateUsers"," Updating arc_owners..." 2015-01-23,10:03:26,138,1,"#00001188","#00000004","info ","MAUpdateUsers"," Updating arc_tags..." 2015-01-23,10:03:26,138,1,"#00001188","#00000004","info ","MAUpdateUsers"," tagName: FOLDER_INBOX, tagValue: Inbox, newUser: 96, oldUser: 8, oldUserTagId: -2147483635, newUserTagId: -2147482935." 2015-01-23,10:03:26,263,1,"#00001188","#00000004","info ","MAUpdateUsers"," tagName: FOLDER_INBOX, tagValue: Postvak IN, newUser: 96, oldUser: 8, oldUserTagId: -2147483634, newUserTagId: -2147482892." 2015-01-23,10:03:26,513,1,"#00001188","#00000004","info ","MAUpdateUsers"," tagName: FOLDER_SENT, tagValue: Sent Items, newUser: 96, oldUser: 8, oldUserTagId: -2147483454, newUserTagId: -2147482915." 2015-01-23,10:03:26,638,1,"#00001188","#00000004","info ","MAUpdateUsers"," tagName: FOLDER_SENT, tagValue: Verzonden items, newUser: 96, oldUser: 8, oldUserTagId: -2147483451, newUserTagId: -2147482184." errors.log 2015-01-23,10:03:33,685,1,"#00001188","#00000001","error ","errors","error: Incorrect syntax near 's'. ;Unclosed quotation mark after the character string ''."

To confirm this known issue,  run the following SQL query to see if it returns more than 0 rows:

SELECT * FROM arc_tags WHERE tagValue LIKE '%''%'

 

Environment

20141117

 

Legacy JIRA ID

2874

 

Resolution

Upgrade to 2015 SR1 and use the version of the tool available for this version (or newer).