After Upgrade Application Hangs because of a Never Ending Query Running On S_ASSET_CON (Doc ID 1956567.1)

Last updated on AUGUST 21, 2017

Applies to:

Siebel Field Service - Version 8.1.1.11.9 [IP2013] and later
Siebel CRM - Version 8.1.1.10 [23021] to 8.1.1.10 [23021] [Release V8]
Information in this document applies to any platform.

Symptoms

After upgrade to 8.1.1.11 there were reported hang behaviors when using functionalities involving assets.

When S_ASSET table is queried and based on the result number of the assets/records, application instantiates the BS "FINS Data Transfer Utilities" which further tries to write on BC - Asset Mgmt - Asset which has a Run Time Event  with Action set "AssetToAssetContact - Upsert" created. This causes a repeating query against S_ASSET_CON table and the application hangs.

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