Archives of the TeradataForum

Message Posted: Thu, 04 May 2006 @ 19:08:07 GMT

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

<-- Anonymously Posted: Thursday, May 04, 2006 14:19 -->

Hi Gurus ,

I am getting same error in different jobs like

     UTY8001 RDBMS failure in Macro Build: 3805, Macro
           'M20060504_050344_89_001_001' already exists.

     UTY8001 RDBMS failure in Macro Build: 3805, Macro
           'M20060504_050349_18_001_001' already exists.

     UTY8001 RDBMS failure in Macro Build: 3805, Macro
           'M20060501_050255_20_001_001' already exists.

when i am looking into error code

3805 Macro '%VSTR' already exists.

Explanation: The user tried to create a table, view, macro, trigger, procedure or function and a macro with that name already existed. This error occurs on the CREATE TABLE, VIEW, MACRO, TRIGGER, PROCEDURE or FUNCTION statement. (As a special case this error can also be caused by two REPLACE MACRO statements issued at the same time from two different sessions: If both sessions try to replace the same macro in the same user or database, and the macro does not already exist, then they will both try to create the macro, and one of the sessions will get this error).

Generated By: RES and OPT modules.

For Whom: End User.

Remedy: Examine the Teradata SQL statement and verify that the request is correct. Change the statement to specify a different name and resubmit the request.

as of now i am using default settings and i am not specified any external job name and all these jobs are loading into same database

      .       Tenacity:    4 hour limit to successfully connect load sessions.
     .   Max Sessions:    6 session(s).
     .   Min Sessions:    4 session(s).
     .     Checkpoint:        15 minute(s).
     .       Errlimit:              No limit in effect.
     .   Restart Mode:        ROBUST.
     .  Serialization:        OFF.
     .        Packing:        20 Statements per Request.
     .   StartUp Rate:        UNLIMITED Statements per Minute.

what is the best method explicit job name

robust off

upgrading

please suggets me

Thanks

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