53 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

Intended Fix Version

London

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

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