SAP Knowledge Base Article - Preview

2788294 - Database error 8642 at OPC - Netweaver

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

SAP Solution Manager 7.2

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.