I suggest you open a support call with IBM Cognos. Superficially, the null pointer exception is occurring within the PostgreSQL JDBC driver.
Assuming you have entered a valid URL and connection properties that PostgreSQL JDBC expects, then the same error may be shown outside CA.
But without more context, not more can be said re probable root cause.
------------------------------
NIGEL CAMPBELL
------------------------------
Original Message:
Sent: Wed May 18, 2022 03:44 AM
From: David GOMEZ PRIETO
Subject: Cognos connection with Postgresql
Good morning Patrick,
Yes, I have filled in the necessary information, I have put the host, the port and the name of the database, but I get an error.
I have tried several things but I always get the same error.
Best regards,
------------------------------
David GOMEZ PRIETO
Original Message:
Sent: Tue May 17, 2022 09:18 AM
From: Patrick Neveu
Subject: Cognos connection with Postgresql
Hi David,
Did you setup a username and password?
What is your connection string? It should look like:
jdbc:postgresql://<host>:<port>/<database-name>
If authentication is required you will need to fill in that information and then test the datasource connection to confirm it successfully connects.
Best regards,
------------------------------
Patrick Neveu
Positive Thinking Company
Original Message:
Sent: Tue May 17, 2022 04:54 AM
From: David GOMEZ PRIETO
Subject: Cognos connection with Postgresql
I have this error
------------------------------
David GOMEZ PRIETO
Original Message:
Sent: Tue May 17, 2022 03:49 AM
From: David GOMEZ PRIETO
Subject: Cognos connection with Postgresql
Good morning,
I would like to know how I can connect to a data server. In my case I first want to test with Postgresql. I have put the data from my server but I have errors.
Thanks for your help.
------------------------------
David GOMEZ PRIETO
------------------------------
#CognosAnalyticswithWatson