Archives of the TeradataForum

Message Posted: Mon, 26 May 2008 @ 12:22:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Mon, 26 May 2008 10:33 -->

Hi All,

I have generate TPT script using TPT wizard 12.0. The main purpose of the script to extract the data from Oracle table and load into Teradata. In TPT there are four options to connect other source.

1. Teradata Table

2. File

3. ODBC DSN

4. Oracle Table

I have created the TPT script using option 4.Oracle Table.

While running the TPT script it throws this error. Could you please help me to resolve this error ?

Thanks a lot in advance.

     =                     SQL Session Connection                      =
     =                                                                 =
     -------------------------------------------------------------------

       51: 05/22/08
     17:34:39|4957|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|10050|opermsgs|****
     17:34:39 Connecting to RDBMS:    'vhgtest'
     52: 05/22/08
     17:34:39|4957|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|10051|opermsgs|****
     17:34:39 Connecting with UserId: 'valholl'
     53: 05/22/08
     17:34:39|4957|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|10904|opermsgs|W_0_o_vvv:
     connecting sessions
     54: 05/22/08
     17:34:39|4977|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|17122|opermsgs|****
     17:34:39 Error: unable to connect to data source
     55: 05/22/08
     17:34:39|4987|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|17101|opermsgs|****
     17:34:39 **Fatal error received from ODBC driver: ***
     **STATE=IM002, CODE=0, **
     **MSG='[Microsoft][ODBC Driver Manager] Data source name not found and
     no default driver specified'**
     **56: 05/22/08 17:34:39|4987|||4020|4|SELECT_2[0001]|0|Table|Fatal
     Error|2113|twbmsgs|Operator(odbcop.dll) instance(1): INITIATE method
     failed with status = Fatal Error**
     *57: 05/22/08
     17:34:39|5017|TWB_STATUS||4020|4|SELECT_2[0001]|1|Table|Info|2241|twbmsgs|MAIN_STEP

     SELECT_2[0001]       Multi Phase Error    W_0_o_vvv               1    1
     INITIATE-Ended       17:34:39     0.0000     0.0200      65000
     0                0                0   100     0 N Y
     58: 05/22/08
     17:34:39|5037|||4020|4|SELECT_2[0001]|0|Table|Info|2255|twbmsgs|PXTB_Terminate:
     Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows
     Sent = 0
     59: 05/22/08
     17:34:39|5037|TWB_STATUS||4020|4|SELECT_2[0001]|1|Table|Info|2241|twbmsgs|MAIN_STEP

     SELECT_2[0001]       Success              W_0_o_vvv               1    1
     TERMINATE-Started    17:34:39     0.0000     0.0000      65000
     0                0                0   100     0 N Y
     60: 05/22/08
     17:34:39|5077|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|10101|opermsgs|
     61: 05/22/08
     17:34:39|5087|||4020|4|SELECT_2[0001]|1|W_0_o_vvv|Info|10002|opermsgs|
     -------------------------------------------------------------------
     =                                                                 =
     =                        Logoff/Disconnect                        =
     =                                                                 =
     -------------------------------------------------------------------

	<Prev	Next>		<<First	<Prev	Next>	Last>>