Skip to content
commit

Merge branch 'main' into 8874-capture-event-data-within-the-registry #225

Sign in to view logs

Merge branch 'main' into 8874-capture-event-data-within-the-registry

Merge branch 'main' into 8874-capture-event-data-within-the-registry #225

GitHub Actions / orcid-scheduler-web Unit Tests failed Oct 25, 2023 in 1s

orcid-scheduler-web Unit Tests ❌

Tests failed

Report Passed Failed Skipped Time
TEST-org.orcid.scheduler.email.cli.manager.EmailMessageSenderTest.xml 1❌ 16s
TEST-org.orcid.scheduler.email.trickle.manager.impl.TrickleManagerImplTest.xml 10✅ 992ms
TEST-org.orcid.scheduler.loader.FundrefOrgLoadSourceTest.xml 6❌ 14s
TEST-org.orcid.scheduler.loader.io.FtpsFileDownloaderTest.xml 9✅ 482ms
TEST-org.orcid.scheduler.loader.io.OrgDataClientTest.xml 4❌ 7s
TEST-org.orcid.scheduler.loader.manager.OrgLoadManagerTest.xml 4✅ 71ms
TEST-org.orcid.scheduler.loader.RorOrgLoadSourceTest.xml 13❌ 24s
TEST-org.orcid.scheduler.tasks.impl.IdentityProviderManagerTest.xml 2❌ 3s

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

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

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

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

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

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

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

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

✅ 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 14s with 0 passed, 6 failed and 0 skipped.

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

❌ 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 482ms with 9 passed, 0 failed and 0 skipped.

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

✅ 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 7s with 0 passed, 4 failed and 0 skipped.

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

❌ 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 71ms with 4 passed, 0 failed and 0 skipped.

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

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

✅ testLoadOrgs
✅ testLoadOrgsDownloadOrgDataFailure
✅ testLoadOrgsNextSourceDisabled
✅ testLoadOrgsLoadOrgDataFailure

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

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

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

❌ 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 3s with 0 passed, 2 failed and 0 skipped.

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

❌ 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 ► 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.42.7/orcid-persistence-2.42.7.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_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day
Caused by: org.hsqldb.HsqlException: unexpected token: day

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.42.7/orcid-persistence-2.42.7.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_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day
Caused by: org.hsqldb.HsqlException: unexpected token: day

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.42.7/orcid-persistence-2.42.7.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_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day
Caused by: org.hsqldb.HsqlException: unexpected token: day

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.42.7/orcid-persistence-2.42.7.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_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day
Caused by: org.hsqldb.HsqlException: unexpected token: day

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.42.7/orcid-persistence-2.42.7.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_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.LiquibaseException: 
liquibase.exception.MigrationFailedException: Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.MigrationFailedException: 
Migration failed for change set db/updates/dw_event.xml::CREATE-DW-EVENT-VIEW-GROUP-BY-DAY-CLIENT_ID-AND-EVENT_TYPE::Daniel Palafox:
     Reason: liquibase.exception.DatabaseException: unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: liquibase.exception.DatabaseException: 
unexpected token: day [Failed SQL: (-5581) CREATE VIEW PUBLIC.dw_event AS SELECT event_type, client_id, COUNT(id), DATE_TRUNC('day', date_created)
            FROM event
            WHERE event_type != 'Public-Page'
            GROUP BY event_type, client_id, DATE_TRUNC('day', date_created)
            ORDER BY DATE_TRUNC('day', date_created) DESC;]
Caused by: java.sql.SQLSyntaxErrorException: unexpected token: day
Caused by: org.hsqldb.HsqlException: unexpected token: day
View more details on GitHub Actions