| Author |
Message |
 Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 18, 2016 9:18 am Subject: Root Cause |
Turns out that someone requested an environment variable be set on the mqsi profile for this server... 
export MQSI_PUBSUB_USE_MQCONTEXT=passAll
Disabling this fixed the issue. |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 08, 2016 11:24 am Subject: Insert timestamp with local timezone |
well, no, you need to try something like
passthru ( insert into tablename (col1, col2) values (value1, TIMESTAMP(whatever))
Having said that, if it works, you need t ... |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 03, 2016 11:58 am Subject: Insert timestamp with local timezone |
In addition to this, while using a PASSTHRU, we cannot use host variables (i.e. 'VALUES (?,?)')
why not ?
Similar to my above post, I believe this is because when you do something like CAST(CURRE ... |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 03, 2016 11:51 am Subject: Insert timestamp with local timezone |
You can't send a character formatted string to a TIMESTAMP WITH LOCAL TIME ZONE datatype in Oracle?
If not, then I'm confused that passthru works.
Sorry, I added an edit to clarify that this d ... |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 03, 2016 9:28 am Subject: Insert timestamp with local timezone |
| So, from what I gather from these responses and from my own testing is that executing a SQL statement directly in ESQL to insert into a TIMESTAMP WITH LOCAL TIME ZONE datatype [EDIT: while including t ... |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 03, 2016 8:40 am Subject: Insert timestamp with local timezone |
What types are the database columns?
The database column is TIMESTAMP(6) WITH LOCAL TIMEZONE.
Are those types listed in the conversion table for ESQL and Database types?
Taking a look at ... |
| Topic: Insert timestamp with local timezone |
jgonz
Replies: 16
Views: 12025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 03, 2016 7:35 am Subject: Insert timestamp with local timezone |
Hi,
We have a requirement to use TIMESTAMP WITH LOCAL TIMEZONE for storing any timestamps in our database considering that each of the nodes in our cluster are in different timezones.
Keeping ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 01, 2016 12:36 pm Subject: BIP7122E with reason code 2093 |
| Update: We have found that this error is completely local to a single environment and opened a PMR. Not sure what will turn up, but will keep posted. |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 29, 2016 10:35 am Subject: BIP7122E with reason code 2093 |
It vaguely sounds like an MQ security issue, of some sort.
But see what a user trace shows.
I was able to have someone send me the user trace logs. I got user trace logs for an application that ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 29, 2016 9:10 am Subject: BIP7122E with reason code 2093 |
What version of IIB are you using? 
WMB v8.0.0.5
MQ v7.5.0.4 |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 27, 2016 11:44 am Subject: BIP7122E with reason code 2093 |
It vaguely sounds like an MQ security issue, of some sort.
But see what a user trace shows.
Thanks for the direction. I tried this, but I'm unfortunately not able to access the user trace, will ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 27, 2016 9:19 am Subject: BIP7122E with reason code 2093 |
The other place to look is at the properties of the MQInput node.
What properties might have an impact due to environment configurations? The only one I can think of would be the Security properti ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 27, 2016 8:50 am Subject: BIP7122E with reason code 2093 |
| I created a new topic, subscription, and flow. Then published a test message to the topic and the new receiving application simply has an MQ Input node and throws an exception which is then caught an ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 27, 2016 8:23 am Subject: BIP7122E with reason code 2093 |
Really could use some help here.
Not sure how helpful this is, but here's more info on the process:
We have a subflow that is used to publish exceptions (using an xml message containing except ... |
| Topic: BIP7122E with reason code 2093 |
jgonz
Replies: 13
Views: 6747
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 19, 2016 8:24 am Subject: Re: BIP7122E with reason code 2093 |
Please check as well that the permissions are set correctly on the queue/topic.
Can you elaborate on what permissions can be set? Publish/subscribe is allowed on the topic and put/get is also al ... |
