This discussion is archived
0 Replies Latest reply: Apr 28, 2013 10:55 AM by XYZ123 RSS

CQLServerTrace : out of order timestamp Error

XYZ123 Newbie
Currently Being Moderated
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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points