Archives of the TeradataForum

Message Posted: Wed, 26 Nov 2003 @ 15:55:36 GMT

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

Hello All,

We are having a serious problem with this error as our multiload programs continue to abort (see partial log below, at the end of the log you will notice error UTY4014 /8018). We are executing on a UNIX 4400, Teradata 5250 V2R4. We receive this error executing the utility with all types of connections to the Teradata.

Note: There are two errors below. One says "RDBMS failure, 8018: The session id is illegal." and second says "UTY4014 Access module error '7' received during 'set position' operation: 'Invalid pmFp parameter'"

Any advice is appreciated.

Happy Thanksgiving!!!

----------------------------------------------------------------------
**** 08:30:12 UTY1802 Processing Import Sequence 1, Source Sequence 100000.
**** 08:36:02 UTY0805 RDBMS failure, 8018: The session id is illegal.
**** 08:36:02 UTY1804 Re-starting this MultiLoad task because a retryable error occurred.

 ---------------------------------------------------------------------
     =
=
     =          MultiLoad Initial Phase
=
     =
=
 ---------------------------------------------------------------------
**** 08:36:02 UTY0829 Options in effect for this MultiLoad import task:
     .       Sessions:    4 session(s).
     .       Checkpoint:  200000 records.
     .       Tenacity:    4 hour limit to successfully connect load sessions.
     .       Errlimit:    2000 rejected record(s).
     .       AmpCheck:    In effect for apply phase transitions.
**** 08:36:03 UTY1024 Session modal request, 'DATABASE', re-executed.
**** 08:36:03 UTY0817 MultiLoad submitting the following request:
     Select NULL from StagingAreaDB.LOAD_TABLE_TLog where (LogType = 125)
     and (Seq = 1) and (MloadSeq = 0);
**** 08:36:03 UTY0817 MultiLoad submitting the following request:
     Select NULL from StagingAreaDB.LOAD_TABLE_TLog where (LogType = 120)
     and (Seq = 1);
**** 08:36:04 UTY0812 MLOAD session(s) requested: 4.
**** 08:36:04 UTY0815 MLOAD session(s) connected: 4.
**** 08:36:04 UTY0817 MultiLoad submitting the following request:
     BEGIN MLOAD "LOAD_TABLE";
**** 08:36:04 UTY0817 MultiLoad submitting the following request:
     Select NULL from StagingAreaDB.LOAD_TABLE_TLog where (LogType = 130) and (Seq = 1) and (MloadSeq = 20);

 ---------------------------------------------------------------------
     =
=
     =          MultiLoad Acquisition Phase
=
     =
=

 ---------------------------------------------------------------------
**** 08:36:04 UTY0817 MultiLoad submitting the following request:
     SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER),MiscInt3 (INTEGER),
     MiscInt4 (INTEGER), MiscInt5 (INTEGER),MiscInt6 (INTEGER), MiscInt7 (INTEGER),
     MiscInt8 (INTEGER),MloadSeq (INTEGER), MloadImpSeq (INTEGER),MloadSrcSeq
     (INTEGER), MloadCkpt (VARBYTE(1024)) from
     StagingAreaDB.LOAD_TABLE_TLog WHERE (LogType = 110) and (Seq = 1)
     and (MloadSeq IN (SELECT MAX(MloadSeq) from
     StagingAreaDB.LOAD_TABLE_TLog where (LogType = 110) and (Seq =
     1)));
**** 08:36:05 UTY0817 MultiLoad submitting the following request:
     BEGIN TRANSACTION;
**** 08:36:05 UTY0817 MultiLoad submitting the following request:
     CHECKPOINT LOADING;
**** 08:36:05 UTY4014 Access module error '7' received during 'set position' operation:
     'Invalid pmFp parameter'

 ---------------------------------------------------------------------
     =
=
     =          Logoff/Disconnect
=
     =
=
 ---------------------------------------------------------------------
**** 08:36:06 UTY6212 A successful disconnect was made from the RDBMS.
**** 08:36:06 UTY2410 Total processor time used = '17.7756 Seconds'
     .       Start : 08:26:55 - WED NOV 26, 2003
     .       End   : 08:36:06 - WED NOV 26, 2003
     .       Highest return code encountered = '12'.

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