While using SLT replication Data is not updated in RS_STATUS table field endtime.

[Former Member]

Hi Folks,

I am using SLT replication, as source ECC system, i found all the data in field endtime is null in RS_STATUS table. as i want to know the last update time of replication, whereas other fields like tablemane, action, starttime is showing proper data.

please anyone can help me getting the reason why endtime is null or any other way to know the last update time of schema.

-Ruchi

[Former Member]

Appreciate any help.

[Former Member]

Hi Ruchi,

Can you check in SLT system..

goto LTR --> click on your schema

Then click in "table triggers" or "triggers" not sure exact name.

here you should have the time stamps for the tables.

Regards,

Venkat

[former_member205400]

I don't think his question was answered......

He is asking about the rs_status table in schema.

I see the same thing. There are no records with a date in the endtime in my table.

What I'm wondering is what the statuses mean.

I see this is my schema.rs_status table for status:

P

X

O

E

I see this is my schema.rs_status table for action:

R

L

S

C

W

I think if we know what these statusus / actioin mean we can determine the replication state of that table.

Anyone?

Mike

[former_member205400]

Anyone know what the actions / status codes mean in table rs-status?

[Former Member]

Well, the front end monitor has the following possible statuses (i'm guessing at the letter assignments based on what I see with my tables)

X = Executed

P = In Process

E = Error

O = Scheduled

And the actions are:

L = Load

R = Replicate

C = Stop

S = Suspend

W = ? Waiting? I've never seen another front end description.