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

[john_wang]

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