3 Replies Latest reply on Oct 7, 2016 11:03 AM by Peter Chan

    DB2 extract fresh on Tableau Server error

    Peter Chan

      Desktop version: 9.0

      Server version:9.3.6

      DB2 version:9.7.0.6

       

      Extract refreshes with no errors on Tableau Desktop. However when the workbook is published to Server and the extract is refreshed. We get the following error

       

      "com.tableausoftware.nativeapi.dll.DataSourceException: [IBM][CLI Driver][DB2/LINUXX8664] SQL0420N Invalid character found in a character string argument of the function "INTEGER". SQLSTATE=22018 prepare.xml class DataSourceException"

       

      None of the calculated field contains the "INTEGER" or "INT" function.

       

      Have anyone experience this issue?

       

      Thanks!

      Peter