Driver compatibility issue for SQL Server database while accessing through UI

Driver compatibility issue for SQL Server database while accessing through UI

book

Article ID: KB0081972

calendar_today

Updated On:

Products Versions
TIBCO MDM 9.1.0

Description

Installing MDM 9.1.0 version on windows server with microsoft SQLSERVER database,While trying to create records in any repository and view all is not allowing from the UI. It is giving NPE error as below in the UI as well as Logs.

Code: JAV-8001: Unexpected error. Class: 'com.tibco.mdm.ui.repository.record.AddProductServlet' and method name: 'service'. Additional information: java.lang.NullPointerException.
ID: 0A000F17_8A808F97625362B2016253ACACDF0022
DATETIME: Fri Mar 23 09:24:08 PDT 2018
EXCEPTIONMESSAGE: java.lang.NullPointerException
STACKTRACE: java.lang.NullPointerException 
    at com.tibco.mdm.repository.engine.RecordBundleProcessor.validateRecordBundleForVeryFatalErrors(RecordBundleProcessor.java:1337) 
    at com.tibco.mdm.repository.engine.RecordBundleProcessor.validateRecordBundleForVeryFatalErrors(RecordBundleProcessor.java:1218) 
    at com.tibco.mdm.repository.engine.RecordBundleProcessor.process(RecordBundleProcessor.java:772) 
    at com.tibco.mdm.repository.engine.RecordBundleProcessor.process(RecordBundleProcessor.java:637) 
    at com.tibco.mdm.ui.repository.core.VRecordUIHelper.processBundle(VRecordUIHelper.java:1987) 
    at com.tibco.mdm.ui.repository.core.VRecordUIHelper.setupAttributeGroupsAsTabs(VRecordUIHelper.java:616) 
    at com.tibco.mdm.ui.repository.record.AddProductServlet.list(AddProductServlet.java:1152) 
    at com.tibco.mdm.ui.repository.record.AddProductServlet.list(AddProductServlet.java:677) 
    at com.tibco.mdm.ui.repository.record.AddProductServlet.checkWrapperUI(AddProductServlet.java:443) 
    at com.tibco.mdm.ui.repository.record.AddProductServlet.routeAction(AddProductServlet.java:386) 
    at com.tibco.mdm.ui.repository.record.AddProductServlet.onService(AddProductServlet.java:230) 
    at com.tibco.mdm.ui.infrastructure.MqServlet.service(MqServlet.java:650) 
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734) 
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541) 
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479) 
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407) 
    at com.tibco.mdm.ui.infrastructure.MqServlet.dispatchReq(MqServlet.java:904) 
    at com.tibco.mdm.ui.infrastructure.MqXMLCServlet.gotoPage(MqXMLCServlet.java:1282) 
    at com.tibco.mdm.ui.infrastructure.MqXMLCServlet.goForward(MqXMLCServlet.java:1313) 
    at com.tibco.mdm.ui.repository.browse.BrowseRepositoryServlet.addProduct(BrowseRepositoryServlet.java:1075) 
    at com.tibco.mdm.ui.repository.browse.BrowseRepositoryServlet.routeAction(BrowseRepositoryServlet.java:166) 
    at com.tibco.mdm.ui.repository.browse.BrowseRepositoryServlet.onService(BrowseRepositoryServlet.java:109) 
    at com.tibco.mdm.ui.infrastructure.MqServlet.service(MqServlet.java:650) 
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
    at com.tibco.mdm.ui.infrastructure.MaliciousRequestContentFilter.doFilter(MaliciousRequestContentFilter.java:45) 
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) 
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:154) 
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) 
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) 
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) 
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) 
    at java.lang.Thread.run(Thread.java:745) 
CLASSNAME: com.tibco.mdm.ui.repository.record.AddProductServlet
METHODNAME: service
<MqException: END>

Environment

MDM 9.1.0+Windows+ jboss-eap-7.0 + SQLSERVER

Resolution

This is causing because of the sqljdbc driver jar version.

To avoid these errors in MDM 9.1.0 versions during CRUD operations from the UI we need to use either sqljdbc6.x.jar or sqljdbc4.2.jar. 

Replace the old version of the driver with sqljdbc4.2 jar and restart the MDM server.

Issue/Introduction

When we try to create a record or View all from a repository in MDM UI is not allowing with SQLSERVER Database and getting exception as Unexpected error. Class: 'com.tibco.mdm.ui.repository.record.AddProductServlet'.

Additional Information

sqljdbc4.2 jar, SQL Server 2014,JAV-8001

Attachments

Driver compatibility issue for SQL Server database while accessing through UI get_app
Powered by Wolken Software