topic Re: how to provide the date input variable into tSOAP in Talend Studio

topic Re: how to provide the date input variable into tSOAP in Talend Studio https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344108#M111797 <P>I suspect that this is because you are supplying your date without casting it from an Object (the globalMap returns everything as an Object) AND (more importantly) your Object is essentially a Date and not a String. The SOAP message essentially transfers everything in the form of a String. So with dates, I suspect that the SOAP message will require it to be sent as a String and not a Date.</P> Wed, 25 Jan 2023 11:58:30 GMT Anonymous 2023-01-25T11:58:30Z how to provide the date input variable into tSOAP https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344107#M111796 <P>Hi experts,</P><P></P><P></P><P>My tSOAP is capturing the input data from text file as below. All other field are okay but I receive the error when I add the date.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000cfEGMAA2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148033i139A88269114F203/image-size/large?v=v2&px=999" role="button" title="0695b00000cfEGMAA2.png" alt="0695b00000cfEGMAA2.png" /></span></P><P>I can process all other variables but I was not able to process the date. I used the below syntax to map the date.</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000cfEVRAA2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149342iB6422F79F5843371/image-size/large?v=v2&px=999" role="button" title="0695b00000cfEVRAA2.png" alt="0695b00000cfEVRAA2.png" /></span></P><P></P><P></P><P></P><P></P><P>I'm getting the below error only when I include the date field. Would you please advise me what is the right format for date, logical and numeric variables for SoapUI input?</P><P></P><P></P><P>Starting job DEV_Job_File_To_QAD_PO at 13:20 25/01/2023.</P><P>[statistics] connecting to socket on port 3701</P><P>[statistics] connected</P><P>Jan. 25, 2023 1:20:28 PM com.sun.xml.messaging.saaj.soap.impl.BodyImpl extractContentAsDocument</P><P>SEVERE: SAAJ0251: Unable to extract Document from body</P><P>Exception in component tSOAP_1 (DEV_Job_File_To_QAD_PO)</P><P>com.sun.xml.messaging.saaj.SOAPExceptionImpl: Unable to extract Document from body</P><P> at com.sun.xml.messaging.saaj.soap.impl.BodyImpl.extractContentAsDocument(BodyImpl.java:347)</P><P> at org.talend.soap.SOAPUtil.extractContentAsDocument(SOAPUtil.java:192)</P><P> at org.talend.soap.SOAPUtil.invokeSOAP(SOAPUtil.java:159)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.tFileInputDelimited_1Process(DEV_Job_File_To_QAD_PO.java:2390)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.runJobInTOS(DEV_Job_File_To_QAD_PO.java:3279)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.main(DEV_Job_File_To_QAD_PO.java:3108)</P><P>Caused by: org.w3c.dom.DOMException: NAMESPACE_ERR: An attempt is made to create or change an object in a way which is incorrect with regard to namespaces.</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.setName(ElementNSImpl.java:153)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.<init>(ElementNSImpl.java:84)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.createElementNS(CoreDocumentImpl.java:2097)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1548)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1750)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1504)</P><P> at com.sun.xml.messaging.saaj.soap.impl.BodyImpl.extractContentAsDocument(BodyImpl.java:338)</P><P> ... 5 more</P><P></P><P></P><P>CAUSE:</P><P></P><P></P><P>org.w3c.dom.DOMException: NAMESPACE_ERR: An attempt is made to create or change an object in a way which is incorrect with regard to namespaces.</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.setName(ElementNSImpl.java:153)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.<init>(ElementNSImpl.java:84)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.createElementNS(CoreDocumentImpl.java:2097)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1548)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1750)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1504)</P><P> at com.sun.xml.messaging.saaj.soap.impl.BodyImpl.extractContentAsDocument(BodyImpl.java:338)</P><P> at org.talend.soap.SOAPUtil.extractContentAsDocument(SOAPUtil.java:192)</P><P> at org.talend.soap.SOAPUtil.invokeSOAP(SOAPUtil.java:159)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.tFileInputDelimited_1Process(DEV_Job_File_To_QAD_PO.java:2390)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.runJobInTOS(DEV_Job_File_To_QAD_PO.java:3279)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.main(DEV_Job_File_To_QAD_PO.java:3108)</P><P></P><P></P><P>CAUSE:</P><P></P><P></P><P>org.w3c.dom.DOMException: NAMESPACE_ERR: An attempt is made to create or change an object in a way which is incorrect with regard to namespaces.</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.setName(ElementNSImpl.java:153)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.ElementNSImpl.<init>(ElementNSImpl.java:84)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.createElementNS(CoreDocumentImpl.java:2097)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1548)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1750)</P><P> at java.xml/com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.importNode(CoreDocumentImpl.java:1504)</P><P> at com.sun.xml.messaging.saaj.soap.impl.BodyImpl.extractContentAsDocument(BodyImpl.java:338)</P><P> at org.talend.soap.SOAPUtil.extractContentAsDocument(SOAPUtil.java:192)</P><P> at org.talend.soap.SOAPUtil.invokeSOAP(SOAPUtil.java:159)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.tFileInputDelimited_1Process(DEV_Job_File_To_QAD_PO.java:2390)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.runJobInTOS(DEV_Job_File_To_QAD_PO.java:3279)</P><P> at precoro_qad.dev_job_file_to_qad_po_0_1.DEV_Job_File_To_QAD_PO.main(DEV_Job_File_To_QAD_PO.java:3108)</P><P>[statistics] disconnected</P><P></P><P></P><P>Job DEV_Job_File_To_QAD_PO ended at 13:20 25/01/2023. [Exit code = 1]</P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 22:10:13 GMT https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344107#M111796 JY3 2024-11-15T22:10:13Z Re: how to provide the date input variable into tSOAP https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344108#M111797 <P>I suspect that this is because you are supplying your date without casting it from an Object (the globalMap returns everything as an Object) AND (more importantly) your Object is essentially a Date and not a String. The SOAP message essentially transfers everything in the form of a String. So with dates, I suspect that the SOAP message will require it to be sent as a String and not a Date.</P> Wed, 25 Jan 2023 11:58:30 GMT https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344108#M111797 Anonymous 2023-01-25T11:58:30Z Re: how to provide the date input variable into tSOAP https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344109#M111798 <P>I changed it to</P><P>         <urn1:poDueDate>" + (String)globalMap.get("row3.po_due_date") + "</urn1:poDueDate></P><P> </P><P>then I get the below error.</P><P> </P><P>Starting job Repeat_of_DEV_File_To_QAD_PO_Header at 23:49 25/01/2023.</P><P>[statistics] connecting to socket on port 3437</P><P>[statistics] connected</P><P>Exception in component tSOAP_1 (Repeat_of_DEV_File_To_QAD_PO_Header)</P><P>java.lang.ClassCastException: class java.util.Date cannot be cast to class java.lang.String (java.util.Date and java.lang.String are in module java.base of loader 'bootstrap')</P><P> at precoro_qad.repeat_of_dev_file_to_qad_po_header_0_1.Repeat_of_DEV_File_To_QAD_PO_Header.tFileInputDelimited_1Process(Repeat_of_DEV_File_To_QAD_PO_Header.java:2414)</P><P> at precoro_qad.repeat_of_dev_file_to_qad_po_header_0_1.Repeat_of_DEV_File_To_QAD_PO_Header.runJobInTOS(Repeat_of_DEV_File_To_QAD_PO_Header.java:3291)</P><P> at precoro_qad.repeat_of_dev_file_to_qad_po_header_0_1.Repeat_of_DEV_File_To_QAD_PO_Header.main(Repeat_of_DEV_File_To_QAD_PO_Header.java:3119)</P><P>[statistics] disconnected</P><P> </P><P>Job Repeat_of_DEV_File_To_QAD_PO_Header ended at 23:49 25/01/2023. [Exit code = 1]</P> Wed, 25 Jan 2023 12:50:15 GMT https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344109#M111798 JY3 2023-01-25T12:50:15Z Re: how to provide the date input variable into tSOAP https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344110#M111799 <P>This line here gives you the reason for this.....</P><P> </P><P>java.lang.ClassCastException: class java.util.Date cannot be cast to class java.lang.String (java.util.Date and java.lang.String are in module java.base of loader 'bootstrap')</P><P> </P><P>The column is a Date column. You cannot cast from Date to String. You will need to change the column to be a String and convert the Date to be formatted as a String before the data is passed to the column. You can use the tConvertType component to do this. This is described here...</P><P> </P><P>https://help.talend.com/r/en-US/8.0/processing/tconverttype-standard-properties</P><P> </P> Wed, 25 Jan 2023 12:59:07 GMT https://community.qlik.com/t5/Talend-Studio/how-to-provide-the-date-input-variable-into-tSOAP/m-p/2344110#M111799 Anonymous 2023-01-25T12:59:07Z