ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportDBInput is not polling records from table?

Post new topicReply to topic
DBInput is not polling records from table? View previous topic :: View next topic
Author Message
junaid
PostPosted: Wed Sep 11, 2019 8:56 pm Post subject: DBInput is not polling records from table? Reply with quote

Apprentice

Joined: 29 Nov 2018
Posts: 41

Hi,
I want to poll record from APPLICATION_TABLE and I used DBInput node. Trigger APP_TO_EVENT is made which inserts record in EVENT_TABLE.
IIB Version: 10.0.0.15

steps which I followed from Youtube link
https://www.youtube.com/watch?v=S2lPNKTvobE

1. Created Data Design Project.
2. Created Data Definition
3. Created Message Model
4. Generated query on DBInput Node and deployed

It was working but when added another trigger in "AFTER UPDATE" case in
APPLICATION_TABLE, same event occurred. Both Triggers are working fine,
and inserting record in EVENT table but DB pooling is not working.

Kindly suggest?

Code:

CREATE TABLE "SCHEMA"."APPLICATION_TABLE"  (
        "PKEY" VARCHAR(10) NOT NULL ,
        "NAME" VARCHAR(10) NOT NULL ,
        "STREET" VARCHAR(10) NOT NULL )   
       IN "USERSPACE1"   ;
ALTER TABLE "SCHEMA"."APPLICATION_TABLE"
   ADD CONSTRAINT "CC1567517313306" PRIMARY KEY
      ("PKEY") ;
CREATE
    TRIGGER "SCHEMA".APP_TO_EVENT AFTER  INSERT
        ON
        "SCHEMA".APPLICATION_TABLE REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC INSERT
            INTO
                "SCHEMA" . EVENT_TABLE(
                    EVENT_PKEY,
                    APP_PKEY,
                    "OBJECT"
                )
            VALUES(
                NEXT VALUE FOR PKEYSEQ,
                N.PKEY,
                'inser'
            );
END ;

CREATE TABLE "SCHEMA"."EVENT_TABLE"  (
        "EVENT_PKEY" INTEGER NOT NULL ,
        "APP_PKEY" VARCHAR(10) NOT NULL ,
        "OBJECT" VARCHAR(10) NOT NULL )   
       IN "USERSPACE1"   ;
ALTER TABLE "SCHEMA"."EVENT_TABLE"
   ADD CONSTRAINT "CC1567517420065" PRIMARY KEY
      ("EVENT_PKEY") ;


Back to top
View user's profile Send private message
junaid
PostPosted: Wed Sep 18, 2019 9:42 pm Post subject: DBInput is not polling records from table? Reply with quote

Apprentice

Joined: 29 Nov 2018
Posts: 41

Pooling has been done. but it pools single record multiple times. DB input node is not deleting event table record . kindly suggest
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Sep 19, 2019 8:36 am Post subject: Re: DBInput is not polling records from table? Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25823
Location: Ohio, USA

junaid wrote:
Pooling has been done. but it pools single record multiple times. DB input node is not deleting event table record . kindly suggest


Transactionality of the flow is wrong?

What does the trace say is happening?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Fri Sep 20, 2019 12:05 am Post subject: Re: DBInput is not polling records from table? Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 312
Location: UK

junaid wrote:
DB input node is not deleting event table record . kindly suggest


hi...what code do you have at the "EndEvent" procedure of the DatabaseInput node? Is it explicitly deleting records or doing something else...also as Vitor suggested running an user trace of the flow should tell you the whole story
Back to top
View user's profile Send private message
junaid
PostPosted: Tue Oct 01, 2019 2:21 am Post subject: Re: DBInput is not polling records from table? Reply with quote

Apprentice

Joined: 29 Nov 2018
Posts: 41

Yes it is deleting record . after event occur. secondly it pools multiple times due to error in esql which is used in DBInput flow
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportDBInput is not polling records from table?
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.