watsonx.ai

watsonx.ai

A one-stop, integrated, end- to-end AI development studio

 View Only
  • 1.  Error when I exported data to a data asset in Modeler flow

    Posted 01/24/20 09:07 AM
    Hello, I tried to export data containing YYYY-MM-DD fields like following to a data asset in Modeler flow.
    Test data used when I got the error message

    But I got the error message below.

    Error

    WDP Connector Error: com.ibm.connect.api.SCAPIException: CDICO9999E: Internal error occurred: Illegal argument error: Unexpected date object type (java.util.Date) (error code: DATA_IO_ERROR)

    It seems that this relate to Date fields, so I omitted two YYYY-MM-DD fields from original data with Filter node. Then I could successfully export data. (I created simple flow to test this issue. The upper flow in the following image failed with the error and the lower flow cloud successfully run without error.)

    How should I do to export YYYY-MM-DD format data?

    ------------------------------
    MANABU ISHII
    ------------------------------

    #WatsonStudio


  • 2.  RE: Error when I exported data to a data asset in Modeler flow

    Posted 01/27/20 09:16 AM
    Hello,

    You can use the filler node to convert the field to date. To do this, use the to_date function.
    Attachment follows image of the filler node.

    Regards,
    Rogerio

    ------------------------------
    Rogerio Rocha
    ------------------------------