CUAN_IC_MASTERDATA_EXTR_DELT not working

[Former Member]

Hello Experts,

While trying to execute ABAP program CUAN_IC_MASTERDATA_EXTR_DELT ,I'm getting the following message:

Trigger SAP_IC_EXTR_ADCP_S400_L200_I for table ADCP in schema SAP_CUAN_CRM_DATA does not exist

I checked Triggers folder under SAP_CUAN_CRM_DATA and it's empty ,searching through this website I've done the following:

*Reset triggers on LTRS tx on SLT Server

*Reset replication status on LTRS Transaction

Do you know how to solve this issue?

Thanks in advance for any help provided 🙂

[Former Member · Accepted solution]

Hi Bernardo,
According to a colleague, the latency time refers to a healthcheck of SLT, that checks the time between writing the entry in the log table to successful replication in target system. It should not lead to an error, so maybe the error is not related to the latency data entry, but has other reasons. The recommendation of SLT, is to always have the latest corrections installed. You can find them in the corresponding SLT note for your SLT release, see also note 2014562 .
Then maybe it could help to just drop the table from this SLT config and replicate again (from SLT cockpit). Is there data in table ADCP? Could you maybe create a data set triggering an entry in ADCP (workplace related address data for contact in your source CRM) and check if it gets replicated? best regards, Sophie.

[Former Member]

Hello Bernardo,
these triggers are on some of the tables of the replicated Schema (in your case SAP_CUAN_CRM_DATA). They get created via the task "Create Full Text Indexes for SAP CRM Tables".
Have you performed the replication of the CRM data via the task list CUAN_SETUP_CRMCONTENT? It normally does all the necessary tasks for you (it also schedules the report CUAN_IC_MASTERDATA_EXTR_DELT as job). If yes, did the step produce an error?

You could do now the following:
just rerun the task list "CRM Integration" from TC Cockpit (trx. cuan_technical_conf). It is "re-executable".

In case you just want to create the triggers for some reason:

• go to transaction stc01 and enter CUAN_SETUP_CRMCONTENT as task list
• create a copy of this task list and name it e.g. Z_CREATE_TRIGGERS
• click on edit and remove all tasks except
  * CL_CUAN_TC_SETUP_CRMCONTENT Define Parameters for Technical Configuration
  * CL_CUAN_TC_CRM_FULLTEXT_INDEX Create Full Text Indexes for SAP CRM Tables
• just run this task list now, it will create the necessary triggers on the selected tables.

For more information see also Chapter CRM Integration in the installation guide.
best regards, Sophie.

[Former Member]

Hello Sophie,

Thank you for having replied to my question, following your advice I executed CUAN_SETUP_CRMCONTENT and it showed the following error:

SAP HANA host for SAP CRM LT replication not provided

The same error is showed on TC Cockpit

My question is how can I add SAP Hana Host on Hybris Marketing

Best regards,

Bernardo

[former_member747290]

Hello!

For create trigger you can see note 2144527.

Best regards,

Pavel

[Former Member]

Hello Bernardo,

it depends a bit your setup. The CRM Integration task list has different parameters.
If you chose as Deployment "Use of Replicated Schema", the task list expects parameters for connecting to the SLT server. The error you mention points to the LT Hana Target Host: this is in your SLT configuration the value for the Hana target host (system where data is replicated to from view of SLT, in your case the Hana of your Marketing system) Note also that you need to enter the value in the CRM task list parameter exactly as in your SLT configuration (syntactically).
In case you already have your replication done (as this seems the case according to your initial description), you already have a CRM target schema in your Hana tenant DB, and you should use CRM deployment option "Reuse of original schema". Then you do not need to provide the SLT target hana host in the task list parameters, but just the name of the CRM Schema, let the task list run and it will do the necessary steps for the triggers and replication jobs.
In case you experience issues with the task list parameters due to former runs that where not successfully, it can help to reset the stored task list parameters as described in note 2400761. Best regards, Sophie.

[Former Member]

Hello Sophie,

Thank you again for your reply and sorry for my delay, my team has successfully solved the issue above but on the Technical Configuration Cockpit we are facing the following issues:

• When run the configuration , tc stops at the step 11/16 Trigger Table Replication for SAP CRM

• When we check LTR , table ADCP is sending the following error "Access Calculation failed" , last week submitted a note to SAP and they say we needed to create a filter on that table. In this case as I wrote early the schema SAP_CUAN_CRM_DATA was replicated before so we are reusing this schema with a new mass transfer ID.

What could be the best strategy to solve ADCP issue?

Greetings

Bernardo