Page 1 of 1
ODBC Read Error
Posted: Fri May 07, 2021 7:02 pm
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.
Re: ODBC Read Error
Posted: Sat May 08, 2021 5:59 pm
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.
Re: ODBC Read Error
Posted: Mon May 10, 2021 2:46 pm
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.
Re: ODBC Read Error
Posted: Mon May 10, 2021 4:44 pm
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.
Re: ODBC Read Error
Posted: Mon May 10, 2021 9:04 pm
by jim wood
I added
to the CFG file but the server log isn't telling me anything more than it was before.
Re: ODBC Read Error
Posted: Mon May 10, 2021 9:06 pm
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.