This discussion is archived
2 Replies Latest reply: Jul 4, 2007 5:58 AM by Marcelinho RSS

Add rules

551112 Newbie
Currently Being Moderated
I tried to create rules by using the following steps mentioned below. When I send the event as in step 4, I get the event queued in inbound queue. Will it not automatically move to the pollution_q_table as mentioned in rule? Should we manually dequeue the event? If we need to manually dequeue the event, why in the first place we need to configure rule?

1. execute dbms_aqadm.create_queue queue_name=>'message_q',queue_table=>'pollu
tion_q_table');
2. execute dbms_aqadm.start_queue(queue_name=>'message_q');
3. exec edg_utl.add_rule('MessageRule',':event.id like''epc:%''',null,null,'me
ssage_q','queue');
4. SQL> edg_utl.sendToStage(1,1,'epc:12354','MySite','MyDevice','data',sysdate,'src
','cor');

Thanks in advance
Visa
  • 1. Re: Add rules
    551112 Newbie
    Currently Being Moderated
    When I add a event it is stored in sda_observations. There is no table called sdh_events. Is it a reason for the rules not getting executed and not forwarding to the queue/call back procedure?

    Does anyone else face this problem when adding rules?? In SES 10.1.3 installation will the sdh_events table be present. If so, which is the sql script that will help to create this table??

    Kindly someone answer this...........

    Thanks
  • 2. Re: Add rules
    Marcelinho Newbie
    Currently Being Moderated
    How to manually create the schemas:
    http://edgeserver.de/?p=15

    Another sample for queue propagation:
    http://edgeserver.de/?p=14