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-pub-web Unit Tests failed Jun 3, 2024 in 1s

orcid-pub-web Unit Tests ❌

Tests failed

Report Passed Failed Skipped Time
TEST-org.orcid.api.identifiers.IdentifierApiServiceDelegatorTest.xml 2✅ 25s
TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.xml 46✅ 33❌ 8s
TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceVersionedDelegatorTest.xml 125✅ 3s
TEST-org.orcid.api.publicV2.server.security.PublicAPISecurityManagerV2Test.xml 19✅ 3ms
TEST-org.orcid.api.publicV3.server.PublicV3ApiServiceDelegatorTest.xml 48✅ 68❌ 3s
TEST-org.orcid.api.publicV3.server.security.PublicAPISecurityManagerV3Test.xml 24✅ 27ms

✅ TEST-org.orcid.api.identifiers.IdentifierApiServiceDelegatorTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.identifiers.IdentifierApiServiceDelegatorTest 2✅ 25s

✅ org.orcid.api.identifiers.IdentifierApiServiceDelegatorTest

✅ testviewIdentifierTypes
✅ testviewIdentifierTypesWithLocale

❌ TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.xml

79 tests were completed in 8s with 46 passed, 33 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest 46✅ 33❌ 8s

❌ org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest

✅ testViewExternalIdentifier
✅ testViewAddresses
✅ testViewExternalIdentifiers
✅ testGetPrivateBiographyUsingToken
❌ testGetPrivateEducationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testViewAddress
✅ testViewBulkWorks
✅ testViewResearcherUrls
✅ testViewKeyword
✅ testGetPublicAddressUsingToken
❌ testGetPublicEducationsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPrivateAddressUsingToken
❌ testViewFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedEmploymentUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetLimitedWorkUsingToken
✅ testViewWorks
✅ testGetLimitedResearcherUrlUsingToken
❌ testGetPublicEmploymentUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQuery
✅ testGetPublicResearcherUrlUsingToken
✅ testFindPerson
❌ testSchemaOrgMBWriterV2
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testFindRecord
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewOtherName
❌ testGetPublicFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateEmploymentUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetPublicOtherNameUsingToken
✅ testGetPublicWorksUsingToken
✅ testViewResearcherUrl
❌ testGetPublicPeerReviewsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPublicExternalIdentifierUsingToken
❌ testGetPublicFundingUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetLimitedAddressUsingToken
✅ testGetPrivateResearcherUrlUsingToken
❌ testViewPeerReviews
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateFundingUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testSearchByQueryIllegalStart
✅ testGetPublicKeywordUsingToken
✅ testGetLimitedOtherNameUsingToken
✅ testGetPrivateKeywordUsingToken
✅ testFindPersonalDetails
✅ testViewClientNonExistent
✅ testGetLimitedExternalIdentifierUsingToken
❌ testGetPublicPeerReviews
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPublicWorkUsingToken
✅ testGetPublicBiographyUsingToken
✅ testValidatePersonUsingToken
❌ testFindActivityDetails
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEducationUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEmploymentsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPrivateOtherNameUsingToken
❌ testViewEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testValidateActivitiesUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testValidateRecordUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedPeerReviewUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testSearchByQueryLegalStart
✅ testViewClient
✅ testViewKeywords
❌ testViewEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedFundingUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testViewEmails
✅ testGetPublicWorks
✅ testViewOtherNames
❌ testGetPublicPeerReviewUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetLimitedKeywordUsingToken
✅ testGetLimitedBiographyUsingToken
❌ testViewEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivatePeerReviewUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetLimitedEducationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testViewWork
❌ testGetPublicEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPrivateWorkUsingToken
❌ testGetPublicFundingsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQueryTooManyRows
✅ testGetPrivateExternalIdentifierUsingToken
❌ testViewFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

✅ TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceVersionedDelegatorTest.xml

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

Test suite Passed Failed Skipped Time
org.orcid.api.publicV2.server.PublicV2ApiServiceVersionedDelegatorTest 125✅ 3s

✅ org.orcid.api.publicV2.server.PublicV2ApiServiceVersionedDelegatorTest

