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.
SAP Knowledge Base Article - Preview