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>

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'.

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

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.

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