OAAM Quova Uploading Fails With Dead Lock In SQL Server 2005 DB (Doc ID 1245005.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Adaptive Access Manager - Version 10.1.4.3 and later
Information in this document applies to any platform.

Symptoms

Geo Location Data Incremental Load fails with the following Error while running Geo Location update against SQL Server 2005 Database.

Caused by: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.1.0) (Build 061004)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.Error Code: 1205
Call:select T0.IP_RANGE_ID IP_RANGE_ID_T0, T0.CREATE_TIME CREATE_TIME_T0, T0.NOTES NOTES_T0, T0.UPDATE_TIME UPDATE_TIME_T0, T0.SEC_LEVEL_DOMAIN SEC_LEVEL_DOMAIN_T0, T0.TO_IP_ADDR
TO_IP_ADDR_T0, T0.FROM_IP_ADDR FROM_IP_ADDR_T0, T0.BASE_IP_ADDR BASE_IP_ADDR_T0 from V_IP_LOC_MAP_SPLIT T0 where T0.BASE_IP_ADDR >= ? order by T0.FROM_IP_ADDR
bind => [1115285504]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms