Cognos ( postgres ) connection failing SQL
I have a connection defined from Cognos Analytics to an Incorta instance 4.9 - the connection tests fine ( currently ) but when I try to pull data I get an error ( file attached )
Data source adapter error: org.postgresql.util.PSQLException: ERROR: Failed to get metadata ( later in the file it give error when falling back to spark )
The ( an ) odd thing is that I *can* pull metadata ( "table" and column names ) but get this error when trying to query the data.
Spark is running.
Any ideas on where to start with this?
adding - down the log file a bit I find this:
ERROR: [18:17:12] [gosales | System | Init] INC_090101001: IO Error while reading snapshot from file: . Please make sure that the latest snapshot file (from the last load job) was properly written. [com.incorta.engine.io.SchemaHandler.getSchemaOnDiskTimestamp]
ERROR: [18:17:12] [gosales | System | Init] java.io.FileNotFoundException: /home/ec2-user/IncortaAnalytics/Tenants/gosales/snapshots/TEMPORARY_OBJECTS_SCHEMA_58.zxs (No such file or directory)