SAP Knowledge Base Article - Preview

2489711 - SQL error 1446 in Oracle after kernel update

Symptom

The following dump is occurring in the system:

Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 06/13/2017 15:23:58


Short Text
SQL error "SQL code: 1446" occurred while accessing table "<Table Name>".

In session "source code extract" of the dump, it is observed that the SQL statement contains "SELECT ... FOR UPDATE, as per the example below:

>>> SELECT SINGLE FOR UPDATE * INTO CORRESPONDING FIELDS OF p_isdokloio

FROM (header_table)

WHERE loio_id = p_object_id-objid AND lo_class = p_object_id-class.


Read more...

Environment

  • Oracle 12 database;
  • SAP Netweaver release independent.

Product

SAP NetWeaver all versions

Keywords

B LOG BY4=>, performing FET, on table, ORA-01446, cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, dumping DbDbslStatement , KBA , BC-DB-DBI , DB Independent Database Interface , BC-DB-ORA , Oracle , 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.