wso2 / financial-services-accelerator

WSO2 Open Banking Accelerator is a collection of technologies that increases the speed and reduces the complexity of adopting open banking compliance. Instead of building a solution from scratch, you can use WSO2 Open Banking Accelerator to meet all legislative requirements with additional benefits beyond compliance.
Apache License 2.0
7 stars 22 forks source link

[OB3] Cast exception for postgresql in event notification #68

Closed anjuchamantha closed 4 months ago

anjuchamantha commented 5 months ago

Description: There is a casting exception issue in event notification subscription flow while using PostgreSql. When request is stored in postgres database following error comes.

"request" is of type json but expression is of type character varying

Affected Product Version: OB3 Accelerator

OS, DB, other environment details and versions: DB - PostgreSQL

Steps to reproduce:

  1. Setup OB3 DBs with postgresSql
  2. Call https://{obiam-host}:{obiam-port}/api/openbanking/event-notifications/subscription/

Related Issues: [Any related issues such as sub tasks, issues reported in other repositories (e.g component repositories), similar problems, etc. ]