Sybase Replication Issue

[Former Member]

Hi experts,

I'm working on replicating tables from sybase ase. But there are 2 problems that I can't solve till now.

1. in my previous thread I found that if the table's name is lower case, SLT will not be able to replicate it.

    Does anyone once face same issue? It's quite a problem because SAP system treat all letters as upper case, but the sybase system is case sensitive. Sybase system is our transaction system. It will be lots of work to change the tables' name to upper case.

2. About replicating view, I followed the knowledge sharing of Astrid

But no lucky.

I have a view V1 generated from table T1 and T2.  Both the tables have primary key.

I raised the replication step-by-step. A table with the same name and structure as the view V1 is created in HANA.

But no data loaded.

Does anyone have similar experience?

our SLT server version as below:

Looking forward to your any input.

Regards,

Chong

[former_member252769]

Hi Chong,

Please double the below points, may be can help:

- Replicate all underlying tables before starting replication of main table of view.

- Cross check if View structure is present in source system which you want to replicate. Make sure that you are having name in upper case letters.

- Dont forget to configure the settings in LTRS tcode for the main table.

If above steps are done.

Then send screenshot and let know if tables is in replication mode or have any error.

Regards

BJ

[Former Member]

Hi BJ,

Sorry for late reply as I'm currently released from the project for a short time for some reasons.

As you said, if we have to replicate all the underlying tables before replicating the view,  my manager decided to replicate all tables and not replicate the view. We will implement the view's logic in HANA.

But today my manager called me and told me a problem. He started the replication of table MKPF in LTRC, but the status keeps "Scheduled" all the time. I can't stop it as it's not in Load/Replication Mode. When I try to start its replication again, it shows error "Scheduling failed for action start replication". I checked in HANA Data Provisioning, there's no table MKPF. Neither with table RS_STATUS.

And when I checked the "Administration Data" tab of the configuration, the "Running Transfer Jobs" is 0. Does that mean a big issue?

Should I restart the configuration by Deactivate and Activate?

Do I need to check the DIALOG processes of the source system?

Regards,

Chong

[thirunavukarassu_saravana]

I had the same problem couple of days back i.e. when adding a table, it was stuck in Scheduled status. I noticed the runtime of the SLT master and data transfer jobs was around 5 days. Ideally these jobs get completed in a day (after around 84000 seconds) and then will get started again as new jobs. So I tried deactivating and activating the configuration, it helped. The table status was changed from Scheduled and it got added successfully.

[Former Member]

Hello Chong,

This is pretty natural, i have faced this no of the times, i normally follow below approach to get through this.

1. goto LTRC--> stop replciation for all the mass tranfer IDS

2. goto SM37 check if there are any active jobs running into the system

3. stop all the active jobs from the system

4. goto sm12 --> check any locks related to the slt are there in hung state --
> delete them as they are in hung state and there is no active job for same

5. check sm66 --> there shouldnt be any active rpocess for the replication

6. check in ECC system if you have enough work processes available for the in dialog for the replication to run

Now go ahead and start the replication and then check if all the background jobs are active once allt he background jobs comes up your replication will go through.

Please let us know the result back.

Thanks and Regards,

Amar Ghuge

[Former Member]

Hello Chong,

Please do have a look at the SAP note   1908498 - How to set SLT jobs in SLT configuration

[Former Member]

Hello Amar Ghuge,

Thank you for your reply in detail.

When I start a new table replication, it's very common that the status keep "Replication(initial Load)" for a long time. I check the resource availability of the SLT server and the source system(ECC or SYBASE DB). It is indeed the case that not enough available processes are for the replication. I have to do some manual work just as you suggested.

I will go through the note and find out the official suggestion.

Regards,

Chong

[Former Member]

Sometimes when I replicate a table from sybase DB, I have to manually create the logging table, trigger in sender system , the target table and synonym in receiver system. By default, SLT will wait for resource to release. Manual work must be involved if the system has poor resource.

[Former Member]

Hello Chong,

Thank you for the feedbacks and updates shared.

I Am tracking this communication, let us know if you need anything more on this.

Amar Ghuge