unable to execute infopackage

[former_member186160]

hi all,

i am facing an issue in loading infopackage in BPQ system.

in BPD , we never faced any issue. but now facing issue in BPQ for the same load.

the connections to source system have been maintained correctly.

i have tried editing the package size from 500,1000,2000,5000 etc

we have observed that this load will fail most times.

occasionally it got completed for one package size , but when we reload with same settings, the load failed.

below snapshot shows the error message:

please suggest.

[Former Member · Accepted solution]

Hi,

Pl put the details of the error...

[former_member186160 · Accepted solution]

hi, this is the error message:

[former_member183012 · Accepted solution]

Have you tried with specific selection in to infopackages?please try and let us the result.

[former_member186160 · Accepted solution]

hi, i tried in multiple packages, but i still get same issue.

[former_member183012 · Accepted solution]

Can you please check the setting n your infopackage once

Infopackage ---> Scheduler ----> Default data transfer---> reduce the packet size

I think its currently 20000 if yes pls reduce it to 10000 and try.

[RamanKorrapati · Accepted solution]

Hi Swetha,

Given error message is not enough to suggest solution.

Please check job log details at ECC and BW SM37.

You may find exact error what it is.

ECC job  how to find:

Go to your info pack monitor, Menu Environment-->job overview-->job in the source system--> enter ecc user id and pass word, select your job and click on log details.

see the loading steps in detailed.

BW job:

Go to your info pack monitor, header tab,

copy request id.

go to bw SM37, enter request id as job name: * <copied request id>*.

select status as Cancel/active.

enter proper date ranges and see the details.

Later you can share the error log here.

Thanks

[Former Member]

Hi Swetha

Can you please send me the error message  once you check time consistencies in your system .

what is the volume of data

[former_member185177]

Hi Swetha,

If there is any fromdate and todate in you infopackage selections.  Then use the selections in fromdate or in Todate as mentioned below :

Fromdate / Todate:    19000101   -  99991231

Your problem will be solved.

Regards,

Krishna Chaitanya.

[former_member183012]

Hi swetha,

Random data means I am not getting.Please anlyze your data and then break it on some criteria and then load in parts.like based on year or some other infoobjects.

Regards,

Ganesh Bothe

[KodandaPani_KV]

Hi,

how much data loading form source to target.

use the some filters at data selection load it to target.

ex- year wise, month wise selections.

Thanks,

Phani.

[former_member186160]

hi,

we have approx 1,300,000 records available in source.

requirement is to load all those records to BW.

by using filters, do you mean to create more than one infopackage, and load for different filter values from each infopackage one after the other  ?

please suggest.

[KodandaPani_KV]

Hi,

if you have year wise data please check the data slections at info pacakge.

ex- source have the 2010,2011,2013 use the same filters in info package data selection

not required for creating the multiple info package.

use the same info package trigger the 3 times.

Thanks,

Phani.

[sriramvijay_ravidoss]

Hi,

Is your Data source is delta enabled?

are you doing this as one time init load or daily process chain.

if it is Process chain then you have to create multiple Info package. you can run it parallel also.

-Sriram

[former_member186160]

hi,

datasource is not delta enabled. we are doing full loads.

we need this for daily loads.

the issue is that we are not sure of the dates or any other range to provide filters.

we get random data .

[sriramvijay_ravidoss]

Hi,

The you need to have multiple info packages. Try to enable delta that will be good.

-Sriram