C

Friday, January 13th, 2023 5:56 PM

Spring Boot Denodo Integration Error

Receiving error when running denodo to Collibra integration on multiple databases :

complex relation legs cant be duplicated. Its not allowed to have the asset more than once in in leg

I have 9 databases I’m trying to run this integration on. The integration receives the above error when trying to run the integration on all 9 databases. However, when I run the integration on each database individually, it works correctly without receiving any error.

368 Messages

2 years ago

Hi @christopher.lynch.exlservice.com,

Regarding the error, can you please try updating line 327 of the com.collibra.marketplace.denodo.component.CollibraAssetTransformer class as follows:

viewDependencies.stream().distinct().forEach(viewDependency -> {

Additionally, it would be helpful if you could share the logs here or as a private message to better understand what the issue might be. Please note that prior to doing so, remove any sensitive information.

Thanks

23 Messages

[quote=“spring-team.collibra.com, post:2, topic:2746”]
Regarding the error, can you please try updating line 327 of the com.collibra.marketplace.denodo.component.CollibraAssetTransformer class as follows:


[/quote]denodo-to-collibra-integration (2).txt (1.5 MB)

Ok I’ve updated the class, but still hitting error. I’ve attached the log file. Additonally, the body of my api call is:
{
“logical”:“e0505ba7-b10a-4c87-80d4-75d9e28901c4”,
“modeling”:“5b823309-84dd-4323-897e-afb379f8b74f”
}

the applications.properties file contains the following:
collibra.domain.ids={
“logical”:“e0505ba7-b10a-4c87-80d4-75d9e28901c4”,
“modeling”:“5b823309-84dd-4323-897e-afb379f8b74f”
}
and the api returns this:
{
“message”: “Internal error during execution.”,
“exceptionMessage”: “{“id”:“f10ef680-efb5-4388-ba4b-1e41c746d25f”,“createdBy”:“c06bb54c-f62e-4221-aa5d-f95624acd8fc”,“createdOn”:1673974583894,“lastModifiedBy”:“c06bb54c-f62e-4221-aa5d-f95624acd8fc”,“lastModifiedOn”:1673974584236,“system”:false,“resourceType”:“Job”,“name”:“Import”,“type”:“IMPORT”,“userId”:“c06bb54c-f62e-4221-aa5d-f95624acd8fc”,“visibility”:0,“progressPercentage”:100,“cancelable”:true,“startDate”:1673974583973,“endDate”:1673974584224,“state”:“ERROR”,“message”:”{\“conflicts\”:{\“Line 83 contains the following errors:\”:[\“More than one complex relation matches the specified criteria.\”]},\“type\”:\“CONFLICT\”,\“message\”:\“The input processing did not complete successfully.\”}",“result”:“FAILURE”}"
}

368 Messages

2 years ago

Hi @christopher.lynch.exlservice.com,

We think that the reason is that you have some already imported relations in your instance which are conflicting. Please ensure everything is cleared from your Collibra instance and try rerunning the integration.
Thanks

Loading...