Everything works fine in Developer, browser gives "An exception was thrown by the data connection" when published

I have a dashboard with a US map (plotting locations), and a few visualizations tied to the selections made on the map via markings.

Everything works perfectly in Tibco Spotfire Developer, but when published and viewed in a browser, any selection crashes out to "An exception was thrown by the data connection"

The data is sitting in a PostGRESQL environment, and other dashboards accessing the same data are fine.

Some troubleshooting I have attempted:

--- Made a different dashboard using the exact same data table: Worked fine

--- Copied the trouble dashboard and removed the map layer: Still throws exception

--- Tried in Chrome and Internet Explorer: No difference

 

I'm at a loss here.

 

3 Comments

ERROR;2017-04-04T09:59:37,594-05:00;2017-04-04 14:59:37,594;093430d1-2b52-4691-ad28-bc74696c1847;2206549978hSpJ;426;akulach.cmp.qrW7g7b3pE6xZNfz;Spotfire.Dxp.Framework.ApplicationModel.NotificationService;"Data connection:

An exception was thrown by the data connection.

Exception text:

System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [42804] ERROR: COALESCE types boolean and "char" cannot be matched;

Error while preparing parameters

   --- End of inner exception stack trace ---

   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)

   at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

   at Spotfire.Dxp.Data.Adapters.PostgreSqlBase.PostgreSqlBaseAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass60.<>c__DisplayClass62.<ExecuteQueryAndCreateTable>b__5e(CancellationToken token)

   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

 

iberger - Sep 17, 2017 - 11:00am ::

ERROR;2017-04-04T09:59:37,594-05:00;2017-04-04 14:59:37,594;093430d1-2b52-4691-ad28-bc74696c1847;2206549978hSpJ;426;akulach.cmp.qrW7g7b3pE6xZNfz;Spotfire.Dxp.Framework.ApplicationModel.NotificationService;"Data connection:

An exception was thrown by the data connection.

Exception text:

System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [42804] ERROR: COALESCE types boolean and "char" cannot be matched;

Error while preparing parameters

   --- End of inner exception stack trace ---

   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)

   at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

   at Spotfire.Dxp.Data.Adapters.PostgreSqlBase.PostgreSqlBaseAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass60.<>c__DisplayClass62.<ExecuteQueryAndCreateTable>b__5e(CancellationToken token)

   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

 

iberger - Sep 17, 2017 - 10:57am ::

Hello.

Please check the Spotfire server/Web Player logs to see what error is thrown when the dashboard fails to load on the Web Player.

 

 

 

Sayali Patil - Sep 15, 2017 - 2:00pm ::
View More Comments + Add a Comment

(1) Answer

Login