EGL: Allocation Process, FS_ALLC, Abends at Step FS_CEDT_ECMB.4uAnchCT.uAnchCDT (SQL) -- RC = 8601 (108,524) The Query Processor Could Not Start The Necessary Thread Resources For Parallel Query Execution (Doc ID 2916006.1)

Last updated on JANUARY 18, 2023

Applies to:

Symptoms

Allocation process, FS_ALLC, abends at at Step FS_CEDT_ECMB.4uAnchCT.uAnchCDT (SQL) -- RC = 8601 (108,524).
SQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The query processor could not start the necessary thread resources for parallel query execution. Reduce load on the server or use the MAXDOP setting to limit parallelism.

ERROR
-----------------------
SQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The query processor could not start the necessary thread resources for parallel query execution. Reduce load on the server or use the MAXDOP setting to limit parallelism. (SQLSTATE 42000) 8642
Failed SQL stmt: UPDATE PS_JRNL_LN SET JRNL_LINE_STATUS = 'a' WHERE BUSINESS_UNIT = 'UNF01' AND PROCESS_INSTANCE = 801367 AND LEDGER IN ( 'ACTUAL', 'REPORTING') AND ( JRNL_LINE_STATUS = '0' OR JRNL_LINE_STATUS = 'w' ) AND EXISTS ( SELECT 'X' FROM PS_COMBO_DATA_TBL WHERE SETID = 'SHARE' AND PROCESS_GROUP = 'XXXXXXX' AND COMBINATION IN ('XXXXX_XXX', 'XXXX_XX') AND VALID_CODE= 'V' AND PS_JRNL_LN.JOURNAL_DATE BETWEEN EFFDT_FROM AND EFFDT_TO AND PS_JRNL_LN.ACCOUNT = ACCOUNT)

Process 801367 ABENDED at Step FS_CEDT_ECMB.4uAnchCT.uAnchCDT (SQL) -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 13.50.51 2022-10-27

STEPS

1. Run Allocations - Allocations > Define and Perform Allocations > Request Allocation

2. Process abends

3. Above error seen in AE_FS_ALLC stdout file

Changes

Cause

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