cancel
Showing results for 
Search instead for 
Did you mean: 

Data Loading issue

Former Member
0 Kudos

When load for Hr Payroll is triggered it fails.

Error occured in the data selection.

Error message "Personnel no. 00008110 , payroll result 00161 : Incomplete administrative data"

Checked at source side all the details of the above personnel number. but there is no such payroll result 00161.

Technical name of the data source is : 0HR_PY_PP_1

Kindly help to get this issue resolved.

points will be assigned.

Thanks & regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

If the extractor checker is also giving the same message, then you can swith on the trace and find where exactly the error is coming.

Go to rsa3 and choose your extractor, dont execute it.

Trace sql is transaction st05 open it in a different mode, activate trace.

Since trace is activated, all database activity is saved into log, then you should be careful, trace shouldn't be activated much time.

You can fllow the below steps:

1. Open another session and go to transaction ST05.

2. Activate trace with filter.

3. Select SQL trace and enter you id.

4. Run RSA3 for your extractor.

5. Deactivate trace in ST05.

6. Display Trace in ST05 for your id.

This should give you an idea of tables the extractor hits.

Then you can check the tables, to trace the error, hope this helps...

Regards

Shilpa

Former Member
0 Kudos

Hello Shilpa

I have done a SQL Trace in ST05 - I am not sure if I can for myself see anything related to the error which I am getting.

At the last line, I do not see anything specific to any sequence number error.

Many Thanks for your help.

Pradip Parmar

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

If there is no such payroll number is the source system

Check the transformations(If BI 7), else check your update rules or transfer rules,

Seems, some problem in mapping of fields.

Or try replicating and activating the data source, sometimes, such errrors are the result of some changes done in the source system

Hope this helps

Regards

Shilpa

Former Member
0 Kudos

Hello

What is RSA3 extractor Checker also gives the same error ?

Thanks.

desgallagher
Contributor
0 Kudos

Hi ,

The problem normally occurs because payroll posting errors.

Now to be able to continue with BW upload you have to proceed as

described in attached note 696638. That means you change the

error message into a warning message as described and then do an upload

again. Please find details in the attached note.

Regards,

Des Gallagher.