2 Replies Latest reply on Feb 24, 2017 10:12 AM by 3394405

    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

    3394405

      Hi all,

      I got problem when i applied row security for my data.

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 23004] Invalid request: Subtotal GROUP BY clause cannot contain an aggregate expression case when Rank([FILTER(PO Amount:[DAggr(Fact - Purchasing - Order.PO Amount)] USING Dim - Business Unit.Key Id = VALUEOF(NQ_SESSION.MNS_COA) or '-999' = VALUEOF(NQ_SESSION.MNS_COA)) desc] ) < 11 then Dim - Supplier.Supplier Number || ' - ' || Dim - Supplier.Supplier Name else 'Others' end . (HY000)

       

      This error just appear when i used account applied row security.
      Can anyone help me!
      Zoe.