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

An Unexpected Error Occurred: Error Number: [-2147217900] Description : [[ProvideX][ODBC Driver]Unexpected extra token: inner] Source: [Microsoft OLE DB Provider for ODBC Drivers] in Sage MAS Intelligence

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: Connector, Report Manager

Version Reported: 4.40

Status:

This issue is being researched by Engineering.

Subject:

An Unexpected Error Occurred: Error Number: [-2147217900] Description : [[ProvideX][ODBC Driver]Unexpected extra token: inner] Source: [Microsoft OLE DB Provider for ODBC Drivers] when adding a Data Field in Sage MAS Intelligence Connector or Report Manager..

Steps to Duplicate:

In ABC company:

1. Open Connector
2. Expand Enterprise Object
3. Expand Sage MAS (Auto Connect)
4. Right click and select Add Data Containers
5. Select the SQL Query radial button and click OK
6. In the 'Specify a name for the Container' field, enter InvoiceSQL and click OK
7. Highlight the InvoiceSQL object
8. In the 'Source Container (SQL Query)' field, enter the following and click Apply:
• Select * From AR_InvoiceHistoryHeader inner join AR_InvoiceHistoryDetail on AR_InvoiceHistoryHeader.InvoiceNo=AR_InvoiceHistoryDetail.InvoiceNo And AR_InvoiceHistoryHeader.HeaderSeqNo=AR_InvoiceHistoryDetail.HeaderSeqNo
9. Right Click on the InvoiceSQL object and select 'Add Expressions'
10. Verify the 'Data Fields' radial button is selected and click Ok
11. Note the error "An Unexpected Error Occurred: Error Number: [-2147217900] Description : [[ProvideX][ODBC Driver]Unexpected extra token: inner] Source: [Microsoft OLE DB Provider for ODBC Driver" occurs.

Expected Behavior:

The error should not occur and the user should be able to add Data Fields.

Possible Workaround:

None