I’m using TDP 4.3.0.718 (64 bit) and just installed Toad Data Point Viewer (3.7.2.16). I am testing how to use the viewer (without access to TIC). I see that from the resultset of a query I can rightclick and “send-To”-> “datapoint viewer”, from there I can designate an existing .qbis file or opt to create a new one. With both options I get the following error message:
The current connection is Oracle
Data Point Viewer refresh log output- 2018-03-13 09:03:18: {SQLfromTDP_2018_03_13_09_55_18} Refreshing dataset - SQLfromTDP_2018_03_13_09_55_18
Data Point Viewer refresh log output- 2018-03-13 09:03:18: {SQLfromTDP_2018_03_13_09_55_18} Opening workbook…
Data Point Viewer refresh log output- 2018-03-13 09:03:18: {SQLfromTDP_2018_03_13_09_55_18} Fetching data…
Data Point Viewer refresh log output- 2018-03-13 09:03:18: {SQLfromTDP_2018_03_13_09_55_18} Failed to load data
Data Point Viewer refresh log output- 2018-03-13 09:03:18: {SQLfromTDP_2018_03_13_09_55_18} Error: Could not find file ‘C:\Users\AL2329\AppData\Local\Temp\1\Quest Software\Toad Data Point Viewer\Workbook6.csv’.
The question is, is sending data to TDV from a resultset a viable action, is it currently broken or am I doing something wrong?
I just tried passing data to Toad Data Point Viewer and had no issues. However, I am using version 3.7.2.20. TDP is generating a csv file to pass the data into the viewer. I notice that there are some subdirectories below the temp dir. Perhaps you are not able to write to those directories so we can’t find the file below.
C:\Users\AL2329\AppData\Local\Temp\1\Quest Software\Toad Data Point Viewer\Workbook6.csv’.
Thanks, I can confirm that I can write and read from the relevant Temp sub folder. I tried again and now it works with a different query. It seems that the problem lies with a variable in the first query, which seems weird as you are exporting a result set (for a given variable value) to a .csv set so apparently the rerunning of the query (with a variable) to generate the .csv file is the problem here.
I do see that the latets version available from: https://community.toadworld.com/m/freeware/1507/download?v=0#download is the 3.7.2.16 version.
I tried with SQL using bind var and had no issues. Can I have the connection type and the SQL statement so i can try and replicate?
Connection is to an Oracle database with OracleClient12Home1 (64) also as ODBC driver.
The SQL is:
SELECT DISTINCT
SPRIDEN.SPRIDEN_ID
AS “Spriden Id”,
SGBSTDN.SGBSTDN_PIDM
AS PIDM,
( ( (SPRIDEN.SPRIDEN_LAST_NAME || ', ')
|| SPRIDEN.SPRIDEN_FIRST_NAME)
|| ’ ')
|| SPRIDEN.SPRIDEN_MI
AS LAST_FIRST_NAME,
SFBETRM.SFBETRM_ESTS_CODE
AS STATUS,
SGBSTDN.SGBSTDN_COLL_CODE_1
AS SCHOOL,
SGBSTDN.SGBSTDN_DEGC_CODE_1
AS “DEGREE”,
STVMAJR.STVMAJR_DESC
AS MAJOR1,
STVMAJR_1.STVMAJR_DESC
AS MAJR2,
SPRIDEN.SPRIDEN_LAST_NAME
AS “Last Name”,
SPRIDEN.SPRIDEN_FIRST_NAME
AS “Firsdt Name”,
SPRIDEN.SPRIDEN_MI
AS “Middle Name”,
SGBSTDN.SGBSTDN_PROGRAM_1
AS PROGRAM,
SGBSTDN.SGBSTDN_ACYR_CODE
AS “Grad Year”
FROM ((((SATURN.SFBETRM SFBETRM
INNER JOIN SATURN.SGBSTDN SGBSTDN
ON (SFBETRM.SFBETRM_TERM_CODE = SGBSTDN.SGBSTDN_TERM_CODE_EFF)
AND (SFBETRM.SFBETRM_PIDM = SGBSTDN.SGBSTDN_PIDM))
INNER JOIN SATURN.STVMAJR STVMAJR
ON (STVMAJR.STVMAJR_CODE = SGBSTDN.SGBSTDN_MAJR_CODE_1))
INNER JOIN SATURN.SPRIDEN SPRIDEN
ON (SPRIDEN.SPRIDEN_PIDM = SGBSTDN.SGBSTDN_PIDM))
LEFT OUTER JOIN SATURN.SPBPERS SPBPERS
ON (SGBSTDN.SGBSTDN_PIDM = SPBPERS.SPBPERS_PIDM))
RIGHT OUTER JOIN SATURN.STVMAJR STVMAJR_1
ON (STVMAJR_1.STVMAJR_CODE = SGBSTDN.SGBSTDN_MAJR_CODE_1_2)
WHERE (SGBSTDN.SGBSTDN_COLL_CODE_1 = :School)
AND (SGBSTDN.SGBSTDN_TERM_CODE_EFF = ‘201603’)
AND (SPRIDEN.SPRIDEN_CHANGE_IND IS NULL)
AND (SGBSTDN.SGBSTDN_STST_CODE = ‘AS’)
ORDER BY “Spriden Id” ASC, “Last Name” ASC