Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
dwmorris
Contributor II
Contributor II

Connector Reply Error due to duplicate field name in MSAccess query

I am posting this in case someone else has a similar issue using QlikSenseDesktop and they get and unexplained "Connector Reply Error"

I had an existing data load script in the data load editor which was grabbing data from a MS Access database via an odbc connection.

My data source/table was an Access query.

Previously I had manually added new fields to the load editor script  without any problems.

After a specific new field I started getting a "Connector Reply Error" *  when trying to load data.

I learned that my Query in MS Access had the same field name listed twice (the new field I was trying to add to the script).

It makes sense now that I see it.  but the problem was difficult to identify.

Note: If you preview your data with data connections->'select data' the duplicate fields  may be identified by field names starting with "expr:".

I hope this helps.

0 Replies