cancel
Showing results for 
Search instead for 
Did you mean: 

problem with upload data from CRM to BI system

Former Member
0 Kudos

When I try to perform full upload data from CRM to BI system with data source 0BPARTNER_ATTR (active version: Excutable). I waited for a long time but there are not any records were transfered (total records need to upload are 130) . I checked the log and can't find any errors.

Pls help me solve this problem.

Thanks and regard

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Check with the basis as it is a basis issue.Check for the BW RFC user whether it can fetch data or not.

You will not have authorization to transfer the data from the CRM system to BW system.

Hope it helps

Thanks

Former Member
0 Kudos

Hi,

The folowing authorizations have been checked for RFC user:

In BI system: S_BI-WHM_RFC

In CRM system: S_BI-WX_RFC

Are there any authorization?

Regard

Former Member
0 Kudos

Hi,

I think these two are needed only.

Thanks

Former Member
0 Kudos

Hi,

on the next day, the process finished with status not success.

The detail errors is:

Extraction(messages): Missing messages

Missing message: Request received

Missing message: Number of sent records

Missing message: Selection completed

Transfer (IDocs and TRFC): Errors occurred

Data package 1: arrived in BW; Processing: Selected number does not agree with transferred n

Request IDoc: Application document posted

Info IDoc 2: sent, not arrived; Data passed to port OK

Info IDoc 1: sent, not arrived; Data passed to port OK

Info IDoc 3: sent, not arrived; Data passed to port OK

Info IDoc 4: sent, not arrived; Data passed to port OK

However, the data has been uploaded to infoobject. Pls explain to me about this error and why the data can be uploaded with this error.

Regard

Former Member
0 Kudos

Hi there,

It seems that the errors indicate a problem with IDOCs. "not arrive" description normally associate with the RFC user not able to log into your source (CRM) system.

Go to transaction code SM59 and check your RFC connection. Also, you can check a different BW extraction from this source system.

Cheers

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Nguyen,

Check if the load has finished succesful in SM37 and see if there are any tRFC struck in the process through SM58 if so, execute the LUW.

Also see if the datasource in the source system(CRM) has the records to be transfered through RSA3.

Try to reschedule after replicating the datasource on BW system and activating the transferstructure.

Hope it helps...

Best Regards,

DMK

*Assign point if it helps...

srinivas_anilkumar
Active Contributor
0 Kudos

Hi ,

Welcome to SDN community.

Can you try the data source in the CRM extractor checker

Assign points if it helps

Regards,

Srinivas

Former Member
0 Kudos

Hi ,

I have already checked in RSA3 in CRM and I can see the 130 records there.

Thanks and Regard

Hieu Truc Nguyen

null