What can be the reason for the errormessage in the title above here?
The loadscript has been working fine for several years, but this problem started recently and I can not figure out why.
Here is adump of the Script Execution Progress window:
Connected
AMIS_tmp << OppdragAmisUTM (row-based qvd optimized) 2 Lines fetched
LocationsForSone32 << OppdragAmisUTM (row-based qvd optimized) 2 Lines fetched
Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Could not parse line 1:0 mismatched input '<EOF>' expecting {SELECT, ID}
[Dataset]:
SQL SELECT * FROM Load(dataset='Dataset')
DATASOURCE Dataset INLINE tableName='LocationsForSone32',tableFields='Key,x,y',geometryType='POINTLATLON',loadDistinct='NO',suffix='',crs='EPSG:25832' {Key x y
1266661 7151839 620403
1260045 7101296 621836}
Here is the loadscript:
LocationsForSone32:
LOAD
%AmisKey as Key,
x_kordinat as x,
y_kordinat as y
FROM $(TransformFolder)\OppdragAmisUTM.qvd (qvd);
/* Generated by Idevio GeoAnalytics for operation Load ---------------------- */
Let [DatasetInlineTable] = 'Key' & Chr(9) & 'x' & Chr(9) & 'y';
Let numRows = NoOfRows('LocationsForSone32');
Let chunkSize = 1000;
Let chunks = numRows/chunkSize;
For n = 0 to chunks
Let chunkText = '';
Let chunk = n*chunkSize;
For i = 0 To chunkSize-1
Let row = '';
Let rowNr = chunk+i;
Exit for when rowNr >= numRows;
For Each f In 'Key', 'x', 'y'
row = row & Chr(9) & Replace(Replace(Replace(Replace(Replace(Replace(Peek('$(f)', $(rowNr), 'LocationsForSone32'), Chr(39), '\u0027'), Chr(34), '\u0022'), Chr(91), '\u005b'), Chr(47), '\u002f'), Chr(42), '\u002a'), Chr(59), '\u003b');
Next
chunkText = chunkText & Chr(10) & Mid('$(row)', 2);
Next
[DatasetInlineTable] = [DatasetInlineTable] & chunkText;
Next
chunkText=''
[Dataset]:
SQL SELECT * FROM Load(dataset='Dataset')
DATASOURCE Dataset INLINE tableName='LocationsForSone32',tableFields='Key,x,y',geometryType='POINTLATLON',loadDistinct='NO',suffix='',crs='EPSG:25832' {$(DatasetInlineTable)}
;
[DatasetInlineTable] = '';
/* End Idevio GeoAnalytics operation Load ----------------------------------- */
