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 for Me (Login required).

Search for additional results

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