OAAM Quova Uploading Fails With Dead Lock In SQL Server 2005 DB
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.
Geo Location Data Incremental Load fails with the following Error while running Geo Location update against SQL Server 2005 Database.
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 => 
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms