Automation script “HEALTHNET” had errors while executing. The execution message and steps are listed below.
Continue on Error Exception Messages:
Exception Messages:
Encountered problem with spooling data to disk.
Closing result spool file.
12288 rows lost from the current result.
Build started
Activity ‘ExceptionEmail’ validation warning: Text of message body is not specified
Build Completed
Executing default description activity
Destination folder name: W:\FL-Tampa-Woodland\RNCBSC\DM\Reports\Monthly Reports\Automation\
File will be copied and not moved
Copied file W:\FL-Tampa-Woodland\RNCBSC\DM\Reports\Monthly Reports\Automation\HealthNet_.xls to W:\FL-Tampa-Woodland\RNCBSC\DM\Reports\Monthly Reports\Automation\HealthNet_2009-10-23.xls
Connecting to ONW_RPT.WORLD (JJSHAWI), NETWORX_OWNER
Connection To: ONW_RPT.WORLD (JJSHAWI), NETWORX_OWNER
Connection successful
Connection logon: JJSHAWI
Last schema: NETWORX_OWNER
Default schema: NETWORX_OWNER
Auto Commit: False
Connection successful.
Executing script: W:\FL-Tampa-Woodland\RNCBSC\DM\DMToadScripts\MonthlyReports\ScriptEditor\HEALTHNET_CONT.sql
Executed Statement
Executed: SELECT DISTINCT T1.PROVPARENTID
, T1.PROVID
, T1.PROVNAME
, T1.ADDR1
, T1.ADDR2
, T1.CITY
, T1.STATE
, T1.ZIP
, T2.SERVICECATID
, T4.COUNTYNAME
FROM TBLPROV T1,TBLPROVIDERSVCCATEGORY T2,TBLPROVCONTRZIP T3, TBLZIPCODEAREA T4
WHERE T3.ZIPCODE = T4.ZIP
AND T1.PROVID = T3.PROVID
AND T2.PROVID = T1.PROVID
AND T1.PROVPARENTID <> 3
AND (T1.PROVID <> 2050 And T1.PROVID <> 9782)
AND (T1.STATE = ‘CA’)
AND (T2.SERVICECATID = ‘THH’)
AND (T2.PROVSVCCATRATING BETWEEN 50
AND 59)
AND (T2.SVCCATRATINGST = ‘CA’)
ORDER BY T1.PROVPARENTID ASC
Script execution complete
Thread (30) Adding Export Notification Subscriber 10/07/2009 8:15:27 AM
Thread (30) Export Started [10/07/2009 8:15:27 AM]
Thread (30) ** START 10/07/2009 8:15:27 AM
Thread (30) Export Wizard: Building object list
Thread (30) Build List 10/07/2009 8:15:28 AM
Thread (30) Exporting Data
Thread (30) BEGIN 10/07/2009 8:15:28 AM : Query
Thread (30) Object SQL Query started.
Thread (58) InternalReadBackground - start
Thread (58) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 126)
ORDER BY TBLCIGNAFCO.CIGNA_FCO_NO ASC,
TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC
Thread (14) DoneReadTreadWriter
Thread (14) DoneReadThreadWriter finally - adapter.RowsRead 2626
Thread (30) END 10/07/2009 8:15:35 AM : Query
Thread (30) Object SQL Query finished.
Thread (30) Export Finished [10/07/2009 8:15:35 AM]
Thread (30) Build Time 00:00:01.1092898
Thread (30) Complete Time 00:00:08.3899806
Thread (30) ** END 10/07/2009 8:15:35 AM
Thread (52) Adding Export Notification Subscriber 10/07/2009 8:55:39 AM
Thread (52) Export Started [10/07/2009 8:55:39 AM]
Thread (52) ** START 10/07/2009 8:55:39 AM
Thread (52) Export Wizard: Building object list
Thread (52) Build List 10/07/2009 8:55:40 AM
Thread (52) Exporting Data
Thread (52) BEGIN 10/07/2009 8:55:40 AM : Query
Thread (52) Object SQL Query started.
Thread (94) InternalReadBackground - start
Thread (94) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 143)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (93) DoneReadTreadWriter
Thread (93) DoneReadThreadWriter finally - adapter.RowsRead 9
Thread (52) END 10/07/2009 8:55:41 AM : Query
Thread (52) Object SQL Query finished.
Thread (52) Export Finished [10/07/2009 8:55:41 AM]
Thread (52) Build Time 00:00:01.0468415
Thread (52) Complete Time 00:00:02.7342875
Thread (52) ** END 10/07/2009 8:55:41 AM
Thread (52) Adding Export Notification Subscriber 10/07/2009 8:55:44 AM
Thread (52) Export Started [10/07/2009 8:55:44 AM]
Thread (52) ** START 10/07/2009 8:55:44 AM
Thread (52) Export Wizard: Building object list
Thread (52) Build List 10/07/2009 8:55:45 AM
Thread (52) Exporting Data
Thread (52) BEGIN 10/07/2009 8:55:45 AM : Query
Thread (52) Object SQL Query started.
Thread (94) InternalReadBackground - start
Thread (94) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 32)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (92) DoneReadTreadWriter
Thread (92) DoneReadThreadWriter finally - adapter.RowsRead 3170
Thread (52) END 10/07/2009 8:55:52 AM : Query
Thread (52) Object SQL Query finished.
Thread (52) Export Finished [10/07/2009 8:55:52 AM]
Thread (52) Build Time 00:00:00.9687190
Thread (52) Complete Time 00:00:07.5466335
Thread (52) ** END 10/07/2009 8:55:52 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 9:35:31 AM
Thread (95) Export Started [10/07/2009 9:35:31 AM]
Thread (95) ** START 10/07/2009 9:35:31 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 9:35:32 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 9:35:32 AM : Query
Thread (95) Object SQL Query started.
Thread (84) InternalReadBackground - start
Thread (84) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 136)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (81) DoneReadTreadWriter
Thread (81) DoneReadThreadWriter finally - adapter.RowsRead 47
Thread (95) END 10/07/2009 9:35:34 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 9:35:34 AM]
Thread (95) Build Time 00:00:01.4999520
Thread (95) Complete Time 00:00:04.8123460
Thread (95) ** END 10/07/2009 9:35:36 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 9:35:40 AM
Thread (95) Export Started [10/07/2009 9:35:40 AM]
Thread (95) ** START 10/07/2009 9:35:40 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 9:35:41 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 9:35:41 AM : Query
Thread (95) Object SQL Query started.
Thread (81) InternalReadBackground - start
Thread (81) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 144)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (84) DoneReadTreadWriter
Thread (84) DoneReadThreadWriter finally - adapter.RowsRead 46
Thread (95) END 10/07/2009 9:35:44 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 9:35:44 AM]
Thread (95) Build Time 00:00:01.2187110
Thread (95) Complete Time 00:00:05.0623380
Thread (95) ** END 10/07/2009 9:35:45 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 9:35:48 AM
Thread (95) Export Started [10/07/2009 9:35:48 AM]
Thread (95) ** START 10/07/2009 9:35:48 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 9:35:50 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 9:35:50 AM : Query
Thread (95) Object SQL Query started.
Thread (81) InternalReadBackground - start
Thread (81) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 128)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (23) DoneReadTreadWriter
Thread (23) DoneReadThreadWriter finally - adapter.RowsRead 14
Thread (95) END 10/07/2009 9:35:52 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 9:35:52 AM]
Thread (95) Build Time 00:00:01.4843275
Thread (95) Complete Time 00:00:03.7030065
Thread (95) ** END 10/07/2009 9:35:52 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 10:42:59 AM
Thread (95) Export Started [10/07/2009 10:42:59 AM]
Thread (95) ** START 10/07/2009 10:42:59 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 10:43:00 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 10:43:00 AM : Query
Thread (95) Object SQL Query started.
Thread (37) InternalReadBackground - start
Thread (37) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 148)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (25) DoneReadTreadWriter
Thread (25) DoneReadThreadWriter finally - adapter.RowsRead 929
Thread (95) END 10/07/2009 10:43:04 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 10:43:04 AM]
Thread (95) Build Time 00:00:01.0000128
Thread (95) Complete Time 00:00:05.2813176
Thread (95) ** END 10/07/2009 10:43:04 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 10:43:07 AM
Thread (95) Export Started [10/07/2009 10:43:07 AM]
Thread (95) ** START 10/07/2009 10:43:07 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 10:43:09 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 10:43:09 AM : Query
Thread (95) Object SQL Query started.
Thread (25) InternalReadBackground - start
Thread (25) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 130)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (37) DoneReadTreadWriter
Thread (37) DoneReadThreadWriter finally - adapter.RowsRead 380
Thread (95) END 10/07/2009 10:43:14 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 10:43:14 AM]
Thread (95) Build Time 00:00:01.3593924
Thread (95) Complete Time 00:00:06.5625840
Thread (95) ** END 10/07/2009 10:43:14 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 10:43:17 AM
Thread (95) Export Started [10/07/2009 10:43:17 AM]
Thread (95) ** START 10/07/2009 10:43:17 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 10:43:19 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 10:43:19 AM : Query
Thread (95) Object SQL Query started.
Thread (25) InternalReadBackground - start
Thread (25) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 137)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (80) DoneReadTreadWriter
Thread (80) DoneReadThreadWriter finally - adapter.RowsRead 9
Thread (95) END 10/07/2009 10:43:20 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 10:43:20 AM]
Thread (95) Build Time 00:00:01.4375184
Thread (95) Complete Time 00:00:03.4219188
Thread (95) ** END 10/07/2009 10:43:21 AM
Thread (95) Adding Export Notification Subscriber 10/07/2009 10:43:26 AM
Thread (95) Export Started [10/07/2009 10:43:26 AM]
Thread (95) ** START 10/07/2009 10:43:26 AM
Thread (95) Export Wizard: Building object list
Thread (95) Build List 10/07/2009 10:43:27 AM
Thread (95) Exporting Data
Thread (95) BEGIN 10/07/2009 10:43:27 AM : Query
Thread (95) Object SQL Query started.
Thread (32) InternalReadBackground - start
Thread (32) InternalReadBackground - after ExecuteReader - command SELECT TBLCIGNAFCO.CARID,
TBLCIGNAFCO.CIGNA_FCO_NO,
TBLCIGNAFCOCODE.“NAME”,
TBLCIGNAFCO.CIGNA_HMO_CD,
TBLCIGNAHMOCODE.“NAME”,
TBLCIGNAFCOADDR.CIGNAFCOADDRID,
TBLCIGNAFCOADDR.ADDR1,
TBLCIGNAFCOADDR.ADDR2,
TBLCIGNAFCOADDR.CITY,
TBLCIGNAFCOADDR.STATE,
TBLCIGNAFCOADDR.ZIP,
TBLCIGNAFCOADDR.PHONE
FROM ( ( NETWORX_OWNER.TBLCIGNAFCO TBLCIGNAFCO
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOCODE TBLCIGNAFCOCODE
ON (TBLCIGNAFCO.CIGNA_FCO_NO = TBLCIGNAFCOCODE.CIGNA_FCO_NO)
AND (TBLCIGNAFCO.CARID = TBLCIGNAFCOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAHMOCODE TBLCIGNAHMOCODE
ON (TBLCIGNAHMOCODE.CARID = TBLCIGNAFCOCODE.CARID)
AND (TBLCIGNAFCO.CIGNA_HMO_CD = TBLCIGNAHMOCODE.CIGNA_HMO_CD)
AND (TBLCIGNAFCO.CARID = TBLCIGNAHMOCODE.CARID))
INNER JOIN
NETWORX_OWNER.TBLCIGNAFCOADDR TBLCIGNAFCOADDR
ON (TBLCIGNAFCO.CIGNAFCOADDRID = TBLCIGNAFCOADDR.CIGNAFCOADDRID)
WHERE (TBLCIGNAFCO.CARID = 123)
ORDER BY TBLCIGNAFCO.CIGNA_HMO_CD ASC,
TBLCIGNAFCOADDR.CIGNAFCOADDRID ASC,
TBLCIGNAFCO.CIGNA_FCO_NO ASC
Thread (87) DoneReadTreadWriter
Thread (87) DoneReadThreadWriter finally - adapter.RowsRead 1619
Thread (95) END 10/07/2009 10:43:31 AM : Query
Thread (95) Object SQL Query finished.
Thread (95) Export Finished [10/07/2009 10:43:31 AM]
Thread (95) Build Time 00:00:01.0937640
Thread (95) Complete Time 00:00:05.7813240
Thread (95) ** END 10/07/2009 10:43:31 AM
Thread (8) Adding Export Notification Subscriber 10/09/2009 9:01:24 AM
Thread (8) Export Started [10/09/2009 9:01:25 AM]
Thread (8) ** START 10/09/2009 9:01:25 AM
Thread (8) Export Wizard: Building object list
Thread (8) Build List 10/09/2009 9:01:29 AM
Thread (8) Exporting Data
Thread (8) BEGIN 10/09/2009 9:01:29 AM : Query
Thread (8) Object SQL Query started.
Thread (6) InternalReadBackground - start
Thread (6) InternalReadBackground - after ExecuteReader - command SELECT DISTINCT TBLPROV.PROVPARENTID
, TBLPROV.PROVID
, TBLPROV.PROVNAME
, TBLPROV.ADDR1
, TBLPROV.ADDR2
, TBLPROV.CITY
, TBLPROV.STATE
, TBLPROV.ZIP
, TBLPROVIDERSVCCATEGORY.SERVICECATID
, TBLZIPCODEAREA.COUNTYNAME
, TBLPROVIDERSVCCATEGORY.PROVSVCCATRATING
, TBLPROVIDERSVCCATEGORY.SVCCATRATINGST
FROM
((NETWORX_OWNER.TBLPROVCONTRZIP TBLPROVCONTRZIP
INNER JOIN
NETWORX_OWNER.TBLZIPCODEAREA TBLZIPCODEAREA
ON (TBLPROVCONTRZIP.ZIPCODE = TBLZIPCODEAREA.ZIP))
INNER JOIN
NETWORX_OWNER.TBLPROV TBLPROV
ON (TBLPROV.PROVID = TBLPROVCONTRZIP.PROVID))
INNER JOIN
NETWORX_OWNER.TBLPROVIDERSVCCATEGORY TBLPROVIDERSVCCATEGORY
ON (TBLPROVIDERSVCCATEGORY.PROVID = TBLPROV.PROVID)
WHERE (TBLPROV.PROVPARENTID <> 3)
AND (TBLPROV.PROVID <> 2050 And TBLPROV.PROVID <> 9782)
AND (TBLPROV.STATE = ‘CA’)
AND (TBLPROVIDERSVCCATEGORY.SERVICECATID = ‘THH’)
AND (TBLPROVIDERSVCCATEGORY.PROVSVCCATRATING BETWEEN 50
AND 59)
AND (TBLPROVIDERSVCCATEGORY.SVCCATRATINGST = ‘CA’)
ORDER BY TBLPROV.PROVPARENTID ASC
Thread (4) DoneReadTreadWriter
Thread (4) DoneReadThreadWriter finally - adapter.RowsRead 27
Thread (8) END 10/09/2009 9:01:38 AM : Query
Thread (8) Object SQL Query finished.
Thread (8) Export Finished [10/09/2009 9:01:38 AM]
Thread (8) Build Time 00:00:04.4058552
Thread (8) Complete Time 00:00:13.4362960
Thread (8) ** END 10/09/2009 9:01:38 AM
Thread (8) Adding Export Notification Subscriber 10/09/2009 9:01:54 AM
Thread (8) Export Started [10/09/2009 9:01:54 AM]
Thread (8) ** START 10/09/2009 9:01:54 AM
Thread (8) Export Wizard: Building object list
Thread (8) Build List 10/09/2009 9:01:55 AM
Thread (8) Exporting Data
Thread (8) BEGIN 10/09/2009 9:01:55 AM : Query
Thread (8) Object SQL Query started.
Thread (6) InternalReadBackground - start
Thread (6) InternalReadBackground - after ExecuteReader - command SELECT DISTINCT TBLPROV.PROVPARENTID
, TBLPROV.PROVID
, TBLPROV.PROVNAME
, TBLPROV.ADDR1
, TBLPROV.ADDR2
, TBLPROV.CITY
, TBLPROV.STATE
, TBLPROV.ZIP
, TBLPROVIDERSVCCATEGORY.SERVICECATID
, TBLZIPCODEAREA.COUNTYNAME
, TBLPROVIDERSVCCATEGORY.PROVSVCCATRATING
, TBLPROVIDERSVCCATEGORY.SVCCATRATINGST
, TBLCONTRACTINFO.CONTRACTNAME
, TBLZIPCODEAREA.STATE
FROM
(((NETWORX_OWNER.TBLPROVCONTRZIP TBLPROVCONTRZIP
INNER JOIN
NETWORX_OWNER.TBLZIPCODEAREA TBLZIPCODEAREA
ON (TBLPROVCONTRZIP.ZIPCODE = TBLZIPCODEAREA.ZIP))
INNER JOIN
NETWORX_OWNER.TBLPROV TBLPROV
ON (TBLPROV.PROVID = TBLPROVCONTRZIP.PROVID))
INNER JOIN
NETWORX_OWNER.TBLPROVIDERSVCCATEGORY TBLPROVIDERSVCCATEGORY
ON (TBLPROVIDERSVCCATEGORY.PROVID = TBLPROV.PROVID))
INNER JOIN
NETWORX_OWNER.TBLCONTRACTINFO TBLCONTRACTINFO
ON (TBLPROVCONTRZIP.KID = TBLCONTRACTINFO.KID)
WHERE (TBLPROV.PROVPARENTID <> 3)
AND (TBLPROV.PROVID <> 2050 And TBLPROV.PROVID <> 9782)
AND (TBLPROV.PROVNAME NOT LIKE ‘%Z%’)
AND (TBLPROV.STATE = ‘CA’)
AND (TBLPROVIDERSVCCATEGORY.SERVICECATID = ‘THH’)
AND (TBLPROVIDERSVCCATEGORY.PROVSVCCATRATING >= 60)
AND (TBLPROVIDERSVCCATEGORY.SVCCATRATINGST = ‘CA’)
AND (TBLCONTRACTINFO.CONTRACTNAME NOT LIKE ‘%PT SPEC%’)
AND (TBLZIPCODEAREA.STATE = ‘CA’)
ORDER BY TBLPROV.PROVPARENTID ASC
Thread (15) DoneReadTreadWriter
Thread (15) DoneReadThreadWriter finally - adapter.RowsRead 558
Thread (8) END 10/09/2009 9:02:06 AM : Query
Thread (8) Object SQL Query finished.
Thread (8) Export Finished [10/09/2009 9:02:06 AM]
Thread (8) Build Time 00:00:01.0311576
Thread (8) Complete Time 00:00:12.1551608
Thread (8) ** END 10/09/2009 9:02:06 AM
Thread (8) Adding Export Notification Subscriber 10/09/2009 9:02:25 AM
Thread (8) Export Started [10/09/2009 9:02:25 AM]
Thread (8) ** START 10/09/2009 9:02:25 AM
Thread (8) Export Wizard: Building object list
Thread (8) Build List 10/09/2009 9:02:26 AM
Thread (8) Exporting Data
Thread (8) BEGIN 10/09/2009 9:02:26 AM : Query
Thread (8) Object SQL Query started.
Thread (6) InternalReadBackground - start
Thread (6) InternalReadBackground - after ExecuteReader - command SELECT T1.PROVPARENTID AS PARID,
T1.PROVID,
T1.FEDERALTAXID,
T1.SHORTNAME,
T1.PROVNAME,
T1.ADDR1,
T1.ADDR2,
T1.CITY,
T1.STATE,
T1.PHONE,
T1.FAX,
SUM (CASE WHEN T2.SERVICECATID = ‘ADMIN’ THEN ‘1’ ELSE NULL END)
AS ADMIN,
SUM(CASE WHEN T2.SERVICECATID = ‘HME’ THEN ‘1’ ELSE NULL END) AS HME,
SUM (CASE WHEN T2.SERVICECATID = ‘HIT’ THEN ‘1’ ELSE NULL END) AS HIT,
SUM (CASE WHEN T2.SERVICECATID = ‘HOSPICE’ THEN ‘1’ ELSE NULL END)
AS HOSPICE,
SUM (CASE WHEN T2.SERVICECATID = ‘MED’ THEN ‘1’ ELSE NULL END) AS MED,
SUM (CASE WHEN T2.SERVICECATID = ‘O/P’ THEN ‘1’ ELSE NULL END) AS OP,
SUM (CASE WHEN T2.SERVICECATID = ‘RESP’ THEN ‘1’ ELSE NULL END) AS
RESP,
SUM (CASE WHEN T2.SERVICECATID = ‘THH’ THEN ‘1’ ELSE NULL END) AS THH,
SUM (CASE WHEN T2.SERVICECATID = ‘WHS’ THEN ‘1’ ELSE NULL END) AS WHS
FROM TBLPROV T1, TBLPROVIDERSVCCATEGORY T2
WHERE T1.PROVID = T2.PROVID
AND ( ( (T2.SERVICECATID) <> ‘EBA’
AND (T2.SERVICECATID) <> ‘DISP’
AND (T2.SERVICECATID) <> ‘REHAB’
AND (T2.SERVICECATID) <> ‘INSTAY’
AND (T2.SERVICECATID) <> ‘LAB’
AND (T2.SERVICECATID) <> ‘SUBACUTE’)
AND ( (T1.PROVID) <> 2050 AND (T1.PROVID) <> 9782)
AND ( (T1.SHORTNAME) NOT LIKE ‘Z%’)
AND ( (T2.PROVSVCCATRATING) >= 30))
GROUP BY T1.PROVPARENTID,
T1.PROVID,
T1.FEDERALTAXID,
T1.SHORTNAME,
T1.PROVNAME,
T1.ADDR1,
T1.ADDR2,
T1.CITY,
T1.STATE,
T1.PHONE,
T1.FAX
ORDER BY T1.PROVNAME
/*** IF DECIDED TO USE DECODE FUNCTION INSTEAD OF CASE STATEMENT
SUM (DECODE (SERVICECATID,‘ADMIN’, ‘1’,NULL)) AS ADMIN,
SUM (DECODE (SERVICECATID,‘RESP’, ‘1’,NULL))AS RESP,
SUM (DECODE (SERVICECATID,‘HME’, ‘1’,NULL)) AS HME ***/
/***THE FOLLOWING DID NOT WORK FOR ME TO CREATE A CROSS TAB
–TRANSFORM First(“X”) AS Expr1
–PIVOT T2.SERVICECATID; ****/
Thread (4) DoneReadTreadWriter
Thread (8) Adding Export Notification Subscriber 10/09/2009 9:03:11 AM
Thread (8) Export Started [10/09/2009 9:03:11 AM]
Thread (8) ** START 10/09/2009 9:03:11 AM
Thread (8) Export Wizard: Building object list
Thread (8) Build List 10/09/2009 9:03:12 AM
Thread (8) Exporting Data
Thread (8) BEGIN 10/09/2009 9:03:12 AM : Query
Thread (8) Object SQL Query started.
Thread (4) DoneReadThreadWriter finally - adapter.RowsRead 10491
Thread (8) END 10/09/2009 9:03:13 AM : Query
Thread (8) Object SQL Query finished.
Thread (8) Export Finished [10/09/2009 9:03:13 AM]
Thread (8) Build Time 00:00:01.1717700
Thread (8) Complete Time 00:00:48.4339220
Thread (8) ** END 10/09/2009 9:03:13 AM
Thread (14) DoneReadTreadWriter
Thread (14) DoneReadThreadWriter finally - adapter.RowsRead 27
Thread (8) END 10/09/2009 9:03:16 AM : Query
Thread (8) Object SQL Query finished.
Thread (8) Export Finished [10/09/2009 9:03:16 AM]
Thread (8) Build Time 00:00:01.1405447
Thread (8) Complete Time 00:00:04.8902807
Thread (8) ** END 10/09/2009 9:03:16 AM
Thread (8) Adding Export Notification Subscriber 10/09/2009 9:03:20 AM
Thread (8)
that need to be run at a certain time/date but get script error message (my computer is on but locked…) , if to test instantly it works and does not fail (the eror reference tables that my sql script does not refrence to at all):-