| Author |
Message
|
| scravr |
 Posted: Thu Apr 20, 2017 11:30 am Post subject: IIB 10 - Mapping node |
 |
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
Guys,
I converted map nodes from v7 to iib10 and get error on esql:space(5) function:
The expression esql:space(5) used for FedRej/Filler4 cannot be automatically converted into a supported transform.
Refer to <MSG-FLOW> and manually create a transform with an equivalent expression.
I have lots of those with different lengths like 5, 10, 30.... and many more.
How do I fix these conversion problems.
Thanks.
ME |
|
| Back to top |
|
 |
| scravr |
| Posted: Fri Apr 21, 2017 4:21 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 4:43 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 21, 2017 4:59 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Start by verifying the business requirements that are behind each flow that runs these maps.
You may find that some are obsolete and don't need to exist any more. You may find that some are simpler than before, and that some don't meet current requirements.
Then get management to prioritize the set of maps left from the above steps.
Then discuss with management the amount of work needed, and the amount of work that would have been avoided had they moved from v7 v8 to v9 to v10 over a longer period of time.
Discuss with them how this indicates the risk taken by a) using unsupported v7, and b) not otherwise maintaining their software integration layer.
Also discuss with them the relationship between the amount of time to migrate IIB flows to v10.0 and re-implementing in another integration project (hint, the maps will still need to be re-written, as well as the flow logic)
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 5:24 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
Can I convert WMB7 to V8, then to IIB9, and then to IIB10?
Will this work? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 21, 2017 5:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| scravr wrote: |
Can I convert WMB7 to V8, then to IIB9, and then to IIB10?
Will this work? |
I meant the entire stack, over time. I.e. migrate their entire code base to v8, and then to v9 a year or so later, and etc...
You *should* only need to move from v7 to v8, then maps *should* be compatible with v10.
But I doubt this will solve any of your problems - I mean I think your maps will still fail.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 5:37 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
| Can I just download toolkit for WMB8 + IIB9, then convert from 7 to 8 and from 8 to 9, then from 9 to 10? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 21, 2017 5:38 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| scravr wrote: |
| Can I just download toolkit for WMB8 + IIB9, then convert from 7 to 8 and from 8 to 9, then from 9 to 10? |
Yes. You can convert your development resources from v7 to v8 and then v9 and v10.
You might only need to convert from v8, and they'll work just fine in v10.
But I doubt that your maps will successfully migrate to v8, without the same issues.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 5:45 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
So how clients moved from v7 to v8 if they had complex maps?
Are they all failed? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 21, 2017 5:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| scravr wrote: |
So how clients moved from v7 to v8 if they had complex maps?
Are they all failed? |
I don't remember.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Apr 21, 2017 5:59 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| scravr wrote: |
| Are they all failed? |
The mapping changed seismically between v7 and v8, in terms of how the product works. v7 maps are converted in (bad) ESQL), v8 and beyond the maps are compiled into running code.
So even if they didn't fail, it was better to rewrite them.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 6:06 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
cannot convert to esql; have too many of them with lots of build-in and custom functions.
Dont IBM have a fix for this issue. after all there are hundreds of customers. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Apr 21, 2017 6:48 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| scravr wrote: |
| Dont IBM have a fix for this issue. |
Raise a PMR and ask. Oh wait, v7 is out of support. Well out.
I agree with my most worth associate that the work involved in this exercise is the sum of the work needed to upgrade from v7 at or about the time it went out of support, plus one or more intermediate versions.
Their plan to save money on upgrade tasks just failed.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| joebuckeye |
| Posted: Fri Apr 21, 2017 7:33 am Post subject: |
|
|
Partisan
Joined: 24 Aug 2007
Posts: 365
Location: Columbus, OH
|
We ran into this issue when moving from v5 to v6 (man I've been doing this too long).
After that experience we never used mapping nodes because you are at the tender mercy of IBM for any conversions to the next version's mapping nodes.
All transforms in broker are done via ESQL, WTX (yuck) or XSLT. Probably 95% or more of our transforms are done via ESQL. |
|
| Back to top |
|
|
| scravr |
| Posted: Fri Apr 21, 2017 7:54 am Post subject: |
|
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
Yes , we have been doing this mqsi/mb/wmb/iib for over 15 yrs !!!
anyone remember and can point to the old support pack that converts map node to esql compute node? |
|
| Back to top |
|
|
|
|
