Table BC_BPEM_EL_ENTRY not found in the control table DMC_MT_TABLES

[p1024029]

Hello All,

I am trying to replicate BPM(PO) processes data into HANA using SLT to use the same data and process in SAP OpInt business scenario.

I am following SAP OpInt Developer guide : http://help.sap.com/saphelp_hana_opint/SAP_OPInt_Developers_Guide.pdf

I am trying to Load and Replicate(Real-time) below BPM tables.

BC_BPEM_EL_ENTRY

BC_BPEM_EL_EVT_MAP

BC_BPEM_EL_RDS

BC_BPEM_UM_MAP

Load is working fine but Replication is failing. When I check logs I have found an error message in LRTC's Table health check status. Please see below for error message screen shot reference. I did the similar replication with ABAP system & HANA using SLT and it works fine but BPM System & HANA is not working.

Could you please help me?. Thanks in Advance.

Naresh

[p1024029 · Accepted solution]

This is fixed after applying couple of new SAP notes.

Regards,

Naresh

[former_member182537 · Accepted solution]

hi -please can you tell what SAP notes is needed to fix? we are getting same issues on SLT SP9.

[p1024029 · Accepted solution]

Hi

We had to apply couple of notes.

Please specify your message, so that i will try to give appropriate note details.

NB

[former_member182537 · Accepted solution]

HI naresh same error just the table name is different

[former_member182537]

REplication of tables failing as tables are not there in master control list even though I ran for dd02l dd02t

[former_member182537]

hi Naresh , here is my full error-

Table DD02L not found in the control table DMC_MT_TABLES

Message no. CNV_IUUC_REPL_TS027

Diagnosis

Table DD02L is not present in the data transfer master table.

System Response

The replication cannot proceed until the control tables are properly
updated.

Procedure

Try to load and replicate this table again. If the error persists, contact
your system administrator.

Procedure for System Administration

No entry found in table DMC_MT_HEADER for table DD02L.

Please can you confirm me which noites can fix this

[p1024029]

Hi,

Please check the IUUC_TAB_ALLOWED table entries in SLT and in source system as well if the source system is ABAP system.

IUUC_TAB_ALLOWED: To maintain restrictions whether to create a table in target or not.

Cheers,

NB

[former_member182537]

Hi Naresh, Thanks for rpely,

None of entries exist in this table either in SLT or SAP ECC (our source)

please confirm what need to be maintained here?

Also provide the related SAP Note

our ECC is on SP7 and SLT is on SP9 and we have not observed any other major issues.##thanks

nilesh

[former_member182537]

so if the entry is blank it should replicate all tables then not sure why its giving error. please advice

[p1024029]

Hi Nilesh,

Error shown in the screen shot was fixed by fixing this IUUC_TAB_ALLOWED.

Yes you are correct, if this table is empty then SLT should create all table in target.

we have faced some other issues regarding datype conversion from MaxDB to HANA. So one of the first SAP Note 2173478 we applied fixed the issue related data type conversions. there are other notes we applied and they also related to data types and data formats.

NB

[former_member182537]

ok thanks ,

I am getting below logs in SM21

Database error 904 with UPD access to table /1LT/00000000201

> con=1(10.60.98.155:1521/PDBST1): ORA-00904: "ALWAYSTRP":

> invalid identifier

how to know which table is it linked to ? cant find any table details & it keeps on occuring every min in SM21 logs.

thanks

[abhishek_singh11]

Hi Naresh,

Please apply Note 1824710 - Installation/Upgrade SLT - DMIS 2011 SP4 / 2010 SP9.

Else, you can do the following steps:

• Deleting Triggers in ECC database
• Deleting logging tables
• Deleting RS_ORDER and RS_STATUS entry for that table in HANA
• Deleting that table entry in the SLT Server

1. GOTO /niuuc_sync_mon
2. GOTO Expert Session
3. Delete Logging Tables
4. Delete Triggers
5. /ose16
6. iuuc_tables
7. DMC_MT_TABLES
8. DMC_COBJ IDEN=*003*
9. IUUC_RS_ORDER
10. IUUC_RS_STATUS /h(ABAP Debug)

Then re-replicate the table

Thanks Much,

Abhishek

[p1024029]

Hi Abhishek,

Thanks for your reply,

Now we upgraded SLT to DMIS 2011 SP08 but still issue persist. any idea?

Thanks,

Naresh

[former_member196555]

The steps Abhishek mentioned should clean up the system. Can you try creating an alternate MT ID and then start replicating the tables? Just to ensure that clean-up was done properly?

Regards,

Harshad.