ODBC Read Error

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

ODBC Read Error

Post by jim wood »

Guys,

I'm testing 2.0.9.2 and I'm getting an ODBC error when I run a process. The process retrieves data from the DB in the preview pane but when I execute it the process runs successfully but when I check the log I see that the server is reporting tm1.sqlapi read error and no data is updated in the cube. Has anybody seen this error?

Thanks,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: ODBC Read Error

Post by gtonkin »

Hi Jim, have you configured a logger for TM1.SQLAPI that is logging the read error? Not sure from your post.
If not, may be worthwhile configuring it - very useful detail when things go wrong.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: ODBC Read Error

Post by jim wood »

Many thanks and no I haven't, but I will now. We think it's a communication issue in in Azure rather a software issue that will help.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ODBC Read Error

Post by Steve Rowe »

We often find turning on or off the Unicode option will get stubborn TI SQL working, though I don't think the preview would work either, worth a double check though.
Technical Director
www.infocat.co.uk
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: ODBC Read Error

Post by jim wood »

I added

Code: Select all

UseSQLExtendedFetch=T
to the CFG file but the server log isn't telling me anything more than it was before.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: ODBC Read Error

Post by jim wood »

Steve Rowe wrote: Mon May 10, 2021 4:44 pm We often turning on or off the Unicode option will get stubborn TI SQL working, though I don't think the preview would work either, worth a double check though.
Thanks Steve. I gave it go, but no dice. I'm pretty sure this is something that's being blocked by Azure. The Azure support team are looking at it as well,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply