Set Value and Postgres

10 views
Skip to first unread message

Joseph Kabariti

unread,
Feb 11, 2021, 7:03:16 PMFeb 11
to i2b2 Install Help
Hi all,

Has anybody experienced an issue wherein dragging a leaf with a set value configured doesn't load the set value at all? 

We are testing this out with Postgres as we know that the value works with SQL Server, but we have yet to get it working with Postgres. All other functionality works fine.

The error logs point to a Postgres exception "Bad value for type long" which makes me think it's processing the c_metadata_xml column as a long instead of a text or xml type. Several stackoverflow articles point to the fact that it may have something to do with the fact that it's trying to process a LOB column as a long, but I'm not sure how to get it to avoid doing that.

If anybody is using Postgres and has set value working, I'd love to hear how you've set things up.

Joseph
Reply all
Reply to author
Forward
0 new messages