Query timeout expired error when launching SMI Report Designer 2-3

Entry Type: Program Issue

Product: Sage ERP MAS 500

Application: Sage MAS Intelligence

Version Reported: 7.30

Status:

Resolved with the Query timeout expired error program fix.

Subject:

Query timeout expired error when launching SMI Report Designer 2-3.

Steps to Duplicate:

1. Open MAS Intelligence / Tools / Report Manager
2. Open Designer / Financial Reports Designer 2-0
3. Select Financial Year 2011 and budget Set 1
4. Click Ok
   Note: Report will generate in Excel successfully
5. Exit Sage MAS Intelligence [Report Manager]
6. Download SMI_111630_46602 for Sage ERP MAS 500 7.30
7. Follow installation steps on SMI_111630_46602_Instructions.pdf file
8. Open MAS Intelligence / Tools / Report Manager
9. Open Designer/ Financial Reports Designer 2-3
10. Select Financial Year 2011 and budget Set 1
11. Click Ok
    Note:  Report will eventually timeout and user will get a Query Timeout expired error message
    Description : Query timeout expired
    Number : -2147217871
    Source : Microsoft SQL Server 10.00.4064
    Driver Error : Unknown
    SQL State : Unknown

Expected Behavior:

Financial Reports Designer 2-3 should not timeout

Possible Workaround:

None