Data load to PSA is failing from 0CRM_COMPLAINTS_I

[Former Member]

Hi All,

I have an issue, Please help me out..

When i schedule a delta data load process to PSA by 0CRM_COMPLAINTS_I data source it is failing.. It was happening from the last three days. I found in the batch job log that it was happening till it goes through Customer Enhancement of the datas source i.e. i could see the log till Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 1,404 records after that nothing is being recorded and the job is getting terminated.

From the monitor screen of BW, Error message is that the file that I am trying to load is being edited.. Exact message is below.

if the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

Ironically.. if i see the job was never successful the aspect would have been different but after repeated attempts suddenly the load is getting successful..

Kindly help me.

Thanks,

Haaris.

[amol_jaiswal]

Hi,

Try to do a RSRV check for the PSA table of this datasource. If there are any problems with this PSA table, you can correct it in RSRV and then try to load.

Hope this helps.

Amol

[Former Member]

Hi Santhosh,

Yesterday's delta load went well when I was repeating the load though I did not activate the DS. later I have done the activation as you suggested. but today the same issue again. Data load failed, Please suggese me if I have to take any action.

Hi Amol,

How to carryout the PSA table repair activity. Please help me.

Thanks

Haaris

[Former Member]

Amol,

I have checked using the functionality Consistency Between PSA Partitions and SAP Administration Information giving the PSA table . but the checks has come green.

do i need to check any other thing here??

[Former Member]

Hi Hari,

Are you not seeing any error in the details screen from the Monitor?

Veerendra.

[Former Member]

Hi Veeredra,

Please find the error discription from monitor status tab.

If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

Haaris

[Former Member]

Hari,

This statement genrally gives for many issues.

Check the Short dumps (Run time errors) in ST22 for this load issue. we can get more information why it is failiing.

Veerendra.

[Former Member]

Hi

I have checked in ST22 already.. but did not find any log corresponding to that error. I have checked in the batch job log also. there is no message saying job cancelled, log os ending up Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 1,404 records . no log is getting recorded after the above log statement.

[Former Member]

Hi Team,

still the problem persists. can any one syggest me??

Thanks

Haaris

[Former Member]

Hi

Are there any recent change in the configuration of 0CRM_COMPLAINTS_I in your CRM system??

if there are any changes then

Go to transaction SE38,

RSDS_DATASOURCE_ACTIVATE_ALL and execute

RS_TRANSTRU_ACTIVATE_ALL and click on execute .

Give your source system and Infosource name and click on execute .

and also replicate the data source once

Then load data again and see.

this will definitely solve your issue

santosh

[Former Member]

Santhosh..

Thank you for your reply.. I am using BI 7.0 system. Anyway i will use that data source activation and will let you know.

Haaris