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

Search for additional results

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