0MATERIAL_ATTR Error occurred in the source system

[former_member209741]

Hi,

I am getting error message in 0MATERIAL_ATTR. I even tried to replicate the DS but still no success.

Error message from the source system

Diagnosis

An error occurred in the source system.

System Response

Caller 09 contains an error message.

Please suggest.

Niraj

[former_member210724]

Niraj,

According to your post data is fine in RSA3.So problem is in BI side.How about data in PSA?

Check whether complete flow is in active or not because you mentioned that you replicated your datasource.Objects related to that DS should be activated after replication.

Anand.

[former_member209741]

Hi Anand,

We are getting this error from about 4-5 days where all data model is working fine from last 8 months... with no changes in it.

I tried to replicate the same now and activated it too. But still not success.

Niraj

[former_member186082]

Hi Niraj,

Is the extraction job in source system getting successful?

Have all the data transferred to BI side?

Have you checked if any IDocs are stuck?

In the monitor screen of the Info package check the DETAILS tab. You will find at which stage the load is being failing and share the screen here if you can.

Try creating a new IP and trigger the load

Regards

Chandu

[former_member209741]

Extraction in r/3 side is going ok. No data is loaded in psa as its giving source system error.

Find details of error log in process monitor.. unable to attache image .

Extraction (messages): Errors occurred - >

Error occurred in the data selection.

Juz let me know how to get status of idcos checked.

Niraj

[Former Member]

Hi Niraj,

If You go detail tab of process Monitor , drill down request message .

Right click on error  , see message . You can get the error details .

There are top line tab you can select Environment tab & select one by one option for error.

By selecting tab BW you can get Idocs status in BW  & Tab OLTP  Idoc in Source system .

Regards,

Anand Mehrotra.

[former_member210724]

Hi,

May I know how you confirmed that extraction is fine at R3?

Use WE02 for IDOC status.

As chandu said, take a screen shot of error and use the Insert Image(Camera icon) for uploading it

Anand.

[Former Member]

Hi,

This memory problem contact your BASIS Team else drop index & load data & build index.

Regards,

Anand Mehrotra.

[Former Member]

Hi,

Please check in the Extarctor if the data is coming properly in r/3 system.

If it data volume is huge then ask basis team to create index on The Fieds in selections of the Datasource.

This will improve the extarction performance.

Regards,

Rajesh

[former_member209741]

Hi Rajesh,

its only mere delta with 3-5 records a time.

Also data is coming up fine in extractor on R/3 side.

Niraj

[former_member209741]

Hi Anand,

What exactly you mean delete index. I am facing this problem at the time of master data load of 0material.

Niraj