[Automate] Troubleshooting

Solution: DSP

Version: 6.7

Component: Automate

As continuation of my previous post , [Automate] Getting started, I want to complement it with a basic guide about some of the most common error/questions I have seen in different projects.

The first one occurs usually when you have just started and want to run transform from Automate, then you open the DataSourceID drop down and ask to your self,

Is it possible to have an interface with Targets from different dsw*?

Yes it’s possible, the common mistake here is that we commonly we think that DataSourceID has to be a specific dsw (like dswMM or dswPP), but actually not, you can make up your own by creating a new data base in SQL (dswAutomate_W1 in this example):

We have grouped the transformation process by “Load Group”, so we have Group01:

Which contains 24 Targets (from different process areas)

This is possible because you do not have a drop down when you assign the ID, it is free text, so you can add any key value (independent of process area):

The second most common is when you have set up your first interface but are having the first error messages, but those, in some cases do not give much information,

How can we found the issue?

This really depends on the consultant skills and knowledge about DSP. We have to notice that in Automate we are building a very customize list of tasks and you need to understand how DSP works, including validations, naming convention and general logic.

As starting point, check the following;

Interface>History:

Then you can check the history:

Tasks has assigned a severity (with images) which indicates what happen during the specific task;

You can check the meaning and even change it (not recommended):

Once you have been able to find the error message, in some cases,this is not enough to fully understand the complexity of the error, from my experience I would like to highlight the three most commons (when you are working Targets and Transform);

1. Please note that if a Target/Object is in status invalid and you try to transform it (someone has been working on it and the transformation failed and you did not reset it), then Automate will skip it (you do not see an error message). What do I do? I have a report that shows the last time a Target was executed. So I can check after Automate has run, if there is something missing. You can also add the boaStatus from transform (all this either in a custom report or custom page).
2. Time out. Many times a target just fails (without apparently reason – please check the error) due to timeout (but this is similar if you try to run multiple targets in parallel). I do not run more than 1 interface at the time and then, all targets in sequence.
3. For the error due to @Publish, what is likely happening is that you passed the wrong key, for instance, WaveProcessAreaObjectID when it should be WaveProcessAreaObjectTargetID (or the other way around). Some screenshots where I replicated the error (passing the TargetID instead of ObjectID).

I hope this helps you.

Please do not hesitate to ask any questions.