DSXchange

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 .

was deadlocked on lock resources with another process and has been chosen as the deadlock victim . Rerun the transaction.

What happens when you rerun? still the same error?

Pls check with you DBA on SQLServer 's(Source Database) isolation level. It is quite possible that the SQL Server has been configured with a very high isolation level and that's causing the deadlock.

1 - Read Committed
2 - Repeatable read
3 - Serializable

Try with "Read Commited"