getting error while looking business rule in MWS

am using webmethods blaze advisor developer to develop the rules
i ahve created the repository in blaze developer.

amd created the project.
created the rules.

i have generated the RMA project to MWS.

sucessfully
deployed to MWS, i can see in MWS Console Administrator—>My Webmethods—>System settings—>Business Rules Settings.

IN Blaze Developer created the repositoiry. with below details.

Repository:CCSClaimRepository
Database User:agservice
Database Password:agservice
Confirm Password:* agservice
URL:jdbc:sqlserver://vms014:1433;databaseName=wmdev

Database Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver

in MWS Console Administration—>Business–>Business Rules.

i can see the Project Name, if i click on project name am getting Rule Maintenance Application screen with below error.

[com.microsoft.sqlserver.jdbc.SQLServerDriver]


Message from webpage

******* Use Ctrl-C to copy this text to the clipboard *******

com.blazesoft.repository.base.NdRepositoryRuntimeException: Could not find class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.blazesoft.repository.jdbc.NdDefaultJdbcRepositoryAccessor.open(:627)
at com.blazesoft.repository.jdbc.NdDefaultJdbcRepositoryAccessor.openConnection(:587)
at com.blazesoft.repository.jdbc.NdDefaultJdbcRepositoryAccessor.loadRepositoryConfig(:1574)
at com.blazesoft.repository.jdbc.NdJdbcRepository.WjHIPVJ(:220)
at com.blazesoft.repository.jdbc.NdJdbcRepository.getRepositoryConfig(:415)
at com.blazesoft.repository.local.WjIrwOD.(:99)
at com.blazesoft.repository.local.NdLocalRepository.(:71)
at com.blazesoft.repository.base.NdRepositoryFactory.newWorkspace(:251)
at com.blazesoft.template.repository.NdRomFactory.newRepositoryConnectionManager(:538)
at com.blazesoft.template.repository.NdRomFactory.newRepositoryConnectionManager(:371)
at com.blazesoft.rma.NdGenericRMASupport.connectToRepository(:2945)
at org.apache.jsp.initRepository_jsp._jspService(initRepository_jsp.java:335)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrap

OK

than i have put sqljdbc4.jar file in default(MWS Server Instance)/lib and restarted the instance still am getting same error.

please help me to re-solve the problem.

regards,
anil kumar ellendula

hi All,

Any update on this issue.

am using webmethods 8.0.1 version.

regards,
anil kumar ellendula

Hi All,

initially i put sqljdbc.jar and sqljdbc4.jar files in <wm_installtion>\MWS\lib directory

On work around i got the below error in MWS Administrator console.

java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

than i have removed the sqljdbc.jar file and kept only sqljdbc4.jar file and restarted the MWS instance, now am able to view the business rules from MWS Administrator console.

Thanks for your co-operation
regards,
anil kumar ellendula

Hi anil,
I was getting exaxtly the same error not even a single difference and i tried to do exactly the same thing as followed by you…but i still get the same error saying Sqlserverdriver is missing…Can you please let me know if you followed anyother procedure apart form what mentioned in the above threads

hi I am getting a error to run rule project as RMA using preview server. I am using Tool–>RMA–>Generate RMA.

I am very new in this, if any one kindly help to resolve this problem.
I am getting the follow error on page.

Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error

type Exception report
message Internal Server Error
description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred between lines: 175 and 415 in the jsp file: /navigation.jsp
Generated servlet error:
C:\SoftwareAG\blaze\Advisor68\RuleMaintenanceCenter\tomcat4\work_\localhost_\navigation$jsp.java:67: error:Class “java/lang/AbstractStringBuilder” is not accessible [JLS 6.6.1]

An error occurred between lines: 175 and 415 in the jsp file: /navigation.jsp
Generated servlet error:
C:\SoftwareAG\blaze\Advisor68\RuleMaintenanceCenter\tomcat4\work_\localhost_\navigation$jsp.java:70: error:Class “java/lang/AbstractStringBuilder” is not accessible [JLS 6.6.1]
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:176)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:188)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:619)