Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

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

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
john_wang
Support
Support

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

Last Update:

Dec 5, 2023 5:08:30 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 5, 2023 5:08:30 AM

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
Labels (1)
Version history
Last update:
‎2023-12-05 05:08 AM
Updated by: