TCP/IP Connection Issue

[JannaB]

Can someone please offer me some insight here? I am running PRPC 5.4,
MSSQL database, Tomcat 5.x....and when I start up in Tomcat, I get the
following stack trace -- can anyoen please help me get past this?
Thank you so much! -Janna

2009-04-04 18:47:02,718 [ main] [ ] [
] ( etier.engine.EngineStartup) ERROR - PegaRULES initialization
failed. S
erver: unknown
com.pega.pegarules.pub.database.ConnectionException: Database-
General Problem
encountered when getting connection for database pegarules
0 08S01
The TCP/IP connection to the host has failed.
java.net.ConnectException: Connec
tion refused: connect
From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 08S01, Error code 0:
com.microsoft.sqlserver.jdbc.SQLServer
Exception: The TCP/IP connection to the host has failed.
java.net.ConnectExcept
ion: Connection refused: connect
at
com.pega.pegarules.engine.database.ExceptionInformation.createExcepti
onDueToDBFailure(ExceptionInformation.java:146)
at
com.pega.pegarules.engine.database.ConnectionManager.getConnection(Co
nnectionManager.java:1206)
at
com.pega.pegarules.engine.database.ConnectionManager.getConnection(Co
nnectionManager.java:838)
at
com.pega.pegarules.engine.database.ConnectionManager.rebuildDBNameDef
initions(ConnectionManager.java:2092)
at com.pega.pegarules.engine.database.ConnectionManager.<init>
(Connectio
nManager.java:495)

[Raffaele Bello]

Are you sure your instance of MSSQL Server is up and running?

--
Hakuna Matata - No Wahala
London, UK

[JannaB]

At first, I found the MSSQL server was not up and running. So I fixed
this, now I get the following stack trace, and I am using the
prconfig.xml file underneath this stack trace:

2009-04-05 00:22:57,578 [ main] [ ] [
] (ine.database.ConnectionManager) INFO - Failover
database: none
2009-04-05 00:22:57,656 [ main] [ ] [
] (iveutil.EnvironmentDiagnostics) INFO - Using Java 1.5
Thread.getAllStackT
races() for thread dumps
2009-04-05 00:22:58,796 [ main] [ ] [

] ( etier.engine.EngineStartup) ERROR - PegaRULES initialization
failed. S
erver: unknown
com.pega.pegarules.pub.database.ConnectionException: Database-
General Problem
encountered when getting connection for database pegarules
0 08S01
The TCP/IP connection to the host has failed.
java.net.ConnectException: Connec
tion refused: connect
From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 08S01, Error code 0:
com.microsoft.sqlserver.jdbc.SQLServer
Exception: The TCP/IP connection to the host has failed.
java.net.ConnectExcept
ion: Connection refused: connect
at
com.pega.pegarules.engine.database.ExceptionInformation.createExcepti
onDueToDBFailure(ExceptionInformation.java:146)
at
com.pega.pegarules.engine.database.ConnectionManager.getConnection(Co
nnectionManager.java:1206)

the file C:\tomcat\webapps\prweb\WEB-INF\classes\prconfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<pegarules>
<env name="Identification/SystemName" value="pega" />
<env name="Initialization/PersistRequestor" value="OnTimeout" />
<env name="Initialization/usenativelibrary" value="true" />
<env name="Initialization/explicitTempDir" value="C:/prpc/temp/
prweb" />
<env name="initialization/displayexceptiontraceback" value="true" />

<!-- use the following entry to specify resource adapter logging
level at startup,
acceptable values: SEVERE,WARN,INFO,CONFIG,FINE,FINER,FINEST -->
<env name="pradapter/logginglevel" value="INFO" />

<env name="agent/enable" value="true" />

<env name="initServices/initEmail" value="true" />
<env name="initServices/initFile" value="true" />
<env name="initServices/initJMS" value="true" />
<env name="initServices/initMQ" value="true" />


<env name="database/baseTable/name" value="pr4_base" />
<!-- use the following to write in specific storage form other than
default -->
<env name="database/storageVersion" value="6"/>

