FastExport Access Module Error

Tools
Enthusiast

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'.

4 REPLIES
Enthusiast

Re: FastExport Access Module Error

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

Teradata Employee

Re: FastExport Access Module Error

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

Re: FastExport Access Module Error

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

Teradata Employee

Re: FastExport Access Module Error

Please start a new thread for new questions.

On mainframe, INFILE must specify a DDNAME not a dataset name.