0 Replies Latest reply: Apr 28, 2013 12:55 PM by XYZ123 RSS

    CQLServerTrace : out of order timestamp Error

    XYZ123
      Hi everyone,

      When I try to run this command I am getting the error which I specified bottom, how can I solve this problem?
      is-total-order parameter was set to "True".
      This is a simple Helloworld Application
      channel parameters are default ( max threads and max size was set to 0
      11.1.1.7 Version
              SELECT
                             shortName, avg(price) as price
                        FROM
                             stockInputChannel [PARTITION BY shortName ROWS 3 RANGE 3 SLIDE 3]
                        GROUP BY
                             shortName 
      <Apr 28, 2013 1:15:48 PM VET> <Emergency> <CQLServerTrace> <BEA-000000> <event timestamp is out of order timestamp0=1,367,171,106,000,000,000 timestamp1=1,367,171,103,357,000,000 event=22715375 : kind=E_PLUS tuple=Tuple(14886,25458514) 'obj=Stock21921411,3.3803851379397982,char[15]=FWGUKXDXBPSYGPB,1367171103357,char[5]=XTCFZ,1367171103357000000,byte[1],obj=PartitionNode25458617,' ts=1367171103357000000 totalOrderingGuarantee=true in PO_GROUP_AGGR#144
      oracle.cep.execution.SoftExecException: event timestamp is out of order timestamp0=1,367,171,106,000,000,000 timestamp1=1,367,171,103,357,000,000 event=22715375 : kind=E_PLUS tuple=Tuple(14886,25458514) 'obj=Stock21921411,3.3803851379397982,char[15]=FWGUKXDXBPSYGPB,1367171103357,char[5]=XTCFZ,1367171103357000000,byte[1],obj=PartitionNode25458617,' ts=1367171103357000000 totalOrderingGuarantee=true in PO_GROUP_AGGR#144
              at oracle.cep.execution.ExecException.OutOfOrderException(ExecException.java:154)
              at oracle.cep.execution.operators.GroupAggr.run(GroupAggr.java:780)
              at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1002)
              at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:984)
              at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)