Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When reloading my data i always get the following error:
GeoAnalytics - Error: Connector reply error: QVX_SYNTAX_ERROR: *Could not connect to route module: Server returned HTTP response code: 504 for URL
So i found this article: https://support.qlik.com/articles/000061074
Based on this advice, i have built a loop that sends a maximum of 100 records to geoanalytics. In total there are about 14.800 records in the datasets. The loop always loads a qvd with 100 records, runs the closest operation code, and saves a qvd with the new information of the geoanalytics plus connector. This works very well for the first 4000 records. Then comes a batch, where i always get a timeout. Then for the following, let's say 200 records, everything runs again, and then again a timeout.
This is the exact error message:
Der folgende Fehler ist aufgetreten:
Connector reply error: QVX_SYNTAX_ERROR: *Route request failed with error: 504,
Der Fehler ist hier aufgetreten:
[ClosestAssociations]:
SQL SELECT [Ziele_Werke_RelationId], [PlzTo], [CityFrom], [Ziele_Werke_Distance], [Ziele_Werke_Route] FROM Closest(costUnit='Kilometers', distance='999', distanceType='car', closestCount='1', dataset1='Ziele', dataset2='Werke')
DATASOURCE Ziele INLINE tableName='Ziele', tableFields='PlzTo,LatTo,LongTo', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {PlzTo LatTo LongTo
91094 49,6405 11,071
91099 49,6634 11,0708
91257 49,7522 11,5419
91278 49,7713 11,4078
91282 49,6817 11,4177
91286 49,7 11,35
91287 49,6524 11,4693
91289 49,8122 11,5827
91320 49,7815 11,1817
91322 49,6443 11,2497
91327 49,769 11,3384
91330 49,7696 11,057
91332 49,863 11,1719
91336 49,6934 10,9988
91344 49,8465 11,3481
91346 49,8 11,2667
91347 49,8837 11,2269
91349 49,7018 11,2575
91352 49,7591 10,9795
91353 49,6895 11,0322
91355 49,6607 11,3227
91356 49,7333 11,15
91358 49,6824 11,1433
91359 49,7095 11,1722
91361 49,6897 11,1021
91362 49,7545 11,1743
91364 49,823 11,1891
91365 49,75 11,1167
91367 49,6309 11,2537
91369 49,7133 11,1356
95030 50,3173 11,8961
95032 50,2953 11,9103
95100 50,1706 12,1305
95111 50,2492 12,0342
95119 50,3303 11,7046
95126 50,2228 11,935
95131 50,2846 11,6249
95138 50,3665 11,6444
95145 50,2624 11,9348
95152 50,317 11,7502
95158 50,1519 11,9483
95163 50,1022 11,8885
95168 50,1301 12,0023
95173 50,1997 12,085
95176 50,2667 11,85
95179 50,3333 11,6
95180 50,3747 11,7785
95183 50,3667 11,95
95183 50,3907 11,8733
95183 50,3667 11,9333
95185 50,3221 11,9978
95186 50,1 12,0833
95188 50,3752 11,7207
95189 50,3333 11,85
95191 50,3 11,8
95192 50,3833 11,6762
95194 50,3 12,05
95195 50,0833 11,9833
95197 50,2783 11,7417
95199 50,1064 12,102
95213 50,1895 11,7882
95233 50,2356 11,7159
95234 50,1621 11,8435
95236 50,1455 11,6913
95237 50,1833 11,85
95239 50,1333 11,8
95326 50,1007 11,4503
95336 50,0999 11,3766
95339 50,0919 11,5803
95339 50,1057 11,6052
95346 50,1643 11,5035
95352 50,1731 11,6339
95355 50,228 11,5551
95356 50,2031 11,5936
95358 50,1552 11,5648
95359 50,0367 11,352
95361 50,1 11,5333
95362 50,1396 11,5776
95364 50,1264 11,5597
95365 50,2 11,4667
95367 50,0667 11,55
95369 50,1333 11,5167
95445 49,9431 11,5592
95447 49,9481 11,5783
95460 50,0456 11,6724
95463 49,9817 11,6139
95466 49,9333 11,7833
95466 49,9416 11,7221
95469 49,8713 11,7812
95473 49,87 11,5607
95473 49,8333 11,6833
95473 49,845 11,6268
95482 50,0954 11,7377}
DATASOURCE Werke INLINE tableName='Werke', tableFields='CityFrom,LatFrom,LongFrom', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {CityFrom LatFrom LongFrom
Tovačov 49,4189 17,28583
Vrdy 49,92574 15,47019
Betonelemente GmbH 51,68386 7,93988
Betonelemente Süd GmbH 48,29701 10,06841
Rakowice Male 51,15575 15,54206
Torun 53,05498 18,69175}
The error always occurs with the same batches. does anyone have an idea what the error could be or how i can get to the bottom of it?