Request Not Found

[Former Member]

Hi All,

My DTP is failing due to " Request Not found error".

I am loading data directly to infocube from PSA and my data source is built on a table.

The mode of data load is full.

Alternate Packages of DTP are failing throwing this error.

Screenshot attached for clarity.

Checks that i already performed.

1. Replicated my data source and reloaded the data

2.Checked PSA and found that last delta request is already loaded and present..(the one extracted by DTP)

Pls help.

[Former Member]

Ok Guys,

Will close the thread now.

Thanks fr the help.

Nayab

[former_member182470]

Nice assignment..

[Former Member]

Hi Guys,

Sharing the long text..

[RamanKorrapati]

Some inconsistency issue at your dtp level. while reactivating your dtp its solved your issue.

As its full load,can you change optimal pkg to 0 and trigger your dtp. it will run.

once its completed your full load, just delete latest request which you loaded to test. other wise target will have double records.

[Former Member]

Hi Nayab

Can you check SBIW -> Settings for data transfer, if it helps?

Anoop

[former_member182470]

Before running DTP, please check your PSA req has got Not Updated to data targets Status or not.

Have you selected "Get data only once" or "Req by Req" or any other settings.

I suggest you run a simple delta DTP without any semantic groups.

[Former Member]

Hi Suman,

As you can see from my above reply error is now resolved.

can you please help on why the error appeared as i am not very clear  on it?

thanks

nayab

[former_member182470]

Have you set the Optimal size to Zero or it is by default? I think it's a new feature in BW 7.3. You have given the reason in your reply itself.

Usually default package size is 50000. It's advisable to keep that.

[Former Member]

Hi Suma,

It was set to zero initially . In the course of discussing this thread  i changed to 50000  and load  was succesfull.

But im not getting hw the error is related to package size?

Regards

Nayab

[RamanKorrapati]

Data always moves to target thru data packets. as per the data volume we set data packet sizes 10000 to 50000.

if you set 0 mean, nothing will read. it says there is no request  mean there is no request which have  0 records at PSA. all your psa request some data with record numbers(1 to XXXXXXXXXXXX) when set at 0 it look for 0 records where there is no request at your psa.

This very simple and general one. try to understand.

[Former Member]

Ok Raman,

However we were having succesfull data loads with "0" optimal setting before today..

It was only today that the error cropped up....

Dont you u think it is deviating from our understanding.

[RamanKorrapati]

Fine, If you share exact error message, it will help us find what caused your issue to get above error.

Always better to share the error message with long text. that would help us to understand what is real issue.if possible to share, please

[former_member182470]

Can you click on Question Mark symbols in your error messages of your screen shot? Every alternate data package is failing because of your BGD settings. If you keep 1 BGD, then you see all may fail or all may pass.

[RamanKorrapati]

Hi Nayab,

From your screen shot please share the error message of Ltxt(yellow icon).

Have you seen your PSA have un loaded request. as you siad its full load, then you need delete the old request and load the new request.

if your DTP is not find the request mean your PSA table may have in consistency.

so please take you PSA table and the adjustment at SE14 and Do the repait of your psa table at RSRV.

Thanks

[Former Member]

Hi nRaman,

thanks for your suggestions..

Actually we resolved the issue now..

In DTP settings optimal package size wa set as "0" and the PSA request has 2.5 million records in more than 200 packets.

So for some packets in DTP it was not reading anything from PSA.

I changed the size to 50000 and succesfully completed the load.

However i am still not clear on error behaviour.Hope you could clarify this for me...

Cheers

Nayab

[RamanKorrapati]

As you said packet size 0, that leads to issue. when set as 0, then nothing will read from source. that's issue. so no problem already resolved. always remember or copy paste errors on doc, keep maintaining such errors. its goof for you in near future.