Skip to content

added the dbms to fix failing tests #485

added the dbms to fix failing tests

added the dbms to fix failing tests #485

GitHub Actions / orcid-api-web Unit Tests failed Jun 3, 2024 in 1s

orcid-api-web Unit Tests ❌

Tests failed

Report Passed Failed Skipped Time
TEST-org.orcid.api.member.server.validator.JSONInputValidatorTest.xml 16✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml 1✅ 9❌ 28s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_AddressesTest.xml 18✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_BiogrphyTest.xml 3✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.xml 1✅ 19❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmailsTest.xml 5✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmploymentsTest.xml 1✅ 19❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ExternalIdentifiersTest.xml 18✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_FundingTest.xml 1✅ 18❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GeneralTest.xml 8✅ 3❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GroupIdTest.xml 12✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_KeywordsTest.xml 18✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_OtherNamesTest.xml 18✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PeerReviewsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PersonalDetailsTest.xml 4✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadPersonTest.xml 5✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadRecordTest.xml 6❌ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ResearcherUrlsTest.xml 18✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_WorksTest.xml 27✅ 2s
TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceVersionedDelegatorTest.xml 271✅ 2❌ 3s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ActivitiesSummaryTest.xml 1✅ 9❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_AddressesTest.xml 19✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_BiogrphyTest.xml 3✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_DistinctionsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EducationsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmailsTest.xml 5✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmploymentsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ExternalIdentifiersTest.xml 18✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_FundingTest.xml 1✅ 18❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GeneralTest.xml 10✅ 3❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GroupIdTest.xml 12✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_InvitedPositionsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_KeywordsTest.xml 18✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_MembershipsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_OtherNamesTest.xml 18✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_PeerReviewsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_PersonalDetailsTest.xml 4✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_QualificationsTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ReadPersonTest.xml 5✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ReadRecordTest.xml 6❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ResearcherUrlsTest.xml 18✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ServicesTest.xml 1✅ 21❌ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_WorksTest.xml 27✅ 2s
TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegatorErrorsTest.xml 294✅ 1❌ 3s
TEST-org.orcid.api.t2.server.delegator.NotificationsApiServiceDelegatorTest.xml 2✅ 72ms
TEST-org.orcid.api.util.ApiUtilsTest.xml 2✅ 9ms

✅ TEST-org.orcid.api.member.server.validator.JSONInputValidatorTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.member.server.validator.JSONInputValidatorTest 16✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml

10 tests were completed in 28s with 1 passed, 9 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest 1✅ 9❌ 28s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest

❌ testViewActitivies_PeerReviewReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_FundingReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testCleanEmptyFieldsOnActivities
❌ testViewActitivies_WorksReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_AffiliationsReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_NoReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActivitiesReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_Activities
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActivitiesWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_AddressesTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_AddressesTest 18✅ 2s

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_BiogrphyTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_BiogrphyTest 3✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest 1✅ 19❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest

❌ testViewPublicEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testUpdateEducationYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewLimitedEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewEducationThatDontBelongToTheUser
❌ testReadPublicScope_Educations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEducationWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testViewEducationsReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEducation
	java.lang.Exception: Unexpected exception, expected<javax.persistence.NoResultException> but was<javax.persistence.PersistenceException>
❌ testAddEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEducationYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testUpdateEducationLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationsWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEducationChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testViewEducationWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmailsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmailsTest 5✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmploymentsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmploymentsTest 1✅ 19❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EmploymentsTest

❌ testViewLimitedEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEmploymentYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
✅ testViewEmploymentThatDontBelongToTheUser
❌ testUpdateEmploymentYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentsReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEmploymentChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentsWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEmploymentWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testReadPublicScope_Employments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEmployment
	java.lang.Exception: Unexpected exception, expected<javax.persistence.NoResultException> but was<javax.persistence.PersistenceException>
❌ testUpdateEmploymentLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ExternalIdentifiersTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ExternalIdentifiersTest 18✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_FundingTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_FundingTest 1✅ 18❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_FundingTest

