cancel
Showing results for 
Search instead for 
Did you mean: 

DTP is running long time and don't have Errors

former_member226980
Participant
0 Kudos

Dear All,

While loading data into info object through DTP , got the following error. The Process type of the .

But the records are transferred but not updating the target info object.

Please find the screen shot.

Please suggest me your solutions to over come this issue.

Thanks,

Sai.K

Accepted Solutions (1)

Accepted Solutions (1)

former_member226980
Participant
0 Kudos

Hi Andras,

Thanks  for your prompt response.

While I am performed  the  RSRV test , got the following issue. please find the attached screen shot.

Please let me know the solution to over come this issue.

Thanks,

Sai.K

Former Member
0 Kudos

Hi,

it looks like master data have some error records,you can try repair them with program RSDMD_CHECKPRG_ALL  and then run the DTP.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Please run master data load to info object ZBATCH and run attribute change run.

Thru RSRV try to do master data tests on info object ZBATCH and correct the error.

Later you can delete present dtp request and retrigger.

Thanks

Answers (7)

Answers (7)

former_member226980
Participant
0 Kudos

Hi All ,

I have execute the program RSDMD_CHECKPRG_ALL and still getting a problem and it's also one of the navigational attribute. Is it possible delete the entire master data from the info object and reload the again or is there any impact on transaction data .

Thanks,

Sai.K

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Deleting master data is not a easy task and not suggestible.

What error you got when ran above program?

share error log details.

Have you tried to do RSRV test on your master data object?

please do that.

Thanks

former_member226980
Participant
0 Kudos

Hi Ram,

While performed the Elementary test ,got the following Error.  For this info object having the navigational attributes and also involved in the aggregates as well.

Earlier  I got the same issue while performed All Combined Test for master data and Run the Program but now both are not showing any errors. But while performing ALL ELEMENTARY TESTS got the below following Error

Please suggest me the solution or need to apply any snote number  to resolve this issue.

Thanks for advance.

ALL ELEMENTARY TEST Error

Regards,

Sai.K

RamanKorrapati
Active Contributor
0 Kudos

From RSRV itself you may option to rectify the error.

click on error line and do the correction.


Lets try to see and compare below tables.

/BIC/PZBATCH and /BIC/SZBATCH.


check 619 record or number form above tables.



former_member226980
Participant
0 Kudos

Hi Ram ,

I have done the comparison  between both tables, found around 4000 less record in /BIC/SZBATCH  than /BIC/PZBATCH.

We have an option CORRECT ERROR in RSRV by using this we can solve this issue?

Thanks,

Sai.K

RamanKorrapati
Active Contributor
0 Kudos

If have less data in master data tables then please load master data to ZBATCH. Reloading master data it just overwrites the old data.

Later do RSRV test and corrections if issue exist.

former_member226980
Participant
0 Kudos

Hi Ram,

it's resolved by running the ACR for the info object and again load the data in to the info object . But still dtp load not completed still running long time.

Please find the attached screen shot.

Thanks,

Sai.K

RamanKorrapati
Active Contributor
0 Kudos

Hi Sai,

Seems like your load is still running.

There is no issues. But system will be busy during your load.

So please check system load balance, tx - SM50/51.

check availability /free application servers to speed up your load.

if needed more then ask basis team to create more application servers.

Lets try to activate transformations and dtp thru programs.

Thanks

Former Member
0 Kudos

Hello Sai,

Please execute transaction RSRV >  All combined test > Check master data for characteristic

to your Target of request.

Let me know if there is any errors appeared.

Br, Andras

RamanKorrapati
Active Contributor
0 Kudos

Hi Sai,

is this full load or delta load?

is your target is info object?

can you refresh your dtp monitor and see the logs  now.

if its full load then delete/cancel present request.

Lets try to activate target object,transformations and dtp.

Before triggering please check bw server condition, see free application servers are there at SM50/51.

if there then you can trigger your load and keep monitoring dtp.

Thanks

former_member182878
Active Participant
0 Kudos

Hi Sai,

How long this dtp is running?

If there are more records it will take time to complete.

If it continous still cancell the job and re trigger.

Let us know if there still issues.

BR,

Prakash K

Former Member
0 Kudos

Hi,

if this is only job which is taking long time, then check if there are any multiple DTP's running from different process chains simultaneous ? as this may create lock issues. you can check the lock entries in SM12.

former_member226980
Participant
0 Kudos

Hi Jyothi,

Thanks for your quick repose.

I have checked sm12 and not found any locks there.but while checking SM37 background is not yet finished and still active state.

Thanks,

Sai.K

Former Member
0 Kudos

ok you can check these ,

  1. check if the job got stuck, select the job , Goto Menu --> Job --> "check status" .
  2. if it still shows as "active" then double click on the job clickon  -->job details-->copy PID number .
  3. goto sm66 --> check if the PID is stopped/error-ed out.

you can cancel the job and re-run DTP (if points 1 and 3 satisfy).

Former Member
0 Kudos

Sai ,

Can u attach the screen shot of your error.

former_member226980
Participant
0 Kudos

Hi Regina,

thanks for quick response  .

I have already attached screen shot and not getting error but my dtp running long time.

Thanks,

Sai.k

Former Member
0 Kudos

hi sai,

Kindly stop your process and Re-run it again and check it whether still its taking long time.

If it so kindly let me know

Former Member
0 Kudos

Sai,

Hope below links will help you in some ways.

If it is helpful kindly mark it as point

former_member183334
Active Participant
0 Kudos

Hi Sai,

Please check the ABAP Routines at Transformation.

Delete the indexes before loading data and create the index after loading.

Regards,

Sathya.

former_member226980
Participant
0 Kudos

Hi Satya,

Thanks for your quick response. Now I am performing the data load for master data attribute and at time of doing this got the above issue.

Thanks,

Sai.K