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?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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)

  • This would suggest a problem with your schema's data.  Are you able to build an Incorta dashboard against this schema successfully?

    • Dan Brock  Hi Dan - yes, it works fine in Incorta.  I have a case open ( 9900 ) w/ an INC filed:  INC-26960    


      We were able to get it working by disabling a system property on the server.   

Like Follow
  • 1 mth agoLast active
  • 3Replies
  • 15Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!