cancel
Showing results for 
Search instead for 
Did you mean: 

SLT - The number of generated logging tables exceedes limit

Former Member
0 Kudos

Hi All,


We have configured a new source schema on our SLT system.

Source: NonSAP MS SQL Database.
SLT : DMIS 2011 SP7
Target: HANA SPS8

While replicating a table, we are encountering the error message on SLT system:
"The number of generated logging tables exceedes limit"

Could someone help me here with the area where we had these limitations set on the SLT system? And help in fixing these issues.

Thanks in Advance.

Lakshman.

Accepted Solutions (1)

Accepted Solutions (1)

tobias_karpstein
Discoverer

Hi Lakshman,

I'm not able to find this message in DMIS at all to further check where and why it is getting triggered. Can you tell me the details of the message (message class and message number?)

Cheerio,

Tobias

Former Member
0 Kudos

Hi Tobias,

Firstly, good to see and interact with you on my first blog.

Thanks for your inputs.

Will share the sequence of actions:

1. New MSSQL source(DB_new) is a copy of existing SLT source(say DB1).

2. New MSSQL source had all the logging tables and triggers carried to it from DB1.

3. For testing purpose, when we replicated table City in new SLT Schema(DB_new),

And, here we observed the error - "The number of generated logging tables exceedes limit"

And, here for City, we observed only logging table is getting created and table in reciever alone in "LTRC- Table Overview".


4. With this, we requested MSSQL team to clean all the unwanted/old logging tables and triggers which came from DB1.

5. After cleanup is done, we are able to replicate all the tables except City. And City still is getting error - "The number of generated logging tables exceedes limit"


** Here we observed that City table alone is having different logging table sequence number compared to all other tables **


6. Here, we requested source MSSQL team to create a copy of City table, i.e city_copy. And we are able to replicate city_copy without any issues.

** Here, we understood that we are missing some cleanup at SLT end, which is pointing to table City on SLT.

**And City table seems got tagged to a logging table that is carried from DB1.**. Other tables have not got affected as we replicated them only after MSSQL done the cleanup.

7. Finally, along with the cleanup we do in LTRC(Processing steps), we cleaned up City related entry we had in table IUUC_LOGTAB_ID.

And, then we replicated the table City without any errors and logging table limit issues are solved.


** Here we observed that City table logging table sequence number is now in sync with other tables **

--
Kindly share your inputs if any to add to my understanding here.

Thank you.

Lakshman.

tobias_karpstein
Discoverer
0 Kudos

Hi Lakshman,

sounds reaonable to me.

Cheerio,

Tobias

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

We got the issues fixed now.

With our new source MSSQL db being a copy from other existing SLT source schema, all the triggers and logging tables are copied from it to new one.

We requested our source MSSQL db team to do the cleanup of all the existing triggers and logging tables in the new MSSQL database and then we are able to replicate tables without any issue.

Still, I coudnt get the info on where the limit for the logging tables is set and how to get it increased.
Kindly help me with this info.

Thank you.

Lakshman.

tobias_karpstein
Discoverer
0 Kudos

Hi Lakshman,

the limit is a implicit one from a number range object, IUUC_SHDW. It can't be set or adjusted via customizing. The logging table is always a combination of /1CADMC/<ident>. The ident is a 8 digit value starting from 00000200 to 99999999. Therefore in a regular set-up you have quite a lot of logging tables to create before reaching this limit.
The message was propably a missleading one due to duplicate names, after the schema copy.

Cheerio,

Tobias