Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle database migration from rel_6_6 or earlier: Error POSTing resource with text fields over 4,000 characters #5633

Closed
lukedegruchy opened this issue Jan 25, 2024 · 0 comments

Comments

@lukedegruchy
Copy link
Collaborator

Describe the bug
After migrating oracle installs from 6.6, POSTING resources with text fields of more than 4,000 characters will fail.

To Reproduce
Steps to reproduce the behavior:

  1. On a pre-6.6 install, create a Patient and some Observations linked to that Patient with valueStrings of over 4,000 characters.
  2. Migrate to the latest pre-release for 7.0.
  3. Try to POST an identical Observation as above
  4. See error: ORA-01461: can bind a LONG value only for insert into a LONG column

Expected behavior
The update should occur and the data should be present in HFJ_RES_VER under one of the RES_TEXT columns

Environment (please complete the following information):

  • HAPI FHIR Version: Master and 7.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant