Question Re: SLT Replication : some tables are missing in Technology Q&A

SLT Replication : some tables are missing

shishupalreddy — Mon, 29 Jul 2013 07:53:25 GMT

Hello SLT experts ,

I have completed SLT configuration and replicated most of the required tables.

But there is one table which does not show in in Data provisioning - Replicate pop up when I try to add that to replication .

For your information : The table is available in replicated DD02L and DD02T tables in HANA .

I also tried by stopping and restarting the SLT replication process from LT replication system .

Please advise how to resolve this issue .

Thanks

Shishupal.

Re: SLT Replication : some tables are missing

tobias_koebler — Mon, 29 Jul 2013 12:20:00 GMT

Hi,

is it an SAP or customer table? If the table in the source is maintained in another language than you are logged in on the HAAN studio, it will not be displayed properly on Data Provisioning.

How to check this? Just write a select on the DD tables with where clause of the table name.

Best,

Tobias

Re: SLT Replication : some tables are missing

shishupalreddy — Mon, 29 Jul 2013 14:04:04 GMT

Hi Tobias,

It is a custom table .

Wrote a select on the DD tables with where clause of the table name and it shows the table in DD tables in HANA as well .

It seems the language in which the table created is different from the language logged in to SAP HANA data provisioning .

Please advise .

Thanks

Shishupal

Re: SLT Replication : some tables are missing

tobias_koebler — Mon, 29 Jul 2013 14:36:33 GMT

Hi Shishupal,

the language is the issue. The Modeler UI cannot handle it so far.

But now worriers, there are few other options available to start the table.

1.) Change the language settings on the Modeler to the same language as the table is specified and you will see it in the Data Provisioning part.

2.) Have a look at this thread: http://scn.sap.com/community/replication-server/blog/2013/06/24/how-to-start-data-provisioning-without-using-the-data-provisioning-ui

3.) use transaction LTRC within the SLT system, there is also an option for starting a replication when you are at DMIS 2011 SP4 or DMIS 2010 SP9.

Best,

Tobias

Re: SLT Replication : some tables are missing

shishupalreddy — Mon, 29 Jul 2013 15:00:05 GMT

Hello Tobias,

I see the below are not available in our RS_ORDER table structure

TABLE_TYPE	NVARCHAR	64	Table Type (space = COLUMN, ROW, HISTORY_COLUMN)
REFRESH_BEHAVIOR	NVARCHAR	1	SLT behaviour for target table in case of reload (space/D = Drop Table, T = Truncate Table, N = Keep Table
LANGUAGE	NVARCHAR	1	Language for column description

I just inserted the table name in to RS_OREDER , but still I think language is missing in the structure of RS_OREDER it self , I could not see the table in data provisioning replication tab .

please advise if there exists any other way to have the missing table appearing in replication process.

Thank you for your time .

Shishupal

Re: SLT Replication : some tables are missing

tobias_koebler — Tue, 30 Jul 2013 06:37:28 GMT

Hi,

this is for Version DMIS 2011 SP4 / DMIS 2010 SP9 (or higher)

are you below this version?

Best,

Tobias

Re: SLT Replication : some tables are missing

shishupalreddy — Tue, 30 Jul 2013 06:42:42 GMT

Hi Tobias,

Yes we are at Lower version .

Thanks

Shishupal

Re: SLT Replication : some tables are missing

tobias_koebler — Tue, 30 Jul 2013 06:57:12 GMT

Hi Shishupal,

I updated the thread for older versions: http://scn.sap.com/community/replication-server/blog/2013/06/24/how-to-start-data-provisioning-without-using-the-data-provisioning-ui

But in general I would recommend to update to the latest version.

Best,
Tobias

Re: SLT Replication : some tables are missing

shishupalreddy — Tue, 30 Jul 2013 07:05:09 GMT

Hello Tobias,

Yesterday I have created entry in RS_ORDER table of the required SLT schema in the same way as you explained in the thread .But still I could not see the Table in the replication.

I am checking if I can change the Language in which Table created to SAP HANA log in language .I will update the thread with the outcome .

Thank you .

Regards,

Shishupal.

Re: SLT Replication : some tables are missing

Former Member — Fri, 10 Jan 2014 15:20:46 GMT

Hi Tobias,

Seems the blog you mentioned is no longer available at mentioned link -

http://scn.sap.com/community/replication-server/blog/2013/06/24/how-to-start-data-provisioning-without-using-the-data-provisioning-ui

Is there an alternative link?

Thanks,

Anoop Sahu

Re: SLT Replication : some tables are missing

tobias_koebler — Wed, 15 Jan 2014 08:27:35 GMT

Hi,

the SCN team did a mistake and changed the URL. The URL will be back soon - in the meanwhile you can access it via: http://scn.sap.com/community/lt-replication-server/blog/2013/06/24/how-to-start-data-provisioning-without-using-the-data-provisioning-ui

Best,

Tobias