Missing node in Message Mapping when test mapping??

[Former Member]

Experts,

I have the following Mapping Structures:

Sender:

<Recordset> 1-1

<Records> 1:unbounded

<field1>1:1

<field2>1:1

…….....

Receiver:

<Recordset> 1-1

<Header> 1-1

<Records> 0-unbounded

<field1>

< field2>

……..

<Trailer> 1-1

Mapping is completed for all fields here.But one thing I notice is on Receiver side : all nodes are Green exept Records - it is Gray with some red smal dot in the gray..

1.Question: What this means?Shouldn't all nodes turn green after mapping is done??

2.When click on TEST on Message MApping I dont even see the Receiver Records node appearing on right(receiver side) But I was able to see Header and Trailer...Why the Records is missing??

On the other hand the result from the test is successfull which is even more confusing ,How come it can be succesful since Records is not there...

I can provide screenshots if needed for more clarity ..Any help is appreciated asap..Thanks much to all!

J...

[Former Member · Accepted solution]

Hi John,

It is very simple and there is no complexity with this problem.

<b> 1.Question: What this means?Shouldn't all nodes turn green after mapping is done??</b>

If you mapped the source field to the correspoding target field..all the target fields get turn to green color. If you didn't mapp any target field that filed should appear with gray color..comming to the small circle in the recordset field...it is indicates that ..that field is "Unbounded".

For resolving the above issue...do the mapping like this.

<Recordset>---><Recordset>

<Records>-------><Records>

<field1>----><field1>

<field2>-----> <field2>1

Keep the empty constant value for the target field Header...

empty constatnt---->Header.

So once you done this check the mappping it will execute fine and even you able to see the recods node in the target structure.

Please let me know if you have any queries...!

Thanks and Regards,

Chandu.

[Former Member · Accepted solution]

Hey Chandu , Thanks for the info...

So Records was set to 0:unbound and it shoudl be OK than with the grey circle and small red dot...

Please see my answer to Danish below...All went green when I changed Occurance from 0:unbound to 1:1.... But than I will not be able to write multiple records , right??

Thanks much!

[Former Member · Accepted solution]

for sure you won't be able

[Former Member · Accepted solution]

So how to acheive multiple records in the Receiver than??Keep in mind for header I dont want multiple !only Records....?

How do I do this , with occurance 0:unbound - right?

Thanks

[Former Member · Accepted solution]

In source change Records occurenece to 0-unbounded.

[Former Member · Accepted solution]

Hi,

I'd do that like that:

Receiver:

<Recordset> 1-1 no mapping

<Header> 1-1 no mapping (only in case if it's non complex element)

<Records> 0-unbounded please map it directly with Records

<field1> one to one mapping

< field2> one to one mapping

best,

wg

[Former Member · Accepted solution]

thanks Woiciech,

Can you tell me what do you mean :

Records> 0-unbounded please map it directly with Records

what is Diretly to you ???

Thanks!!

Jon

[Former Member · Accepted solution]

you are mapping it with Records from source structure one to one

[Former Member · Accepted solution]

yes I did, and I do - field to field ...

But it didn't work well with 0:unbound , did turn green with 1:1....Wired!

Thanks

[Former Member · Accepted solution]

Could you post here sample source and target file?

best,

wg

[Former Member · Accepted solution]

Do you actually want XML target and source file to be posted here?

[Former Member · Accepted solution]

Hey

just upload the screenshot for message mapping on www.flickr.com or if you are unable to access that website from work place then mail them to me

Thanx

Aamir

[Former Member · Accepted solution]

Hi Aamir,

Actually I have solved the problem thanks to you , but for everyone else here is the fix:

1.I have not given my Sender Records occurence correctly - if had sender <Records> 1:unbounded meaning that my record will be present in sender structure at least 1 time..which was incorrect..I may have case when my record occures only 0 time, hence in Sender <Records> must be 0:unbounded

2. I mapped the Sender tag <Records> with the Receiver tag <Records>

3. I had all my objects Inactive in IR - so I activated them - all of them.

This all 3 steps fixed my problem with the mapping..I can go now and test it - and everything works great.I am not sure though whichone was the one that did the magic, but all 3 steps were mandatory anyway

Thanks Aamir! Extemely helpful.PRoblem solved!Great job!

Regards

[Former Member]

sometimes it helps to delete the mapping of the node and save it and afterwards make the same mapping graphical mapping is not a perfect tool

best,

wg

[Former Member]

Hi Jon,

Either you didn't map it or something is wrong with repository. Please close integration repository and check if now it's green.

best,

wg

[Former Member]

Woicieh,

Nothing happened after I reopen the IR..Wired.

I feel I have done all mapping fine - but if doubts I can provide screenshots...Thanks guys!

Jon

[Former Member]

Check if you CACHE is updated or not.

ENVIRONMENT--->CACHE notifications.

Award points if usefull.....

[Former Member]

Dinesh,

Thanks for your advise - nothing changes!Very wired!Thanks

[Former Member]

Jon,

Is the 'Records' node in the 'Header' context or in the Recordset context?

Appreciate if you could describe the structures as per the context hierarchies.

Thanks,

Anand

[Former Member]

Anand,

Thanks for trying to help...Records is same level as Header but separate node with its subelements - fields1, fields2 etc...

Here How the strucures look:

Sender
<Recordset> 1-1
   <Records> 1:unbounded
        <field1>1:1
        <field2>1:1
         …….

Receiver
<Recordset> 1-1
    <Header> 1-1
     <Records> 0-unbounded
           <field1>
           < field2>
           ……..
     <Trailer> 1-1

I can send you sreenshots if you want for more clarity ..Thanks!

[Former Member]

jon i guess some thing wrong with Occurences of Records

but iam not sure.

Try keeping occurences of Records in Target as 1:unbounded and try it.

Award points if usefull.....

[Former Member]

Danish,

I just tried - didn't help,Actually in opposite - the Reords node in the receiver turned entire red..Thanks!

Jon

[Former Member]

Try both ways

[Former Member]

Dinesh

I changed occurance of Records 1:1 and suddenly Records went green...So I am able to test the Structure with values now...Good this is really encouraging

but I wanted to the have Records Occurence 0:unboind because I wanted to be able to write mutliple records in the receiver:

Header

records

records

records

......

So if I keep 1:1 I will not be able to do it...? Right?

did u get what is wrong with records 0:unbound??

Thanks

much!!!

[Former Member]

Hi,

Please go back to the previous occurence and make something like that:

either:

do not map any complex elements with occurence 1...1

or

map all of them with constants (according to graphical tool specification it's not manatory)

best,

wg

[Former Member]

Hi John,

If you change the occurrence the field color didn't get change....there is no relation with the occurrence and the color of the field.

The field only will turn to green color once you mapped to that field.

Please let me know if you have any queries...!

Thanks and Regards,

Chandu.

[Former Member]

Hi John,

If you change the occurrence the field color didn't get change....there is no relation with the occurrence and the color of the field.

The field only will turn to green color once you mapped to that field.

Please let me know if you have any queries...!

Thanks and Regards,

Chandu.

[Former Member]

Jon,

Have you mapped the 'Records' node to a source node.

Since the occurence of the Records node is 0..unbounded, I suppose a mapping would be required.

Thanks,

Anand

[Former Member]

Anand,

I have mapped the Records fields in the Receiver with the fields with the Sender(Source)

Why would that Records node is still Gray , shouldn't be Green as Header and trailers are??

Also why is missing the entire node when click on testing?Any clues?

Thanks much!

Jon