| Author |
Message |
 Topic: intermittent Connection dead issues |
akill
Replies: 3
Views: 6468
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Dec 02, 2019 4:04 am Subject: intermittent Connection dead issues |
Hi,
Thanks for the quick response.
As your network team suggested it looks like some sort of firewall/OS level setting on the Database server to kill off idle connections older than 60 minutes. ... |
| Topic: intermittent Connection dead issues |
akill
Replies: 3
Views: 6468
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Dec 02, 2019 2:29 am Subject: intermittent Connection dead issues |
Hi all,
We are getting intermittent Connection dead issues while connecting to oracle DB.
Below are the inputs from concern teams:
Notwork Team : Firewall terminates the idle connection for e ... |
| Topic: intermittent Connection dead issues IIB to Oracle DB |
akill
Replies: 1
Views: 7244
|
Forum: General Discussion Posted: Mon Dec 02, 2019 12:03 am Subject: intermittent Connection dead issues IIB to Oracle DB |
Hi all,
We are getting intermittent Connection dead issues while connecting to oracle DB.
Below are the inputs from concern teams:
Notwork Team : Firewall terminates the idle connection for e ... |
| Topic: An XML parsing error :: Internal error codes are '1539' and |
akill
Replies: 3
Views: 5446
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 28, 2018 9:12 pm Subject: An XML parsing error :: Internal error codes are '1539' and |
Hi timber,
Thanks for your reply.
a) you are submitting an invalid XML document and
Agreed, my input date contains '&' which is not parsable - This is one test case i have to handle.
... |
| Topic: An XML parsing error :: Internal error codes are '1539' and |
akill
Replies: 3
Views: 5446
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 28, 2018 3:28 am Subject: An XML parsing error :: Internal error codes are '1539' and |
Hi Experts,
I am getting following error:
2018-08-28 15:14:40.572044 18123 UserTrace BIP5004E: An XML parsing error ''The entity name must immediately follow the '&' in the entity r ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jul 06, 2018 1:44 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
This reply is just to close the thread:
We have neglected all the warnings/Errors seen in odbc trace as data is inserting to DB successfully !! 
Thanks all for the help  |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 12, 2018 8:23 pm Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi abhi_thri/fjb_saper ,
It doesn't sounds right...are you saying that all your transactions are successful (data is inserted to DB) but you can still see errors at odbc trace? Also always use mqs ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 12, 2018 5:03 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi all,
I have checked the odbc.ini file , the middleware admin team didn't add InstallDir value in the file . We added it and now we are not getting this issue (all the records are getting inserte ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 12, 2018 3:15 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi fjb_saper ,
Below is the driver which is being used .
<InstallationPath>/iib-10.0.0.7/server/ODBC/drivers/lib/UKora95.so
Thanks in advance . |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 12, 2018 2:20 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi fjb_saper ,
DB team is not terminating connections and DB is accessible all the time . They also concluded that there is no log available as the request hasn't reached DB(because it is a Error ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 11, 2018 7:33 pm Subject: Re: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
I doubt it very much. Looks more like input text too long for column width... 
No , because when i tried inserting the same failure records they are getting inserted successfully . |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 11, 2018 7:11 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi abhi_thri,
Thanks for your response .
Yes i tried and those messages are inserted successfully .
ODBC Trace tells:
I didn't check connectDatasourceBeforeFlowStarts property on th ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 11, 2018 5:05 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
I found that below are the possible reasons which causes SQL State 21
1.Insert value list does not match column list
2.Degree of derived table does not match column list
But in my case some rec ... |
| Topic: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
akill
Replies: 17
Views: 19781
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 11, 2018 4:13 am Subject: [unixODBC][IBM][ODBC 20101 driver][20101]10703 |
Hi Guys,
I am using queue based message flow(MQ--> DatabaseNode) , Basically i put message in the queue from that message will be inserted into database .
My message flow is inserting records i ... |
| Topic: Exception with MSSQL Query using passthru . |
akill
Replies: 10
Views: 11053
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 08, 2017 11:45 am Subject: Exception with MSSQL Query using passthru . |
Hi akill,
To make sure the fine gentlemen here haste in providing their expertise and knowledge, you should try to include in your posts as much as possible of the relevant information for your cur ... |