❌ testViewPrivateFundingWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testUpdateFundingLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddFundingWithInvalidExtIdTypeFail
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewFundingReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewFundingSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_Funding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewFundingThatDontBelongToTheUser
❌ testUpdateFundingYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewFundingWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewFundingSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testUpdateFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPublicFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateFundingChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testAddFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteFunding
	java.lang.Exception: Unexpected exception, expected<javax.persistence.NoResultException> but was<javax.persistence.PersistenceException>
❌ testViewLimitedFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteFundingYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GeneralTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GeneralTest 8✅ 3❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GeneralTest

❌ testOrcidProfileCreate_CANT_UpdateOnClaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testOrcidProfileCreate_CANT_ViewOnClaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testOrcidProfileCreate_CAN_CRUDOnUnclaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQuery
✅ testOrcidProfileCreate_CANT_AddOnClaimedAccounts
✅ testOrcidProfileCreate_CANT_DeleteOnClaimedAccounts
✅ testViewClientNonExistent
✅ testOrcidProfileCreateCanViewAndCreateGroupIds
✅ testViewClient
✅ testSearchByQueryBadScope
✅ testSearchByQueryTooManyRows

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GroupIdTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_GroupIdTest 12✅ 2s

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_KeywordsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_KeywordsTest 18✅ 2s

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_OtherNamesTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_OtherNamesTest 18✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PeerReviewsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PeerReviewsTest 1✅ 21❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PeerReviewsTest

❌ testViewPrivatePeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdatePeerReviewLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddPeerReviewDuplicateFails
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testViewPeerReviewSummary
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReviewReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewPeerReviewThatDontBelongToTheUser
❌ testAddPeerReviewWithInvalidExtIdTypeFail
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReviewSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeletePeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReviewWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testAddPeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdatePeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewLimitedPeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReviews
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReviewSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testAddPeerReviewWithSameExtIdValueButDifferentExtIdType
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPublicPeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeletePeerReviewYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testUpdatePeerReviewWhenYouAreNotTheSourceOf
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_PeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivatePeerReviewWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testUpdatePeerReviewChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PersonalDetailsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_PersonalDetailsTest 4✅ 2s

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadPersonTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadPersonTest 5✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadRecordTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadRecordTest 6❌ 2s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ReadRecordTest

❌ testReadPrivateEmails_OtherThingsJustPublic_Record
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewRecordReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewRecord
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewRecordWrongScope
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewRecordWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testReadPublicScope_Record
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ResearcherUrlsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ResearcherUrlsTest 18✅ 2s

✅ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_WorksTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_WorksTest 27✅ 2s

❌ TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceVersionedDelegatorTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceVersionedDelegatorTest 271✅ 2❌ 3s

❌ org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceVersionedDelegatorTest

