Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Shared Dataset loop
Topic Summary: Shared Dataset loop
Created On: 04/13/2018 04:35 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 04/13/2018 04:35 AM
User is offline View Users Profile Print this message

Author Icon
Apprentice (20-49)

Posts: 35
Joined: 04/12/2016

Hi Guys,

I actually designing a workflow where in one task a sql action create/update an dataset with information that i need in another task of the workflow. So i create two datasets (dtnid1 and dtnid2) in the workflow designer. Then i add the task where the SQL statement updates the dataset and added there in create and populate dataset dtnid1. In the following task there is an loop action for this dataset (dtnid1).
I start the workflow and in the second task i got an error that the variable/dataset are not existing. I checked a sample task where the shared dataset is used (workflow loop). So far it looks identicly (without the loop action).

So where is mistake?

 04/14/2018 03:05 AM
User is offline View Users Profile Print this message

Author Icon
Apprentice (20-49)

Posts: 31
Joined: 05/29/2012

I quickly tested this and it worked good.

1. Added a dataset called dtnid1 in Workflow designer.
2. Created a task with this code that is running on one machine

<AMFILESYSTEM ACTIVITY="get" MODE="folder" SOURCE="c:\spool\" RESULTDATASET="dtnid1" FILEPROPERTY="fullname" />

3. Added a second task running on another machine. Added this code:

<AMLOOP ACTIVITY="dataset" DATASET="dtnid1">
<AMFILESYSTEM ACTIVITY="write_file" FILE="c:\temp\dtnid1.txt">%dtnid1(2).FullName%</AMFILESYSTEM>

The second task both displayed the datasets data in the loop as well as wrote the data to the file outside the loop.

Maybe you have a type or something somewhere?
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 3132 guests browsing this forum, which makes a total of 3132 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog