All Forums UDA
Greyghost 51 posts Joined 07/09
05 Aug 2009
MLoad Error

Hello,I need some help regarding an error that occurred while our production loading was running. Here is the error message:---------------------------------------------- ------------------------------Access module error '34' received during 'read' operation on record number '1361905': 'pmunxRBuf: fread error (Invalid argument)'-------------------------------------------- --------------------------------A fast look at the record everything looked fine. So, I removed the record from the input file (saving it for analysis) and reran the MLoad. It ran cleanly.I went back to analyze the single record, and started by just trying to MLoad this record. I expected an error, but the MLoad ran to a zero completion code!I am now very confused on why the production job abended when there appears to be nothing wrong with the data.Can anyone shed any light on this situation?Thanks!Paul

Greyghost 51 posts Joined 07/09
06 Aug 2009

Just to add to the confusion on this issue, I reran the MLoad with a file that originally failed, and it ran fine the second time.I am working in a Windows server environment. Does this error have anything to do with connectivity, or available server space? This weeks production files were much larger than normal.Thanks!Paul

Raja_KT 1246 posts Joined 07/09
07 Aug 2009

Paul,1) Check how many instances are/were runniing when you run your mload.2) Which USER_ID YOU EXECUTE YOUR SCRIPT? :)Then you will get an answer.... :)Rgds,Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Greyghost 51 posts Joined 07/09
11 Aug 2009

Hi Raja,Is there a way to check this after the runs have completed? Is there some Teradata table that stores the information you are pointing me to?Thanks!Paul

Raja_KT 1246 posts Joined 07/09
12 Aug 2009

Paul,I m not sure. You can get the info from the TDBA.Please let me know if you get the info.Thanks and regards,Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.