✅ testDeactivatedRecordViewEducations
✅ test03ViewOtherNames
✅ test01ViewAddresses
✅ testDeactivatedRecordViewEmails
✅ test02ViewEducationSummary
✅ test00ViewAddress
✅ testDeactivatedRecordViewAddresses
✅ test00ViewEmployment
✅ testDeactivatedRecordViewKeywords
✅ test0103ViewActivities
✅ test03ViewExternalIdentifiers
✅ test01ViewAddress
✅ testDeactivatedRecordViewOtherNames
✅ test00ViewPerson
✅ test02ViewExternalIdentifiers
✅ test00ViewRecord
✅ testDeactivatedRecordViewResearcherUrls
✅ test03ViewEducationSummary
✅ testViewBulkWorks
✅ test01ViewExternalIdentifiers
✅ test02ViewAddress
✅ test01ViewExternalIdentifier
✅ testDeactivatedRecordViewPerson
✅ test03ViewEmployment
✅ test00ViewExternalIdentifiers
✅ testDeactivatedRecordViewRecord
✅ test00ViewKeyword
✅ test03ViewAddress
✅ test03ViewOtherName
✅ test01ViewEmploymentSummary
✅ test02ViewResearcherUrl
✅ test00ViewAddresses
✅ test01ViewKeyword
✅ test03ViewPersonalDetails
✅ test02ViewEmails
✅ test02ViewKeyword
✅ test02ViewResearcherUrls
✅ test03ViewEmploymentSummary
✅ test00ViewFunding
✅ test02ViewPeerReview
✅ testDeactivatedRecordViewWorks
✅ test03ViewKeyword
✅ test01ViewFunding
✅ test02ViewPerson
✅ test02ViewPersonalDetails
✅ test02ViewRecord
✅ test02ViewFunding
✅ test02ViewOtherName
✅ testDeactivatedRecordViewFundings
✅ test03ViewFundingSummary
✅ test03ViewFunding
✅ testDeactivatedRecordViewPersonalDetails
✅ test01ViewOtherNames
✅ testSearchByQuery
✅ test01ViewPersonalDetails
✅ test01ViewWork
✅ test01ViewOtherName
✅ test01ViewResearcherUrl
✅ test01ViewResearcherUrls
✅ test02ViewExternalIdentifier
✅ test03ViewKeywords
✅ test01ViewEmployment
✅ test01ViewPeerReviewSummary
✅ test00ViewPersonalDetails
✅ test02ViewKeywords
✅ test03ViewPeerReviewSummary
✅ test02ViewFundingSummary
✅ test00ViewOtherName
✅ test00ViewActivities
✅ test00ViewPeerReview
✅ testDeactivatedRecordViewPeerReviews
✅ test03ViewWork
✅ test03ViewEducation
✅ test01ViewKeywords
✅ test03ViewWorkSummary
✅ test03ViewPeerReview
✅ test00ViewResearcherUrls
✅ test01ViewEmails
✅ testViewClientNonExistent
✅ testDeactivatedRecordViewActivities
✅ test03ViewBiography
✅ test00ViewResearcherUrl
✅ testViewBulkWorksNonExistentUser
✅ test00ViewKeywords
✅ test00ViewEmploymentSummary
✅ test02ViewEducation
✅ test01ViewPerson
✅ test02ViewEmploymentSummary
✅ test02ViewWorkSummary
✅ test01ViewRecord
✅ test02ViewOtherNames
✅ test01ViewFundingSummary
✅ test03ViewExternalIdentifier
✅ test0102ViewActivities
✅ test02ViewBiography
✅ test03ViewEmails
✅ test01ViewEducation
✅ test02ViewEmployment
✅ test00ViewWork
✅ test01ViewWorkSummary
✅ test03ViewAddresses
✅ testViewClient
✅ testDeactivatedRecordViewEmployments
✅ testViewBiographyWhereBiographyIsNull
✅ test00ViewExternalIdentifier
✅ test03ViewPerson
✅ test03ViewRecord
✅ test01ViewBiography
✅ test01ViewActivities
✅ test01ViewPeerReview
✅ test00ViewFundingSummary
✅ test00ViewEducation
✅ test00ViewPeerReviewSummary
✅ test00ViewWorkSummary
✅ test03ViewResearcherUrl
✅ test02ViewAddresses
✅ test02ViewWork
✅ test00ViewEducationSummary
✅ test02ViewPeerReviewSummary
✅ testDeactivatedRecordViewExternalIdentifiers
✅ test00ViewBiography
✅ test00ViewOtherNames
✅ test03ViewResearcherUrls
✅ test01ViewEducationSummary
✅ test00ViewEmails

✅ TEST-org.orcid.api.publicV2.server.security.PublicAPISecurityManagerV2Test.xml

19 tests were completed in 3ms with 19 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.api.publicV2.server.security.PublicAPISecurityManagerV2Test 19✅ 3ms

✅ org.orcid.api.publicV2.server.security.PublicAPISecurityManagerV2Test

