Skip to content

Added the 4 months interval for all dw views #394

Added the 4 months interval for all dw views

Added the 4 months interval for all dw views #394

GitHub Actions / orcid-scheduler-web Unit Tests failed Feb 21, 2024 in 1s

orcid-scheduler-web Unit Tests ❌

Tests failed

Report Passed Failed Skipped Time
TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml 2❌ 14s
TEST-org.orcid.scheduler.email.trickle.manager.impl.TrickleManagerImplTest.xml 10✅ 513ms
TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml 6❌ 9s
TEST-org.orcid.scheduler.loader.io.FtpsFileDownloaderTest.xml 9✅ 312ms
TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml 4❌ 4s
TEST-org.orcid.scheduler.loader.manager.OrgLoadManagerTest.xml 4✅ 32ms
TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml 13❌ 15s
TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml 2❌ 2s

❌ TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml

2 tests were completed in 14s with 0 passed, 2 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest 2❌ 14s

❌ org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest

❌ testAddWorksToRecordEmail
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testCreateDigest
	java.lang.IllegalStateException: Failed to load ApplicationContext

✅ TEST-org.orcid.scheduler.email.trickle.manager.impl.TrickleManagerImplTest.xml

10 tests were completed in 513ms with 10 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.email.trickle.manager.impl.TrickleManagerImplTest 10✅ 513ms

✅ org.orcid.scheduler.email.trickle.manager.impl.TrickleManagerImplTest

✅ testAttemptSendSkippedAccountDeprecated
✅ testAttemptSendMarketingSuccess
✅ testAttemptSendAlreadyProcessed
✅ testAttemptSendSkipped
✅ testAttemptMarketingSendFailure
✅ testAttemptSendSuccess
✅ testAttemptSendSkippedAccountDeactivated
✅ testAttemptSendEmailNoLongerExists
✅ testAttemptSendFailure
✅ testAttemptSendSkippedAccountLocked

❌ TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml

6 tests were completed in 9s with 0 passed, 6 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.loader.FundrefOrgLoadSourceTest 6❌ 9s

❌ org.orcid.scheduler.loader.FundrefOrgLoadSourceTest

❌ testDownloadOrgData
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testLoadLatestOrgsNoExistingOrgs
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testGetSourceName
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testLoadLatestOrgsDownloadFailed
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testSetDisabled
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testLoadLatestOrgsTwoExistingOrgs
	java.lang.IllegalStateException: Failed to load ApplicationContext

✅ TEST-org.orcid.scheduler.loader.io.FtpsFileDownloaderTest.xml

9 tests were completed in 312ms with 9 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.loader.io.FtpsFileDownloaderTest 9✅ 312ms

✅ org.orcid.scheduler.loader.io.FtpsFileDownloaderTest

✅ testDownloadFileNoPropsSet
✅ testDownloadFileNoUsername
✅ testDownloadFileNoLocalFilePath
✅ testDownloadFileNoPassword
✅ testDownloadFileSuccess
✅ testDownloadFileNoRemoteFilePath
✅ testDownloadFileErrorOccurs
✅ testDownloadFileNoHost
✅ testDownloadFileNoPort

❌ TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml

4 tests were completed in 4s with 0 passed, 4 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.loader.io.OrgDataClientTest 4❌ 4s

❌ org.orcid.scheduler.loader.io.OrgDataClientTest

❌ testGet
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testGetFailure
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testDownloadFileSuccess
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testDownloadFileFailure
	java.lang.IllegalStateException: Failed to load ApplicationContext

✅ TEST-org.orcid.scheduler.loader.manager.OrgLoadManagerTest.xml

4 tests were completed in 32ms with 4 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.loader.manager.OrgLoadManagerTest 4✅ 32ms

✅ org.orcid.scheduler.loader.manager.OrgLoadManagerTest

✅ testLoadOrgs
✅ testLoadOrgsDownloadOrgDataFailure
✅ testLoadOrgsNextSourceDisabled
✅ testLoadOrgsLoadOrgDataFailure

❌ TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml

