Notifications

245 views

Description

Data source with CSV format with use_last_run_datetime set to true but empty last_run_database_field fails with "Syntax Error. Encountered":



Steps to Reproduce

1. Create a Data source, name = test_1. import set table u_vtest, attachment
    IMPORTANT: Set use_last_run_datetime = true, last_run_database_field = "" (empty).

2. Attach a csv file test.csv

3 Save

4. Click "Load All Records"

Observe the error:

Syntax Error. Encountered " "ASC" "ASC "" at line 1, column 61.
Was expecting one of:
<UNSIGNEDINT> ...
<UNSIGNEDNUMBER> ...
"NULL" ...
"CURRENT_DATE" ...
"?" ...
"LOWER" ...
"ROUND" ...
"UPPER" ...
"COUNT" ...
"MAX" ...
"MIN" ...
<NAME> ...
<STRING> ...
"-" ...
"(" ...
```

5. Click on "Test Load 20 Records"

Observe it fails with the message "Can't access columns with empty name by name".

CSV imports should instead ignore the use_last_run_datetime settings.



Workaround

This issue is under investigation. As a workaround, on the Data Sources with CSV format, set "Use last run datetime" to false.

 


Related Problem: PRB1253023

Seen In

Jakarta

Fixed In

London

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-02 12:00:27
Published:2018-02-20