| Author |
Message
|
| sandkul.2006 |
 Posted: Fri Mar 20, 2015 11:42 am Post subject: Record and Replay issue for Multiple EGs on same broker |
 |
|
Novice
Joined: 20 Mar 2015
Posts: 10
|
Hi,
I have configured RECORD and REPLAY successfully.
We have one DataCaptureStore and 2 DataCaptureSource for 2 different EGs on same broker.
For one EG it works fine and records are getting inserted into DB tables.
But for second all the captured messages are getting stuck into "SYSTEM.BROKER.DC.RECORD" queue.
This means the subscription works fine and events are getting emitted properly, but not getting inserted into DB. I didn't find any documentation or post for this issue.
Could anyone assist me in resolving my issue please.
Thanks in advance!! |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Mar 20, 2015 12:13 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
did you check multiple transactions are getting supported by the Record and Replay feature for the DB,
AFIK - it can do only one at a time . you can check and see that,
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sandkul.2006 |
| Posted: Fri Mar 20, 2015 12:21 pm Post subject: |
|
|
Novice
Joined: 20 Mar 2015
Posts: 10
|
Yes, it does support. We have another broker where same configuration is done long back and it works for 2 EGs.
But I am facing this issue on newly created broker.
Note: Same DB (DSN) is being used on both brokers (datacapturestore). |
|
| Back to top |
|
|
| sandkul.2006 |
| Posted: Fri Mar 20, 2015 1:01 pm Post subject: |
|
|
Novice
Joined: 20 Mar 2015
Posts: 10
|
Just now I tried creating new datacaturestore, and it worked for me.
I am not sure if this is good practice to create separate datacapturestores for each EG when data source is same.
Currently its working, but please suggest what could be the issue and how i can resolve it with single datacapturestore. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Fri Mar 20, 2015 1:30 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| sandkul.2006 wrote: |
Just now I tried creating new datacaturestore, and it worked for me.
I am not sure if this is good practice to create separate datacapturestores for each EG when data source is same.
Currently its working, but please suggest what could be the issue and how i can resolve it with single datacapturestore. |
this will end up in hell lot of Handles, i think a single handle should go to DB and do the update
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sandkul.2006 |
| Posted: Fri Mar 20, 2015 1:37 pm Post subject: |
|
|
Novice
Joined: 20 Mar 2015
Posts: 10
|
Thanks Gayathri for your comments.
I know this is not the best way we should do it and as you correctly pointed out i will end up in lot of handles.
So i asked about solution/suggestion if any to resolve this issue. I have tried reconfiguring datacapturestore and corrosponding datacapturesource but it still didnt work.
Please let me know if i am missing out on any step. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Fri Mar 20, 2015 2:01 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
In my area..what i have designed is publish all the events and made a separate flow just subscribe and put it to the DB, so only one data source.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
