Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Raghava534
Contributor III
Contributor III
‎2022-07-05 06:43 AM

} cannot be converted to NUM type at field PSGNUM

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.

460 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2022-09-07 06:28 AM

In response to Raghava534

Hello,

It looks like a bug in tSAPIDOCoutput while posting data with field like PSGNUM.

As you are using Talend data services 7.3.1 Enterprise edition, could you please raise a support case through support cycle with priority?

Best regards

Sabrina

View solution in original post

460 Views
0 Likes
11 Replies
Harvey69
Contributor
Contributor
‎2022-07-06 02:23 AM

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.

 

341 Views
0 Likes
Anonymous
Not applicable
‎2022-07-06 03:52 AM

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

 

 

341 Views
0 Likes
Raghava534
Contributor III
Contributor III
‎2022-08-26 07:14 AM
Author

Hi,

Appreciated your support and reply.

 

We are using Talend data services 7.3.1 Enterprise edition.

 

I am still not yet resolved.

341 Views
0 Likes
Raghava534
Contributor III
Contributor III
‎2022-08-26 07:17 AM
Author

In response to Harvey69

That link not useful to me

341 Views
0 Likes
Anonymous
Not applicable
‎2022-08-30 04:55 AM

In response to Raghava534

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

341 Views
0 Likes
Raghava534
Contributor III
Contributor III
‎2022-09-01 07:50 AM
Author

In response to Anonymous

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

 

341 Views
0 Likes
Raghava534
Contributor III
Contributor III
‎2022-09-07 03:17 AM
Author

Hi team,

 

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

341 Views
0 Likes
Anonymous
Not applicable
‎2022-09-07 06:15 AM

Hello,

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

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

Best regards

Sabrina

 

341 Views
0 Likes
Raghava534
Contributor III
Contributor III
‎2022-09-07 06:20 AM
Author

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

341 Views
0 Likes