Troubleshooting
Problem
Executing a SELECT statement to query/retrieve data from a memory optimized table may result in an error due to compatibility issues with ODBC Driver 13 for SQL Server.
Diagnosing The Problem
Review the tm1server.log file to ensure the problem is related to a memory optimized table.
tm1server.log: "...[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master."
Resolving The Problem
In Planning Analytics Administration, review the driver type selected for the data source that was created.
Steps:
1. Log into Planning Analytics Workspace
2. Click on Administration
3. Click on the Secure Gateway tab
4. Select your Secure Gateway connection
5. Click on the Data sources tab
6. Click on the 3 dots to the right of the data source connection
7. Select Edit
8. Click Show DSN
If ODBC Driver 13 for SQL Server is the driver type, recreate the data source connection so the driver is ODBC Driver 11 for SQL Server.
Then log out and log back into the application, and re-run the same query.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
20 September 2021
UID
ibm16251307