13 tests were completed in 15s with 0 passed, 13 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.loader.RorOrgLoadSourceTest 13❌ 15s

❌ org.orcid.scheduler.loader.RorOrgLoadSourceTest

❌ execute_Stats_Test_1
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_Stats_Test_2
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_Stats_Test_3
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_UpdateExistingInstitute_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_NothingToCreateNothingToUpdate_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testDownloadOrgData
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_DeprecatedObsoleteInstitutes_1_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_DeprecatedObsoleteInstitutes_2_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_JustAddOneExeternalIdentifier_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testGetSourceName
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_UpdatePreferredIndicator_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ execute_AddMissingWikipediaExtId_Test
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testSetDisabled
	java.lang.IllegalStateException: Failed to load ApplicationContext

❌ TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml

2 tests were completed in 2s with 0 passed, 2 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest 2❌ 2s

❌ org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest

❌ testCreateEntityFromXmlWithLegacyNames
	java.lang.IllegalStateException: Failed to load ApplicationContext
❌ testCreateEntityFromXml
	java.lang.IllegalStateException: Failed to load ApplicationContext

Annotations

Check failure on line 0 in TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest ► testAddWorksToRecordEmail

Failed test found in:
  TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: unexpected token: day : line: 3 [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_client_details AS select client_details_id, client_name, client_description, client_website, group_orcid,
            client_type, user_obo_enabled, date_created, last_modified
            from client_details where last_modified > date_trunc('day',(now() - interval '4 months'))]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: unexpected token: day : line: 3 [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_client_details AS select client_details_id, client_name, client_description, client_website, group_orcid,
            client_type, user_obo_enabled, date_created, last_modified
            from client_details where last_modified > date_trunc('day',(now() - interval '4 months'))]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: unexpected token: day : line: 3 [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_client_details AS select client_details_id, client_name, client_description, client_website, group_orcid,
            client_type, user_obo_enabled, date_created, last_modified
            from client_details where last_modified > date_trunc('day',(now() - interval '4 months'))]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day : line: 3 [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_client_details AS select client_details_id, client_name, client_description, client_website, group_orcid,
            client_type, user_obo_enabled, date_created, last_modified
            from client_details where last_modified > date_trunc('day',(now() - interval '4 months'))]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day : line: 3
Caused by: org.hsqldb.HsqlException: unexpected token: day : line: 3

Check failure on line 0 in TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest ► testCreateDigest

Failed test found in:
  TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details]
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DW_CLIENT_DETAILS

Check failure on line 0 in TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.loader.FundrefOrgLoadSourceTest ► testDownloadOrgData

Failed test found in:
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details]
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DW_CLIENT_DETAILS

Check failure on line 0 in TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.loader.io.OrgDataClientTest ► testGet

Failed test found in:
  TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml
  TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml
  TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml
  TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details]
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DW_CLIENT_DETAILS

Check failure on line 0 in TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.loader.RorOrgLoadSourceTest ► execute_Stats_Test_1

Failed test found in:
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
  TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details]
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DW_CLIENT_DETAILS

Check failure on line 0 in TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml

See this annotation in the file changed.

@github-actions github-actions / orcid-scheduler-web Unit Tests

org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest ► testCreateEntityFromXmlWithLegacyNames

Failed test found in:
  TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml
  TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml
Error:
  java.lang.IllegalStateException: Failed to load ApplicationContext
Raw output
java.lang.IllegalStateException: Failed to load ApplicationContext
Caused by: org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'liquibase' defined in URL [jar:file:/home/runner/.m2/repository/org/orcid/orcid-persistence/2.51.2/orcid-persistence-2.51.2.jar!/orcid-persistence-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_views_with_4_months_interval.xml::ALTER-DW-CLIENT-DETAILS-VIEW-USER-OBO-FOUR-MONTHS::Camelia Dumitru:
     Reason: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: liquibase.exception.DatabaseException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details] [Failed SQL: (-5501) DROP VIEW PUBLIC.dw_client_details]
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DW_CLIENT_DETAILS in statement [DROP VIEW PUBLIC.dw_client_details]
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DW_CLIENT_DETAILS