Error while accessing Oracle DB through IS

[former_member186897]

Hi All,

I am facing an issue while accessing any of the database in Oracle. It has successfully created the connection in IS but it throws SQL Syntax error when I try to access that. Can anybody help me who have faced the similar issue? Appreciate the help. I am using Oracle 11g.

Thanks,

MS Ansari

[former_member186897]

The problem is with the order by clause where it accessing able_name instead of table_name. Is this a bug from SAP?

[Former Member]

Hi Ansari,

May i know which version of IS you are using. It would be good if you can provide the complete platform details.

Thanks,

Ramakrishna Kamurthy

[former_member186897]

Hi Ram,

It is IS 4.2 and Oracle 11g. OS is Linux. Thanks !

[Former Member]

Hi Ansari,

Have you tried to access the same database through Data Services in IS Server? If not, try to create DataStore to connect the database and create a test ETL job to read data from the table.

If you already have Profiler configuration setup, try to do profiling a table (from this database) in DS, let see how it works. If you not find any issue here, then there will be problem in IS side.

Thanks,

Ramakrishna Kamurthy