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: Dataset: Variable "sql_nid.CurrentRow" could not be set
Topic Summary: Looping through a dataset
Created On: 01/12/2018 06:22 AM
Status: Read Only
Linear : Threading : Single : Branch
 Dataset: Variable "sql_nid.CurrentRow" could not be set   - TimoCordes - 01/12/2018 06:22 AM  
 Dataset: Variable   - Leonard Amabile - 01/12/2018 06:26 AM  
 Dataset: Variable   - TimoCordes - 01/12/2018 07:07 AM  
 Dataset: Variable   - TimoCordes - 01/15/2018 02:43 AM  
 Dataset: Variable   - Mary Manzano - 01/16/2018 02:10 PM  
 Dataset: Variable   - TimoCordes - 01/18/2018 05:19 AM  
 Dataset: Variable   - Devin Cannon - 01/19/2018 11:44 AM  
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Devin Cannon, on Wednesday, January 24, 2018 2:07 AM

Answer:
Hi,

In the task it's looping the "sql_nid" dataset (Step 14) but then before the end of the loop it's repopulating "sql_nid" with different information (Step 38). That logic seems strange - not sure if that's intended - but I'm able to reproduce this error if the query on Step 38 returns Null.
 01/12/2018 06:22 AM
User is offline View Users Profile Print this message

Author Icon
TimoCordes
Apprentice (20-49)

Posts: 35
Joined: 04/12/2016

Hi Guys,

i have a little problem. I modified an older job. After that modification there is a looping through a dataset which contains a loop through another dataset (both from SQL querys). The job runs fine thorugh the first pass and after he complete the first run and got back to the start of the "big" loop i got following error: Variable "sql_nid.CurrentRow" could not be set.

Any one a hint?

Regards
Timo

 Category Survey
AutoMate 10 version: 10.7.0
Windows version: Windows 10
Statistics
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 3609 guests browsing this forum, which makes a total of 3609 users using this forum.

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

Sitemap Network Automation Software Blog