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 siskbr...@peoplepc.com 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://remote server: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
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 siskbr...@peoplepc.com wrote: From: bruce sisk siskbr...@peoplepc.com 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 stra...@unt.edu 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: !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot ...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): !--database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/-- database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot 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. !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database_mysqldisabled driver=com.mysql.jdbc.Driver initial=0 max-active=75 max-idle=25 min-idle=0 password=password url=jdbc:mysql://localhost/rkm user=root/ database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver 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/ database_sybasedisabled 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/ database_oracledisabled 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
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 siskbr...@peoplepc.com 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://remote server: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.netsponsor%3armisoluti...@verizon.netARSlist: 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.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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://remote server: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
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: !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot ...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): !--database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/-- database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot 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. !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database_mysqldisabled driver=com.mysql.jdbc.Driver initial=0 max-active=75 max-idle=25 min-idle=0 password=password url=jdbc:mysql://localhost/rkm user=root/ database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver 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/ database_sybasedisabled 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/ database_oracledisabled 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 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://remote server:1433' ERROR: kms.sql.SQLServer: Failed to create
Re: RKM No Suitable Driver
Does RKM 7.5 run against a 7.1 ARS?? -Original Message- From: strauss stra...@unt.edu 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: !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot ...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): !--database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:microsoft:sqlserver://localhost:1433 user=RKMAdmin/-- database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver password=!!gdfadfcdfddhglda schema_name=rkm type=sqlserver url=jdbc:sqlserver://localhost:1433 user=RKMAdmin/ /RKM_boot 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. !-- Shipping default is SQLServer2000 on localhost:1433(default install) -- database_mysqldisabled driver=com.mysql.jdbc.Driver initial=0 max-active=75 max-idle=25 min-idle=0 password=password url=jdbc:mysql://localhost/rkm user=root/ database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver 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/ database_sybasedisabled 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/ database_oracledisabled 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 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
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://remote server: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
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 database driver element. It is similar to the following statement: database driver=com.microsoft.jdbc.sqlserver.SQLServerDriver initial=0 max-active=75 max-idle=25 min-idle=0 password=password url=jdbc:microsoft:sqlserver://server:1433 user=RKM_Admin/ 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://server:1433 The database driver element should be similar to the following statement: database driver=com.microsoft.sqlserver.jdbc.SQLServerDriver initial=0 max-active=75 max-idle=25 min-idle=0 password=password url=jdbc:sqlserver://server:1433 user=RKM_Admin/ 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 jdso...@shyle.net 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://remote server: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