Upgrading SanteDB iCDR with large databases

Issue: After installing an upgrade for a SanteDB iCDR server, the service starts never finishes, and it is logged that a database update has failed.

Applies To:

SanteDB iCDR (Version 2.1.x)

Symptoms:

Upon starting the Windows Service or Linux daemon you notice that the startup takes a long time
When attempting to access the server via an API or dCDR you receive a 503 error
In the SanteDB log file there are log entries noting:

SanteDB.OrmLite.Migration.SqlFeatureUtil@ [2022-01-18T09:16:05.4466863-05:00]: Could not install 20220112-01 - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt at Npgsql.NpgsqlConnector.<g__ReadMessageLong|194_0>d.MoveNext()Cause: This rejection is caused because the ssnAuthority has not been configured for the dCDR or iCDR.

Solutions:

Note the update file name in the log (example: 20220112-01) and locate the equivalent SQL file in $installdir$/data/sql/updates/20220112-PSQL.sql (note: Firebird database have -FBSQL as their suffix)
Open a connection to the database using a client tool (like PGAdmin, DBeaver, etc.)
Run the update file manually
Kill the SanteDB host process
Restart the SanteDB iCDR host process

PreviousSanteDB 2.1.161+ on PostgreSQL 10 returns "websearch_to_tsquery" error NextUpgrading Gateway to SanteDB Langley (v2.0.30+) from SanteDB Kelowna and earlier

Last updated 3 years ago

Was this helpful?

Upgrading SanteDB iCDR with large databases

Issue: After installing an upgrade for a SanteDB iCDR server, the service starts never finishes, and it is logged that a database update has failed.

Applies To:

SanteDB iCDR (Version 2.1.x)

Symptoms:

Upon starting the Windows Service or Linux daemon you notice that the startup takes a long time
When attempting to access the server via an API or dCDR you receive a 503 error
In the SanteDB log file there are log entries noting:

SanteDB.OrmLite.Migration.SqlFeatureUtil@ [2022-01-18T09:16:05.4466863-05:00]: Could not install 20220112-01 - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt at Npgsql.NpgsqlConnector.<g__ReadMessageLong|194_0>d.MoveNext()Cause: This rejection is caused because the ssnAuthority has not been configured for the dCDR or iCDR.

Solutions:

Note the update file name in the log (example: 20220112-01) and locate the equivalent SQL file in $installdir$/data/sql/updates/20220112-PSQL.sql (note: Firebird database have -FBSQL as their suffix)
Open a connection to the database using a client tool (like PGAdmin, DBeaver, etc.)
Run the update file manually
Kill the SanteDB host process
Restart the SanteDB iCDR host process

PreviousSanteDB 2.1.161+ on PostgreSQL 10 returns "websearch_to_tsquery" error NextUpgrading Gateway to SanteDB Langley (v2.0.30+) from SanteDB Kelowna and earlier

Last updated 3 years ago

Was this helpful?