SAP BusinessObjects Access to Collibra Integration - startup error | Integrations

SAP BusinessObjects Access to Collibra Integration - startup error

Hello @spring-team@collibra.com @spring-team.collibra.com

We are working on enabling SAP BusinessObjects Access to Collibra Integration as a stand-alone jar (fatjar). We downloaded and configured sap-bo-to-collibra-integration-1.1.0.jar, however we are getting a following error during startup.

D:\collibra_test\sap-bo-intergration>java -jar ./lib/sap-bo-to-collibra-integration-1.1.0.jar --spring.config.location=file:./conf/application.properties --logging.config=./conf/log4j2.xml

. ____ _ __ _ _
/\ / ’ __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ’ / ` | \ \ \
\/ )| |)| | | | | || (| | ) ) ) )
’ || .__|| ||| |_, | / / / /
=========||==============|/=////
:: Spring Boot :: (v2.5.10)

2022-03-30 10:36:25,997 [main] INFO com.collibra.marketplace.sap.businessobjects.Application - Starting Application v1.1.0 using Java 11.0.13 on HQDCEDCJOBDV01 with PID 3820 (D:\collibra_occ\sap-bo-intergration\lib\sap-bo-to-collibra-integration-1.1.0.jar started by x.Gusmanov.Oybek in D:\collibra_occ\sap-bo-intergration)
2022-03-30 10:36:25,997 [main] INFO com.collibra.marketplace.sap.businessobjects.Application - No active profile set, falling back to 1 default profile: “default”
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.configuration.EnableEncryptablePropertiesBeanFactoryPostProcessor - Post-processing PropertySource instances
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Skipping PropertySource configurationProperties [class org.springframework.boot.context.properties.source.ConfigurationPropertySourcesPropertySource
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Converting PropertySource commandLineArgs [org.springframework.core.env.SimpleCommandLinePropertySource] to EncryptableEnumerablePropertySourceWrapper
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Skipping PropertySource servletConfigInitParams [class org.springframework.core.env.PropertySource$StubPropertySource
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Skipping PropertySource servletContextInitParams [class org.springframework.core.env.PropertySource$StubPropertySource
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Converting PropertySource systemProperties [org.springframework.core.env.PropertiesPropertySource] to EncryptableMapPropertySourceWrapper
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Converting PropertySource systemEnvironment [org.springframework.boot.env.SystemEnvironmentPropertySourceEnvironmentPostProcessor$OriginAwareSystemEnvironmentPropertySource] to EncryptableSystemEnvironmentPropertySourceWrapper
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Converting PropertySource random [org.springframework.boot.env.RandomValuePropertySource] to EncryptablePropertySourceWrapper
2022-03-30 10:36:27,716 [main] INFO com.ulisesbocchio.jasyptspringboot.EncryptablePropertySourceConverter - Converting PropertySource Config resource ‘file [conf\application.properties]’ via location ‘file:./conf/application.properties’ [org.springframework.boot.env.OriginTrackedMapPropertySource] to EncryptableMapPropertySourceWrapper
2022-03-30 10:36:27,857 [main] INFO com.ulisesbocchio.jasyptspringboot.filter.DefaultLazyPropertyFilter - Property Filter custom Bean not found with name ‘encryptablePropertyFilter’. Initializing Default Property Filter
2022-03-30 10:36:27,872 [main] INFO com.ulisesbocchio.jasyptspringboot.resolver.DefaultLazyPropertyResolver - Property Resolver custom Bean not found with name ‘encryptablePropertyResolver’. Initializing Default Property Resolver
2022-03-30 10:36:27,872 [main] INFO com.ulisesbocchio.jasyptspringboot.detector.DefaultLazyPropertyDetector - Property Detector custom Bean not found with name ‘encryptablePropertyDetector’. Initializing Default Property Detector
2022-03-30 10:36:28,138 [main] INFO org.springframework.boot.web.embedded.tomcat.TomcatWebServer - Tomcat initialized with port(s): 8080 (http)
2022-03-30 10:36:28,153 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler [“http-nio-8080”]
2022-03-30 10:36:28,153 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
2022-03-30 10:36:28,153 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.58]
2022-03-30 10:36:28,216 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
2022-03-30 10:36:28,216 [main] INFO org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2156 ms
2022-03-30 10:36:28,622 [main] INFO com.collibra.marketplace.library.integration.InternalSharedLibraryConnection - Authenticating with the Collibra Platform…
2022-03-30 10:36:31,169 [main] WARN org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘technicalLineageProcessor’ defined in URL [jar:file:/D:/collibra_occ/sap-bo-intergration/lib/sap-bo-to-collibra-integration-1.1.0.jar!/BOOT-INF/classes!/com/collibra/marketplace/sap/businessobjects/component/TechnicalLineageProcessor.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘collibraImportApiHelper’ defined in URL [jar:file:/D:/collibra_occ/sap-bo-intergration/lib/sap-bo-to-collibra-integration-1.1.0.jar!/BOOT-INF/lib/collibra-integration-library-1.1.4.jar!/com/collibra/marketplace/library/integration/CollibraImportApiHelper.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘internalSharedLibraryConnection’: Invocation of init method failed; nested exception is com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“An unexpected error occurred during execution.”,“details”:“java.net.ConnectException: Connection refused: connect”,“cause”:“Connection refused: connect”}
2022-03-30 10:36:31,169 [main] INFO org.apache.catalina.core.StandardService - Stopping service [Tomcat]
2022-03-30 10:36:31,185 [main] INFO org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener -

Error starting ApplicationContext. To display the conditions report re-run your application with ‘debug’ enabled.
2022-03-30 10:36:31,200 [main] ERROR org.springframework.boot.SpringApplication - Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘technicalLineageProcessor’ defined in URL [jar:file:/D:/collibra_occ/sap-bo-intergration/lib/sap-bo-to-collibra-integration-1.1.0.jar!/BOOT-INF/classes!/com/collibra/marketplace/sap/businessobjects/component/TechnicalLineageProcessor.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘collibraImportApiHelper’ defined in URL [jar:file:/D:/collibra_occ/sap-bo-intergration/lib/sap-bo-to-collibra-integration-1.1.0.jar!/BOOT-INF/lib/collibra-integration-library-1.1.4.jar!/com/collibra/marketplace/library/integration/CollibraImportApiHelper.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘internalSharedLibraryConnection’: Invocation of init method failed; nested exception is com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“An unexpected error occurred during execution.”,“details”:“java.net.ConnectException: Connection refused: connect”,“cause”:“Connection refused: connect”}
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.16.jar!/:5.3.16]

Any suggestions on what can be causing this error?

Thank you,
Peter Vilim

Peter Vilim

Posted 4 years ago · Edited 1 year ago·Last reply 4 years ago

4 comments

springboot_team

·4 years ago · Edited

Hello Peter,

Thanks for confirming.

Can you please advise whether your Collibra instance is an on-premise or cloud version and its Product Version (can be retrieved from the Settings > General > System page of your instance)?

Additionally, can you please check whether the following cURL request works?

curl --location --request POST 'https://<subdomain>.collibra.com/rest/2.0/auth/sessions' \
--header 'accept: application/json' \
--header 'Content-Type: application/json' \
--data-raw '{
    "username": "<username>",
    "password": "<password>"
}'

where:

<subdomain> should be replaced with your Collibra instance sub-domain
<username> should be replaced with your Collibra instance username
<password> should be replaced with your Collibra instance password

This request should return a csrfToken as part of the response body and the status code should be 200 - OK.

It might be helpful to also check if there could be any firewalls/proxy servers that might be blocking the connection.

springboot_team

·4 years ago · Edited

Hello @peter.vilim ,

Thanks for trying the SAP BO to Collibra integration.

Regarding the connection refused error, can you please confirm that the following properties are defined in the application.properties file?

collibra.url=https://<sub-domain>.collibra.com
collibra.username=
collibra.password=

where:

collibra.url should be the Collibra instance url without any base paths
collibra.username should be the basic authentication username used to authenticate with the Collibra instance
collibra.password should be the basic authentication password used to authenticate with the Collibra instance

Please refer to the documentation, “Encrypt Configuration Properties” section on how you can encrypt these values.

springboot_team

·4 years ago · Edited

Hello @peter.vilim ,

Thanks for trying the SAP BO to Collibra integration.

Regarding the connection refused error, can you please confirm that the following properties are defined in the application.properties file?

collibra.url=https://<sub-domain>.collibra.com
collibra.username=
collibra.password=

where:

collibra.url should be the Collibra instance url without any base paths
collibra.username should be the basic authentication username used to authenticate with the Collibra instance
collibra.password should be the basic authentication password used to authenticate with the Collibra instance

Please refer to the documentation, “Encrypt Configuration Properties” section on how you can encrypt these values.

Peter Vilim

OP4 years ago · Edited

Yes, confirmed. All 3 properties are defined.

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard