|
Archives of the TeradataForumMessage Posted: Thu, 09 Jul 2009 @ 21:19:02 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||