You can translate the question and the replies:

Error message of curl command for Data catalog sync to VDP

Hi Team, We are using curl command for Data catalog sync with VDP in our script for some part of automation purpose. Sometimes when we run the curl command below, it will have '500' StatusCode and errors messages returned, can you please help to see why the errors and how we prevent it happen: curl command we ran for data catalog metadata sync with VDP: curl --request POST --user "user_id:password" --header "Content-Type: application/json" --data '{ "allServers": "true", "priority": "server" }' "http://company.com:9090/denodo-data-catalog/apirest/synchronize" Error message returned: "httpStatusCode":500, "jsonResponse":{"result":"ERROR","data":null,"message":"Statement too complex. Try rewriting the query to remove complexity. Eliminating many duplicate expressions or breaking up the query and storing interim results in a temporary table can often help resolve this error."}
user
01-03-2021 00:46:26 -0500

1 Answer

Hi, A "Statement too complex" error occurs when synchronizing with the VDP server data there are many tables with modified fields. You could use the following workaround to overcome it. Please follow the below steps: 1. Export the Data Catalog metadata. 1. Rename the Data Catalog server to Data Catalog old. 1. Create a new Data Catalog server. 1. Logout and login to the new Data Catalog. 1. Synchonize with VDP Server. 1. Import the previously exported metadata file with **Override Existing Metadata** option. After performing the above workaround, please verify if the Virtual DataPort Server changes are reflected in Data Catalog. If everything is fine after verification, you could delete old server. Hope this helps!
Denodo Team
02-03-2021 04:06:12 -0500
You must sign in to add an answer. If you do not have an account, you can register here