My Oracle Support Banner

EMM: WM_WO_CI Fails With Error "NUMBER: -2147012894" "THE OPERATION TIMED OUT" "In Routine SendSoapRequest SUBMITTODB" While Loading Two Or More Lines (Doc ID 2996951.1)

Last updated on JANUARY 11, 2024

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



WM_WO_CI Fails with Error "Number: -2147012894" "The operation timed out" "in routine sendSOAPRequest_SubmitToDB" while loading Two or more Lines and is causing the system to be unusable on Microsoft SQL Server Database.

Error: NUMBER: -2147012894" "THE OPERATION TIMED OUT" "IN ROUTINE SENDSOAPREQUEST_SUBMITTODB"

 

Replication Steps:

1) Load the CI "WM_WO_CI" in an Excel to CI file.
2) Select the fields "Business Unit,Work Order ID,Work Type,Service Group,Shop, Priority Code,Required Start,Required End,WO Transaction Template ID,Long Description,AM Business Unit,Asset Identification" from level 0
3) Provide test data more than 5 rows.
4) Set the chunking factor to more than 1.
5) Submit data.
6) Excel will time out.
7) To veirfy the deadlock execute the sql "UPDATE PS_PROJECT SET LAST_ACTIVITY_ID = 'SOME NUMBER' WHERE BUSINESS_UNIT = 'US001' AND PROJECT_ID = 'CORRECTIVE';" the SQL will not complete indicating deadlock.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.