Error Refreshing iSeries Extract After Upgrading Tableau Server "Check the Data Connection page for necessary updates to an access token or embedded credentials"

Version 1

    Issue

    After upgrading Tableau Server, previously working extracts pointing to DB2 on iSeries using an ODBC Connection, the refresh fails with the error "Check the Data Connection page for necessary updates to an access token or embedded credentials"

     

    • The following errors will appear in the Tableau Server logs at Logs/Backgrounder/Backgrounder.log:
      • (,,,) scheduled-background-job-runner-1 : ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: :refresh_extracts java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.DataSourceException: Tableau was unable to generate a query to perform this operation.
    • The following errors will also appear Tableau Server logs at Logs/Vizqlserver/Logs/Backgrounder.txt:
      • Unable to connect using the DSN named ",<iSeries Server Name>". Check that the DSN exists and is a valid connection AND
      • Connected to Generic ODBC version \"07.01.0015\", recognized as \"7.1.15\" AND
      • DataSourceException (type=Unknown): [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.\n AND
      • GenericODBCConnection::CheckTopSupport: failed to detect top style via SQLRelationCheckTop. Capability customization may be required
    Environment
    • Tableau Server
    • ODBC
    • iSeries DB2
    Resolution

    Connecting to an IBM DB2 data source on iSeries platform is currently not supported. However, you may have some success connecting to this data source on the ISeries platform using the following suggestions: 

    Root CauseConnecting to IBM DB3 is not supported on iSeries platforms. Functionality may not persist after upgrading
    Additional Information

    For more information about the capabilities and limitations of connecting to unsupported data sources using the generic ODBC connections, see Tableau and ODBC and Customizing and Tuning ODBC Connections

    Related Links

    "Error 'Cannot connect to IBM DB2 database" http://kb.tableau.com/articles/issue/error-cannot-connect-db2-running-iseries