Cognos Collibra integration failed to connect to Cognos server with JSONException

Hello Jacky,

Thanks for trying the Cognos to Collibra integration.

The issue could be that the Cognos authentication response is not as expected.

To address this, can you please confirm that the active directory/user management DB is configured and that the ‘authentication’ option is activated from the Congos instance settings (by default it is not enabled)?

Additionally, can you please advise whether an on-premise or Cloud Cognos instance is being used?

Hello Jacky,

Thanks for the update.

Regarding the error encountered, can you please from the com.collibra.marketplace.cognos.component.CognosAuthentication class, line 50, replace:

@Scheduled(fixedRateString = "...

with:

@Scheduled(fixedDelayString = "...

Additionally, can you please also ensure that the following property (from the application.properties file) is set to the timeout of the Cognos instance? (For more information regarding the Cognos instance session timeout, you can refer to this page).

source.http.session.timeout=

Then, check whether the issue has been resolved please?

In case it still fails, can you please provide the error/stack trace for this issue? Thank you

Hi,
Here is the latest error after the code change and properties change.

2022-03-29 11:04:12 [main] INFO com.collibra.marketplace.cognos.Application - Starting Application v1.0.0 using Java 1.8.0_322 on ohcircolledge1d.ameritas.com with PID 1055293 (/home/aalxzaa/cognos-integration-1.0.0.jar started by aalxzaa in /home/aalxzaa)
2022-03-29 11:04:12 [main] DEBUG com.collibra.marketplace.cognos.Application - Running with Spring Boot v2.5.8, Spring v5.3.14
2022-03-29 11:04:12 [main] INFO com.collibra.marketplace.cognos.Application - No active profile set, falling back to default profiles: default
2022-03-29 11:04:15 [main] INFO com.collibra.marketplace.library.integration.InternalSharedLibraryConnection - Authenticating with the Collibra Platform…
2022-03-29 11:04:17 [main] INFO com.collibra.marketplace.library.integration.InternalSharedLibraryConnection - Successfully authenticated with the Collibra Platform.
2022-03-29 11:04:19 [scheduling-1] INFO com.collibra.marketplace.cognos.component.CognosAuthentication - Starting Session Extraction with authentication parameters
2022-03-29 11:04:19 [main] INFO com.collibra.marketplace.cognos.Application - Started Application in 6.958 seconds (JVM running for 8.014)
2022-03-29 11:04:19 [scheduling-1] INFO com.collibra.marketplace.cognos.component.CognosAuthentication - Forbidden
2022-03-29 11:04:19 [scheduling-1] ERROR com.collibra.marketplace.cognos.component.CognosAuthentication - Unable to Authenticate IBM Cognos Credentials: Attempted read from closed stream.
2022-03-29 11:04:19 [scheduling-1] DEBUG com.collibra.marketplace.cognos.component.CognosAuthentication - Completed Session Extraction with authentication parameters

Just to to update this post that development was done against a Congos instance having version 11.2, while the issue was replicated when using Cognos v11.1. This occurred due to the API changes between these versions (i.e. the endpoints, session and authentication methods).