Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ----------------------------------- */