Hello guys, could you help me please. I'm running...
# gd-beginners
t
Hello guys, could you help me please. I'm running this chart without good data and it's giving this error. I can't identify the problem, when I run it in Cloud Connect it runs without problems, but when I run it directly in Good Data, it gives this error.
m
Hello Tomas, from our logs, I can see the ETL is failing due to a non printable character in your data:
Copy code
"Can't parse line \"%s\" in %s, probably wrong parsing parameters or inappropriate usage of escape character.\",\"parameters\":[\"8105\",\"upload_dataset.td_orcamento.csv\"]
It is indeed possible that those are getting through when running the graph locally. There are few options how to troubleshoot this further: a) review content of source records close to row mentioned in error message. b) you can remove non-printable character using the component: Reformat c) CC CTL2 function removeNonPrintable(string) should eliminate this type of error. More information can be found here: String Functions
t
reports that the error is in the escape character, but there is none. How could you do this in format?
m
The line in question is not specified in the logs, hence the scape character as a placeholder, but you should look instead for any non printable character in the source data. The method specified in point c usually takes care of this, but if you are still experiencing issues, please do let us know.
t
I've done everything and it didn't solve it, I've attached the complete error log.
m
The issue with the non printable characters was resolved, but the new error is due to a improperly formatted date field:
Copy code
Component [DW_TF_ORCAMENTO:DW_TF_ORCAMENTO] finished with status ERROR.:
    f0120dtaemissao (date) cannot be set to "Mar 22 2024 12:00AM" - doesn't match defined format "yyyy-MM-dd HH:mm:ss" in field 12 ("f0120dtaemissao"), metadata "TF_ORCAMENTO"; value: 'Mar 22 2024 12:00AM':
    Unparseable date: "Mar 22 2024 12:00AM" at position 0
Could you take a look?