Skip to Content
avatar image
Former Member

BODS Delta Job Issue

Hi All,

I have an issue facing in bods delta load.

I have job in production for both full load and delta load.

I got requirement to do filters in one data flow and I have done in where condition.

I am doing full load changing parameter in script for 60 days.

$START = sysdate () - num_to_interval(60, 'D');

Once the full load job is successful, we are changing the parameter in the same job to 15 days and activating the scheduler to run for every 1 hour.

$START = sysdate () - num_to_interval(15, 'D');

Example: full load starts from 24-Nov-2016 and loads till 23-Jan-2017.

For delta when I changed parameter to 15..it will take date from 10-Jan-2017 but when loading delta I am getting integrity constraint violation error in data flow.

Before the filters applied once the full load job is successful and used to change parameter to 15 for delta and I was activating the scheduler to run accordingly.It was working fine.

After my change in filters when I am performing the same , it gives the error :(

Thanks in advance for help..Suggest me on this..!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 26, 2017 at 06:47 AM

    how your data flow looks like... what are te transforms used between source and target.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ravi,

      We are using Source tables from SAP and Non-SAP systems and target into HANA , in between we used only Query transforms.

      Thank you.

  • Jan 30, 2017 at 10:34 AM

    Use Table comparison to compare rows between your Source and target. I suggest you use ABAP Data flow for pulling data from SAP tables

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded