Fast export error

Teradata Applications
Enthusiast

Fast export error

I am running fast export through informatica. Sometime fast export is getting failed with below error. To fix it we try to re run fastexport and it is getting finished succesfully. Sometimes we need to re run twice. I am not able to find the root cause and permanent fix for it. It is strange error because workflow dont fail everytime.Please help.

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

     =                                                                      =

     =          FastExport Utility    Release FEXP.14.00.00.003             =

     =          Platform SOLARIS/SPARC                                      =

     =                                                                      =

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

     =                                                                      =

     =     Copyright 1990-2011 Teradata Corporation. ALL RIGHTS RESERVED.   =

     =                                                                      =

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

0003 .LOGTABLE P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS;

0004 .DATEFORM ANSIDATE;

**** 10:38:02 UTY1200 DATEFORM has been set to ANSIDATE.

0005 .LOGON prd/P0_SBL_LOADER,;

**** 10:38:04 UTY8400 Teradata Database Release: 14.00.07.07

**** 10:38:04 UTY8400 Teradata Database Version: 14.00.07.07

**** 10:38:04 UTY8601 Character set specified: ASCII                        

**** 10:38:04 UTY8400 Current RDBMS has UDT support

**** 10:38:04 UTY8400 Current RDBMS has Large Decimal support

**** 10:38:04 UTY8400 Current RDBMS has FEXP w/o Spooling support

**** 10:38:04 UTY8400 Current RDBMS has TASM support

**** 10:38:04 UTY8400 Maximum supported buffer size: 1M

**** 10:38:04 UTY8400 Data Encryption supported by RDBMS server

**** 10:38:15 UTY6211 A successful connect was made to the RDBMS.

**** 10:38:15 UTY6217 Logtable 'P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS' has been

     created.

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

     =                                                                      =

     =          Processing Control Statements                               =

     =                                                                      =

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

0006 .BEGIN EXPORT

     TENACITY 4

     SESSIONS 5

     SLEEP 6;

0007 .EXPORT OUTFILE

     '/apps/Informatica/9.5.0/server/infa_shared/Temp/pcis01/FE_V_DM_CM_DIM_AGRE

     EMENTS.out' FORMAT FASTLOAD MODE INDICATOR;

0008 Select FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_KEY,

     FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_ID,

     FE_V_DM_CM_DIM_AGREEMENTS.PARENT_ID,  FE_V_DM_CM_DIM_AGREEMENTS.START_DATE,

      FE_V_DM_CM_DIM_AGREEMENTS.TERM,  FE_V_DM_CM_DIM_AGREEMENTS.END_DATE,

     FE_V_DM_CM_DIM_AGREEMENTS.DEALER_CODE,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_BRAND,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_MODEL,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_IMEI,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN,  FE_V_DM_CM_DIM_AGREEMENTS.PARENT_RP,

     FE_V_DM_CM_DIM_AGREEMENTS.EXTERNAL_CONTRACT_REFERENCE,

     FE_V_DM_CM_DIM_AGREEMENTS.SUBSIDY,  FE_V_DM_CM_DIM_AGREEMENTS.COMMISSION,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN_FEE_EX_VAT FROM

     P0_OR_SBL.FE_V_DM_CM_DIM_AGREEMENTS;

0009 .END EXPORT;

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

     =                                                                      =

     =          FastExport Initial Phase                                    =

     =                                                                      =

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

**** 10:38:15 UTY8700 Options in effect for this FastExport task:

     .       Sessions:    5 session(s).

     .       Mode:        INDICATOR

     .       Blocksize:   64330 bytes.

     .       Outlimit:    No limit in effect.

     .       Tenacity:    4 hour limit to successfully connect load sessions.

     .       Sleep   :    6 minute(s).

**** 10:38:15 UTY8715 FastExport is submitting the following request:

     Select NULL from P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS where (LogType =

     220) and (Seq = 1) and (FExptSeq = 0);

**** 10:38:20 UTY8715 FastExport is submitting the following request:

     SET QUERY_BAND='UTILITYNAME=FASTEXP;' UPDATE FOR SESSION;

**** 10:38:20 UTY8715 FastExport is submitting the following request:

     CHECK WORKLOAD FOR BT;BEGIN FASTEXPORT;

**** 10:38:20 UTY8715 FastExport is submitting the following request:

     CHECK WORKLOAD FOR Select FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_KEY,

     FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_ID,

     FE_V_DM_CM_DIM_AGREEMENTS.PARENT_ID,  FE_V_DM_CM_DIM_AGREEMENTS.START_DATE,

      FE_V_DM_CM_DIM_AGREEMENTS.TERM,  FE_V_DM_CM_DIM_AGREEMENTS.END_DATE,

     FE_V_DM_CM_DIM_AGREEMENTS.DEALER_CODE,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_BRAND,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_MODEL,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_IMEI,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN,  FE_V_DM_CM_DIM_AGREEMENTS.PARENT_RP,

     FE_V_DM_CM_DIM_AGREEMENTS.EXTERNAL_CONTRACT_REFERENCE,

     FE_V_DM_CM_DIM_AGREEMENTS.SUBSIDY,  FE_V_DM_CM_DIM_AGREEMENTS.COMMISSION,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN_FEE_EX_VAT FROM

     P0_OR_SBL.FE_V_DM_CM_DIM_AGREEMENTS;

