Table Comparison Filter Option - Issue in Data Services

[Former Member]

Hi,

We have a scenario where we need to update delta records of Sales Order table from JDE to SAP HANA via BODS.

I have used table comparison to detect the records that need to be updated or inserted.

The issue I am facing is when I try to restrict the amount of records that is going to fill in the cache using filter option then I get the below error even though the column is present in the comparison table.

ERROR MESSAGE : Only columns from a comparison table are allowed in a table comparison filter expression.

I tried the same thing in the other table using filter option in table comparison and it worked perfectly.

I am wondering if there is any limitation on this table comparison filter based on size or number of columns or is it a known bug which needs to be fixed with a sap note.

The target volume is huge with around 14 million records so unless I use the filter the cache will not be able to accommodate the full volume.

Appreciate your help. Thanks in advance.

Also when I had 250+ columns in the target table the datastore was not even available in the filter editor. Only the variables tab was available. Has anyone faced similar issue?

Cheers,
Prashanth

[Former Member · Accepted solution]

This seems to be a bug in BODS which doesn't allow the use of columns in table comparison filter. We have moved to an alternate approach to handle the volumes.

Thanks,
Prashanth