DIAdem
Diadem 2020 - Analysis script does not trigger automatically
@dmurthy wrote:I am seeing an odd issue on our SystemLink 2020 server where -
- Triggered analysis script do not execute while the same analysis script executed manually on the server run.
- This only happens for analysis scripts that use Data Finders generated in 2020. Data finders generated in previous versions and migrated to 2020 work without problems.
I can reproduce this.
Triggered Task works fine on SystemLink 19.6 + TDM 19.6. It seems to continue to work when I upgrade the server to SystemLink 20.1 + TDM 20.1.
However, on a new VM that has 20.1 installed directly, the same script no longer works (even though I used the same settings).
The error only occurs if Data Filtering is enabled. It works fine on 20.1 if Data Filtering is disabled: https://forums.ni.com/t5/SystemLink/SystemLink-TDM-Enabling-Data-Filter-causes-errors-in-Analysis/m-...
Hi Eva,
Thank you for responding. Unfortunately, this information does not help to get the automations back running.
I put the same Analysis Automation Procedure in a Triggered Task and in a Manual Task (using the SystemLink TDM User Account):
When I add a file to the DataFinder Search Area, the Triggered Task starts running but produces an error. But when I put the same file in my Data Cart and run the Manual Task, there is no error:
I don't think the error is caused by a configuration error, because:
- The SystemLink TDM User Account works fine for the Manual Task.
- The SystemLink TDM User Account is a local administrator account, which has permission to run as a background service.
- The Triggered Task works fine if I disable Data Filtering (see https://forums.ni.com/t5/SystemLink/SystemLink-TDM-Enabling-Data-Filter-causes-errors-in-Analysis/m-... )
I've attached the sample ANP and TDM files used to generate this error. Are you able to create a Triggered Task that successfully uses these files on SystemLink 2020 R2 + SystemLink TDM 20.1?
Hi JKSH,
Since 20.1 it is not sufficient to grant Windows administrator privileges to the SystemLink TDM user account. You also need to add execute query permissions in the SystemLink security WebUI.
Note: You will not see this application with your normal user account. This application is only visible to SystemLink Server administrators.
If you run the task with items in the DataCart no DataFinder query is executed from within the task. In this case the query has been executed before by you before you added the files to the DataCart.
When executing a task with Data Filtering enabled (and using a DataFinder as data source instead of DataCart) the DataFinder is always used/queried to get the list of files the tasks works on.
Are you already familiar with the new security web application and is it possible for you to figure out whether the SystemLink TDM account has been granted execute query priviliges in the Security application? Please let me know if you need more instructions here.
Have a nice day,
Eva
Hi Eva,
Thank you, you are a lifesaver! I used the Security web app to assign the "Data Maintainer" role to the SystemLink TDM User Account. The triggered task now runs successfully.
@EvaW wrote:
Since 20.1 it is not sufficient to grant Windows administrator privileges to the SystemLink TDM user account. You also need to add execute query permissions in the SystemLink security WebUI.
This is the crucial piece of information that I was missing. I thought that my SystemLink TDM User Account already had those permissions because I can use that account to log into Windows and execute queries via DIAdem. I didn't realize that permission to execute queries via DIAdem doesn't translate to permission to execute queries via the Analysis Automation instance.
Could NI please document the new 20.1 requirements clearly in the release/upgrade notes, manual, and help files? (If the documentation already exists, could you please point me to it?)
Currently, the NI SystemLink TDM Configuration app says that the account needs "access permissions for executing Analysis Automation and Data Preparation tasks. Refer to the Help for more information." However, neither the app nor the Help mentions that it needs permissions to execute queries:
I'd like to suggest an improvement to the workflow: When the account is first set up in NI SystemLink TDM Configuration, perhaps the app could offer to assign the required permissions (or check the account's permissions and alert the admin if they are not set up).
@EvaW wrote:
If you run the task with items in the DataCart no DataFinder query is executed from within the task. In this case the query has been executed before by you before you added the files to the DataCart.
When executing a task with Data Filtering enabled (and using a DataFinder as data source instead of DataCart) the DataFinder is always used/queried to get the list of files the tasks works on.
I'm trying to understand this behaviour.
- To run a triggered task with Data Filtering, the account needs permission for Data Indexing and Navigation > Execute queries but does not need permission for Analysis Automation and Execution > Execute tasks -- Why is that?
- The task is only triggered after the Analysis Automation Instance has already determined that the file matches the filter. Would it be possible for the Instance pass the file to the task, just like how the Data Cart passes the files to the task?
