[Common] Automation Engine

Answered

Comments

6 comments

  • Best answer
    Avatar
    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.

    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    Guillaume Brochet

    Thanks Ben for this additional info. 

    0
    Comment actions Permalink

Please sign in to leave a comment.