Cognos BI Server on Linux - Unable to create remote sql server jdbc connection

[xplorerdev]

Hi,

I have a 64Bit Cognos BI Server 10.2.1 (FP 13) running on Centos 7.5 machine. Trying to connect to a remote Windows machine having Sql Server 2012 instance. I have copied sqljdbc4.jar files to /opt/ibm/cognos/c10_64/v5dataserver/lib and /opt/ibm/cognos/c10_64/webapps/p2pd/WEB-INF/lib directories.

Both the connections are failing:

Microsoft SQL Server (OLE DB) / Compatible      Failed      QE-DEF-0285 The logon failed.
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0106 The function "{0}" is not supported.
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()

Microsoft SQL Server (JDBC) / Dynamic      Failed      DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.
DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.
Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[queryChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[queryAsyncHandler] com.cognos.pogo.async.impl.AsyncHandler

Same connection is working fine from another Cognos BI Server 10.2.1 installation on another Windows machine.

Any suggestions/ideas for this linux bit?

Best Regards

[MFGF]

Hi,

I have a 64Bit Cognos BI Server 10.2.1 (FP 13) running on Centos 7.5 machine. Trying to connect to a remote Windows machine having Sql Server 2012 instance. I have copied sqljdbc4.jar files to /opt/ibm/cognos/c10_64/v5dataserver/lib and /opt/ibm/cognos/c10_64/webapps/p2pd/WEB-INF/lib directories.

Both the connections are failing:

Microsoft SQL Server (OLE DB) / Compatible      Failed      QE-DEF-0285 The logon failed.
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0106 The function "{0}" is not supported.
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()

Microsoft SQL Server (JDBC) / Dynamic      Failed      DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.
DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.
Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[queryChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[queryAsyncHandler] com.cognos.pogo.async.impl.AsyncHandler

Same connection is working fine from another Cognos BI Server 10.2.1 installation on another Windows machine.

Any suggestions/ideas for this linux bit?

Best Regards

Hi,

The first error is to be expected - this is saying the OLE-DB link isn't working, but you're not connecting via OLE-DB.

The second error is the more interesting one. Are you seeing any other information in your cogserver.log file? I found a technote which might provide a clue?

http://www-01.ibm.com/support/docview.wss?uid=swg21595001

Cheers!

MF.

[xplorerdev]

Thanks for the reply MF.
Well, this is a fresh install so there is no 2nd instance. Also, the content manager url says it's Running.
I have tried DB2 also and getting the same error.

However, the same DB2 and SQL connection work on another windows machine.

Is there something else to be done for Linux environment? Just wondering.

[MFGF]

Thanks for the reply MF.
Well, this is a fresh install so there is no 2nd instance. Also, the content manager url says it's Running.
I have tried DB2 also and getting the same error.

However, the same DB2 and SQL connection work on another windows machine.

Is there something else to be done for Linux environment? Just wondering.

Which files exactly did you copy into v5dataserver/lib and WEB-INF/lib? Is it possible you have multiple versions in there?

MF.

[xplorerdev]

First I copied sqljdbc4.jar in both locations. Bumped Cognos. Tested connection. Did not work.

Then I removed this and copied sqljdbc42.jar. Bumped Cognos. Still did not work.

[sdf]

can you test first if your BI server can reach the Database server via simple ping test. Had this once with a client. Turned out a network issue/ rule in their firewall that does not permit the connection.

just to check to rule out a network connectivity issue.