Re: RKM No Suitable Driver
Bruce..
Could you stop Tomcat.. Clean the Tomcat log directory.. Restart and then
ship the logs? Specifically the catalina.out file.
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Mahendra Mahalkar
Sent: Wednesday, January 27, 2010 1:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: RKM No Suitable Driver
**
Try the last thing is that install mid-tier with the tomcat on separate
box & RKM with the tomcat on the separate box.
Cheers,
Mahendra Mahalkar
On Tue, Jan 26, 2010 at 7:38 AM, bruce sisk
wrote:
So...I spent the weekend wiping this server and reinstalling:
Java 1.6 P18
MS SQL 2005 JDBC drivers 1.2
Mid-tier 7.1 P8 including Tomcat
RKM 7.2
Mid-tier is working and fully able to communicate with the DB.
RKM installed with no issues.
I am unable to complete the Configuration wizard. I get to the screen
where it asks for the info to create the DB objects and I get the error in
the log shown below...Failed to create database objects. No suitable driver.
I have the JDBC on the same server as the RKM install. I have read and
followed ALL of the KB articles that apply or may apply to this. I added a
classpath to the environment varibales...is that correct?? Should it be in
a Tomcat config somewhere?? Is the 1.2 version the correct one to use??
I am sure there are many installations of this out there. I would
appreciate any help.
Thanks,
Bruce Sisk
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:arsl...@arslist.org]on Behalf Of bruce sisk
>Sent: Thursday, January 21, 2010 10:16 PM
>To: arslist@ARSLIST.ORG
>Subject: RKM No Suitable Driver
>
>
>I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with
Tomcat
>and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be
>remnants of a 7.0.x install). Mid-tier works. the .jar files are in
the
>tomcat common lib folder.
>
>I keep getting an error when trying to create the rkm database using
the RKM
>Config Wizard:
>
>ERROR: Diagnostics: Failed to create database connection: Cannot create
JDBC
>driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for
connect
>URL 'jdbc:microsoft:sqlserver://:1433'
>ERROR: kms.sql.SQLServer: Failed to create database objects: No
suitable
>driver
>
>I have a classpath that points to the sqljdbc.jar. It is the 1.2
version of
>the JDBC driver.
>
>I am not getting a login failure so I don't think that is the reason.
>
>I am stumped. I am about ready to wipe the whole server and start
over, but
>I am not sure if that is the solution. Would hate to do all that and
still
>get the same problem.
>
>Below is the details of the log file.
>
>Bruce Sisk
>
>21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database
>connection: Cannot create JDBC driver of class
>'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL
>'jdbc:microsoft:sqlserver://xxx:1433'
>21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521
>21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer
connection
>pool...
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver:
>jdbc.searchserver.SSDriver
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL:
>jdbc:searchserver:SearchServer_5.4
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0
>21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file
not
>specified, using defaults
>21-Jan-10 22:03:25INFO: AppConfig: Configuration settings
successfully
>loaded.
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database
connection...
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver:
>com.microsoft.sqlserver.jdbc.SQLServerDriver
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL:
>jdbc:microsoft:sqlserver://xxx:1433
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password:
>21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create
database
>objects: No suitable driver
>21-Jan-10 22:03:31 DEBUG: AppConfig:
>kms.authentication.SystemConfigurationAuthenticator created.
>
>___
Re: RKM No Suitable Driver
Try the last thing is that install mid-tier with the tomcat on separate box & RKM with the tomcat on the separate box. Cheers, Mahendra Mahalkar On Tue, Jan 26, 2010 at 7:38 AM, bruce sisk wrote: > So...I spent the weekend wiping this server and reinstalling: > > Java 1.6 P18 > MS SQL 2005 JDBC drivers 1.2 > Mid-tier 7.1 P8 including Tomcat > RKM 7.2 > > Mid-tier is working and fully able to communicate with the DB. > RKM installed with no issues. > > I am unable to complete the Configuration wizard. I get to the screen > where it asks for the info to create the DB objects and I get the error in > the log shown below...Failed to create database objects. No suitable driver. > > I have the JDBC on the same server as the RKM install. I have read and > followed ALL of the KB articles that apply or may apply to this. I added a > classpath to the environment varibales...is that correct?? Should it be in > a Tomcat config somewhere?? Is the 1.2 version the correct one to use?? > > I am sure there are many installations of this out there. I would > appreciate any help. > > Thanks, > > Bruce Sisk > > > > >-Original Message- > >From: Action Request System discussion list(ARSList) > >[mailto:arsl...@arslist.org]on Behalf Of bruce sisk > >Sent: Thursday, January 21, 2010 10:16 PM > >To: arslist@ARSLIST.ORG > >Subject: RKM No Suitable Driver > > > > > >I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with > Tomcat > >and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be > >remnants of a 7.0.x install). Mid-tier works. the .jar files are in the > >tomcat common lib folder. > > > >I keep getting an error when trying to create the rkm database using the > RKM > >Config Wizard: > > > >ERROR: Diagnostics: Failed to create database connection: Cannot create > JDBC > >driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect > >URL 'jdbc:microsoft:sqlserver://:1433' > >ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable > >driver > > > >I have a classpath that points to the sqljdbc.jar. It is the 1.2 version > of > >the JDBC driver. > > > >I am not getting a login failure so I don't think that is the reason. > > > >I am stumped. I am about ready to wipe the whole server and start over, > but > >I am not sure if that is the solution. Would hate to do all that and > still > >get the same problem. > > > >Below is the details of the log file. > > > >Bruce Sisk > > > >21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database > >connection: Cannot create JDBC driver of class > >'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL > >'jdbc:microsoft:sqlserver://xxx:1433' > >21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 > >21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection > >pool... > >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: > >jdbc.searchserver.SSDriver > >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: > >jdbc:searchserver:SearchServer_5.4 > >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 > >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 > >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 > >21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file not > >specified, using defaults > >21-Jan-10 22:03:25INFO: AppConfig: Configuration settings successfully > >loaded. > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database > connection... > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: > >com.microsoft.sqlserver.jdbc.SQLServerDriver > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: > >jdbc:microsoft:sqlserver://xxx:1433 > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx > >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: > >21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database > >objects: No suitable driver > >21-Jan-10 22:03:31 DEBUG: AppConfig: > >kms.authentication.SystemConfigurationAuthenticator created. > > > > > >PeoplePC Online > >A better way to Internet > >http://www.peoplepc.com > > > > >___ > >UNSUBSCRIBE or
Re: RKM No Suitable Driver
The no suitable driver all comes down to you JDBC connection defined in KMS_Config.xml you have to make sure you are referencing the driver correctly. RKM 7.5 doesn't integrate out of the box with ARS 7.1 the workflows are different. If you are running ARS 7.2 I recommend RKM 7.2 patch 3 Alan BlakeKnowlysis --- On Mon, 1/25/10, bruce sisk wrote: From: bruce sisk Subject: Re: RKM No Suitable Driver To: arslist@ARSLIST.ORG Date: Monday, January 25, 2010, 9:10 PM Does RKM 7.5 run against a 7.1 ARS?? -Original Message- >From: strauss >Sent: Jan 25, 2010 10:18 PM >To: arslist@ARSLIST.ORG >Subject: Re: RKM No Suitable Driver > >On 7.1 and 7.2 I have had much better luck installing RKM with the JDBC Driver >for SQL Server 2000 installed, even though I was normally using it against a >local install of SQL Server 2005 Standard; the KMS_config.xml file is coded >for that, and is better able to complete the installation. THEN I usually >edit the xml file to change the driver. > > >OOTB: > > password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" >url="jdbc:microsoft:sqlserver://localhost:1433" user="RKMAdmin"/> > > >...and then comment out the old line and add the new line with the correct >syntax for the 2005 driver (.jdbc.sqlserver. get inverted to sqlserver.jdbc): > > > password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" >url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/> > > >I checked several of my RKM 7.2 servers, and all have the 2000 syntax >commented out and the 2005 syntax added. Trying to do this _during_ the >install doesn't work - do it afterwards. > >== > >BTW, in 7.5 they include more possibilities for the db: > >"Out-of-the-box JDBC driver >A JDBC driver is provided with the BMC Remedy Knowledge Management >installation, for Sybase, Oracle®, and MS SQL databases. MySQL databases >requires you to acquire the relevant JDBC driver." > > > max-active="75" max-idle="25" min-idle="0" password="password" >url="jdbc:mysql://localhost/rkm" user="root"/> > initial="0" max-active="75" max-idle="25" min-idle="0" >password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" >url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/> > initial="0" max-active="75" max-idle="25" min-idle="0" password="" >url="jdbc:sybase:Tds:localhost:5000/rkm" user="sa"/> > initial="0" max-active="75" max-idle="25" min-idle="0" password="password" >url="jdbc:oracle:thin:@localhost:1521:orcl" user="system"/> > >...and the installer must have set the syntax to 2005 or later; my db on that >server is SQL Server 2008. It was built in early November, days before WWRUG >2009 as a new install with RKM 7.5.00.001, and I have forgotten whether the >installer even supports SQL Server 2000, or what choices it gave me (and none >of the documentation is helpful in this regard). > >Christopher Strauss, Ph.D. >Call Tracking Administration Manager >University of North Texas Computing & IT Center >http://itsm.unt.edu/ > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org] On Behalf Of bruce sisk >Sent: Monday, January 25, 2010 8:09 PM >To: arslist@ARSLIST.ORG >Subject: Re: RKM No Suitable Driver > >So...I spent the weekend wiping this server and reinstalling: > >Java 1.6 P18 >MS SQL 2005 JDBC drivers 1.2 >Mid-tier 7.1 P8 including Tomcat >RKM 7.2 > >Mid-tier is working and fully able to communicate with the DB. >RKM installed with no issues. > >I am unable to complete the Configuration wizard. I get to the screen where >it asks for the info to create the DB objects and I get the error in the log >shown below...Failed to create database objects. No suitable driver. > >I have the JDBC on the same server as the RKM install. I have read and >followed ALL of the KB articles that apply or may apply to this. I added a >classpath to the environment varibales...is that correct?? Should it be in a >Tomcat config somewhere?? Is the 1.2 version the correct one to use?? > >I am sure there are many installations of this out there. I would appreciate >any help. > >Thanks, > >Bruce Sisk > > > >>-Original Message- >&
Re: RKM No Suitable Driver
Does RKM 7.5 run against a 7.1 ARS?? -Original Message- >From: strauss >Sent: Jan 25, 2010 10:18 PM >To: arslist@ARSLIST.ORG >Subject: Re: RKM No Suitable Driver > >On 7.1 and 7.2 I have had much better luck installing RKM with the JDBC Driver >for SQL Server 2000 installed, even though I was normally using it against a >local install of SQL Server 2005 Standard; the KMS_config.xml file is coded >for that, and is better able to complete the installation. THEN I usually >edit the xml file to change the driver. > > >OOTB: > > password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" > url="jdbc:microsoft:sqlserver://localhost:1433" user="RKMAdmin"/> > > >...and then comment out the old line and add the new line with the correct >syntax for the 2005 driver (.jdbc.sqlserver. get inverted to sqlserver.jdbc): > > > password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" > url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/> > > >I checked several of my RKM 7.2 servers, and all have the 2000 syntax >commented out and the 2005 syntax added. Trying to do this _during_ the >install doesn't work - do it afterwards. > >== > >BTW, in 7.5 they include more possibilities for the db: > >"Out-of-the-box JDBC driver >A JDBC driver is provided with the BMC Remedy Knowledge Management >installation, for Sybase, Oracle®, and MS SQL databases. MySQL databases >requires you to acquire the relevant JDBC driver." > > >initial="0" max-active="75" max-idle="25" min-idle="0" password="password" > url="jdbc:mysql://localhost/rkm" user="root"/> >initial="0" max-active="75" max-idle="25" min-idle="0" > password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver" > url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/> >driver="com.sybase.jdbc2.jdbc.SybDriver" initial="0" max-active="75" > max-idle="25" min-idle="0" password="" > url="jdbc:sybase:Tds:localhost:5000/rkm" user="sa"/> >driver="oracle.jdbc.driver.OracleDriver" initial="0" max-active="75" > max-idle="25" min-idle="0" password="password" > url="jdbc:oracle:thin:@localhost:1521:orcl" user="system"/> > >...and the installer must have set the syntax to 2005 or later; my db on that >server is SQL Server 2008. It was built in early November, days before WWRUG >2009 as a new install with RKM 7.5.00.001, and I have forgotten whether the >installer even supports SQL Server 2000, or what choices it gave me (and none >of the documentation is helpful in this regard). > >Christopher Strauss, Ph.D. >Call Tracking Administration Manager >University of North Texas Computing & IT Center >http://itsm.unt.edu/ > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org] On Behalf Of bruce sisk >Sent: Monday, January 25, 2010 8:09 PM >To: arslist@ARSLIST.ORG >Subject: Re: RKM No Suitable Driver > >So...I spent the weekend wiping this server and reinstalling: > >Java 1.6 P18 >MS SQL 2005 JDBC drivers 1.2 >Mid-tier 7.1 P8 including Tomcat >RKM 7.2 > >Mid-tier is working and fully able to communicate with the DB. >RKM installed with no issues. > >I am unable to complete the Configuration wizard. I get to the screen where >it asks for the info to create the DB objects and I get the error in the log >shown below...Failed to create database objects. No suitable driver. > >I have the JDBC on the same server as the RKM install. I have read and >followed ALL of the KB articles that apply or may apply to this. I added a >classpath to the environment varibales...is that correct?? Should it be in a >Tomcat config somewhere?? Is the 1.2 version the correct one to use?? > >I am sure there are many installations of this out there. I would appreciate >any help. > >Thanks, > >Bruce Sisk > > > >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:arsl...@arslist.org]on Behalf Of bruce sisk >>Sent: Thursday, January 21, 2010 10:16 PM >>To: arslist@ARSLIST.ORG >>Subject: RKM No Suitable Driver >> >> >>I am installing RKM 7.2 on a Windows
Re: RKM No Suitable Driver
On 7.1 and 7.2 I have had much better luck installing RKM with the JDBC Driver for SQL Server 2000 installed, even though I was normally using it against a local install of SQL Server 2005 Standard; the KMS_config.xml file is coded for that, and is better able to complete the installation. THEN I usually edit the xml file to change the driver. OOTB: ...and then comment out the old line and add the new line with the correct syntax for the 2005 driver (.jdbc.sqlserver. get inverted to sqlserver.jdbc): I checked several of my RKM 7.2 servers, and all have the 2000 syntax commented out and the 2005 syntax added. Trying to do this _during_ the install doesn't work - do it afterwards. == BTW, in 7.5 they include more possibilities for the db: "Out-of-the-box JDBC driver A JDBC driver is provided with the BMC Remedy Knowledge Management installation, for Sybase, Oracle®, and MS SQL databases. MySQL databases requires you to acquire the relevant JDBC driver." ...and the installer must have set the syntax to 2005 or later; my db on that server is SQL Server 2008. It was built in early November, days before WWRUG 2009 as a new install with RKM 7.5.00.001, and I have forgotten whether the installer even supports SQL Server 2000, or what choices it gave me (and none of the documentation is helpful in this regard). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of bruce sisk Sent: Monday, January 25, 2010 8:09 PM To: arslist@ARSLIST.ORG Subject: Re: RKM No Suitable Driver So...I spent the weekend wiping this server and reinstalling: Java 1.6 P18 MS SQL 2005 JDBC drivers 1.2 Mid-tier 7.1 P8 including Tomcat RKM 7.2 Mid-tier is working and fully able to communicate with the DB. RKM installed with no issues. I am unable to complete the Configuration wizard. I get to the screen where it asks for the info to create the DB objects and I get the error in the log shown below...Failed to create database objects. No suitable driver. I have the JDBC on the same server as the RKM install. I have read and followed ALL of the KB articles that apply or may apply to this. I added a classpath to the environment varibales...is that correct?? Should it be in a Tomcat config somewhere?? Is the 1.2 version the correct one to use?? I am sure there are many installations of this out there. I would appreciate any help. Thanks, Bruce Sisk >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org]on Behalf Of bruce sisk >Sent: Thursday, January 21, 2010 10:16 PM >To: arslist@ARSLIST.ORG >Subject: RKM No Suitable Driver > > >I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat >and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be >remnants of a 7.0.x install). Mid-tier works. the .jar files are in the >tomcat common lib folder. > >I keep getting an error when trying to create the rkm database using the RKM >Config Wizard: > >ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC >driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect >URL 'jdbc:microsoft:sqlserver://:1433' >ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable >driver > >I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of >the JDBC driver. > >I am not getting a login failure so I don't think that is the reason. > >I am stumped. I am about ready to wipe the whole server and start over, but >I am not sure if that is the solution. Would hate to do all that and still >get the same problem. > >Below is the details of the log file. > >Bruce Sisk > >21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database >connection: Cannot create JDBC driver of class >'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL >'jdbc:microsoft:sqlserver://xxx:1433' >21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 >21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 >21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection >pool... >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: >jdbc.searchserver.SSDriver >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: >jdbc:searchserver:SearchServer_5.4 >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 >21-Jan-10
Re: RKM No Suitable Driver
So...I spent the weekend wiping this server and reinstalling: Java 1.6 P18 MS SQL 2005 JDBC drivers 1.2 Mid-tier 7.1 P8 including Tomcat RKM 7.2 Mid-tier is working and fully able to communicate with the DB. RKM installed with no issues. I am unable to complete the Configuration wizard. I get to the screen where it asks for the info to create the DB objects and I get the error in the log shown below...Failed to create database objects. No suitable driver. I have the JDBC on the same server as the RKM install. I have read and followed ALL of the KB articles that apply or may apply to this. I added a classpath to the environment varibales...is that correct?? Should it be in a Tomcat config somewhere?? Is the 1.2 version the correct one to use?? I am sure there are many installations of this out there. I would appreciate any help. Thanks, Bruce Sisk >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org]on Behalf Of bruce sisk >Sent: Thursday, January 21, 2010 10:16 PM >To: arslist@ARSLIST.ORG >Subject: RKM No Suitable Driver > > >I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat >and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be >remnants of a 7.0.x install). Mid-tier works. the .jar files are in the >tomcat common lib folder. > >I keep getting an error when trying to create the rkm database using the RKM >Config Wizard: > >ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC >driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect >URL 'jdbc:microsoft:sqlserver://:1433' >ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable >driver > >I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of >the JDBC driver. > >I am not getting a login failure so I don't think that is the reason. > >I am stumped. I am about ready to wipe the whole server and start over, but >I am not sure if that is the solution. Would hate to do all that and still >get the same problem. > >Below is the details of the log file. > >Bruce Sisk > >21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database >connection: Cannot create JDBC driver of class >'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL >'jdbc:microsoft:sqlserver://xxx:1433' >21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 >21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 >21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection >pool... >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: >jdbc.searchserver.SSDriver >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: >jdbc:searchserver:SearchServer_5.4 >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 >21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 >21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file not >specified, using defaults >21-Jan-10 22:03:25INFO: AppConfig: Configuration settings successfully >loaded. >21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection... >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: >com.microsoft.sqlserver.jdbc.SQLServerDriver >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: >jdbc:microsoft:sqlserver://xxx:1433 >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx >21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: >21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database >objects: No suitable driver >21-Jan-10 22:03:31 DEBUG: AppConfig: >kms.authentication.SystemConfigurationAuthenticator created. > > >PeoplePC Online >A better way to Internet >http://www.peoplepc.com > >___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" PeoplePC Online A better way to Internet http://www.peoplepc.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: RKM No Suitable Driver
To set the database driver for MS-SQL 2005 Open the kms_config.xml file . The kms_config.xml file is located in the following deffault folder: \BMC Remedy Knowledge Management\data\kms_conf Locate the element. It is similar to the following statement: Make the following changes: Change the driver attribute to the following value: database driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" Change the url attribute to the following value: url="jdbc:sqlserver://:1433" The element should be similar to the following statement: Save the kms_config.xml file. Restart web services. For Apache Tomcat, stop and start the Apache Tomcat service. Thanks & Regards, Mahendra Mahalkar On Fri, Jan 22, 2010 at 12:04 PM, Joe D'Souza wrote: > Bruce, > > Have you installed the 2005 SQL client? It's not a thick client as it used > to be in the past but just a few dll files etc that get installed. > > If so, can you resolve / ping the SQL server by the remote server name you > have provided? Maybe it requires a FQDN in case you are supplying just the > machine name. Also the default port that you are using 1433, is that what > the SQL server is configured to use or have the defaults been changed? > > I know you said you aren't getting a login failure so if any of the above > didn't check correctly, that is what you would be getting. But I just > thought you could check that anyways just in case the error reporting was > faulty. > > Does the system and application event log throw anything more that may be > of > interest to you? > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of bruce sisk > Sent: Thursday, January 21, 2010 10:16 PM > To: arslist@ARSLIST.ORG > Subject: RKM No Suitable Driver > > > I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with > Tomcat > and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be > remnants of a 7.0.x install). Mid-tier works. the .jar files are in the > tomcat common lib folder. > > I keep getting an error when trying to create the rkm database using the > RKM > Config Wizard: > > ERROR: Diagnostics: Failed to create database connection: Cannot create > JDBC > driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect > URL 'jdbc:microsoft:sqlserver://:1433' > ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable > driver > > I have a classpath that points to the sqljdbc.jar. It is the 1.2 version > of > the JDBC driver. > > I am not getting a login failure so I don't think that is the reason. > > I am stumped. I am about ready to wipe the whole server and start over, > but > I am not sure if that is the solution. Would hate to do all that and still > get the same problem. > > Below is the details of the log file. > > Bruce Sisk > > 21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database > connection: Cannot create JDBC driver of class > 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL > 'jdbc:microsoft:sqlserver://xxx:1433' > 21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 > 21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection > pool... > 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: > jdbc.searchserver.SSDriver > 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: > jdbc:searchserver:SearchServer_5.4 > 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 > 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 > 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 > 21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file not > specified, using defaults > 21-Jan-10 22:03:25INFO: AppConfig: Configuration settings successfully > loaded. > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection... > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: > com.microsoft.sqlserver.jdbc.SQLServerDriver > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: > jdbc:microsoft:sqlserver://xxx:1433 > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx > 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: > 21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database > objects: No suitable driver > 21-Jan-10 22:03:31 DEBUG: AppConfig: > kms.authentication.SystemConfigurationAuthenticator created. > > > PeoplePC Online > A better way to Internet >
Re: RKM No Suitable Driver
Bruce, Have you installed the 2005 SQL client? It's not a thick client as it used to be in the past but just a few dll files etc that get installed. If so, can you resolve / ping the SQL server by the remote server name you have provided? Maybe it requires a FQDN in case you are supplying just the machine name. Also the default port that you are using 1433, is that what the SQL server is configured to use or have the defaults been changed? I know you said you aren't getting a login failure so if any of the above didn't check correctly, that is what you would be getting. But I just thought you could check that anyways just in case the error reporting was faulty. Does the system and application event log throw anything more that may be of interest to you? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of bruce sisk Sent: Thursday, January 21, 2010 10:16 PM To: arslist@ARSLIST.ORG Subject: RKM No Suitable Driver I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be remnants of a 7.0.x install). Mid-tier works. the .jar files are in the tomcat common lib folder. I keep getting an error when trying to create the rkm database using the RKM Config Wizard: ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://:1433' ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of the JDBC driver. I am not getting a login failure so I don't think that is the reason. I am stumped. I am about ready to wipe the whole server and start over, but I am not sure if that is the solution. Would hate to do all that and still get the same problem. Below is the details of the log file. Bruce Sisk 21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://xxx:1433' 21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection pool... 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: jdbc.searchserver.SSDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: jdbc:searchserver:SearchServer_5.4 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file not specified, using defaults 21-Jan-10 22:03:25INFO: AppConfig: Configuration settings successfully loaded. 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection... 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: com.microsoft.sqlserver.jdbc.SQLServerDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: jdbc:microsoft:sqlserver://xxx:1433 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: 21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver 21-Jan-10 22:03:31 DEBUG: AppConfig: kms.authentication.SystemConfigurationAuthenticator created. PeoplePC Online A better way to Internet http://www.peoplepc.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
RKM No Suitable Driver
I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be remnants of a 7.0.x install). Mid-tier works. the .jar files are in the tomcat common lib folder. I keep getting an error when trying to create the rkm database using the RKM Config Wizard: ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://:1433' ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of the JDBC driver. I am not getting a login failure so I don't think that is the reason. I am stumped. I am about ready to wipe the whole server and start over, but I am not sure if that is the solution. Would hate to do all that and still get the same problem. Below is the details of the log file. Bruce Sisk 21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://xxx:1433' 21-Jan-10 22:03:25INFO: Diagnostics: Code version: 7.2.00.1521 21-Jan-10 22:03:25INFO: Diagnostics: Config version: 7.2.00.1521 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection pool... 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: jdbc.searchserver.SSDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: jdbc:searchserver:SearchServer_5.4 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 21-Jan-10 22:03:25INFO: HomeFinder: SearchServer properties file not specified, using defaults 21-Jan-10 22:03:25INFO: AppConfig: Configuration settings successfully loaded. 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection... 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: com.microsoft.sqlserver.jdbc.SQLServerDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: jdbc:microsoft:sqlserver://xxx:1433 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: 21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver 21-Jan-10 22:03:31 DEBUG: AppConfig: kms.authentication.SystemConfigurationAuthenticator created. PeoplePC Online A better way to Internet http://www.peoplepc.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