✅ checkIsPublicBiographyTest
✅ checkIsPublicFilterableTest
✅ filterPeerReviewsTest
✅ filterFundingsTest
✅ filterEmploymentsTest
✅ filterWorksTest
✅ filterExternalIdentifiersTest
✅ checkIsPublicNameTest
✅ filterAddressesTest
✅ checkIsPublicPersonTest
✅ checkIsPublicRecordTest
✅ checkIsPublicVisibilityTypeTest
✅ filterEmailsTest
✅ checkIsPublicPersonalDetailsTest
✅ checkIsPublicActivitiesSummaryTest
✅ filterKeywordsTest
✅ filterResearcherUrlsTest
✅ filterOtherNamesTest
✅ filterEducationsTest

❌ TEST-org.orcid.api.publicV3.server.PublicV3ApiServiceDelegatorTest.xml

116 tests were completed in 3s with 48 passed, 68 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.api.publicV3.server.PublicV3ApiServiceDelegatorTest 48✅ 68❌ 3s

❌ org.orcid.api.publicV3.server.PublicV3ApiServiceDelegatorTest

✅ testViewExternalIdentifier
✅ testViewAddresses
❌ testGetPublicMembershipUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewExternalIdentifiers
✅ testGetPrivateBiographyUsingToken
❌ testGetPublicDistinctionUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicMemberships
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateMembershipUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPrivateEducationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testViewDistinction
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedDistinctionUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testViewAddress
✅ testViewBulkWorks
❌ testViewDistinctions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewResearcherUrls
❌ testViewQualification
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewKeyword
✅ testGetPublicAddressUsingToken
✅ testExpandedSearchByQueryNoRowsParamSet
❌ testGetPublicInvitedPositionsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEducationsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPrivateAddressUsingToken
❌ testViewFunding
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedEmploymentUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetLimitedWorkUsingToken
❌ testGetPublicServiceUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicQualifications
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewWorks
✅ testGetLimitedResearcherUrlUsingToken
❌ testGetPrivateServiceUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPublicEmploymentUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQuery
✅ testGetPublicResearcherUrlUsingToken
✅ testFindPerson
❌ testSchemaOrgMBWriterV3
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewPeerReview
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testFindRecord
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewOtherName
❌ testGetPublicServices
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateEmploymentUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetPublicOtherNameUsingToken
✅ testGetPublicWorksUsingToken
✅ testViewResearcherUrl
❌ testGetPublicServicesUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicPeerReviewsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedInvitedPositionUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPublicMembershipsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPublicExternalIdentifierUsingToken
❌ testGetPublicFundingUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetLimitedAddressUsingToken
✅ testGetPrivateResearcherUrlUsingToken
❌ testViewPeerReviews
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicQualificationsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateFundingUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testSearchByQueryIllegalStart
✅ testGetPublicKeywordUsingToken
❌ testViewMembership
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetLimitedOtherNameUsingToken
✅ testGetPrivateKeywordUsingToken
❌ testGetPublicInvitedPositionUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testFindPersonalDetails
✅ testViewClientNonExistent
❌ testGetLimitedServiceUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPublicDistinctionsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedQualificationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetLimitedExternalIdentifierUsingToken
❌ testGetPublicPeerReviews
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPublicWorkUsingToken
❌ testGetPublicQualificationUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicDistinctions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPublicBiographyUsingToken
✅ testValidatePersonUsingToken
❌ testFindActivityDetails
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateDistinctionUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testViewInvitedPositions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEducationUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewEducation
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicEmploymentsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetPrivateOtherNameUsingToken
❌ testViewEducations
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testValidateActivitiesUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewQualifications
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testValidateRecordUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedPeerReviewUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testSearchByQueryLegalStart
✅ testViewClient
✅ testViewKeywords
❌ testViewEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedFundingUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testViewEmails
✅ testGetPublicWorks
❌ testViewService
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewOtherNames
❌ testGetPrivateQualificationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPublicPeerReviewUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testGetLimitedKeywordUsingToken
✅ testGetLimitedBiographyUsingToken
❌ testViewEmployment
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPrivateInvitedPositionUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetPrivatePeerReviewUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testGetLimitedEducationUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
❌ testViewMemberships
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewInvitedPosition
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testViewWork
❌ testGetPublicEmployments
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetLimitedMembershipUsingToken
	java.lang.Exception: Unexpected exception, expected<org.orcid.core.exception.OrcidNonPublicElementException> but was<javax.persistence.PersistenceException>
✅ testGetPrivateWorkUsingToken
❌ testGetPublicInvitedPositions
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testGetPublicFundingsUsingToken
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testSearchByQueryTooManyRows
✅ testViewClientSummary
✅ testGetPrivateExternalIdentifierUsingToken
❌ testViewServices
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testViewFundings
	javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

✅ TEST-org.orcid.api.publicV3.server.security.PublicAPISecurityManagerV3Test.xml

24 tests were completed in 27ms with 24 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
org.orcid.api.publicV3.server.security.PublicAPISecurityManagerV3Test 24✅ 27ms

