5 Replies Latest reply on Jan 21, 2014 10:41 AM by Dharmesh Purohit

    User filter not working when connecting to DB

    Dharmesh Purohit

      Hi all,


      I have defined some user filters and my data source was excel sheet and user filters were working fine with the excel dataset.


      Now we have data in database and when I again try to create the same user filter this is giving me database error.




      This try to create some kind of Session Table that table does not exists.


      Here is full error message.


      DB2 database error 0x80040E37: [DB2] SQL0204N  "SESSION.#Tableau_1_Context" is an undefined name.  SQLSTATE=42704

      The table "[SESSION].[#Tableau_1_Context]" does not exist.

      Unable to connect to the server "hostname". Check that the server is running and that you have access privileges to the requested database.


      Any thoughts?