AdhocProjection works for Insert but not for Delete

I have a custom process on UNSAccountBinUNSGroupB that calls and runs Sync project workflow.

It works for Insert event.

I have another workflow for deletion with the same mapping just processing is set to just delete in target system.

I run the Process, synchronization is called but in the logs I do not see any action (no delete action).  It always tries Insert action!

How to set adhoc projection step to be able to delete object ? 

Parents Reply Children
  • version is 8.0.1

    Yes two different workflows ...I tried first with just one for Assignments and removal but because it did not worked I split it in to two! 

    If in processing I leave only DELETE when onject exists only in Target system nothing happens ....If I add also insert then I get insert. ...so it must be a problem of execution.

    In Adhocprojection step I have set correct UID_DPRProjectionConfiguration (workflow) and UID_DPRSystemVariableSet (variable set).

    No matter what I do I always get INSERT in SYNC logs. 

  • Did you tried to use the events ASSIGN and REMOVE instead of INSERT and DELETE? For M:N tables these are the ones to go. In addition, what type of connector are you using? 

  • Yes I use Remove/Assign events as they are the only events on UNSAccountBinUNSGroupB. ...but I generate event Remove on an record, process is triggered, ADHocProjection runs but in the sync logs I get only Insert on none (detending on Processing setting in the workflow)

  • How can I tell the adhocprojection that this should be a delete execution method? 

  • Again, what type of connector are you using?

    In addition, can you post the CausingEntityPatch from the process step that does an insert instead of a delete?

  • I thinkYou are right. I see that object state in CausingEntityPatch for object deleted in UNSAccountBinUNSGroupB  is 

    <Data State="Loaded, PermissionBased" />

    ...observing normal action I see that state is 

    <Data State="Loaded, Deleted, ToDeletePhysical" />.

    I tried to "hardcode" the entity patch with Data state change to "Loaded, Deleted, ToDeletePhysical"  but it did not do anything again!

  • causing entity patch is bellow and connector is SAP CUA:

    This bellow runs , all looks OK but I still do not get the Delete Execution!

    <?xml version="1.0" encoding="UTF-8"?>
    <Patch Display="900.00.SOL/Alfa Beta - TEST">
       <Key>
          <T>UNSAccountBInUNSGroupB</T>
          <P>d36e6fe3-79b7-4ec9-a19a-9613e889c46a</P>
          <P>f6f827d6-76be-4753-988c-1abde61fb80a</P>
       </Key>
       <Diff>
          <Data State="Loaded, Deleted, ToDeletePhysical" />
          <Op Columnname="RiskIndexCalculated" Type="Value" ValType="Double" AlreadyApplied="True">
             <OldValue>0</OldValue>
             <Value>0</Value>
          </Op>
          <Op Columnname="UID_UNSAccountB" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue>d36e6fe3-79b7-4ec9-a19a-9613e889c46a</OldValue>
             <Value>d36e6fe3-79b7-4ec9-a19a-9613e889c46a</Value>
          </Op>
          <Op Columnname="UID_UNSGroupB" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue>f6f827d6-76be-4753-988c-1abde61fb80a</OldValue>
             <Value>f6f827d6-76be-4753-988c-1abde61fb80a</Value>
          </Op>
          <Op Columnname="XDateInserted" Type="Value" ValType="Date" AlreadyApplied="True">
             <OldValue>2019-05-15T08:56:51.7600000Z</OldValue>
             <Value>2019-05-15T08:56:51.7600000Z</Value>
          </Op>
          <Op Columnname="XDateUpdated" Type="Value" ValType="Date" AlreadyApplied="True">
             <OldValue>2019-05-15T08:56:51.7600000Z</OldValue>
             <Value>2019-05-15T08:56:51.7600000Z</Value>
          </Op>
          <Op Columnname="XIsInEffect" Type="Value" ValType="Bool" AlreadyApplied="True">
             <OldValue>True</OldValue>
             <Value>True</Value>
          </Op>
          <Op Columnname="XMarkedForDeletion" Type="Value" ValType="Int" AlreadyApplied="True">
             <OldValue>0</OldValue>
             <Value>1</Value>
          </Op>
          <Op Columnname="XObjectKey" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue>&lt;Key&gt;&lt;T&gt;UNSAccountBInUNSGroupB&lt;/T&gt;&lt;P&gt;d36e6fe3-79b7-4ec9-a19a-9613e889c46a&lt;/P&gt;&lt;P&gt;f6f827d6-76be-4753-988c-1abde61fb80a&lt;/P&gt;&lt;/Key&gt;</OldValue>
             <Value>&lt;Key&gt;&lt;T&gt;UNSAccountBInUNSGroupB&lt;/T&gt;&lt;P&gt;d36e6fe3-79b7-4ec9-a19a-9613e889c46a&lt;/P&gt;&lt;P&gt;f6f827d6-76be-4753-988c-1abde61fb80a&lt;/P&gt;&lt;/Key&gt;</Value>
          </Op>
          <Op Columnname="XOrigin" Type="Value" ValType="Int" AlreadyApplied="True">
             <OldValue>1</OldValue>
             <Value>0</Value>
          </Op>
          <Op Columnname="XTouched" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue />
             <Value />
          </Op>
          <Op Columnname="XUserInserted" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue>xx_user</OldValue>
             <Value>xx_user</Value>
          </Op>
          <Op Columnname="XUserUpdated" Type="Value" ValType="String" AlreadyApplied="True">
             <OldValue>xx_user</OldValue>
             <Value>xx_user</Value>
          </Op>
       </Diff>
    </Patch>

    (p.s. ...CODE insert tool for XML does not work on the site!)
  • interestingly... deleting object in UNSAccountBinUNSGroupB  (or to say proper... removing group membership) produces   Causing entity patch withthis event state:

    State="Loaded, PermissionBased" 

    This looks really strange to me!

  • Weird. I think you should contact support then as this may has to do with some of your custom mapping rules in the synchronization project.

    But may I ask why you are connecting CUA to UNS and do not use the OOTB CUA stuff? 

  • ;-) ...SAP Authorization and SAP CUA on same IM system problem (we talked in Budapest if You remember).

    But They need some minor stuff linked to CUA also in this system... so UNS !