Symptom
- Error message 'Database error 8642 at OPC' displays in sm21 system log on BW system.
- Corresponding developer trace shows information similar with below:
****
C (8642) [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The query processor could not start the necessary thread resources for parallel query execution.
C Error 99 (dbcode 8642) in StartSelect
C StartSelect: stmt of NULL_STMTID
C select TOP 100 [P0000].[/BIC/TGDT23G346] AS [0000000052] ,[T0000].[TXTMD]AS
... <--- the sql statement which caused this error
C [0000000052] ASC OPTION (USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE') , MAXDOP 4
****
Read more...
Environment
- SQL Server 2014 (and newer)
- Netweaver
Product
Keywords
'Database error 8642 at OPC' 8642 , KBA , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.