need help on meesage mapping

[former_member200386]

Dear experts,

I am working on one scenario where i need perform UPDATE_INSERT operation in multiple (customer ,material, employee)tables. i have created the scenario it is working fine. now we had some cases there is chances that no data will updated in those tables. now my problem is i have few date fields used date transformation logic.

yyyymmdd to DD-MMM_YY

i applied customer_id(primary key) ---> exists---->create----> node

if if i test with null values in that node i am getting unparsable date error.

do we need to write UDF?

Regards

Pavan

[former_member190624 · Accepted solution]

Hi Pavan,

Your mapping logic is wrong , you are trying as

customer_id(primary key) ---> exists---->create----> node , here you testing with null value ,means node exists but value is null . So, try as below

customer_id -> length != 0 -> create--> node. Hope this will work.

Regards

Hari.

[former_member200386 · Accepted solution]

Hi Hari,

Thanks alot . now i applied your logic it's working fine.

Regards,

Pavan

[zameerf]

Hi Pavan,

Are you getting error in mapping step or in receiver JDBC channel?

If in mapping step, then you can first check if date input field is not blank, then you can do date transformation logic. As dateTrans function expects some input in the desired format.

If error is in JDBC receiver, then probably you have to adjust your mapping output to have the expected date format of database.

Regards,

Zameer

[former_member200386]

HI Zameer,

Thanks for your qucik response. i am getting error in message mapping test only.not at the  jdbc recv channel end. i know when ever we used date transformation  logic input is required. but my problem i have no need to send any data in some cases that table which contains date field is there.please suggest me

Regards,

Pavan