✅ test02CreateWork
✅ testDeactivatedRecordViewEducations
✅ test03UpdateResearcherUrl
✅ test03ViewOtherNames
✅ test01ViewAddresses
✅ testDeactivatedRecordViewEmails
✅ test02ViewEducationSummary
✅ test00ViewAddress
✅ test01UpdateWork
✅ testDeactivatedRecordCreateEducation
✅ testDeactivatedRecordViewAddresses
✅ test00ViewEmployment
✅ testDeactivatedRecordViewKeywords
✅ test02DeleteResearcherUrl
✅ test0103ViewActivities
✅ test03CreateKeyword
✅ test03ViewExternalIdentifiers
✅ test00UpdateOtherName
✅ test01ViewAddress
✅ testDeactivatedRecordViewOtherNames
✅ test00ViewPerson
✅ testDeactivatedRecordDeleteAffiliation
✅ test02ViewExternalIdentifiers
✅ test00ViewRecord
✅ testDeactivatedRecordViewResearcherUrls
✅ test03ViewEducationSummary
✅ testViewBulkWorks
✅ test03CreateOtherName
✅ test01ViewExternalIdentifiers
✅ test02CreateAddress
✅ test03UpdateEducation
✅ test02ViewAddress
✅ test01ViewExternalIdentifier
✅ test02DeleteWork
✅ testDeactivatedRecordViewPerson
✅ test03ViewEmployment
✅ test00ViewExternalIdentifiers
✅ test03UpdateAddress
✅ testDeactivatedRecordDeleteResearcherUrl
✅ test02UpdateResearcherUrl
✅ testDeactivatedRecordViewRecord
✅ test00ViewKeyword
✅ testViewBulkWorksWithTooManyPutCodes
✅ test03CreateFunding
✅ test03ViewAddress
✅ test03ViewOtherName
✅ test01ViewEmploymentSummary
✅ test02ViewResearcherUrl
✅ test00ViewAddresses
✅ test03UpdateEmployment
✅ test01ViewKeyword
✅ test03ViewPersonalDetails
✅ test01DeleteResearcherUrl
✅ test02ViewEmails
❌ test2_0
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ test2_1
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testDeactivatedRecordUpdateResearcherUrl
✅ test02CreateKeyword
✅ test02DeleteAffiliation
✅ test02ViewKeyword
✅ test02ViewResearcherUrls
✅ testDeactivatedRecordDeleteOtherName
✅ test01CreateExternalIdentifier
✅ test03ViewEmploymentSummary
✅ test03UpdateKeyword
✅ test00ViewFunding
✅ test02ViewPeerReview
✅ test00UpdateEmployment
✅ testDeactivatedRecordViewWorks
✅ test03UpdateWork
✅ test03ViewKeyword
✅ test01UpdateResearcherUrl
✅ test02CreateOtherName
✅ testDeactivatedRecordDeletePeerReview
✅ test02DeletePeerReview
✅ test01CreateAddress
✅ test02UpdateEducation
✅ test03CreateExternalIdentifier
✅ test01ViewFunding
✅ test02UpdateAddress
✅ test02ViewPerson
✅ test01CreateEmployment
✅ testDeactivatedRecordCreateAddress
✅ test02ViewPersonalDetails
✅ test00DeleteResearcherUrl
✅ test02CreateFunding
✅ test02ViewRecord
✅ test02ViewFunding
✅ test02ViewOtherName
✅ testDeactivatedRecordUpdateExternalIdentifier
✅ testDeactivatedRecordViewFundings
✅ test03UpdateFunding
✅ testDeactivatedRecordUpdatePeerReview
✅ test02UpdatePeerReview
✅ test01DeleteExternalIdentifier
✅ test03ViewFundingSummary
✅ test03ViewFunding
✅ test00UpdateExternalIdentifier
✅ testDeactivatedRecordUpdateOtherName
✅ test01CreateKeyword
✅ testViewBulkWorksWithBadPutCode
✅ testDeactivatedRecordViewPersonalDetails
✅ test02UpdateKeyword
✅ test00UpdateResearcherUrl
✅ test03CreatePeerReview
✅ test03DeleteExternalIdentifier
✅ test02UpdateExternalIdentifier
✅ testDeactivatedRecordCreateKeyword
✅ test01ViewOtherNames
✅ testSearchByQuery
✅ test01CreateOtherName
✅ test00CreateAddress
✅ test01UpdateEducation
✅ test01ViewPersonalDetails
✅ test01UpdateAddress
✅ test01ViewWork
✅ test00CreatePeerReview
✅ test01CreateFunding
✅ test01ViewOtherName
✅ test01ViewResearcherUrl
✅ testDeactivatedRecordUpdateAddress
✅ test02UpdateFunding
✅ test01ViewResearcherUrls
✅ testDeactivatedRecordCreateFunding
✅ test02ViewExternalIdentifier
✅ test03ViewKeywords
✅ test01ViewEmployment
✅ test01DeleteAffiliation
✅ test03CreateResearcherUrl
✅ test03DeleteAddress
✅ test00CreateKeyword
✅ test01ViewPeerReviewSummary
✅ test01UpdateKeyword
✅ test01CreateWork
✅ test00ViewPersonalDetails
✅ testDeactivatedRecordUpdateKeyword
✅ test00CreateOtherName
✅ test00UpdateEducation
✅ test00UpdateWork
✅ test00UpdateAddress
✅ test02ViewKeywords
✅ test03ViewPeerReviewSummary
✅ test02ViewFundingSummary
✅ test03CreateEducation
✅ test00CreateFunding
✅ test00ViewOtherName
✅ test03DeleteKeyword
✅ test00ViewActivities
✅ testDeactivatedRecordUpdateWork
✅ test01UpdateFunding
✅ test00ViewPeerReview
✅ testDeactivatedRecordViewPeerReviews
✅ test02CreateResearcherUrl
✅ test03ViewWork
✅ test01UpdateEmployment
✅ test03ViewEducation
✅ testDeactivatedRecordUpdateFunding
✅ test01DeleteWork
✅ test02DeleteAddress
✅ test03DeletePeerReview
✅ test01ViewKeywords
✅ test00UpdateKeyword
✅ test03ViewWorkSummary
✅ test03ViewPeerReview
✅ testDeactivatedRecordCreateEmployment
✅ test02CreateEmployment
✅ test03DeleteFunding
✅ testDeactivatedRecordCreateResearcherUrl
✅ test00ViewResearcherUrls
✅ test01ViewEmails
✅ test00DeletePeerReview
✅ test03UpdatePeerReview
✅ testViewClientNonExistent
✅ test03CreateWork
✅ testDeactivatedRecordViewActivities
✅ test02CreateEducation
✅ test03ViewBiography
✅ test01CreateResearcherUrl
✅ test00ViewResearcherUrl
✅ test02DeleteKeyword
✅ test00ViewKeywords
✅ test00ViewEmploymentSummary
✅ test00UpdateFunding
✅ test03DeleteOtherName
✅ test02UpdateWork
✅ test02ViewEducation
✅ testDeactivatedRecordCreateExternalIdentifier
✅ test00UpdatePeerReview
✅ test00DeleteAffiliation
✅ test01DeleteAddress
✅ test01ViewPerson
✅ test02ViewEmploymentSummary
✅ test02ViewWorkSummary
✅ testDeactivatedRecordCreateOtherName
✅ test01ViewRecord
✅ test00CreateExternalIdentifier
✅ testDeactivatedRecordUpdateEducation
✅ test02ViewOtherNames
✅ testDeactivatedRecordDeleteAddress
✅ test01ViewFundingSummary
✅ test02DeleteFunding
✅ test01CreatePeerReview
✅ test03ViewExternalIdentifier
✅ test03DeleteWork
✅ test00CreateResearcherUrl
✅ test02CreateExternalIdentifier
✅ test0102ViewActivities
✅ test03UpdateOtherName
✅ test01CreateEducation
✅ test02ViewBiography
✅ test01DeleteKeyword
✅ testDeactivatedRecordDeleteExternalIdentifier
✅ test02DeleteOtherName
✅ test03ViewEmails
✅ testDeactivatedRecordDeleteKeyword
✅ test01ViewEducation
✅ test02ViewEmployment
✅ test00DeleteExternalIdentifier
✅ test00DeleteAddress
✅ test00ViewWork
✅ test01ViewWorkSummary
✅ test03ViewAddresses
✅ testViewClient
✅ test02DeleteExternalIdentifier
✅ test01DeleteFunding
✅ testDeactivatedRecordViewEmployments
✅ testViewBulkWrongToken
✅ test01UpdateExternalIdentifier
✅ test00ViewExternalIdentifier
✅ test03ViewPerson
✅ testDeactivatedRecordDeleteFunding
✅ testDeactivatedRecordUpdateEmployment
✅ test02UpdateEmployment
✅ test03ViewRecord
✅ test03UpdateExternalIdentifier
✅ test02UpdateOtherName
✅ test00CreateEducation
✅ test01ViewBiography
✅ test00DeleteKeyword
✅ test01ViewActivities
✅ test01ViewPeerReview
✅ test00CreateWork
✅ test01DeleteOtherName
✅ test03CreateEmployment
✅ test00ViewFundingSummary
✅ test00ViewEducation
✅ testDeactivatedRecordCreateWork
✅ test00ViewPeerReviewSummary
✅ test00ViewWorkSummary
✅ test01DeletePeerReview
✅ test03ViewResearcherUrl
✅ test02ViewAddresses
✅ test00DeleteFunding
✅ test00CreateEmployment
✅ test02ViewWork
✅ test00DeleteWork
✅ test00ViewEducationSummary
✅ test03DeleteAffiliation
✅ test02ViewPeerReviewSummary
✅ testDeactivatedRecordViewExternalIdentifiers
✅ test01UpdateOtherName
✅ test00ViewBiography
✅ test01UpdatePeerReview
✅ test03DeleteResearcherUrl
✅ test00ViewOtherNames
✅ testDeactivatedRecordDeleteWork
✅ test00DeleteOtherName
✅ test03CreateAddress
✅ test03ViewResearcherUrls
✅ test01ViewEducationSummary
✅ testDeactivatedRecordCreatePeerReview
✅ test02CreatePeerReview
✅ test00ViewEmails

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ActivitiesSummaryTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ActivitiesSummaryTest 1✅ 9❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ActivitiesSummaryTest

