SSD - [DB Connection] Data source not initialized for: postgres_0

[Savkar]

Hi Team,

I have been trying to get records from pgAdmin database, but I am getting the following error while hitting swagger url.

I have checked using mysql db also but getting same error for DB connection.

Regards,
Savkar

[Eldho]

@Shamnad_KS @ragesh-a @Muhseena_T can you please help?

[Simphiwe]

Hi @Savkar

Thank you for reaching out.
Are you using public schema by default ?
If No, Did you add the correct schema on the schema field.

Please check if you getting any error on your server logs.

[Savkar]

Hi @Simphiwe, I’m using my own schema & added to the schema field.

And not getting any error in server logs.

[Sam]

Hello @Savkar ,You could try the following approach to resolve the issue:
1.Uninstall and reinstall PostgreSQL to ensure a clean setup.
2. Use the Data Model section in Neutrinos Studio to configure the database connection properly.
3. Perform operations like find and insert using the Data Model operations instead of direct queries.

Let me know if this works.

Thanks

[Savkar]

Hi @Sam, I followed the approach that you have suggested, but still getting same error
Data source not initialized for::postgres_1

[Shamnad_KS]

Hi Savkar,

Could you please make sure that your database credentials are correct? Also, try connecting via CLI using the same credentials to verify the connection.

[Savkar]

Connecting via CLI and able to retrieve using same credentials.

[Shamnad_KS]

Thanks for confirming that the credentials work via CLI.

Would it be possible for us to connect over Teams to troubleshoot this further together?

[Savkar]

Hi @Shamnad_KS, I have created new project in Neutrinos studio and did same configuration for Postgres DB connection, it’s worked for me now as expected.

Thanks…