Toad World® Forums

Rowcount variable in 2.5 isn't showing up in email subject or body


#1

I’ve just upgraded to Toad for Data Analysts 2.5 and I’m having trouble getting the new automation variables feature to work.

I’ve set the “Row count variable” in my Select to File activity to “rc” (no quotes). The query does select 2761 rows from an Oracle database. Log message indicates “Row count variable rc set to 2761 rows”. However, in the Send Email activity, this variable doesn’t show up in the subject “#rc# Rows Output” or body “You have selected #rc# rows.” The email is sent and received fine, and the attached Excel file looks great. Subject and body both still contain the literal value “#rc#”.

Any ideas?


#2

This works for me. Can you attach you log fil for me to look at.

Note: The variable names are case sensitive.

Debbie
rc.png


#3

Here’s the log:

– 9/10/2009 3:49:14 PM: MigrationList.log: Build started
– 9/10/2009 3:49:18 PM: MigrationList.log: Activity ‘ExceptionEmail’ validation warning: Text of message body is not specified
– 9/10/2009 3:49:18 PM: MigrationList.log: Build Completed
– 9/10/2009 3:49:18 PM: MigrationList.log: Connecting to

(Server)

– 9/10/2009 3:49:18 PM: MigrationList.log: Connection successful.
– 9/10/2009 3:49:18 PM: MigrationList.log: Begin Export
– 9/10/2009 3:49:18 PM: MigrationList.log: SQL to execute:

(Query)

– 9/10/2009 3:49:18 PM: MigrationList.log: Beginning export.
– 9/10/2009 3:49:49 PM: MigrationList.log: Attempted to export 2761 rows.
– 9/10/2009 3:49:49 PM: MigrationList.log: Successfully exported 2761 rows.
– 9/10/2009 3:49:49 PM: MigrationList.log: Export Finished, click

(Filename)

to view file.
– 9/10/2009 3:49:49 PM: MigrationList.log: Row count variable rc set to 2761 rows
– 9/10/2009 3:49:49 PM: MigrationList.log: Send email


#4

Unfortunately, that did not give me enough information. Can you zip up the Automation script (*.tas) and corresponding files and post or send to me in private email?

dpeabody@quest.com