SAP Knowledge Base Article - Preview

1934015 - Error: INSERT ON EXISTING UPDATE with CASCADE in blank-padded database could fail with "SQLCODE -198 : Primary key for row in table 'parent_table' is referenced by foreign key 'child_table_fk'"


  • Using a build of SQL Anywhere lower than, and
  • Using a blank-padded database ("dbinit -b")
  • Using an INSERT ON EXISTING UPDATE statement on a table with CASCADE foreign key references and the insertion value that is similar to an existing entry in the table without padded spaces



  • SAP Sybase SQL Anywhere 11 and 12


SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0


11655814 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.