<env name="database/databases/PegaRULES/dataSource" value="java:comp/
env/jdbc/PegaRULES"/>

<!--
Pegasystems recommends that you use Application Server connection
pooling to the database for Websphere and
Weblogic. These examples are provided if you need to use Pega
Connection Pooling for Tomcat or for testing purposes.
If you are using Application server connection pooling, there is no
longer a need to edit this file.

Oracle 9i (Type 2) oracle.jdbc.OracleDriver
jdbc:oracle:oci:@your_tns_name
Oracle 10g (Type 4) oracle.jdbc.OracleDriver
jdbc:oracle:thin:@serverName:1521:db
IBM DB/2 Type 4 com.ibm.db2.jcc.DB2Driver
jdbc:db2://serverName:port/dbName
SQL Server 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://serverName:
1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}
SQL Server 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://localhost:
1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}

-->

<env name="database/drivers"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" /
>
<env name="database/databases/PegaRULES/url" value="jdbc:sqlserver://
localhost:
1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}" />
<env name="database/databases/PegaRULES/userName" value="pega" />
<env name="database/databases/PegaRULES/password" value="rulez" />

</pegarules>

thank You. -Janna

[zuorio]

Hi

I didn´t have time to check all your configuration file (I'm on
holidays :)) but it doesn´t sounds good to me:

<env name="database/drivers"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDrive
r" /

if you are using MSSQL server

Check also url, user and password are correct and also that you have
enough connections availaible

Cheers,

Raff

> value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDrive r" /

[JannaB]

To check the URL, is there a way to see what the values in the
parameters in prconfig.xml as I have it are? A way to see the values,
of, say ${SystemName} in my the following in my prconfig.xml:

<env name="database/databases/PegaRULES/url" value="jdbc:sqlserver://
localhost:
1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}" />

-Thank You -Janna

[JannaB]

I solved my connection problem (posting the solution herein in case
some future person arrives at this thread via a search, to facilitate
their finding a solution). It was the port. I am using MS SQL Express,
so I had to go in and set the port for TCP IP to match what I had in
the connection string (1433) or vice versa. -Janna

[JannaB]

After I read your post I see I was not getting connection -- so I fix
this and now get the following stack trace (I include prconfig.xml
below it):

2009-04-05 00:22:57,578 [ main] [ ] [
] (ine.database.ConnectionManager) INFO - Failover
database: none
2009-04-05 00:22:57,656 [ main] [ ] [
] (iveutil.EnvironmentDiagnostics) INFO - Using Java 1.5
Thread.getAllStackT
races() for thread dumps

2009-04-05 00:22:58,796 [ main] [ ] [

] ( etier.engine.EngineStartup) ERROR - PegaRULES initialization
failed. S
erver: unknown
com.pega.pegarules.pub.database.ConnectionException: Database-
General Problem
encountered when getting connection for database pegarules
0 08S01
The TCP/IP connection to the host has failed.
java.net.ConnectException: Connec
tion refused: connect
From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 08S01, Error code 0:
com.microsoft.sqlserver.jdbc.SQLServer
Exception: The TCP/IP connection to the host has failed.
java.net.ConnectExcept
ion: Connection refused: connect
at
com.pega.pegarules.engine.database.ExceptionInformation.createExcepti
onDueToDBFailure(ExceptionInformation.java:146)
at
com.pega.pegarules.engine.database.ConnectionManager.getConnection(Co
nnectionManager.java:1206)

The file C:\tomcat\webapps\prweb\WEB-INF\classes\prconfig.xml:

1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}

SQL Server 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://localhost:

1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}

-->

<env name="database/drivers"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" /
>

<env name="database/databases/PegaRULES/url" value="jdbc:sqlserver://
localhost:
1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR
${SystemName}@${NodeName} ${DBName} #${ConnectionID}" />

<env name="database/databases/PegaRULES/userName" value="pega" />
<env name="database/databases/PegaRULES/password" value="rulez" />

</pegarules>

Thank you - Janna