Message Mapping error

[Former Member]

Hi,

All the fields in my message type are not mapped to the external definition provided in the message mapping. when i am trying to activate it its giving me "Mapping not sufficiently defined". its a file to JDBC scenario.Please help.

[Former Member]

Hi ,

Suppose this is the example

CustomerMsg

--Customers

-

---

customer

-

---

Street

-

---

city_code

-

---

Country

-

---

Country_code

-

---

Country_name

-

---

Region

-

---

Region_code

-

---

Region_name.

where customer,street,city_code,countryand regio are of the same level under Customers. country_code and region_code are fields inside country and region resp.

has to be mapped to

access

--Customer

--street

--citycode

--countrycode

--regioncode

--postalcode

In this case the commom node is Customers so will access be linked to Customers

Regards

[Former Member]

hi Vinithra,

you need to map all mandatory fields first...

then u map constant -

---

Access,

remaining fields u map 1-1 directly.

it will work

Regards,

yadav

[Former Member]

Hi

Yes if Customers is the parent node of all it need to be mapped to access node in JDBC receiver document.

Keep in mind you want to pass the column values to the table so it need to occur number of times the values occur in source.

Now taking your example.

Customer occur 3 times and you expect 3 records to be created with respective values in table. You need to map Customers to Access to make effect on 3 records.

Thanks

Gaurav

[Former Member]

Hi all,

Consider this CustomerMsg

-Customers(1...unbounded)

-Location_Data

-Country(0..1)

-country_code

-country_name

this is the source structure which is to be mapped with

TABLE

access

-country_code

-country_name

so in this case access shld be mapped with customers,Location Data or country as the field ar under country but country is a child of Location Data.

Thanx

[Former Member]

Hi,

Map as follows:

Country(0..1) - access

-country_code - Country_code

-country_name - country_name

Regards,

Sreeni

[Former Member]

Hi,

If suppose the field is under a node X( with occurence 0..1) which in turn is under the node Y(with occurence 1... unbounded) . so which one is to be linked with "access". also can the root node be linked with access??

Regards

Vinithra

[Former Member]

Hi,

need to map child elements to the ACCESS.. not the nodes...

Regards,

Sreenivas.

[Former Member]

map Y --> access. Since Y (child node/elements) contains the field that need to used either in INSERT/UPDATE.

[Former Member]

map Y --> access. Since Y (child node/elements) contains the field that need to used either in INSERT/UPDATE.

[rajasekhar_reddy14]

Hi,

File 2 jdbc scanrio

only map 1:unbounded fields only

node has occurance 0:unbounded(

child nodes having 1:unbounded no need to map this fields.when if you not mapped node.

send screen shot rajasekhar84 at gmail dot com.

i wil try to help.its very simple problem

regards,

raja

[Former Member]

Hi...

For JDBC reciever, the format will be different.

Find the below link. It will tell you step by step for File to JDBC scenario.

Regards,

Leela

[Former Member]

Hi all, Thanks for ur replies........... i had the problem due to occurence and its solved now....... but i have one more doubt... can anybody please tell me in file to JDBC scenario , which field is supposed to be mapped to "access"??

I get confused everytime .Please explain

Thanks

[prasad_ulagappan2]

access is a node under which you need to give the column name of the table where you need to insert/modify/delete/etc...

[Former Member]

Hi,

Use Constant to map the field Access and can pass the following values.in constnat ..INSERT/UPDATE_INSERT/DELETE...depends on your requirement.

Regards,

Sreenivas.

[Former Member]

Hi,

Sorry for the wrong reply...

the anwer which i have given is for Action ...not for access...

As prasad told, need to passthe column name of the table to access filed.

Regards,

Sreeni.

[prasad_ulagappan2]

if u r just testing, just map constants to all the mandatory fields and check out...u wont get this error..

[Former Member]

hi,

I have made the TABLE as required .Does that mean i have to map all fields ??

Thanx

[rajasekhar_reddy14]

hi if you occurance 1:1 fileds not mapped then ,u wil find this type of error.

check your message mapping red icon will show,identify those fileds and map it.

regards,

raja

[Former Member]

Hi,

In message mapping having 1:1 occurance then that field is mandatory.

If you needed that field in the target then just map with source or map with constand.

if the field is not needed then select the field and right click choose disable field.

Regards,

Prakasu

[Former Member]

hi,

cld u post the snapshot of ur mapping.

Siddhesh

[Former Member]

u need to map all Mandatory Fields.