❌ testViewActitivies_PeerReviewReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_FundingReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testCleanEmptyFieldsOnActivities
❌ testViewActitivies_WorksReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_AffiliationsReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActitivies_NoReadLimited_NoSource
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActivitiesReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_Activities
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewActivitiesWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>

✅ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_AddressesTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_AddressesTest 19✅ 2s

✅ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_BiogrphyTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_BiogrphyTest 3✅ 2s

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_DistinctionsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_DistinctionsTest 1✅ 21❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_DistinctionsTest

❌ testViewDistinctionSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddDistinctionsDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testUpdateDistinctionChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testViewDistinctions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewDistinctionsWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testUpdateDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewDistinctionSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testDeleteDistinctionYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testUpdateDistinctionLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_Distinctions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewLimitedDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateDistinctionWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testUpdateDistinctionDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testUpdateDistinctionYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testDeleteDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPublicDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewDistinctionThatDontBelongToTheUser
❌ testViewDistinctionReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewDistinctionsReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewDistinctionWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EducationsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EducationsTest 1✅ 21❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EducationsTest

❌ testViewPublicEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testUpdateEducationDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testUpdateEducationYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewLimitedEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewEducationThatDontBelongToTheUser
❌ testAddEducationsDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testReadPublicScope_Educations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEducationWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testViewEducationsReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEducationYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testUpdateEducationLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationsWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducationSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEducationChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testViewEducationWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>

