DTP pulling zero records

[#1]

Hi folks,

I am facing a problem where-in I have a Std. DSO between a WDSO & a cube. The data from Std. DSO was deleted completely however the WDSO & the cube has data. Now, I want to load data from WDSO to Std DSO. But, my DTP (WDSO --> Std. DSO) is pulling zero records each time I run it. I tried with delta DTP as well as full DTP(with and without Semantic keys). DTP completes with a message -'No more data available'.what could be the problem here?

[former_member199734]

Hi fellas,

Did some body faced this kind of issue? please help on next steps.

[RamanKorrapati]

Hi,

What kind of dtp your running?

is it delta one or full load one?

previous if you ran delta dtp and no loads happens to WDSO then it pulls 0 records only.

if you deleted whole data from Stnd DSO and reloaded whole data WDSO with delta mode then it may pulls whole data.

First load data to WDSO and later you can run your delta dtp to load data to SDSO.

Thanks

[former_member199734]

Hi Raman,

I deleted the whole data of std. DSO and then loaded delta to WDSO and then ran delta DTP (WDSO--> STd DSO). It pulled zero records even though there were records loaded to WDSO through Delta Info package prior to this.

Also tried with full DTP, to load complete data from WDSO. It also didn't pull.

However, if I check the option 'only retrieve last request' in full DTP then it pulls data.

[RamanKorrapati]

As of now your std DSO will be 0 records now.

Try to activate your DSO and transformations.

Later try to load full load dtp  to std DSO from WDSO and see.

if it allowed data then its fine if not then delete old std dso and create new std dso.

Where your facing this issue?

prod to dev?

if its in dev system then delete old std dso and create new std dso and transformations.

later try to load data from WDSO to Std DSO.

[former_member199734]

This is quality system. Deleting the DSO is last option.

[RamanKorrapati]

At dev system, try to load data to old std dso.

if its works then again transport your std DSO to bw quality.

later try to load data to Std DSO at bw quality server and check.

if it won't works then delete and recreate new std dso.

[former_member199734]

Yes..this can be done if we are sure that problem is with DSO only . I already checked this and it's working in Dev.

[RamanKorrapati]

in such case, retransport your std DSO to bwq.

later try to load and check it.

even if its same issue then you can create new std dso at dev system and transport to bwq.