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 IndexSearch

Search found 16 matches
Author Message
Topic:intermittent Connection dead issues
akill

Replies: 3
Views: 1585

PostForum:WebSphere Message Broker 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: 1585

PostForum:WebSphere Message Broker 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: 2773

PostForum: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: 1892

PostForum:WebSphere Message Broker 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: 1892

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 5684

PostForum:WebSphere Message Broker 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: 3495

PostForum:WebSphere Message Broker 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 ...
Goto page 1, 2  Next Page 1 of 2

Jump to:
Protected by Anti-Spam ACP


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

Copyright MQSeries.net. All rights reserved.