SLT init load. IUUC* tables was deleted

[Former Member]

Dear ALL,

i have a problem with slt. Content of all iUUC* were deleted, and

iuuc_repl_head  too

so, i have no tables RS* in HANA

can somebody give me content of iuuc* tables for creating replication.

Thx.

[Former Member · Accepted solution]

DMIS SP 7 was the unswer of all problems

[balwant108]

We have to upgrade to DMIS SP7 for the answer you mean

[Former Member]

Can Smb run this ABAP-code in SLT system and copy result hear?

Data lt_tables type TABLE OF DD02L-tabname.

DATA ls_tables TYPE DD02L-tabname.

DATA a type i.

select tabname from  DD02L into TABLE lt_tables where tabname like '%IUUC%' and tabclass = 'TRANSP'.

loop at lt_tables INTO ls_tables.

  select count( * ) from (ls_tables) into a.

if a <> 0 .

  write: /,ls_tables,a.

ENDIF.

ENDLOOP.

Thx.

[Former Member]

there you go:

IUUC_1N_CONS_REG                        6

IUUC_EXCEPT_TAB                     6.379

IUUC_KB_AIM_TABL                   19.665

IUUC_LOGTAB_ID                         86

IUUC_REPL_CONFIG                        1

IUUC_REPL_HEAD                         10

IUUC_RS_ORDER                           9

IUUC_TABLE_EXCEP                       25

IUUC_ACTIV_VAL                          8

IUUC_EXIT_FB                            4

IUUC_KB_AIM_XREF                        7

IUUC_LOG_APPLTAB                        3

IUUC_REPL_CONPAR                        4

IUUC_REPL_LTNCY                       224

IUUC_RS_STATUS                        359

IUUC_TABLE_EXCPT                    3.131

IUUC_ASS_RUL_MAP                       19

IUUC_ISOLATION                        124

IUUC_KB_XPRA_GEN                      197

IUUC_MT_HEADER                          1

IUUC_REPL_FIELD                        45

IUUC_REPL_MAP                           1

IUUC_SPC_PROCOPT                       65

IUUC_TAB_ID                             9

IUUC_COMMAND                            2

IUUC_KB_AIM_GEN                       263

IUUC_KB_XPRA_TAB                    1.366

IUUC_PERF_OPTION                       86

IUUC_REPL_HDR                           1

IUUC_REPL_STAT                        224

IUUC_TABLES                             9

IUUC_TAB_SELFLD                         2

[Former Member]

Anooj,

Excluding  tables which have MT_ID field(generated) or convert objects(generated) i have this list :

IUUC_REPL_CONPAR

IUUC_REPL_FIELD (may be SLT need may be not)

IUUC_REPL_HDR

IUUC_TAB_SELFLD

Can You give me content of this list too?

Thank you so much

[Former Member]

IUUC_REPL_CONPAR & IUUC_REPL_HDR only have entries from your configuration in LTR. So you just need to create a configuration in LTR to see entries in these tables

IUUC_REPL_FIELD (Ignore the first column):

Table: IUUC_REPL_FIELD

X Table Name alignment of fields Field Name Key field data type Lenght of field

