Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-11863

Finalize day - receive 'The requested Operation failed' error when the system tries to generate impacting event

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2020R4
    • Fix Version/s: CFA 2021R1
    • Component/s: Events
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants
    • Source Code ID(s):
    • Sprint:
      CFAMX 2021R1 Sprint 1

      Description

      Finalize day - 'The requested Operation failed' error occurs when the system tries to generate an impacting event.
      CFA Testing, store 02693

      Error message extract:
      Cannot simultaneously fetch multiple bags: NHibernate.Loader.Criteria.CriteriaLoader(SELECT this_.EventProfileId as eventprofileid1_90_2_, this_.EntityId as entityid2_90_2_, this_.Name as name3_90_2_, this_.Source as source4_90_2_, this_.SalesItemsIntervals as salesitemsintervals5_90_2_, adjustment3_.EventProfileId as eventprofileid4_87_4_, adjustment3_.EventAdjustmentId as eventadjustmentid1_87_4_, adjustment3_.EventAdjustmentId as eventadjustmentid1_87_0_, adjustment3_.IntervalStart as intervalstart2_87_0_, adjustment3_.Adjustment as adjustment3_87_0_, adjustment3_.EventProfileId as eventprofileid4_87_0_, tags1_.EventProfileId as eventprofileid6_91_5_, tags1_.EventProfileTagId as eventprofiletagid1_91_5_, tags1_.EventProfileTagId as eventprofiletagid1_91_1_, tags1_.Date as date2_91_1_, tags1_.Note as note3_91_1_, tags1_.EntityId as entityid4_91_1_, tags1_.IsTransitioned as istransitioned5_91_1_, tags1_.EventProfileId as eventprofileid6_91_1_ FROM Forecasting.EventProfile this_ left outer join Forecasting.EventAdjustments adjustment3_ on this_.EventProfileId=adjustment3_.EventProfileId inner join Forecasting.EventProfileTags tags1_ on this_.EventProfileId=tags1_.EventProfileId WHERE ((this_.EntityId = ? and this_.Name = ?) and this_.Source = ?) ORDER BY adjustment3_.IntervalStart ASC, this_.EventProfileId desc)
      ErrorsHelpAbout
      NHibernate.QueryException
      Full error message is attached.

        Attachments

        1. 2020R4 Finalized Day impacting event error.txt
          15 kB
          Stacy Privalova
        2. AnotherInHibernateExceptionObjectObject
          5 kB
          Soma Dixon
        3. image-2020-09-11-14-45-15-788.png
          204 kB
          Stacy Privalova
        4. image-2020-09-22-16-36-30-086.png
          83 kB
          Michael DeBinder
        5. image-2020-09-22-16-38-47-516.png
          170 kB
          Michael DeBinder
        6. screenshot-1.png
          157 kB
          Soma Dixon
        7. screenshot-2.png
          171 kB
          Soma Dixon

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.