Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Could not parse line 1:0 mismatched input '<EOF>' expecting {SELECT, ID}
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=''