✅ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmailsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmailsTest 5✅ 2s

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmploymentsTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmploymentsTest 1✅ 21❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_EmploymentsTest

❌ testViewLimitedEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEmploymentYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
✅ testViewEmploymentThatDontBelongToTheUser
❌ testAddEmploymentsDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testUpdateEmploymentDuplicateExternalIDs
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidDuplicatedActivityException> but was<javax.persistence.PersistenceException>
❌ testUpdateEmploymentYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentsReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEmploymentChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentsWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmploymentReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateEmploymentWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testReadPublicScope_Employments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEmploymentWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEmploymentLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

✅ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ExternalIdentifiersTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_ExternalIdentifiersTest 18✅ 2s

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_FundingTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_FundingTest 1✅ 18❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_FundingTest

❌ testViewPrivateFundingWhereYouAreNotTheSource
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidVisibilityException> but was<javax.persistence.PersistenceException>
❌ testUpdateFundingLeavingVisibilityNullTest
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPrivateFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testAddFundingWithInvalidExtIdTypeFail
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewFundingReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewFundingSummaryReadPublic
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testReadPublicScope_Funding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewFundingThatDontBelongToTheUser
❌ testUpdateFundingYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewFundingWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testViewFundingSummaryWrongToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
❌ testUpdateFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPublicFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testUpdateFundingChangingVisibilityTest
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.VisibilityMismatchException> but was<javax.persistence.PersistenceException>
❌ testAddFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteFunding
	java.lang.Exception: Unexpected exception, expected<javax.persistence.NoResultException> but was<javax.persistence.PersistenceException>
❌ testViewLimitedFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testDeleteFundingYouAreNotTheSourceOf
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.WrongSourceException> but was<javax.persistence.PersistenceException>
❌ testViewFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

❌ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GeneralTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GeneralTest 10✅ 3❌ 2s

❌ org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GeneralTest

