Archives of the TeradataForum

Message Posted: Mon, 27 Oct 2003 @ 14:38:51 GMT

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

When I run an mload script (mload -b < thismloadscript), I get an intermittent error pertaining to an invalid user and was wondering if anyone else had experienced anything similar. Here's the shell of a log file. We've gotten this message on a different scripts the two times we've had it out of over 1000 runs to date. Hopefully I'm providing enough information on the "load flow" to make some sense.

**** 06:10:33 UTY2414 BRIEF option is enabled.

 -----------------------------------------------------------------------
     =          MultiLoad Utility     Release MLOD.07.06.00
=
     =          Platform HP-UX
=

 -----------------------------------------------------------------------
**** 06:10:33 UTY2411 Processing start date: MON OCT 27, 2003

 -----------------------------------------------------------------------
     =          Logon/Connection
=

 -----------------------------------------------------------------------
0001 .RUN FILE /xxx/xxx/xxx/xxx/xxxr_logon;
0002 .logon XXXX/username,;
**** 06:10:33 UTY6214 Reminder: A .Logtable statement must be entered
for a
successful logon.
0003 .LogTable DB_NAME.LG_TABLENAME ;
**** 06:10:33 UTY8400 Default character set: ASCII
**** 06:10:33 UTY8400 Maximum supported buffer size: 64K
**** 06:10:40 UTY6211 A successful connect was made to the RDBMS.
**** 06:10:40 UTY6217 Logtable 'DB_NAME.LG_TABLENAME' has been created.

     Database DB_NAME ;
**** 06:10:40 UTY1016 'DATABASE' request successful.

0009 .BEGIN IMPORT MLOAD Tables stg_x,
stg_y
            WorkTables                WT_x,
                             WT_y
            ErrorTables               ET_x
                                                UV_x
                                                             , ET_y
                                           UV_y;

 -----------------------------------------------------------------------
     =          Processing MultiLoad Statements
=

 -----------------------------------------------------------------------
0010 .Layout TABLE;
....
0193 .IMPORT INFILE /xxx/xxx/xxx/xxx/xxxxxxx/xxxxxxxxx.dat
         Format Text
         Layout TABLE;
0194 .END MLOAD ;

 -----------------------------------------------------------------------
     =          MultiLoad Initial Phase
=

 -----------------------------------------------------------------------
**** 06:10:41 UTY0829 Options in effect for this MultiLoad import task:
     .       Sessions:    One session per available amp.
     .       Checkpoint:  15 minute(s).
     .       Tenacity:    4 hour limit to successfully connect load
sessions.
     .       Errlimit:    No limit in effect.
     .       AmpCheck:    In effect for apply phase transitions.
**** 06:10:49 UTY0817 MultiLoad submitting the following request:
     Select NULL from DB_NAME.LG_TABLENAME where (LogType = 120) and
(Seq
= 1);
**** 06:10:49 UTY0805 RDBMS failure, 8017: The UserId, Password or
Account
is invalid.

How can there be an invalid account at this point in the process? Any ideas?

Thanks!

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