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
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.