SAP Knowledge Base Article - Preview

2130187 - Error: "BODI-320004: Error or warning in executing the SQL statement" When using Data Services Repository Manager to create Sybase ASE repository

Symptom

  • When using Data Services Repository Manager to create a Data Services repository using a Sybase ASE database the following error is seen:

BODI-320004: Error or warning in executing the SQL
statement < CREATE TABLE ADDRVALIDATESUMMARY( OBJECT_KEY INT
NOT NULL , OBJECT_ID VARCHAR(255) NOT NULL, ENGINENAME CHAR(50)
NOT NULL, COUNTRYID CHAR(2) NOT NULL, COMPONENTNAME VARCHAR(64),
ADDEDRECS INT, DELETEDRECS INT, CORRECTEDRECS INT,
UNCHANGEDRECS INT, SUITEL_TYPE INT DEFAULT 0 NOT NULL,
DATA_SOURCE_ID VARCHAR(80) DEFAULT' ' NOT NULL, PRIMARY KEY
(OBJECT_KEY, OBJECT_ID, ENGINENAME, COUNTRYID,
COMPONENTNAME, SUITEL_TYPE, DATA_SOURCE_ID) ) >.

The message from the underlying database is: <Sybase SQL Server <IPS>
error message for operation <ct_results>: <Sybase Server message number
<1920> State <1> Severity <16> From Server <IPS>: Message Text is:
Column 'COMPONENTNAME' is part of a primary key constraint and cannot
be null. Sybase Server message number <2761> State <4> Severity <16>


Read more...

Environment

  • SAP Data Services 4.2 SP2 (14.2.2.482)
  • Sybase ASE Server 15.7
  • Linux Supported Environment

Product

SAP Data Services 4.2

Keywords

BODS, repoman, repository manager, create repository, Sybase ASE, BODI-320004, Sybase_content.sql , KBA , EIM-DS-SVR , Data Services Administration/Server , 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.