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

"An error occurred creating Sage MAS 500 Intelligence modules, tasks and desktop icons" followed by "ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]Unable to add the tsmTaskPerm record because it is trying to reference a record in tsmUserGroup that does not exist. Reference ID: (R_4283)..." occurs when updating SMI Database

Entry Type: Program Issue

Product:Sage MAS 500 ERP

Application: SMI

Version Reported: 7.30.3

Status:

This issue is being researched by Engineering.

Subject:

"An error occurred creating Sage MAS 500 Intelligence modules, tasks and desktop icons" followed by "ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]Unable to add the tsmTaskPerm record because it is trying to reference a record in tsmUserGroup that does not exist. Reference ID: (R_4283)..." occurs when updating SMI Database

Steps to Duplicate:

In [SOA] company:

1.  Delete several default security group in Maintain Security Group prior to updating SMI
2.  Download and install SMI Server and Client
3.  During SMI Server installation, when prompted, update database by selecting 'Servername' and 'Database name' and select 'OK' button.  Notice error occurs.

Expected Behavior:

SMI should update database successfully

Resolution:

1. Please click HERE to use the Download Manager to download the latest Sage MAS Intelligence Server version for Sage ERP MAS 500
2. Using "Windows Add and Remove Programs," uninstall your current version of Sage MAS Intelligence server for Sage ERP MAS 500
3. Reinstall the latest Sage MAS Intelligence server version