Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: ErrorSource: (null), ErrorMsg: (null) on load from access database

I've got a nice dashboard built pulling lots of data from an access database. Everything is working fine. Today I added a new table with some staffing information in it. If I run the query in the access database, all is well. Data shows up with correct values, no errors, etc. When I add it to the load script, it gives me a "Error: ErrorSource: (null), ErrorMsg: (null)" message and won't load that table. No idea what the issue is. The statement is:

SQL SELECT ChgNo,
Company,
dateserial(year(DataDate), month(DataDate), 1) as Monthly_DataDate,
Employee,
FTEs,
Location,
OT,
PED,
Position,
PositionID,
RateTableID,
ResID,
Source
FROM
`Master Staffing Database Format`;

Any ideas?

Labels (1)
10 Replies
Not applicable
Author

Found the error. Apparently Position is a reserved word in either Qlikview or the OLEDB connection. Changing the field name (not aliasing it) allowed the data to load without issue.