TeleFlow Forums
http://teleflow.org/phpbb/

SQL: Parameter reset - query runs outside of TeleFlow
http://teleflow.org/phpbb/viewtopic.php?f=10&t=505		 Page 1 of 1
Author:  susan.burkley [ Wed Mar 26, 2008 9:28 am ]
Post subject:  SQL: Parameter reset - query runs outside of TeleFlow
The call number keeps ‘resetting’ to ‘0’, even know there is a record. (I’ve tested externally with success.) Since the call number is set to 0, it throws off the rest of the flow. Here is the log output:

2008/03/23 15:12:56.093: [1] START
2008/03/23 15:12:56.109: [3] Run Flowchart
2008/03/23 15:12:56.109: Flowchart is 'dbset'
2008/03/23 15:12:56.109: OutboundReq_Check==>
DbSet
2008/03/23 15:12:56.125: [1] START
2008/03/23 15:12:56.125: [3] Set Global Variable
2008/03/23 15:12:56.125: Setting global variable '@DB_COUNTER' to '4'
2008/03/23 15:12:56.125: [2] FINISH
2008/03/23 15:12:56.125: OutboundReq_Check<==DbSet
2008/03/23 15:12:56.125: [14] DB Connect
2008/03/23 15:12:56.125: Parameters is 'DSN=Voice'
2008/03/23 15:12:56.125: ConnectString: DSN=Voice
2008/03/23 15:13:01.453: SQL Error State: 01000
Native Error Code: 1645
ODBC Error: [Microsoft][SQL Native Client][SQL Server]Changed database context to 'Voice'.
2008/03/23 15:13:01.484: SQL Error State: 01000
Native Error Code: 1647
ODBC Error: [Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.
2008/03/23 15:13:01.562: SQL Error State: HY092
Native Error Code: 0
ODBC Error: [Microsoft][SQL Native Client]Invalid attribute/option identifier
2008/03/23 15:13:01.562: [5] SQL Statement
2008/03/23 15:13:01.562: Handle is '1'
2008/03/23 15:13:01.578: Warning time threshold is ''
2008/03/23 15:13:01.578: Empty Warning time threshold defaults to '2000'
2008/03/23 15:13:01.578: <----- BEGIN ----->
USE VOICE

SELECT DISTINCT TOP 1
PhoneNo AS OUTCALLNUM
FROM
Patient, Link
WHERE
Patient.PatientID = Link.PatientID

<----- END ----->
2008/03/23 15:13:02.359: Success with info
2008/03/23 15:13:02.359: Elapsed Time: 0.797
2008/03/23 15:13:02.375: [7] SQL Fetch
2008/03/23 15:13:02.375: Handle is '1'
2008/03/23 15:13:02.375: ERROR: Can only fetch records after select statements.
2008/03/23 15:13:02.375: FAILURE
2008/03/23 15:13:02.375: [11] Set Global Variable
2008/03/23 15:13:02.390: Setting global variable '@OUTCALLNUM' to '0'
2008/03/23 15:13:02.390: [2] FINISH
2008/03/23 15:13:02.390: Outbound_Main<==OutboundReq_Check
2008/03/23 15:13:02.390: [93] Compare
2008/03/23 15:13:02.406: First Value '@OUTCALLNUM' evaluates to '0'
2008/03/23 15:13:02.406: Second Value is '0'
2008/03/23 15:13:02.406: @OUTCALLNUM = 0?
2008/03/23 15:13:02.406: (integer):0 = (integer):0?
2008/03/23 15:13:02.406: TRUE
2008/03/23 15:13:02.421: [100] Wait
2008/03/23 15:13:02.421: Delay '@CHECK_PAUSE' evaluates to '30000'
2008/03/23 15:13:02.421: Waiting 30000 milliseconds
2008/03/23 15:13:32.421: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@
2008/03/23 15:13:32.421: [31] Run Flowchart
2008/03/23 15:13:32.421: Flowchart is 'DEFAULTS'

Any assistance that you may provide will be greatly appreciated. Thanks in advance,
Author:  Chris [ Tue Jun 24, 2008 10:34 am ]
Post subject:  Re: SQL: Parameter reset - query runs outside of TeleFlow
This issue was handled off-line, but for the benefit of those in the forums:

You can see in the log snippet that the SQL Fetch is failing, and when it does, it sets the number to 0.
Quote:
[7] SQL Fetch
2008/03/23 15:13:02.375: Handle is '1'
2008/03/23 15:13:02.375: ERROR: Can only fetch records after select statements.
2008/03/23 15:13:02.375: FAILURE
2008/03/23 15:13:02.375: [11] Set Global Variable
2008/03/23 15:13:02.390: Setting global variable '@OUTCALLNUM' to '0'

The SELECT statement was incorrect because of the "USE VOICE" line. Since the DB Connect step already set the database to use, no clause to set the database to use was required anyway.
Page 1 of 1 All times are UTC - 8 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/