✅ org.orcid.api.publicV3.server.security.PublicAPISecurityManagerV3Test

✅ checkIsPublicBiographyTest
✅ checkIsPublicFilterableTest
✅ filterDistinctionsTest
✅ filterPeerReviewsTest
✅ filterMembershipsTest
✅ filterFundingsTest
✅ filterServicesTest
✅ filterEmploymentsTest
✅ filterWorksTest
✅ filterExternalIdentifiersTest
✅ checkIsPublicNameTest
✅ filterAddressesTest
✅ filterInvitedPositionsTest
✅ checkIsPublicPersonTest
✅ checkIsPublicRecordTest
✅ filterQualificationsTest
✅ checkIsPublicVisibilityTypeTest
✅ filterEmailsTest
✅ checkIsPublicPersonalDetailsTest
✅ checkIsPublicActivitiesSummaryTest
✅ filterKeywordsTest
✅ filterResearcherUrlsTest
✅ filterOtherNamesTest
✅ filterEducationsTest

Annotations

Check failure on line 754 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPrivateEducationUsingToken

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

Check failure on line 730 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPublicEducationsUsingToken

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEducationsUsingToken(PublicV2ApiServiceDelegatorTest.java:730)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEducationsUsingToken(PublicV2ApiServiceDelegatorTest.java:730)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEducationsUsingToken(PublicV2ApiServiceDelegatorTest.java:730)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEducationsUsingToken(PublicV2ApiServiceDelegatorTest.java:730)

Check failure on line 219 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testViewFunding

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewFunding(PublicV2ApiServiceDelegatorTest.java:219)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewFunding(PublicV2ApiServiceDelegatorTest.java:219)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewFunding(PublicV2ApiServiceDelegatorTest.java:219)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewFunding(PublicV2ApiServiceDelegatorTest.java:219)

Check failure on line 807 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetLimitedEmploymentUsingToken

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

Check failure on line 762 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPublicEmploymentUsingToken

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEmploymentUsingToken(PublicV2ApiServiceDelegatorTest.java:762)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEmploymentUsingToken(PublicV2ApiServiceDelegatorTest.java:762)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEmploymentUsingToken(PublicV2ApiServiceDelegatorTest.java:762)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicEmploymentUsingToken(PublicV2ApiServiceDelegatorTest.java:762)

Check failure on line 1497 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testSchemaOrgMBWriterV2

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testSchemaOrgMBWriterV2(PublicV2ApiServiceDelegatorTest.java:1497)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testSchemaOrgMBWriterV2(PublicV2ApiServiceDelegatorTest.java:1497)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testSchemaOrgMBWriterV2(PublicV2ApiServiceDelegatorTest.java:1497)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testSchemaOrgMBWriterV2(PublicV2ApiServiceDelegatorTest.java:1497)

Check failure on line 297 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testViewPeerReview

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewPeerReview(PublicV2ApiServiceDelegatorTest.java:297)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewPeerReview(PublicV2ApiServiceDelegatorTest.java:297)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewPeerReview(PublicV2ApiServiceDelegatorTest.java:297)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testViewPeerReview(PublicV2ApiServiceDelegatorTest.java:297)

Check failure on line 665 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testFindRecord

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testFindRecord(PublicV2ApiServiceDelegatorTest.java:665)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testFindRecord(PublicV2ApiServiceDelegatorTest.java:665)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testFindRecord(PublicV2ApiServiceDelegatorTest.java:665)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testFindRecord(PublicV2ApiServiceDelegatorTest.java:665)

Check failure on line 833 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPublicFundings

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicFundings(PublicV2ApiServiceDelegatorTest.java:833)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicFundings(PublicV2ApiServiceDelegatorTest.java:833)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicFundings(PublicV2ApiServiceDelegatorTest.java:833)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicFundings(PublicV2ApiServiceDelegatorTest.java:833)

Check failure on line 814 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPrivateEmploymentUsingToken

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

Check failure on line 985 in orcid-pub-web/src/test/java/org/orcid/api/publicV2/server/PublicV2ApiServiceDelegatorTest.java

See this annotation in the file changed.

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

org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest ► testGetPublicPeerReviewsUsingToken

Failed test found in:
  TEST-org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.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.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicPeerReviewsUsingToken(PublicV2ApiServiceDelegatorTest.java:985)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicPeerReviewsUsingToken(PublicV2ApiServiceDelegatorTest.java:985)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicPeerReviewsUsingToken(PublicV2ApiServiceDelegatorTest.java:985)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
	at org.orcid.api.publicV2.server.PublicV2ApiServiceDelegatorTest.testGetPublicPeerReviewsUsingToken(PublicV2ApiServiceDelegatorTest.java:985)