search

santedb / santempi

SanteDB MPI Project
Apache License 2.0
3 stars 5 forks source link

Error when running TEST: OHIE-CR-02-FHIR #13

Open jainpranav1 opened 6 months ago

jainpranav1 commented 6 months ago

The failure occurs on Test Step 3: Create TEST_HARNESS

image

Here is the test case log:

image

Here is the response message:

<RestServiceFault xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://santedb.org/fault">
   <data>ERROR</data>
   <data>ERROR</data>
   <data>23505</data>
   <data>duplicate key value violates unique constraint "sec_app_app_pub_id_idx"</data>
   <data>Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.</data>
   <data>public</data>
   <data>sec_app_tbl</data>
   <data>sec_app_app_pub_id_idx</data>
   <data>nbtinsert.c</data>
   <data>666</data>
   <data>_bt_check_unique</data>
   <type>PostgresException</type>
   <message>23505: duplicate key value violates unique constraint "sec_app_app_pub_id_idx"

DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.</message>
   <policyOutcome>Deny</policyOutcome>
</RestServiceFault>

I see that there is an issue regarding a duplicate key value. How can I fix this?

I followed the quick start guide: https://help.santesuite.org/installation/quick-start-guide.

I used this docker compose file: https://github.com/santedb/hello-mpi/blob/master/docker-compose.yml.

Please let me know.

justin-fyfe commented 6 months ago

This is expected if you have re-run the installation qualification on a non-empty database, since the SOAP-UI tests don't check for the existence of that credential prior to attempting to create it.

jainpranav1 commented 5 months ago

Thank you for the reply. I will check if this is the case.

jainpranav1 commented 5 months ago

I used datagrip to open the postgresql database to see if any data was on it. All I see is an empty schema named "public". The MPI dashboard also returns no patients. So it seems as if the database is empty. However, the SOAP UI test still doesn't work.

image image
jainpranav1 commented 5 months ago

I decided also to delete all my containers, images, and volumes to start from scratch. I followed this tutorial here: https://www.youtube.com/watch?v=klQxQx_kgMw. However, even after doing these steps, the same error occurs.

jainpranav1 commented 5 months ago

One other point to make is more than just this test case fails. All test cases, but the first one, fail. I just decided to focus on the second test case in this issue for simplicity.

image
jainpranav1 commented 5 months ago

I decided to look up the unique constraint "sec_app_app_pub_id_idx" on Google and found that it is in the ADO Security Tables.

image image