All Forums Tools
toadrw 69 posts Joined 07/04
13 Jun 2012
FastExport Access Module Error

Hello all:

Does anyone know why FastExport would not be able to find the named pipe below?  Any thoughts?  Thank you for your help!

The Named Pipes Access Module is installed (version 13.10.00.3).

**** 09:56:52 UTY4019 Access module error '4' received during 'File open'

    operation: 'Requested file not found'  File Name :
    '\\.\pipe\JMASTGTMP_B_ADDRESS'.
    ====================================================== ==================
    =                                                                      =
    =          Logoff/Disconnect                                           =
    =                                                                      =
    ====================================================== ==================
**** 09:56:53 UTY1001 Unexpected parcel: 11, expected 10.
**** 09:56:54 UTY6212 A successful disconnect was made from the RDBMS.
**** 09:56:54 UTY2410 Total processor time used = '0.842405 Seconds'
    .       Start : 09:56:47 - WED JUN 13, 2012
    .       End   : 09:56:54 - WED JUN 13, 2012
    .       Highest return code encountered = '12'.

 

Full FEXP text...

----------------------

    ====================================================== ==================

    =                                                                      =
    =          FastExport Utility    Release FEXP.13.10.00.012             =
    =          Platform WIN32                                              =
    =                                                                      =
    ====================================================== ==================
    =                                                                      =
    =     Copyright 1990-2011 Teradata Corporation. ALL RIGHTS RESERVED.   =
    =                                                                      =
    ====================================================== ==================
**** 09:56:48 UTY2411 Processing start date: WED JUN 13, 2012
    ====================================================== ==================
    =                                                                      =
    =          Logon/Connection                                            =
    =                                                                      =
    ====================================================== ==================
0001 .LOGTABLE JMASTGTMP.B_ADDRESS_lg;
0002 .LOGON tdprd/xxxxxxxxxxxxxxxx (edited out);
**** 09:56:51 UTY8400 Teradata Database Release: 13.10.03.03
**** 09:56:51 UTY8400 Teradata Database Version: 13.10.03.06
**** 09:56:51 UTY8400 Default character set: ASCII
**** 09:56:51 UTY8400 Current RDBMS has UDT support
**** 09:56:51 UTY8400 Current RDBMS has Large Decimal support
**** 09:56:51 UTY8400 Current RDBMS has FEXP w/o Spooling support
**** 09:56:51 UTY8400 Current RDBMS has TASM support
**** 09:56:51 UTY8400 Maximum supported buffer size: 1M
**** 09:56:51 UTY8400 Data Encryption supported by RDBMS server
**** 09:56:51 UTY6211 A successful connect was made to the RDBMS.
**** 09:56:51 UTY6217 Logtable 'JMASTGTMP.B_ADDRESS_lg' has been created.
    ====================================================== ==================
    =                                                                      =
    =          Processing Control Statements                               =
    =                                                                      =
    ====================================================== ==================
0003 .BEGIN EXPORT SESSIONS * TENACITY 5 SLEEP 10;
0004 .EXPORT OUTFILE \\.\pipe\JMASTGTMP_B_ADDRESS FORMAT FASTLOAD MODE INDICATOR;
0005 LOCKING ROW FOR ACCESS SELECT * FROM JMASTGTMP.B_ADDRESS;
0006 .END EXPORT;
    ====================================================== ==================
    =                                                                      =
    =          FastExport Initial Phase                                    =
    =                                                                      =
    ====================================================== ==================
**** 09:56:51 UTY8700 Options in effect for this FastExport task:
    .       Sessions:    1024 session(s).
    .       Mode:        INDICATOR
    .       Blocksize:   64330 bytes.
    .       Outlimit:    No limit in effect.
    .       Tenacity:    5 hour limit to successfully connect load sessions.
    .       Sleep   :    10 minute(s).
**** 09:56:51 UTY8715 FastExport is submitting the following request:
    Select NULL from JMASTGTMP.B_ADDRESS_lg where (LogType = 220) and (Seq = 1)
    and (FExptSeq = 0);
**** 09:56:51 UTY8715 FastExport is submitting the following request:
    SET QUERY_BAND='UTILITYNAME=FASTEXP;' UPDATE FOR SESSION;
**** 09:56:51 UTY8715 FastExport is submitting the following request:
    CHECK WORKLOAD FOR BT;BEGIN FASTEXPORT;
**** 09:56:51 UTY8715 FastExport is submitting the following request:
    CHECK WORKLOAD FOR LOCKING ROW FOR ACCESS SELECT * FROM
    JMASTGTMP.B_ADDRESS;
**** 09:56:51 UTY8715 FastExport is submitting the following request:
    CHECK WORKLOAD END;
**** 09:56:51 UTY0844 Session count 4 returned by the DBS overrides
    user-requested session count.
**** 09:56:52 UTY8705 EXPORT session(s) requested: 4.
**** 09:56:52 UTY8706 EXPORT session(s) connected: 4.
**** 09:56:52 UTY8715 FastExport is submitting the following request:
    BT;BEGIN FASTEXPORT;
**** 09:56:52 UTY8715 FastExport is submitting the following request:
    SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER), MiscInt3 (INTEGER),FExptSeq
    (INTEGER), FExptCkpt (VARBYTE(1024)) from JMASTGTMP.B_ADDRESS_lg WHERE
    (LogType = 210) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
    JMASTGTMP.B_ADDRESS_lg where (LogType = 210) and (Seq = 1)));
**** 09:56:52 UTY8715 FastExport is submitting the following request:
    SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),  MiscInt3 (INTEGER),FExptSeq
    (INTEGER), FExptCkpt (VARBYTE(1024)) from JMASTGTMP.B_ADDRESS_lg WHERE
    (LogType = 212) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
    JMASTGTMP.B_ADDRESS_lg where (LogType = 212) and (Seq = 1)));
**** 09:56:52 UTY4019 Access module error '4' received during 'File open'
    operation: 'Requested file not found'  File Name :
    '\\.\pipe\JMASTGTMP_B_ADDRESS'.
    ====================================================== ==================
    =                                                                      =
    =          Logoff/Disconnect                                           =
    =                                                                      =
    ====================================================== ==================
**** 09:56:53 UTY1001 Unexpected parcel: 11, expected 10.
**** 09:56:54 UTY6212 A successful disconnect was made from the RDBMS.
**** 09:56:54 UTY2410 Total processor time used = '0.842405 Seconds'
    .       Start : 09:56:47 - WED JUN 13, 2012
    .       End   : 09:56:54 - WED JUN 13, 2012
    .       Highest return code encountered = '12'.

toadrw 69 posts Joined 07/04
19 Jun 2012

The issue was related to the tdpid and the hosts file.  

SuSeSi 61 posts Joined 10/08
22 Jun 2012

On Windows, One should run Load utility first which will create the pipe, and then fastexport the data to the pipe created.

-Sudhansu

bshkris 1 post Joined 06/11
27 Mar 2013

Hi,
I am experincing the same issue, but submitting the job thu mainframe system.
UTY4019 Access module error '4' received during 'File open'operation: 'Requested file not found'
 
even though specified the input file
INPFILE='PMIT.NDM.WDA.ORG.MSR.MO.ACTLS.G0016V00',
still receiving the open error?
 
Please advise me.
 
Thanks,
Hari
 

Fred 1096 posts Joined 08/04
02 Apr 2013

Please start a new thread for new questions.
On mainframe, INFILE must specify a DDNAME not a dataset name.

You must sign in to leave a comment.