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

Qlik Replicate: cannot add Azure SQL DB target endpoint with error Failed to get syntax

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

Qlik Replicate: cannot add Azure SQL DB target endpoint with error Failed to get syntax

Last Update:

Sep 27, 2023 4:27:14 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 27, 2023 4:26:56 AM

Creating and adding a new target endpoint to Azure SQL DB and testing the connection fails with:

SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties.
SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties,Failed to get 'SQLServer_New' syntax

Resolution

Review the active Internal Parameters set in the endpoint. 

  1. Go to the  Endpoint connection
  2. Switch to the Advanced tab
  3. Click Internal Parameters
  4. Review the set parameters for a syntax parameter set to a specific value (in our example: SQLServer_New).
  5. Remove the Internal Parameter.

    syntax added.png

 

Environment

Qlik Replicate 

 

Labels (1)
Version history
Last update:
‎2023-09-27 04:27 AM
Updated by: