how to stop SLT initial load jobs

[Former Member]

Hi

we have copied addon table KNA1 as ZKNA1 and trying to load it from HANA studio data provisioning.

After load, the job status is "Scheduled" for long time and never ends.

I dont what problem makes the job scheduled. i want to stop this and try again.

how to stop this scheduled job..?

There is no option in HANA studio data provision to stop loaded jobs.

Pls advice.

Regards

[Former Member]

Hi Chandra,

Are other tables that you replicated still running? You could try stopping & restarting the master job in LTR for that configuration in your SLT system. It will not affect the existing replication jobs, it will only temporarily stop them. As the database trigger & logging will continue to run even when the master job is stopped, there should be no issues. When the master job restarts, replication will automatically continue from the point it stopped.

While you are doing this, it might fix the ZKNA1 initial load problem as well. Worth a try.

Thanks,

Anooj

[Former Member]

Hi Anooj

Thanks for reply.

I confirmed the jobs in LTR.. current situation is

-3 DD tables are in process status at LTR

-one job status is error. but current action is Replication(initial load running) at LTR

- no other jobs are currently replicating in LTR

-new 4 jobs are status "scheduled" in data provisining

Actually we have 5 people loading data from SLT.

one or two has "executed" status, rest of the three users were always "scheduled" status.

When the status is scheduled..do we always want to stop and start the job at LTR?

looks strange...any other way ..

Any way how to stop the Replication(Initial load running) job. ? i stop and started the Master job in LTR. but no use. status not changed

Any idea. how to stop the scheduled job.

Regards

Chandra

[Former Member]

Hi Chndra,

I am not sure how you can stop & restart an initial load. It is different from the replication process isn't it. Have you had a look at the transaction IUUC_SYNC_MON for you mass transfer ID (which you can get from LTR). This transaction can show you application logs to tell you more about what happened to the intiial load that you kicked off. May be it failed with an ST22 dump in the source system or the SLT system and you can get more info from there.

Thanks,

Anooj

[Former Member]

Hi Anooj

Thanks for reply.

ZKNA1_10 is error at data provisioning

ZKNA1_XX is Scheduled status

Neither of them can be stopped or reloaded.

There is not error in ST22.

I checked in application log.it says below error

Access plan 00001 of conversion object "ZKNA1_10" does not exist

There is no hint to understand what the error says and  to solve the problem.

Even we know whats the problem of error, but we dont know how to stop the job.

In LTR i  see "Triggers" tab displaying with below messages

DD02L Trigger is active in source system

DD02T Trigger is active in source system

DD02L Trigger is active in source system

ZKNA1_10 Trigger is active in source system

I restarted the LTR Master job service, but still no use.

Any other way to troubleshoot or get loaded?

Regards

[Former Member]

Hi Chandra,

Can you check if you can find an entry for this table in RS_ORDER tables (within SLT schema)?

If yes, you can delete this entry and the table will show up again when you click on 'Load' or 'Replicate' in Data Provisioning.

If not, are there entries for this table in RS_STATUS? Can you see if you are able to implement the Note 1737160 and follow the manual steps within there?

Thanks,

Anooj

[Former Member]

Hi Chandra,

  Where you able to troubleshoot the problem, I have a similar error, trying to address it