on 10-11-2013 7:10 AM
Dear PI Expert,
I have a issue for one of the PI interface from SQL Server to ECC. There are two interfaces one interface syncronise data correctly on a regular basis i.e. after every 30 minutes. But second interface update table record status in SQL Server as if data has been posted to PI->ECC but message does not appear in SXMB_MONI.
but when i refresh full cache using http://<hostname>:<J2EEport>/CPACache/refresh?mode=full and also 'Integration builder' - > 'clear SLD data cache'
it start creating message in 'SXMB_MONI' and data gets pushed to ECC but old records for which message not created remain missing in ECC. and problem is repetative and not able to diagnose.
Regards
Vaman Kamat
Hi ,
Few cents, please check the runtime parameter LOGGING_SYNC on integration engine(sxmb_adm) configuration . If parameter (LOGGING_SYNC) was set to zero, change it to 1 and check you scenario again.
Thanks
Hari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vaman,
do you see messages in Adapter Engine monitoring before? Who or what triggers your messages?
The "clear SLD cache" is purely design time related and should have no effect on runtime behaviour. The full cache refresh only should have indirect effects, maybe it restarts Communication Channels.
Regards,
Jörg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello sir,
I have checked 'Adapter Engine' monitoring in runtime workbench both inteface shows successful with no. of successful attempt in 'success' column but as far as 'Error' column shows '-' ( No error )
Message gets trigger when SQL Server realise a table entry with status 'N' and once PI pulls the data status automatically changes to 'X'. Currently status gets change to 'X' without message in 'SXMB_MONI'
Regards
Vaman Kamat
Hello Vaman,
after the message pull by PI the message will first appear in Adapter Engine. Can you see that? Is the Communication Channel ok?
Can you confirm that you see the messages in Adapter Engine, but not in SXMB_MONI?
Or do you see the messages in AE after cache refresh etc.?
Regards,
Jörg
Hello Sir,
No . I am not able to see any new message in Adapter Engine and as far as communication channel is concern shows Functional and polling every 60 sec successfully.
Yes. after refreshing cache using http://<hostname>:<J2EEport>/CPACache/refresh?mode=full message appears in AE.
Regards
Vaman Kamat
Hello Vaman,
apparently, your channel polls "successfully", but doesn't create any message in the system. So something about the CC or the adapter does not work. Can you try to stop and start the CC instead of performing a full CPACache refresh? Or, alternatively, restart the JDBC adapter in NWA? Do they create the same behaviour? If yes, something may be wrong with your JDBC connection, maybe it closes prematurely or loses connection somehow.
Regards,
Jörg
Hi Vaman,
As per your previous replies, you told that message is not creating when the table is having Mix N and X records, right? if that is the case there is some problem with the update..
How many records that you are reading at a time? if you are reading more records it may be one of the reason for this issue. you should limit the record reading.
Try to stop and start the communication channel.
Do the server restart if possible, sometimes it will helps.
Regards
Bhargava krishna
take a look to this blog
by the way do you execute the query in the DB directly? does it work?
regards
Rodrigo
Hi Vaman,
I have worked extensively in JDBC scenarios and never experienced such issues, thats why it surprises me.
>>>>Today few messages got generated automaticallly but few are missing.
I suggest you look at some aspects:
Hope it helps you nail down the problem.
Ambrish
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.