OS : SLES 10
Version : 8.0.1
Database for IA : SQLServer
Information Analyzer.
Error, when running column analysis. The error occurs when it runs one of the BaseProfileLoadX_ColumnAnalysisTaskxxxxxxx.
The fatal error that shows up in the datastage director log is -
ODBC function "SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [DataDirect][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (CC_OdbcDBStatement::executeUpdate, file CC_OdbcDBStatement.cpp, line 712)
Any help on this is greatly appreciated. Thanks .