Skip to Content
Former Member
Oct 20, 2011 at 07:58 PM

PI JDBC Commmunication Channel Error


Hello Experts,

I am facing problems with the JDBC communication channel in PI. I have a sender JDBC communication channel which is trying to execute a distributed query in a SQL Server 2000 database. My query looks like:

select * from [ServerName].[DatabaseName].[dbo].[ViewName]

The reason I have to specify the Server Name and Database Name is because I am connecting to a different database on a different server through PI and then trying to execute the above query. All the required database permissions have been set up correctly and this query works fine if I execute it on SQL Server Management Studio. But in RWB in channel monitoring I am seeing these errors.

Database-level error reported by JDBC driver while executing statement 'select * from [ServerName].[DatabaseName].[dbo].[Viewname] where role_id is not null'. The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.'. For details, contact your database server vendor.

This looks like a database error but I wanted to check if there could be a problem with JDBC driver used by PI.

Any help, ideas will be greatly appreciated.