Dead lock when running column analysis

[rvvrr]

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 .

[mahadev.v]

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?

[mee]

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"