✅ testExpandedSearchByQueryRowsParamTooGreat
✅ testExpandedSearchByQueryNoRowsParamSet
❌ testOrcidProfileCreate_CANT_UpdateOnClaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testOrcidProfileCreate_CANT_ViewOnClaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testOrcidProfileCreate_CAN_CRUDOnUnclaimedAccounts
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQuery
✅ testOrcidProfileCreate_CANT_AddOnClaimedAccounts
✅ testOrcidProfileCreate_CANT_DeleteOnClaimedAccounts
✅ testViewClientNonExistent
✅ testOrcidProfileCreateCanViewAndCreateGroupIds
✅ testViewClient
✅ testSearchByQueryBadScope
✅ testSearchByQueryTooManyRows

✅ TEST-org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GroupIdTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.memberV3.server.delegator.MemberV3ApiServiceDelegator_GroupIdTest 12✅ 2s
Report exceeded GitHub limit of 65535 bytes and has been trimmed

Annotations

Check failure on line 535 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies_PeerReviewReadLimited_NoSource

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_PeerReviewReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:535)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_PeerReviewReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:535)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_PeerReviewReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:535)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_PeerReviewReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:535)

Check failure on line 474 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies_FundingReadLimited_NoSource

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_FundingReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:474)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_FundingReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:474)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_FundingReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:474)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_FundingReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:474)

Check failure on line 596 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies_WorksReadLimited_NoSource

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_WorksReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:596)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_WorksReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:596)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_WorksReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:596)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_WorksReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:596)

Check failure on line 110 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:110)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:110)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:110)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:110)

Check failure on line 395 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies_AffiliationsReadLimited_NoSource

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_AffiliationsReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:395)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_AffiliationsReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:395)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_AffiliationsReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:395)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_AffiliationsReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:395)

Check failure on line 658 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActitivies_NoReadLimited_NoSource

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_NoReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:658)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_NoReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:658)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_NoReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:658)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActitivies_NoReadLimited_NoSource(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:658)

Check failure on line 85 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActivitiesReadPublic

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesReadPublic(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:85)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesReadPublic(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:85)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesReadPublic(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:85)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesReadPublic(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:85)

Check failure on line 102 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testReadPublicScope_Activities

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testReadPublicScope_Activities(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:102)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testReadPublicScope_Activities(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:102)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testReadPublicScope_Activities(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:102)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testReadPublicScope_Activities(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:102)

Check failure on line 95 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest ► testViewActivitiesWrongToken

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.xml
Error:
  java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
Raw output
java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesWrongToken(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:95)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesWrongToken(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:95)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesWrongToken(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:95)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_ActivitiesSummaryTest.testViewActivitiesWrongToken(MemberV2ApiServiceDelegator_ActivitiesSummaryTest.java:95)

Check failure on line 163 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_EducationsTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest ► testViewPublicEducation

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.xml
Error:
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewPublicEducation(MemberV2ApiServiceDelegator_EducationsTest.java:163)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewPublicEducation(MemberV2ApiServiceDelegator_EducationsTest.java:163)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewPublicEducation(MemberV2ApiServiceDelegator_EducationsTest.java:163)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewPublicEducation(MemberV2ApiServiceDelegator_EducationsTest.java:163)

Check failure on line 137 in orcid-api-web/src/test/java/org/orcid/api/memberV2/server/delegator/MemberV2ApiServiceDelegator_EducationsTest.java

See this annotation in the file changed.

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

org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest ► testViewEducationSummaryWrongToken

Failed test found in:
  TEST-org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.xml
Error:
  java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
Raw output
java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidUnauthorizedException> but was<javax.persistence.PersistenceException>
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewEducationSummaryWrongToken(MemberV2ApiServiceDelegator_EducationsTest.java:137)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewEducationSummaryWrongToken(MemberV2ApiServiceDelegator_EducationsTest.java:137)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewEducationSummaryWrongToken(MemberV2ApiServiceDelegator_EducationsTest.java:137)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.memberV2.server.delegator.MemberV2ApiServiceDelegator_EducationsTest.testViewEducationSummaryWrongToken(MemberV2ApiServiceDelegator_EducationsTest.java:137)