Question Re: DTP pulling zero records in Technology Q&A

DTP pulling zero records

former_member199734 — Mon, 18 Aug 2014 06:14:33 GMT

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?

Re: DTP pulling zero records

sat_p2 — Mon, 18 Aug 2014 07:21:32 GMT

Hi,

Please try load with Full DTP.

Regards,

Satya.

Re: DTP pulling zero records

Former Member — Mon, 18 Aug 2014 07:31:57 GMT

"No more data available'. will come only when we have already load data into ODS. Go to Manage of Std. DSO and delete the all requests there....

Re: DTP pulling zero records

former_member199734 — Mon, 18 Aug 2014 07:35:26 GMT

Hi Nadeem,

I have deleted all the data once again from std. dso and tried running full load (with/ without filters on fiscal period) but no luck.

Re: DTP pulling zero records

former_member199734 — Mon, 18 Aug 2014 07:36:33 GMT

Hi Satya,

I have tried that already. (after completely deleting std DSO data).

Re: DTP pulling zero records

Former Member — Mon, 18 Aug 2014 07:47:07 GMT

Check all requests in WDSO are active otherwise they won't load to Std. DSO

Re: DTP pulling zero records

former_member199734 — Mon, 18 Aug 2014 07:56:09 GMT

I beleive there is no conccept of activation for WDSO. however, I checked WDSO once again and all the requests are green.

Re: DTP pulling zero records

former_member199734 — Tue, 19 Aug 2014 12:33:06 GMT

Hi fellas,

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

Re: DTP pulling zero records

RamanKorrapati — Tue, 19 Aug 2014 12:38:23 GMT

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

Re: DTP pulling zero records

sat_p2 — Wed, 20 Aug 2014 09:44:28 GMT

Hi,

Please try steps whatever mention Ramanjaneyulu Korrapati .

I am sure it will work...

1. Load some data to WDSO.

2. Delete entire data in SDSO.

3. Load data to SDSO by using Delta DTP or Full DTP.

Regards,

Satya.

Re: DTP pulling zero records

former_member199734 — Thu, 21 Aug 2014 05:31:30 GMT

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.

Re: DTP pulling zero records

RamanKorrapati — Thu, 21 Aug 2014 05:39:25 GMT

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.

Re: DTP pulling zero records

former_member199734 — Thu, 21 Aug 2014 05:44:17 GMT

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

Re: DTP pulling zero records

RamanKorrapati — Thu, 21 Aug 2014 05:50:06 GMT

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.

Re: DTP pulling zero records

former_member199734 — Thu, 21 Aug 2014 05:54:25 GMT

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.

Re: DTP pulling zero records

RamanKorrapati — Thu, 21 Aug 2014 05:56:33 GMT

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.

Re: DTP pulling zero records

gennadiy_tatarintsev — Tue, 26 Aug 2014 09:34:47 GMT

Hi,

have you got any filter values in DTP header tab->Selections? What "REQUID" values are there?