Unexpected exception while translating results: [MetaMatrix][SQLServer JDBC Driver]null
Issue
-
We recently migrated from Microsoft SQL Server 2005 to Microsoft SQL Server 2008. When testing this, one of the queries gives an error when I deploy the VDB to the 5.5.4 MetaMatrix Server, I receive the following error:
Jun 01, 2011 06:27:19.294 [QueryProcessorQueue_Worker_62|0.1.2.3] ERROR <com.metamatrix.core|0> Unexpected exception while translating results: [MetaMatrix][SQLServer JDBC Driver]null java.sql.SQLException: [MetaMatrix][SQLServer JDBC Driver]null
-
But this query works perfectly fine when I execute it from the 5.5.4 Designer's SQL Explorer and on my local 5.5.3 MetaMatrx Server
Environment
- MetaMatrix Enterprise Server 5.5.4
- Microsoft SQL Server 2008
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.