**** 10:38:20 UTY8715 FastExport is submitting the following request:

     CHECK WORKLOAD END;

**** 10:38:20 UTY0844 Session count 4 returned by the DBS overrides

     user-requested session count.

**** 10:38:27 UTY8705 EXPORT session(s) requested: 4.

**** 10:38:27 UTY8706 EXPORT session(s) connected: 4.

**** 10:38:27 UTY8715 FastExport is submitting the following request:

     BT;BEGIN FASTEXPORT;

**** 10:38:27 UTY8715 FastExport is submitting the following request:

     SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER), MiscInt3 (INTEGER),FExptSeq

     (INTEGER), FExptCkpt (VARBYTE(1024)) from

     P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS WHERE (LogType = 210) and (Seq = 1)

     and (FExptSeq IN (SELECT MAX(FExptSeq) from

     P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS where (LogType = 210) and (Seq =

     1)));

**** 10:39:14 UTY8715 FastExport is submitting the following request:

     SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),  MiscInt3 (INTEGER),FExptSeq

     (INTEGER), FExptCkpt (VARBYTE(1024)) from

     P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS WHERE (LogType = 212) and (Seq = 1)

     and (FExptSeq IN (SELECT MAX(FExptSeq) from

     P0_OR_SBL.FE_FE_V_DM_CM_DIM_AGREEMENTS where (LogType = 212) and (Seq =

     1)));

**** 10:39:19 UTY8715 FastExport is submitting the following request:

     Select FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_KEY,

     FE_V_DM_CM_DIM_AGREEMENTS.AGREEMENT_ID,

     FE_V_DM_CM_DIM_AGREEMENTS.PARENT_ID,  FE_V_DM_CM_DIM_AGREEMENTS.START_DATE,

      FE_V_DM_CM_DIM_AGREEMENTS.TERM,  FE_V_DM_CM_DIM_AGREEMENTS.END_DATE,

     FE_V_DM_CM_DIM_AGREEMENTS.DEALER_CODE,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_BRAND,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_MODEL,

     FE_V_DM_CM_DIM_AGREEMENTS.HANDSET_IMEI,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN,  FE_V_DM_CM_DIM_AGREEMENTS.PARENT_RP,

     FE_V_DM_CM_DIM_AGREEMENTS.EXTERNAL_CONTRACT_REFERENCE,

     FE_V_DM_CM_DIM_AGREEMENTS.SUBSIDY,  FE_V_DM_CM_DIM_AGREEMENTS.COMMISSION,

     FE_V_DM_CM_DIM_AGREEMENTS.RATEPLAN_FEE_EX_VAT FROM

     P0_OR_SBL.FE_V_DM_CM_DIM_AGREEMENTS;

**** 10:39:19 UTY8724 Select request submitted to the RDBMS.

**** 10:45:07 UTY8725 Select execution completed. 48026 data blocks generated.

**** 11:48:19 UTY8726 502 records written to output file.

     UTY8732 0.02 blocks processed per minute (5-minute sample).

     UTY8732 0.02 blocks processed per minute (running average).

**** 12:28:38 UTY4014 Access module error '34' received during 'write'

     operation: 'pmunxWBuf: fwrite byte count error (System error message

     detected: 32)'

**** 12:28:38 UTY8721 Error attempting to write file

     /apps/Informatica/9.5.0/server/infa_shared/Temp/pcis01/FE_V_DM_CM_DIM_AGREE

     MENTS.out, return code is 12.      

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

     =                                                                      =

     =          Logoff/Disconnect                                           =

     =                                                                      =

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

**** 12:28:38 UTY1001 Unexpected parcel: 11, expected 10.

**** 12:28:44 UTY6212 A successful disconnect was made from the RDBMS.

**** 12:28:44 UTY2410 Total processor time used = '1.67 Seconds'

     .       Start : 10:38:02 - TUE MAR 24, 2015

     .       End   : 12:28:44 - TUE MAR 24, 2015

     .       Highest return code encountered = '12'.

5 REPLIES
Enthusiast

Re: Fast export error

The SQL is returning 23 million records

Teradata Employee

Re: Fast export error

Error code 34 from Data Connector is just "fatal error has occurred"; error code 32 on fwrite is "broken pipe". So you would need to figure out why the consuming process aborted / closed the pipe.

Enthusiast

Re: Fast export error

Dear Fred, Thanks for your reply.

I am not able to root cause, this FE is creating the .out file where it will write but while writing it is getting failed. Without any change if we submit same script then it is getting finished successfully.

You said :  figure out why the consuming process aborted / closed the pipe

How can is figure it out? what do you mean by consuming process?

Junior Supporter

Re: Fast export error

Hi.

Filesystem error. You are generating almost 3GB. If you are on a 32bit Linux you may be hitting 2GB limit, run out of space on filesystem or filesystem quota...

HTH.

Cheers.

Carlos.

Enthusiast

Re: Fast export error

if the Highest return code encountered = '12'. means the retcode is 12?