KB44541: In MicroStrategy Web 9.3.1, "Database error...Catalog GetColumns failed" error is seen when trying to import data from an Impala 1.x data source

SYMPTOM
The following error is received when users try to import tables from an Impala 1.x data source using a DSN-less connection or using a DSN.
 

Database error <5>: Catalog Get Columns failed. %0d%oaError type: Odbc error. Odbc operation attempted: SQLColumns

 
The database type chosen for the connection is 'Impala 1.x', as shown below:

 
CAUSE
This is a known issue with importing data from an Impala data source in Strategy 9.3.1. This issue is also seen in Strategy 9.4.0.
  
ACTION
Contact Strategy Technical Support for an update on this issue.
 
WORKAROUND
Users on Strategy 9.4.0 can implement the steps below to address this error:

1. Contact Strategy Technical Support to obtain the updated DATABASE.PDS file.
2. Make a backup of the existing DATABASE.PDS file before replacing it with the new file.
3. After obtaining the new PDS file, refer to the following Strategy Knowledge Base document to install the updated database object
4. In this case, the database object 'Impala 1.x' needs to be updated.

KB43537: How to install DBMS objects provided by Strategy Technical Support
 
Users on Strategy 9.3.1 should obtain the updated 'Database_Impala1.x.PDS' file from Strategy Technical Support. After obtaining the file, update the database object as instructed in KB43537.