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'"

Symptom

  • Using a build of SQL Anywhere lower than 11.0.1.2569, 12.0.0.2652 and 12.0.1.3297
  • 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


Read more...

Environment

  • SAP Sybase SQL Anywhere 11 and 12

Product

SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

Keywords

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.