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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.