Skip to main content

[Common] Automation Engine

Answered

Comments

6 comments

  • Best answer
    Ben Bauer

    Hi Guillaume,

    The list of variables is equal to the column names in the "Data Load - View".  You can get the database name and the view name for the "Data Load - View" from the vertical of the Task record in the Automation Engine.  For example, Common -> Automation Engine -> Automation Instruction Tasks -> {vertical}.  You can also drill into the designs of these views if you wish to understand how the content is generated.

    0
  • Guillaume Brochet

    Hi,

    After 22 days, the only way i found to match AE-Instruction with dsp web interface is usage of SQL monitoring tool.

    Time spent on this topic was very rewarding, this is a very powerful toolset inside dspMigrate.
    Once the basics are understood, in introduce much threshold into the tools.

    Best regards

    2
  • Tyler Warden

    Thanks for the feedback Guillaume and impressive research.  I am curious what in say the front end of the application or in the help or blogs would have saved you some time from those 22 days.  

    0
  • Guillaume Brochet

    Hi Tyler,

    What could be useful at front end is the possibility to display the associated "Automated Instruction" runned when clicking, or at least have it traced in a log somewhere (when a action fails we can see in the log something like :

    Build failed for 'srSAL001_CLIENT_IRIS_CLIENT_zLegacyKUNNRUpdSel' in database 'dswBB_EUR_SAP_PREP'. Executing Rule SQL for Instruction Group "Register+Source+Rule"-[54ea7eaf-128d-437a-8404-d707e6daa7df]
    Instruction "Register+Source+Rule+-+EUR"-[1ad85c44-b937-4254-bd18-2540f02805a9] 
    0
  • Guillaume Brochet

    What would also be very useful is the list of inside variable available in AE like #AutoGenerateRule#, #ACTION#, #boaUserId#, and insight of how their content is generated !

    0
  • Guillaume Brochet

    Thanks Ben for this additional info. 

    0

Please sign in to leave a comment.