Message missing: Finished saving PSA

[Former Member]

Hi BI Experts,

While loading extracting data from ECC system, infopackage running for long time and one of the Data package stuck in running status with a message "Message missing: Finished saving PSA" and it is used to run at most for an hour.

It causes ABAP runtime error DBIF_RSQL_SQL_ERROR and we can see few tRFC entries failed in tRFC queue.

Have tried extracting by decreasing the size of Data package, even though it causes same result.

Could someone suggest some solution for this case?

Br,

Raviteja M

[Former Member · Accepted solution]

Hi All,

Found the problem.

One of the field in Data Source cannot hold more than 8 digits in our BW system but corresponding field in ECC can hold the value.

So we are enhancing the field length in BW data source.

Hence Problem solved.

Thanks for your responses .

Best Regards,

Raviteja M

[jananipriya · Accepted solution]

Hiii

Good to hear!!!

If possible can you list the steps by which you enhanced the length of field because I'm too having same issue.

Thanks in advance

[RamanKorrapati]

Hi Ravi,

please lets try to activate your psa or data source.

Later cross check your RFC connections between EC and BW.

is this is full load or delta load?

if its full load then again, rerun your info pack and see.

during your load please check ECC SM58 and your ECC info pack job,

Thanks

[Former Member]

Hi Raman,

It is full load(without selections) and it is fetching approximately 29 million records.

Data source has been activated again with RSDS_DATASOURCE_ACTIVATE_ALL .

We will check in SM58 while loading is in progress and let you know.

FYI, we have loaded most of the records by doing selective full load in 10 infopackages(10 splits of selections). 9 out of 10 splits loaded into BW system. 1 failed with same problem again.

Best Regards,

Raviteja M

[RamanKorrapati]

Hi Ravi,

at source side have any indexes on your source table?

Better to use selective load than single load.

please check more information about error from ST22 or SM37 ecc logs.

Even try to run your load in background and non business hours or nite times/early hours.

Thanks

[Former Member]

Hi,

You can check the job log in ECC and see at what point your load is getting stuck.

For trfc issue, take help of BASIS team.

Thanks,

Rashi

[Former Member]

Hi Rashi,

Yes, we have already checked with SAP PI team regarding tRFC failures and forwarded this upto Basis.

Since it is stuck in only one Data package, problem might be with the data loading from ECC.

Few of the records might be erroneous. Couldn't able sort out the problem.

As of now we are narrowing the load by selective data load  and almost loaded most of the data.

Loaded data by splitting infopacakge(inf1,inf2....info10). One of the infopackage stuck like earlier.

I think problem lies in the particular set of records.

Could you please give some suggestions on current situation?

[bhavinvyas]

check with your basis team for Table Space issue. Ask them to increase the table space.

after that also you are getting dumps then try to load it in parts.

Hope it helps

- Bhavin Vyas

[Former Member]

Hi Bhavin,

Basis team confirming that this problem is not occurring their side.

I also want to add something to query, this is full load and loading 29 million records from ECC.

Basis had an opinion on the load, that it might be occurring due to incorrect records from ECC.

Is there any way to identify incorrect records?

Regards,

Raviteja M

[former_member186053]

Hi Raviteja,

Please check with Basis regarding trfc issue and also check with them about the settings of trfc. Also can you check the consistency of your PSA using RSRV t-code. Even go through the dumps and do detailed analysis.

Thanks,

Vengal.

[Former Member]

Hi Vengal,

I had already checked with Basis team and have created OSS message to SAP regarding this issue.

They've done consistency check and confirmed everything is fine and started load once again.

But it results same as earlier problem and created dumps again.

Regards,

Raviteja M