X RS_LOG_FILES 001 LOG_FILE X NVARCHAR 000256
X RS_LOG_FILES 002 DESCRIPTION  NVARCHAR 000256
X RS_MESSAGES 001 TABLENAME X NVARCHAR 000128
X RS_MESSAGES 002 COMPONENT X NVARCHAR 000064
X RS_MESSAGES 003 ORDERID X INTEGER 000000
X RS_MESSAGES 004 MESSAGETIME X TIMESTAMP 000000
X RS_MESSAGES 005 LINENO X SMALLINT 000000
X RS_MESSAGES 006 LINE  NVARCHAR 001024
X RS_ORDER 001 SID X NVARCHAR 000003
X RS_ORDER 002 CI_HOST X NVARCHAR 000256
X RS_ORDER 003 TABLENAME X NVARCHAR 000128
X RS_ORDER 004 ORDERID  INTEGER 000000
X RS_ORDER 005 ACTION  NVARCHAR 000001
X RS_ORDER_EXT 001 SID X NVARCHAR 000003
X RS_ORDER_EXT 002 CI_HOST X NVARCHAR 000256
X RS_ORDER_EXT 003 TABLENAME X NVARCHAR 000128
X RS_ORDER_EXT 004 ORDERID  INTEGER 000000
X RS_ORDER_EXT 005 ACTION  NVARCHAR 000001
X RS_REPLICATION_COMPONENTS 001 SID X NVARCHAR 000003
X RS_REPLICATION_COMPONENTS 002 CI_HOST X NVARCHAR 000256
X RS_REPLICATION_COMPONENTS 003 SCHEMA_NAME X NVARCHAR 000128
X RS_REPLICATION_COMPONENTS 004 PORT X NVARCHAR 000064
X RS_REPLICATION_COMPONENTS 005 TARGET_SCHEMA X NVARCHAR 000256
X RS_REPLICATION_COMPONENTS 006 PDB_NAME X NVARCHAR 000064
X RS_REPLICATION_COMPONENTS 007 COMPONENT X NVARCHAR 000064
X RS_REPLICATION_COMPONENTS 008 ACTION  NVARCHAR 000064
X RS_REPLICATION_COMPONENTS 009 STATUS  NVARCHAR 000001
X RS_REPLICATION_COMPONENTS 010 SUBCOMPONENT  NVARCHAR 000064
X RS_REPLICATION_COMPONENTS 011 SLT_SID  NVARCHAR 000003
X RS_REPLICATION_COMPONENTS 012 SLT_HOST  NVARCHAR 000256
X RS_REPLICATION_COMPONENTS 013 CHANGE_TIME  TIMESTAMP 000000
X RS_REPLICATION_COMPONENTS 014 COMMENTS  NVARCHAR 001000
X RS_SCHEMA_MAP 001 SID X NVARCHAR 000003
X RS_SCHEMA_MAP 002 CI_HOST X NVARCHAR 000256
X RS_SCHEMA_MAP 003 SRC_SCHEMA X NVARCHAR 000128
X RS_SCHEMA_MAP 004 TRG_SCHEMA  NVARCHAR 000128
X RS_STATUS 001 SID X NVARCHAR 000003
X RS_STATUS 002 CI_HOST X NVARCHAR 000256
X RS_STATUS 003 TABLENAME X NVARCHAR 000128
X RS_STATUS 004 ACTION X NVARCHAR 000001
X RS_STATUS 005 STARTTIME X TIMESTAMP 000000
X RS_STATUS 006 ORDERID  INTEGER 000000
X RS_STATUS 007 ENDTIME  TIMESTAMP 000000
X RS_STATUS 008 STATUS  NVARCHAR 000001
X RS_STATUS 009 PID  INTEGER 000000

IUUC_TAB_SELFLD:

Table Name  Field Name     Boolean Variable (X=True, -=False, Space=Unknown)

DBTABLOG  LOGID
TSPEVDEV  TIMESTAMP   X

[Former Member]

Ou, Anooj

IUUC_TABLES plz too ,

i completely forgot about it.

[Former Member]

This table only has the list of tables chosen to be replicated in HANA for a specific configuraiton. These entries will be recreated when you create a new configuration in LTR and replicate tables via Data Provisioning in the HANA studio

[Former Member]

So, i don't understand what can i do with SLT

msg !Error occured when inserting in the database

when i creating configuration.

[Former Member]

Sorry to know that. I think you should speak to SAP support, they might have a way to fix this without having to reinstall SLT.

The delete all IUUC* tables option should carry some strong warning messages I suppose.

Good Luck!

[Former Member]

Hi Dimitriy,

How/why did the IUUC* table entries get deleted?

Table entries of iuuc_repl_head are as follows:

Table Name|create origin|table behaviour|table type|comment

DD02L|1|3|1|SAP TABLES
DD02T|1|3|1|R/3 DD: SAP TABLE TEXTS
DD08L|1|3|1|R/3 DD: RELATIONSHIP DEFINITIONS
RS_LOG_FILES|2|1|2|
RS_MESSAGES|2|1|2|

RS_ORDER|2|1|2|
RS_ORDER_EXT|2|1|2|
RS_REPLICATION_COMPONENTS|2|1|2|
RS_SCHEMA_MAP|2|1|2|
RS_STATUS|2|1|2|

The rest of the iuuc_repl* table entries will be recreated when you create a new configuration.

I am not too sure about the rest of the iuuc* tables - there are too many of them. Good Luck!

If that doesn't work, guess you are better off reinstalling slt.

Thanks,

Anooj

[Former Member]

In trc IUUC-Expert functions

  button : Delete all IUUC Tables (For my mind this function will have to clear SLT config) but not

and i have all iuuc* tables clear.

What can I do with SLT now? & How can I reinstall it?