sap-businessobjects-to-collibra-integration
Hello ,
i need to connect SAP BO to Collibra . the sample code provided on marketplace is a bit confusing also its look like some part of code is missing() . if any one have latest version of sample code or the exact steps for integration that would be helpful.
When i tried to launch app without fixing error.it showed me below error:
com.collibra.marketplace.sap.businessobjects.Application - No active profile set, falling back to default profiles: default
2021-11-10 17:28:25,759 [main] ERROR org.springframework.boot.SpringApplication - Application run failed
java.lang.NoSuchMethodError: org.springframework.web.context.support.ServletContextAwareProcessor: method ‘void ()’ not found
If anyone have any solution or point of contact for this type of integration. please Guide us
Thanks In advance
Ravi G
·4 years ago · EditedHi ,
I have side question on the version SAP BO BI supported by this integration solution , will this integration supports any version of SAP BO?
We are interested to know if this can support 4,2 and 4.3.
Regards
Nagarajan
springboot_team
·4 years ago · EditedHello Saumya,
Thanks for reviewing the SAP BO integration.
Just to let you know that we are analysing the options available to incorporate the Data Foundation layer information. However, currently, we do not have an ETA of when it would be available.
pratikmori
OP4 years ago · Editedit was permission issue, which was resolved. thanks
springboot_team
·4 years ago · EditedHello Pratik,
Regarding the error that is being returned by the Collibra Platform API (i.e. “You are not allowed to perform this action on ‘SAP BO’”, it seems that it could be a permission issue and not an error related to the Integration Library.
Can you please confirm that the instance account being used by the SAP BO integration has the necessary permissions?
saumyasrivastava
·4 years ago · EditedHi Team, this particular integration ingestions only the business layer. Could you please let us know if this will be further expanded to add the data foundation layer from SAP BO?
pratikmori
OP4 years ago · EditedHi @spring-team.collibra.com,
After changing the spring boot library version to 1.1.3 in POM.XML ,
i am getting below error in CollibraImportApiHelper Class.
Caused by: com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“The Collibra Platform job did not complete successfully.”,“failingObjects”:[],“collibraPlatformApiError”:"{“id”:“65056a81-fc7e-4b73-9910-145d0d76eca7”,“createdBy”:“1aedd1cf-7819-496c-b202-a2fc597c1a74”,“createdOn”:1641917697927,“lastModifiedBy”:“1aedd1cf-7819-496c-b202-a2fc597c1a74”,“lastModifiedOn”:1641917702030,“system”:false,“resourceType”:“Job”,“name”:“Import”,“type”:“IMPORT”,“userId”:“1aedd1cf-7819-496c-b202-a2fc597c1a74”,“visibility”:0,“progressPercentage”:100,“cancelable”:false,“startDate”:1641917698897,“endDate”:1641917702023,“state”:“ERROR”,“message”:"{\“type\”:\“MESSAGE\”,\“message\”:\“You are not allowed to perform this action on ‘SAP BO’.\”}"}"}
** at com.collibra.marketplace.library.integration.CollibraImportApiHelper.internalImportAssets(CollibraImportApiHelper.java:656) ~[collibra-integration-library-1.1.3.jar:1.1.3]**
** at com.collibra.marketplace.library.integration.CollibraImportApiHelper.internalImportAssetsInBatches(CollibraImportApiHelper.java:568) ~[collibra-integration-library-1.1.3.jar:1.1.3]**
** … 95 more**
Can u please guide here
Thanks,
Pratik
springboot_team
·4 years ago · EditedHello Pratik,
Just to let you know that v1.1.3 of the Collibra Integration Library addressing this issue has been released: https://marketplace.collibra.com/listings/spring-boot-integration-library/
springboot_team
·4 years ago · EditedHello Pratik,
Thanks for the update.
Since the latest version of the Collibra Platform is using a different versioning scheme than what is supported by the Spring Boot Integration Library, a new version would need to be released.
We are currently working on this and will keep you updated once the fix is available.
pratikmori
OP4 years ago · EditedHi @spring-team.collibra.com,
Is there any tentative date/timeline available for new version ?
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi @spring-team.collibra.com,
After Updating my Collibra instance version i am getting below error in SAP BO CONNETOR .Current Version of my DGC is Collibra 2022.01.0 and i tried to connet using sap bo connetor version Version 1.0.1 and version 1.0.0 but both of them are giving same error.
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘collibraImportApiHelper’ defined in URL [jar:file:/C:/Users/pratikkumar.b.mori/.m2/repository/com/collibra/marketplace/collibra-integration-library/1.0.2/collibra-integration-library-1.0.2.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 internal error occurred during execution.”,“details”:“The connected version of the Collibra Platform - v"2022.01.0-48” - is less than the minimum version required by this connector - v5.7.x - it is not supported."}
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:229) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1372) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1222) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.13.jar:5.3.13]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.13.jar:5.3.13]
Can you please Guide me. I am attaching full logs for your reference please have a look.SAP BO Connetor Error.txt (24.9 KB)
Thanks,
Pratik
springboot_team
·4 years ago · EditedHi Pratik,
We will be working on a new feature (technical lineage) and will include ingestion of sub-folders in that version. It is currently in our backlog. An ETA for the updates is not available as of today.
Thanks and regards
pratikmori
OP4 years ago · EditedHi Team,
Thanks for confirming , Do you have any documentation where we can see how CMA file is working.
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi @spring-team.collibra.com,
Are you planning to do the Enhancements to ingest the metadata for sub-Folders? If Yes then when ?
How we can change CMA File is there any documentation ?
Thanks,
Pratik
springboot_team
·4 years ago · EditedHi Pratik,
An updated version of the SAPBO integration has just been published on Marketplace: https://marketplace.collibra.com/listings/sap-businessobjects-to-collibra-integration/
This fixes the issue you faced with regards to null valued SAPBO fields.
And to answer your questions:
The SAPBO user needs to have enough rights to be able to use SAPBO’s REST API to extract universes and their items. It does not need permission to modify, create or delete universes and their items.
Currently the integration only ingests metadata from top-level folders.
springboot_team
·4 years ago · EditedHi Pratik,
This error is occurring because an SAPBO entity does not have the flag “hasLov” set to either true or false. This flag indicates whether or not this SAPBO entity has a list of values.
The SAPBO integration is taking the value provided by this flag and adding it as a “Categorical Data” attribute True/False value. But since this value is null, Collibra is failing to process it, thus leading to the failure of the whole Collibra import, thus leading to the failure of the sync.
A fix on the SAPBO integration is needed to avoid this scenario. With this fix, we’ll make sure not to add the “Categorical Data” attribute whenever SAPBO’s “hasLov” entity is null. Similar scenarios for other attributes are also possible, which we’d also need to fix.
We will publish this fix on Marketplace in the near future. We will also included other fixes (such as an upgrade of the log4j dependency due to CVE-2021-44228)
pratikmori
OP4 years ago · EditedHi @spring-team.collibra.com ,
Thanks for clarifying my doubt. I will remove the log4j dependency.
Can you please answer below questions :
We are currently using Power-User access to get the metadata. Can you please let us know what minimum access is required to fetch the metadata from SAP BO using this integration.
Why the integration is not ingesting the metadata for the subFolders which is inside the folders.
Ex. Universe -> Folder -> Subfolder-> Measures ,Dimensions
i can’t see the measurers and dimensions in Collibra which are inside subFolders.
Thanks,
Pratik
pratikmori
OP4 years ago · Edited@spring-team.collibra.com @bas.van.reeuwijk @james_scicluna.epam.com.
Please guide us
pratikmori
OP4 years ago · EditedHi Team,
Can you please guide us which kind of SAP BO access required to connect with SAP BO and fetch the metadata using the this integration.
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi @bas.van.reeuwijk @spring-team.collibra.com @james_scicluna.epam.com ,
Can you please help here, Below error is coming after the fetching Folders from SAP BO:
com.collibra.marketplace.library.integration.CollibraAsset@67a5cca3
2021-12-13 15:50:13,862 [http-nio-8081-exec-2] INFO com.collibra.marketplace.library.integration.CollibraImportApiHelper - Total number of asset batches to upsert: 1
2021-12-13 15:50:17,645 [http-nio-8081-exec-2] ERROR com.collibra.marketplace.sap.businessobjects.exception.GlobalExceptionHandler - Internal error during execution.
com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“There are one or more validation errors.”,“details”:“The attribute having ID/name ‘00000000-0000-0000-0001-000500000045’ of asset ‘AegGVp7JqrxDtJOKG8.oYBY>Signet Location>_iMFrgJ0-EeeyRZEB7IsL2A’ has an invalid value. Error: The attribute having value ‘null’ and values 'null is not valid. Either value or values must be defined.”}
** at** com.collibra.marketplace.library.integration.CollibraImportApiHelper.internalImportAssetsInBatches(CollibraImportApiHelper.java:575) ~[collibra-integration-library-1.0.2.jar:1.0.2]
at com.collibra.marketplace.library.integration.CollibraImportApiHelper.importAssets(CollibraImportApiHelper.java:111) ~[collibra-integration-library-1.0.2.jar:1.0.2]
at com.collibra.marketplace.sap.businessobjects.service.MainProcessor.start(MainProcessor.java:95) ~[classes/:?]
at com.collibra.marketplace.sap.businessobjects.controller.EntryPointController.syncTriggeredByApiRequest(EntryPointController.java:51) ~[classes/:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) ~[spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1064) [spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) [spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.3.9.jar:5.3.9]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.3.9.jar:5.3.9]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-embed-core-9.0.50.jar:4.0.FR]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.3.9.jar:5.3.9]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-embed-core-9.0.50.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:121) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:178) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) [spring-security-web-5.5.1.jar:5.5.1]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) [spring-web-5.3.9.jar:5.3.9]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) [spring-boot-actuator-2.5.3.jar:2.5.3]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.3.9.jar:5.3.9]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.3.9.jar:5.3.9]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) [tomcat-embed-core-9.0.50.jar:9.0.50]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.50.jar:9.0.50]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.50.jar:9.0.50]
at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“There are one or more validation errors.”,“details”:“The attribute having ID/name ‘00000000-0000-0000-0001-000500000045’ of asset ‘AegGVp7JqrxDtJOKG8.oYBY>Signet Location>_iMFrgJ0-EeeyRZEB7IsL2A’ has an invalid value. Error: The attribute having value ‘null’ and values 'null is not valid. Either value or values must be defined.”}
at com.collibra.marketplace.library.integration.CollibraImportApiHelper.internalImportAssets(CollibraImportApiHelper.java:687) ~[collibra-integration-library-1.0.2.jar:1.0.2]
at com.collibra.marketplace.library.integration.CollibraImportApiHelper.internalImportAssetsInBatches(CollibraImportApiHelper.java:564) ~[collibra-integration-library-1.0.2.jar:1.0.2]
… 95 more
Caused by: com.collibra.marketplace.library.integration.exception.CollibraIntegrationLibraryException: {“message”:“There are one or more validation errors.”,“details”:“The attribute having ID/name ‘00000000-0000-0000-0001-000500000045’ of asset ‘AegGVp7JqrxDtJOKG8.oYBY>Signet Location>_iMFrgJ0-EeeyRZEB7IsL2A’ has an invalid value. Error: The attribute having value ‘null’ and values 'null is not valid. Either value or values must be defined.”}
** at** com.collibra.marketplace.library.integration.InternalCollibraLibraryExceptionMapper.logAndRethrowException(InternalCollibraLibraryExceptionMapper.java:94) ~[collibra-integration-library-1.0.2.jar:1.0.2]
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi Team,
I got below error:
I have hidden the URL for privacy.
i tried two different path to connect with BO and fetch the token:
2)v1/logon/long
but it is throwing an error in both cases.
can you please tell us what is the issue here.
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi Bas,
I also tried using POSTMAN . Please refer below screenshot.
Am i doing anything wrong in postman ?
Thanks,
Pratik
springboot_team
·4 years ago · EditedThe triggering endpoint is http://localhost:8081/api/sync
pratikmori
OP4 years ago · EditedHi Bas,
Screenshot of Application.properties
I am passing the same credenticals.
But it is throwing below error.
do you have any idea what is the issue here.
Thanks
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
The integration expects a POST request, so you’ll need to use something like Postman https://www.postman.com/ to trigger the integration.
Regards,
Bas
pratikmori
OP4 years ago · EditedHi Bas,
As you guided us. i created keystore.jks file. See the below screenshot.
After that i configure the values in application.properties.(This is correct right or do i need to change anything)
Refer below screenshot.
Now i m try to running the application it asking me the username and password.
Refer below ss.
Which credentials i need to pass here ? (Collabra, SAP BO or any other)
Thanks,
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
Here you need to pass the credentials that you have set in the integration properties file for
trigger.api.usernameandtrigger.api.passwordRegards,
Bas
pratikmori
OP4 years ago · EditedHi Bas,
The application has started.
Please find below the application logs showing the start-up
2021-12-01 11:26:43,384 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler [“http-nio-8081”]
2021-12-01 11:26:43,410 [main] INFO org.springframework.boot.web.embedded.tomcat.TomcatWebServer - Tomcat started on port(s): 8081 (http) with context path ‘’
2021-12-01 11:26:43,575 [main] INFO com.collibra.marketplace.sap.businessobjects.Application - Started Application in 7.577 seconds (JVM running for 10.026)
However, We are unable to reach the below end point from Chrome browser. Can you please check .
https://localhost:8081/sync
Can you please share any screenshot for the above endpoint screen when hit from local machine ?
Also can you please let us know the significance of the below properties from application.properties file and how we can configure these in local?
server.ssl.enabled=
server.ssl.key-alias=
server.ssl.key-store=
server.ssl.key-store-password=
server.ssl.key-password=
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi Bas,
The application has started.
Please find below the application logs showing the start-up
2021-12-01 11:26:43,384 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler [“http-nio-8081”]
2021-12-01 11:26:43,410 [main] INFO org.springframework.boot.web.embedded.tomcat.TomcatWebServer - Tomcat started on port(s): 8081 (http) with context path ‘’
2021-12-01 11:26:43,575 [main] INFO com.collibra.marketplace.sap.businessobjects.Application - Started Application in 7.577 seconds (JVM running for 10.026)
However, We are unable to reach the below end point from Chrome browser. Can you please check .
https://localhost:8081/sync
Can you please share any screenshot for the above endpoint screen when hit from local machine ?
Also can you please let us know the significance of the below properties from application.properties file and how we can configure these in local?
server.ssl.enabled=
server.ssl.key-alias=
server.ssl.key-store=
server.ssl.key-store-password=
server.ssl.key-password=
Thanks,
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
I would recommend to not use SSL so set
server.ssl.enabled=falseThis would mean that you use
http://localhost:8081/syncTo setup SSL please check the documentation
Kind Regards,
Bas van Reeuwijk
pratikmori
OP4 years ago · EditedHi Bas van Reeuwijk,
What do I need to fill in instead of server host
I know about server-port, which is in application.properties
EX. In this case
https://server-host:8081/sync
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi Bas,
As you suggested i checked the DGC logs.In the logs i can see below error entries of userAuthenticationListner
"
** Line 11796: 2021-11-30 12:36:59.410 [ajp-nio-0.0.0.0-8080-exec-37] INFO c.c.d.c.s.a.UserAuthenticationListener - User failed to log in: AuthenticationEvent{userName=‘This is correct just removing beacuse of client data proetection’, sessionId=‘null’, realms=null, timeout=0, licenseType=CONSUMER, productPermissions=‘null’, action=LOGIN, remoteHost=‘null’, userAgent=‘null’, userAgentVersion=‘null’, failureReason=org.apache.shiro.authc.AuthenticationException: Authentication token of type [class org.apache.shiro.authc.UsernamePasswordToken] could not be authenticated by any configured realms., timestamp=1638275819410} [trace_id=95b9d883383180bf8636ffd163a0a1f6, trace_flags=01, span_id=608c82deae57b9df]**
"
Please have a look and guide us for further step.
Thanks
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
It looks like your account doesn’t have enough permissions inside Collibra as it states
Regards,
Bas
pratikmori
OP4 years ago · EditedHi Bas,
now my local is running fine. do you have any steps what to do next for ingestion of SAP business objects to collibra. I did not see any document in market place. We did not have a much idea about ingestion. Do you have any document handy .
Really appreciate your help.
Thanks,
Pratik
pratikmori
OP4 years ago · EditedHi Bas,
As you suggested i checked the DGC logs.In the logs i can see below error entries of userAuthenticationListner
"
** Line 11796: 2021-11-30 12:36:59.410 [ajp-nio-0.0.0.0-8080-exec-37] INFO c.c.d.c.s.a.UserAuthenticationListener - User failed to log in: AuthenticationEvent{userName=‘This is correct just removing beacuse of client data proetection’, sessionId=‘null’, realms=null, timeout=0, licenseType=CONSUMER, productPermissions=‘null’, action=LOGIN, remoteHost=‘null’, userAgent=‘null’, userAgentVersion=‘null’, failureReason=org.apache.shiro.authc.AuthenticationException: Authentication token of type [class org.apache.shiro.authc.UsernamePasswordToken] could not be authenticated by any configured realms., timestamp=1638275819410} [trace_id=95b9d883383180bf8636ffd163a0a1f6, trace_flags=01, span_id=608c82deae57b9df]**
"
Please have a look and guide us for further step.
Thanks
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
Please read the documentation under Triggering the integration
Kind Regards,
Bas van Reeuwijk
pratikmori
OP4 years ago · EditedHi Team,
There are no trailing “/” in the URL that we have provided in application.properties . I am able to login using the same username and password when i hit DGC via the browser. so the credentials are valid
and i can login .Not sure why the same credentials are not working with the connector .
can we set-up a quick call to discuss on this error.
Thanks,
Pratik
basvan_reeuwijk
·4 years ago · EditedHi Pratik,
My suggestion would be to have a look in the dgc.log and check for entries with “UserAuthenticationListener” this will provide you with more detail as to why the authentication fails.
Regards,
Bas
pratikmori
OP4 years ago · EditedHi James & Data Citizens,
Thanks for helping us.
All other configuration related issues were resolved , but we are getting below exception while running the application.
Please refer a above screenshot and please help us out.
springboot_team
·4 years ago · EditedHi Pratik,
The connector is failing to authenticate with Collibra on startup. The login request is hitting Collibra and is not technically failing (since the response code is 200), but the response obtained is not as expected (the expected response should contain a Collibra session ID in the Cookie header).
Most probably the reason for this is that the collibra.url property in the application.properties file is not set correctly. If the URL of the sign in page of your Collibra instance is as follows: https://acme.collibra.com/signin, then collibra.url must be set to exactly https://acme.collibra.com.
springboot_team
·4 years ago · EditedHi Pratik,
This error can only be due to an incorrect username and/or an incorrect password and/or an incorrect Collibra URL. Please make sure that there aren’t any trailing “/” in the URL or any trailing empty spaces in the username/password/URL.
pratikmori
OP4 years ago · EditedHi James & Data Citizens,
Thanks for helping us.
All other configuration related issues were resolved , but we are getting below exception while running the application.
Please refer a above screenshot and please help us out.
pratikmori
OP4 years ago · EditedHi Team,
Thanks For Guiding us.
i changed the url and now it is throwing 401 error code .The user name and password is correct.
Please see below error.
jamesscicluna1
·4 years ago · EditedHi Pratik and Priyabrata,
Are you running the integration from an IDE? If so, then probably you have some missing configurations or incorrect configurations in your IDE.
Can you try instead to run the integration from terminal by navigating to the sbi-sap-bo-1.0.0 folder (where the pom.xml file resides) and running this command:
mvn spring-boot:runAlternatively, you can first package the jar using:
mvn clean packageand then execute the jar (created in the target folder ) using:
java -jar sbi-sap-bo-1.0.0.jarFormer User
·4 years ago · EditedI am also looking for same Resolution …Please let me know if anyone can help on this…Regards