} cannot be converted to NUM type at field PSGNUM

[Raghava534]

Dear All,

I am facing below issue while posting data through tSAPIDOCoutput. Can suggest how to archive this.

Exception in component tSAPIDocOutput_1

com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Value char[] {EDI_DC40   0000000000000001   2  ZWMMBID02                          ZMM_IDOC_INPUT_IBD_GR           ZMM_IDTALEND  LS TALEND                                                A000000015LS HQ1CLNT100                                              20220705133628                                                                   

E2MBXYH002            0000000000000001000001000000012022070520220705                     4600023010

E2MBXYI003            000000000000000100000212345603

E2MBXYJ001            000000000000000100000315897504                                                                                                          4600023010000440

EDI_DC40   0000000000000002   2  ZWMMBID02                          ZMM_IDOC_INPUT_IBD_GR           ZMM_IDTALEND  LS TALEND                                                A000000015LS HQ1CLNT100                                              20220705133628                                                                   

E2MBXYH002            0000000000000002000001000000012022070520220705                     4600023010

E2MBXYI003            000000000000000200000212345603

E2MBXYJ001            000000000000000200000315897504                                                                                                          4600023010000440

} cannot be converted to NUM type at field PSGNUM

kudus,

Thanks,

Raghava.

[Harvey69]

The problem occurs when converting or setting the PSGNUM field type, and is being fixed with APAR JR36095. You can find further details and a workaround below.

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are? We will appreciate if a lot if you could give us some description about your current state.

Best regards

Sabrina

[Raghava534]

Hi,

Appreciated your support and reply.

We are using Talend data services 7.3.1 Enterprise edition.

I am still not yet resolved.

[Raghava534]

That link not useful to me

[Anonymous]

Hello,

We need a bit more information about your situation.

Your attempt to map an IDoc to SAP? Any tXMLMap component is using in your job design?

Any sample of your IDoc can be posted here?

Best regards

Sabrina

[Raghava534]

Now I am going to explain my scenario.

We will get the XML structure from one of external system and we are going convert that as IDOC by using tSAPIDOCoutput component. Now issue with if I send one item data in XML IDOC posting to SAP successfully but XML having multiple Items it is throwing error like below.

} cannot be converted to NUM type at field PSGNUM

Exception in component tSAPIDocOutput_1

com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Value char[] {EDI_DC40   0000000000000001   2  ZWMMBID02                          ZMM_IDOC_INPUT_IBD_GR           ZMM_IDTALEND  LS TALEND                                                A000000015LS HQ1CLNT100                                              20220705133628                                                                   

E2MBXYH002            0000000000000001000001000000012022070520220705                     4600023010

E2MBXYI003            000000000000000100000212345603

E2MBXYJ001            000000000000000100000315897504                                                                                                          4600023010000440

EDI_DC40   0000000000000002   2  ZWMMBID02                          ZMM_IDOC_INPUT_IBD_GR           ZMM_IDTALEND  LS TALEND                                                A000000015LS HQ1CLNT100                                              20220705133628                                                                   

E2MBXYH002            0000000000000002000001000000012022070520220705                     4600023010

E2MBXYI003            000000000000000200000212345603

E2MBXYJ001            000000000000000200000315897504                                                                                                          4600023010000440

} cannot be converted to NUM type at field PSGNUM

[Raghava534]

Hi team,

Can some one help on this please !!!!!!!!!!

[Anonymous]

Hello,

Here exists a jira issue on talend bug tracker about parsing IDOC.

https://jira.talendforge.org/browse/TDM-5263

Best regards

Sabrina

[Raghava534]

Hi Sabrina,

Do you mean is it raised to Talend support team ?

Can you please help me any temp solution. IT is very urgent issue to me.

Kudus