Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 27, 2016 at 05:54 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2016 at 12:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2016 at 07:28 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2017 at 01:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 14, 2017 at 12:43 PM

    Did someone find a solution?

    Add comment
    10|10000 characters needed characters exceeded