PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **

"Syntax error (missing operator) in query expression '(((tenant.code)='System's of America')) ORDER BY role.name'." error occurs when attempting to open the Security Manager after installing Sage MAS Intelligence.

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: Security Manager 

Version Reported: 7.30.3 / 1.00.0073 

Status:

This issue is being researched by Engineering.

Subject:

"Syntax error (missing operator) in query expression '(((tenant.code)='System's of America')) ORDER BY role.name'." error occurs when attempting to open the Security Manager after installing Sage MAS Intelligence.

Steps to Duplicate:

This issue was specific to a Customer's Database where certain conditions must exist:

• If a colon(') or comma(,) exist in the maintain site registration for the Company Name.
• If a colon(') or comma(,) exist in the maintain company name for the Company Name.

If there is a comma in the Company Name then the Tenant Code System Variable is updated with the name. Example (Tenant Code = System's of America).

When trying to open the Security manager the SMI Registry fails and this error may appear.

Expected Behavior:

The error should not occur if there are any commas or colons in the Company Name.

Possible Workaround:

1. Uninstall Sage MAS Intelligence Database and Client.
2. Update the name in System Manager > Maintain Site and in System Manager > Maintain Company so there are no commas or colons in the name. (Example: Systems of America)
3. Auto-Register MAS 500.
4. Install the Sage MAS Intelligence Client and Database.
5. Auto-Register MAS 500.
6. Confirm that the error is not received any longer in Security Manager then adjust the Company Name as needed.