| Author |
Message |
 Topic: Connecting to Google BigQuery via IIBv9 |
wmbv7newbie
Replies: 1
Views: 2053
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 25, 2016 9:02 am Subject: Connecting to Google BigQuery via IIBv9 |
Hi,
We are doing a PoC and exploring the options of connecting to Google BigQuery through integration bus v9. If someone has any guidance to offer or suggestions we could try, that would be great h ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Apr 15, 2016 1:36 pm Subject: IIB : MRM with Parsed Record Sequence Query |
For now I am doing a substring to extract the fields from the lines due to shortage of time and since I had already validated lengths at previous stage.
Would post the trace tests over the weekend ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Apr 15, 2016 4:12 am Subject: IIB : MRM with Parsed Record Sequence Query |
| I have connected both the out and failure terminals of RCD to mq but nothing comes there. I am just getting some unreadable exception with only mqrfh2 in the error queue through the logger subflow att ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2016 10:10 pm Subject: IIB : MRM with Parsed Record Sequence Query |
So I have reached the final stage where everything else works as expected except for final validation of model 2.
At second stage, I am validating the Body which contains lines of 2, 4 and 8. In my ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2016 12:10 pm Subject: IIB : MRM with Parsed Record Sequence Query |
So removed all validations from first model as it wasnt working that way. I have now put all field level validations in second model. The first model now only knows the file structure as --
1. Head ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2016 9:14 am Subject: IIB : MRM with Parsed Record Sequence Query |
| One problem with this model is that if I add length validations to any of the 2, 4, 8 lines and any record fails, it doesn't continue processing next record. The flow throws an exception and flow term ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2016 7:28 am Subject: IIB : MRM with Parsed Record Sequence Query |
Thanks @timber and @mqjeff. I made some significant progress on this. Going by your suggestion, I created the DFDL as below -
<?xml version="1.0" encoding="UTF-8"?><xsd ... |
| Topic: Load Balanced/ Highly Available MQs |
wmbv7newbie
Replies: 10
Views: 5479
|
Forum: General IBM MQ Support Posted: Thu Apr 14, 2016 7:12 am Subject: Load Balanced/ Highly Available MQs |
| Thanks for the suggestion but all apps are mq server based |
| Topic: Load Balanced/ Highly Available MQs |
wmbv7newbie
Replies: 10
Views: 5479
|
Forum: General IBM MQ Support Posted: Wed Apr 13, 2016 8:56 pm Subject: Load Balanced/ Highly Available MQs |
Hi,
We are exploring some solutions to make our mqs highly available/load balanced. For example, we might have QUEUE1 defined on all of our servers. When we send a message, we don't want to say &qu ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 12:35 pm Subject: IIB : MRM with Parsed Record Sequence Query |
Looks like my brain is not working anymore 
I modified the body in DFDL as below -
---- OrderBody occurs unbounded
-------sequence occurs exactly once
----------FieldFor2 , initiator 2 (w ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 12:03 pm Subject: IIB : MRM with Parsed Record Sequence Query |
| 2 is initiator and record type 4 and 8 are choices? |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 11:49 am Subject: IIB : MRM with Parsed Record Sequence Query |
thanks a ton @mqjeff!!! I am so close now.
Input -
0SOC00001
23036178280Gerard van der
40001184776138
40001184776138
40001184776138
80000001 0001
23036178280Gerard van der
40001184776138
... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 10:42 am Subject: IIB : MRM with Parsed Record Sequence Query |
Thanks.
wmbv7newbie wrote:
Quote:
Do the blocks of 2 or 4 records always come as a set? or do you need to deal with a block like {2-record,4-record,2-record,2-record,2-record,4-record} ?
Yes. Th ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 6:54 am Subject: IIB : MRM with Parsed Record Sequence Query |
Are 'corrupt records' records with invalid values (by business logic, not by model restrictions - i.e. field length) ? Or are they records that don't meet model restrictions?
Which will give parsing ... |
| Topic: IIB : MRM with Parsed Record Sequence Query |
wmbv7newbie
Replies: 26
Views: 14026
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 12, 2016 6:35 am Subject: IIB : MRM with Parsed Record Sequence Query |
@smdavies99 - Although thats dummy data, i have removed most of the content now.
@timber and @fjb_saper - Line 0 and 9 will come only once in one file. The block with lines 2, 4 and 8 will repeat u ... |
