TM1 Forum

Hi All,

I'm using PAX 2.0.8
We have a new process that connect through ODBC to a view in Oracle 11g.

While i'm getting results in PL-SQL, tm1 showing me only the view headers (wo data).
Based on posts in this forum, I already done the follows without any success.

1. Checked that cfg file contains:
SQLFetchScroll=T
UseSQLExtendedFetch=T

2. I checked only one column to make sure there is no problem with one of the column and it still shows nothing

Thanks for helping
Roei

Are you using the same user in the ODBC as you are when running the query yourself? Sounds like security rights for the ODBC user to me.

Hi,

Thanks for your answer.
Yes, it's the same user and still don't work

Roei

Hi,
Do you still have the issue? I think only one of the parameters cab be used in one setting. I am not sure.

Paul.