Delete trigger during ECC Upgrade

[pan_cheng]

Hi Experts,

We had set up SLT server to replicate data from ECC to HANA. We are going for ECC upgrade. While doing ECC upgrade in dev enviroment we are getting errors that about the triggers existing on the system. As per the SAP note 1620618 it looks we need to delete the triggers that were set up on ECC. Any idea how to handle the scenario. Does Reset Trigger works in this scenario. We don't want to load or replicate tables again. Can you please provide the details steps that needed to recover after deleting triggers on ECC. Appreciate your help.

Thanks,

[Former Member]

Hi Pan, Thank you so much for quick response. Apart from DD* tables, we are getting the below error in the Downtime phase MAIN_SWITCH/EU_SWITCH for tables which has triggers. We had to delete triggers to proceed. Do we need to reload these tables again or create triggers manually and resume replication ? 3 ETQ398 SQL: RENAME "USMD202T_2" TO "USMD202T_2~~OLD" 4 ETQ010 Date & Time: 20160822113638 3 ETQ398 SQL: RENAME "USMDZ5201" TO "USMDZ5201~~OLD" 3 ETQ398 SQL: RENAME "USR21" TO "USR21~~OLD" 4 ETQ010 Date & Time: 20160822113638 1EETQ008 Error message: DBSL error 99 (db code -750): 1EETQ009XSQL0750N The statement failed because the table or column cannot be renamed. 1EETQ009XSQLSTATE=42986 1EETQ003 exit code: "20" Regards, Anil

[Former Member]

Hi Pan,

We are in the similar situation, in our development ECC upgrade to EhP8, in the downtime phase SUM tool could not rename tables which has triggers, so we had to delete the triggers and proceed with the upgrade.

If we delete the triggers is there a way to resume the replication or do we need to reload the tables?

How was your testing, could you please post your test experience.

Regards,

Anil

[pan_cheng]

Hi Anil,

We upgraded  and it is successful Here  are the steps

Ensure there are no unprocessing records and deactivate SLT Config. When the upgrade is completed reset trigger flag and recreate the triggers by following below steps.

Log into LTRC | MT_ID | Expert Functions | Reset Status for Triggers and Logging Tables | Select 'Reset

"Trigger created" flag'

Log into LTRC | MT_ID | Processing Steps | Create Database Trigger

If issues with DD* tables please reload these tables. They are small and should not cause any issues to

your SLT configuration.

After creating the triggers then activate SLT Config.

Thanks,

[pan_cheng]

You can also refer SAP note 2250802.

Thanks,

[thirunavukarassu_saravana]

Which version of ECC are you upgrading? For which tables are you getting errors?

I remember for doing a EHP upgrade in our ECC landscape, we had to drop only the triggers of DD02T, DD02L & DD08L tables. We just reloaded these tables after the upgrade as these are not going to cause any troubles. In your case, is it complaining about the other application tables?

[pan_cheng]

Thanks Saravanan for your quick response. Its complaining about the triggers on DD02T, DD02L, DD08L Tables only.  If we delete the triggers how to create the triggers again. I couldn't get your statement that reloaded the tables after the upgrade. Do you meant to say we have to create configuration again. We are replicating around 40 tables. What steps we have to do before deleting the trigger and after deleting the trigger. If we won't enable the trigger how does SLT knows from which record we have to replicate. Can we suspend the replication and resume it after the upgrade. Appreciate your help.

Thanks,

[thirunavukarassu_saravana]

Hi Pan,

You dont need to recreate the SLT configuration and the other 40 tables will not be impacted by this. Only the DD* tables will be impacted and it is okay as it's not going to affect any other tables.

You can follow the below steps:-

1) Stop Replication for tables DD02L, DD02T & DD08L in SLT. This will delete the triggers in the ECC system

2) Deactivate the SLT configuration before the upgrade downtime phase starts (to stop the data replicating from ECC to HANA during the upgrade)

After the upgrade,

1) Activate the SLT configuration

2) Add the tables DD02L, DD02T & DD08L in SLT using Start Replication option. This will create the triggers and load the tables again.

[pan_cheng]

Thanks a lot Saravanan. I am going to test this in our test environment. Two more questions.

Before upgrade

1) Stop Replication for tables DD02L, DD02T & DD08L in SLT. This will delete the triggers in the ECC system (Do we need to stop replication or Suspend also works here)

2) Deactivate the SLT configuration before the upgrade downtime phase starts (to stop the data replicating from ECC to HANA during the upgrade)

After the upgrade,

1) Activate the SLT configuration

2) Add the tables DD02L, DD02T & DD08L in SLT using Start Replication option. This will create the triggers and load the tables again. (This is same like adding any other table for replication right)

Once again appreciate your help.

Thanks,

[thirunavukarassu_saravana]

Pan,

Please find my answers below:-

Do we need to stop replication or Suspend also works here? - We need to stop replication. Suspend will not work as it will not delete the triggers. Suspend is like pausing the replication & resuming it, which will not help in this case.

This is same like adding any other table for replication right? - Yes, that's right, same like any other new table in SLT.

Please test and let me know your feedback.

[pan_cheng]

Thanks Saravanan. Appreciate your help.

Thanks,