cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to use a HANA table in table comparison transform in BODS

Former Member
0 Kudos

Hi Team,

In a job I am trying to use a HANA table as comparison table. This is a permanent table in HANA.

But while using as comparison table its not showing the list of columns on the out put schema of the transform. If I validate the job it's showing the error - The table has not been imported. But this table is imported and already exist in the data store as a permanent table.

Re importing the table also didn't help to resolve the issue.

Can anyone let me know what may be the reason for this issue ? This problem is there with all tables from this particular HANA schema.

Thanks,

Deepa

Accepted Solutions (0)

Answers (5)

Answers (5)

0 Kudos

Did someone find a solution?

Former Member
0 Kudos

Hi Everyone,

I am facing similar problem with Oracle Table, I am able to use that table as a source and target both but the schema is not populating while using that table in table comparison. For other tables in same data stores, Table comparison is working fine.

Regards

aasavaribhave
Advisor
Advisor
0 Kudos

What Hana revision is it - that would be important. Can you try creating a new Hana datastore pointing to same instance and import the specific table in it and try to use it as comparison table.

Former Member
0 Kudos

Hi Aasavari,

Thanks for replying.

Yes, I am able to use the table as source, target and also able to view the data. We are using BODS 4.2.7 and HANA 1.x. I believe we don't have a problem because of the versions. Because on the same BODS instance, we are able to use table from another HANA datastore(different HANA server) with version 1.x as comparison table.

As you said table comparison transform is not able to read the table data. That is the problem.

While validating it's showing the error table not has been imported. But indeed its imported. I re importing it several times too.

Thanks,

Deepa

aasavaribhave
Advisor
Advisor
0 Kudos

are you able to view data on that table or use it as source? If the issue is specific to all tables in a particular schema - tables from other schemas actually work fine? Check optimized SQL for the DF - is it reading from comparison table? what's DS version and Hana revision?