SAP Knowledge Base Article - Preview

2382713 - Upgrade to Afaria SP7 fails with error No primary key value for foreign key

Symptom

  • Error processing SQL statements: IF NOT EXISTS(SELECT * FROM A_V_DB_OBJECTS WHERE OBJECT_NAME='FK_A_SSP_ENROLLMENT_CODES_A_ENROLLMENT_CODES' AND OBJECT_TYPE = 'FK') BEGIN ALTER TABLE A_SSP_ENROLLMENT_CODES ADD NOT NULL FOREIGN KEY FK_A_SSP_ENROLLMENT_CODES_A_ENROLLMENT_CODES(...
  • ADO Error: Description = [Sybase][ODBC Driver][SQL Anywhere] No Primary key value for foreign key 'FK_A_SSP_ENROLLMENT_CODES_A_ENROLLMENT_CODES' in table 'A_SSP_ENROLLMENT_CODES' SQLSTATE = 23000 NativeError = -194

Read more...

Environment

  • SAP Afaria 7 SP 7
  • SAP SQL Anywhere 12.0.1.xxxx

Product

SAP Afaria 7.0

Keywords

A_ENROLLMENT_CODES, A_SSP_ENROLLMENT_CODES , KBA , MOB-AFA , Afaria , 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.