on 10-27-2016 8:17 AM
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
Did someone find a solution?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.