Archives of the TeradataForum

Message Posted: Wed, 13 Sep 2006 @ 16:14:09 GMT

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

Hi,

During fexport and mload operation using named pipe. I get the following error messages.Any suggestions !

     **** 19:50:50 UTY4014 Access module error '34' received during 'write' operation: 'pmunxWBuf:
          fwrite byte count error (System error message detected: 32)'

Fexport Script:

     mknod /home/employeeinfo/employee.pipe p
     fexp << fexpcall1 >> fexp.out
      .logtable p_bcd_ut1.employee_log;

      .RUN FILE /home/logininfo/login.cfg;

       .BEGIN EXPORT SESSIONS 64 16 TENACITY 2 SLEEP 5;
      .EXPORT OUTFILE /home/employeeinfo/employee.pipe FORMAT FASTLOAD;
        select * from edwdev.employee  where empnum  between 7878788 and 97878788;
      .end export;
      .logoff;
     fexpcall1

Fexport Log

     **** 19:50:49 UTY8715 FastExport is submitting the following request:
             select * from p_bcd_t.employee  where per_num  between 6270 and 6282;
     **** 19:50:49 UTY8724 Select request submitted to the RDBMS.
     **** 19:50:50 UTY8725 Select execution completed. 5911 data blocks generated.
     **** 19:50:50 UTY4014 Access module error '34' received during 'write' operation: 'pmunxWBuf:
          fwrite byte count error (System error message detected: 32)'
     **** 19:50:50 UTY8721 Error attempting to write file
          /home/employeeinfo/employee.pipe,
          return code is 12.

          --------------------------------------------------------------
          -                                                            -
          -          Logoff/Disconnect                                 -
          -                                                            -
          --------------------------------------------------------------

     **** 19:50:51 UTY1001 Unexpected parcel: 11, expected 10.
     **** 19:50:53 UTY6212 A successful disconnect was made from the RDBMS.
     **** 19:50:53 UTY2410 Total processor time used = '2.73 Seconds'
          .       Start : 19:49:29 - MON SEP 11, 2006
          .       End   : 19:50:53 - MON SEP 11, 2006
          .       Highest return code encountered = '12'.

Regards,

Sam

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