All Forums Tools
Apukad 5 posts Joined 03/05
14 Mar 2006
Fastload from batch file

Hello Everyone,I have to create a fastload what imports data from an Oracle (8)database every day. I've created the amj file and the .fld file. (see the 00_cfm_data.fld and cfm.amj)If I use the teradata Oleload application, loading will be succesful, but If I insert it into a .bat file it will give back the following message. (00_cfm_data.log!)The batch file:Echo Setting Rundate...fastload < \\Bud11Srv5223\Groups\Dwh\Application\jov_lists\ 00_cfm_data.fld > \\Bud11Srv5223\Groups\Dwh\Application\Log\ 00_cfm_data.log My operating system is Win XP SP2 and my oracle ODBC driver (MSDAORA) does not work, so I have to use MSDSQL drivers.Could anybody please explain what was my fault?Thanks in advance!

Apukad 5 posts Joined 03/05
14 Mar 2006

=================================================================== = = = FASTLOAD UTILITY VERSION 07.06.00.000 = = PLATFORM WIN32 = = = =================================================================== =================================================================== = = = Copyright 1984-2004, NCR Corporation. = = ALL RIGHTS RESERVED. = = = ===================================================================**** 10:02:06 Processing starting at: Tue Mar 14 10:02:06 20060001 .SET SESSION CH****T "ASCII";**** 10:02:06 Command completed successfully =================================================================== = = = Logon/Connection = = = ===================================================================0002 LOGON hunccp/hunccp_mmo,**** 10:02:11 Current CLI or RDBMS allows maximum row size: 64K**** 10:02:11 Character set for this job: ASCII**** 10:04:24 CLI Error 301: CLI2: SESSOVER(301): Exceeded max number of sessions allowed.**** 10:04:28 Number of FastLoad sessions connected = 298**** 10:04:28 FDL4808 LOGON successful0003 DATABASE hunccp_fls ;**** 10:04:28 Command completed successfully0004 drop table "d_cust_licenses";**** 10:04:32 Command completed successfully0005 CREATE TABLE "D_CUST_LICENSES" ( home_store_id DECIMAL(7,0) NOT NULL, CUST_NO DECIMAL(12,0) NOT NULL, LICENSE_SYS_TYPE VARCHAR(6) CHARACTER SE T LATIN NOT NULL, LICENSE_SYS_NO VARCHAR(90) CHARACTER S ET LATIN NOT NULL, VALID_FROM TIMESTAMP(0) NOT NULL, VALID_FROM_DATE DATE NOT NULL FORMAT 'Y YYY-MM-DD', VALID_FROM_TIME FLOAT NOT NULL FORMAT ' 99:99:99', VALID_TO TIMESTAMP(0) NOT NULL, VALID_TO_DATE DATE NOT NULL FORMAT 'Y YYY-MM-DD', VALID_TO_TIME FLOAT NOT NULL FORMAT ' 99:99:99', DL_ID DECIMAL(1,0) NOT NULL, SPECIAL_TAX_NO VARCHAR(90) CHARACTER S ET LATIN, MGE_CAT_ID DECIMAL(3,0), ASSORT_SECTION_ID DECIMAL(1,0) ) ;**** 10:04:34 Command completed successfully0006 BEGIN LOADING "D_CUST_LICENSES" ERRORFILES D_CUST_LICENSES_errors1, D_CUST_LICENSES_errors2 INDICATORS ;**** 10:04:34 Indicator mode is set to ON**** 10:04:40 Number of AMPs available: 476**** 10:04:40 BEGIN LOADING COMPLETE0007 AXSMOD Oledb_Axsmod "noprompt";**** 10:04:40 I/O Error on Open: 3, Text: Requested Access Module not found**** 10:04:40 Error: Invalid pmHandle parameter**** 10:04:40 Error: Invalid pmHandle parameter =================================================================== = = = Logoff/Disconnect = = = ===================================================================**** 10:04:40 Logging off all sessions**** 10:07:44 Total processor time used = '5.34375 Seconds' . Start : Tue Mar 14 10:02:06 2006 . End : Tue Mar 14 10:07:44 2006 . Highest return code encountered = '12'.**** 10:07:44 FastLoad Paused

Apukad 5 posts Joined 03/05
14 Mar 2006

Hi, the problem was the batcf file, because I had to correct it as following:Path C:\Program Files\Common Files\NCR\AXSMOD;C:\Program Files\NCR\Teradata Client\Bin;%PATH%;Echo Setting Rundate...fastload < \\Bud11Srv5223\Groups\Dwh\Application\jov_lists\00_cfm_data.fld > \\Bud11Srv5223\Groups\Dwh\Application\Log\00_cfm_data.log

You must sign in to leave a comment.