I am using Jdbc adapter Notification (update notification ) in a Clustered environment .I was successful in using notification in Devlopemt box (which is not In cluster) is working fine.
But when I use Update Notification in Cluster its not Working for me .
Server A and server B are in cluster and when I am able to enable that Notification though Admin screen for Server A
And when I enable the Notification in Server B its giving me this Error :-
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification HarmonWIN.GP.Notification:EAIControNotif.
[ADA.1.316] Cannot execute the SQL statement “CREATE TABLE WMBEAI_N1_ba333jn (xxxx int, xxxxx varchar(50), xxxx varchar(50), xxxx varchar(256), xxxx int, xxxx decimal(15,2), xxxx datetime NULL, xxxx varchar(18), xxxx datetime NULL, xxxx varchar(40), xxxxx varchar(40), xxxx varchar(40), xxxx int, xxxx NULL, xxxx numeric(9) xxxx, xxxx numeric(14))”. "
(42S01/2714) [wm-cjdbc33-0009][SQLServer JDBC Driver][SQLServer]There is already an object named ‘WMB_N1_ba333jn’ in the database."
[wm-cjdbc33-0009][SQLServer JDBC Driver][SQLServer]There is already an object named ‘WMB_N1_ba333jn’ in the database.
I am assuming that its is trying to create table again when Server A had already created .
If any one had gone though similar problem.
I will appreciate to share your thoughts and experiences…
is there any FIx or work around for this problem /???