Qlik Replicate and Sybase ASE source endpoint: Irrelevant DDL - ignored

john_wang — Tue, 05 Dec 2023 10:08:30 GMT

Using a Sybase ASE source endpoint, Qlik Replicate may not capture or simply ignore all DDL (Data Definition Language) commands, while DML (Data Manipulation Language) commands (Insert/Update/Delete) are captured and applied successfully.

Example of DDL in a source database:

alter table db_test.dbo.tb_test add notes varchar(50) null

Qlik Replicate ignores the above DDL. Reviewing the task logs (if set to trace or verbose logging level) shows:

[SOURCE_CAPTURE ]T: Captured DDL / type for table dbo.tb_test (identified by objid 672002394) is not known to metadata manager. Irrelevant DDL - ignored... (sybase_endpoint_metadata.c:710)

Resolution

Verify the user's privileges as per Required permissions for SAP Sybase AES.

Example of how to create a user (qruser) which owns sufficient permissions and works fine with DML/DDL operations:

create login qruser with password qruser123
sp_adduser qruser
grant role sa_role, replication_role, sybase_ts_role to qruser
sp_displaylogin qruser;

Internal Investigation ID(s)

#00112248

Environment

Qlik Replicate all versions , on both platforms: Windows and Linux
Sybase ASE all versions , on both platforms: Windows and Linux

article Qlik Replicate and Sybase ASE source endpoint: Irrelevant DDL - ignored in Official Support Articles

Qlik Replicate and Sybase ASE source endpoint: Irrelevant DDL - ignored

Resolution

Internal Investigation ID(s)

Environment