Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   TPT script error - extracting from Oracle using non DSN connection
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016