Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 21:19:02 GMT

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

Greetings,

For a couple of days our backup script is failing. The below is the error in the log file:

     07/08/2009 23:46:17  TABLE "dCustomerAddress2" -   5,268,800 BYTES,  10,304
                          ROWS ARCHIVED
     07/09/2009 00:03:27  RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS
     ----------------------------------------------------------------
     Execution traceback not available on this platform.
     ----------------------------------------------------------------
     07/09/2009 00:04:34  UTILITY EVENT NUMBER  - 299
     07/09/2009 00:04:34  RESTART COMPLETED
     07/09/2009 05:44:02  *** Failure 8018:The session id is illegal.
     07/09/2009 05:45:05  LOGGED OFF   6 SESSIONS
     07/09/2009 05:45:05  ARCMAIN TERMINATED WITH SEVERITY 12

The change we did was to move the box having the database to a different physical location, everything else being the same.

Can anyone suggest what to do? I don t see my database crashing and I am not sure about session id issue. Also, for two days the daily ETL is stuck, and doesn t complete until and unless I release the lock manually. Can it be because of this?

Thanks

Ayush

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