Description:

The user can not create records either through the UI or direct import for any repository.

When trying to create records (either through the UI or direct import) for a repository, the following error displays on MDM UI:

=================
JAV-8001: Unexpected error. Class: 'com.tibco.mdm.ui.repository.record.AddProductServlet' and method name: 'service'. Additional information: java.lang.NullPointerException.

=================

The elink.log containing the detailed errors is attached (Filename:elink.log).

The attached file (Filename:elink.log) indicates the error is caused by the following SQL statement:

SELECT CA.ID, CA.NAME, CA.DESCRIPTION, CA.CATALOGATTRIBUTEDATATYPEID, CADT.NAME "CATALOGATTRIBUTEDATATYPENAME",  CA.ATTRIBUTELENGTH, CA.ATTRIBUTEPOSITION, CA.REQUIRED, CA.ACTIVE,  CA.MODMEMBERID, CA.MODDATE, CA.MODVERSION, CA.HELP, CA.SEARCHABLE, CA.DISPLAYINRECORDLIST, CA.QUICKVIEWABLE,CA.CATALOGVERSIONNUMBER,  CA.DBCOLUMNNAME, AG.NAME "CATEGORY", RS.PARENTID "GROUPID",  CA.UNIQUEVALUE, CA.PREDEFINED,  CA.DISPLAYNAME,  CA.MULTIVALUE , CA.TABLENAME,  AG.DESCRIPTION "GROUPDESCRIPTION", AG.PREDEFINED "GROUPPREDEFINED",  CA.PARTITIONKEY, CA.SHAREDTABLE, CA.FLEXIBLE FROM CATALOGATTRIBUTE CA, CATALOGATTRIBUTEDATATYPE CADT, RELATIONSHIP RS, ATTRIBUTEGROUP AG  WHERE CATALOGID = 34255 AND RS.OWNERID = 34255  AND CA.ACTIVE = 'Y' AND AG.ACTIVE = 'Y'  AND RS.PARENTID = AG.ID  AND RS.ACTIVE = 'Y' AND RS.CHILDID = CA.ID AND RS.TYPE IN (6,5) AND RS.MODDATE =  ( SELECT MAX(R.MODDATE) FROM RELATIONSHIP R, ATTRIBUTEGROUP AGROUP            WHERE AGROUP.ACTIVE='Y' AND AGROUP.ID=R.PARENTID AND R.OWNERID = RS.OWNERID  AND R.CHILDID = RS.CHILDID AND R.TYPE IN (5,6) AND R.MODDATE <=  dbo.TO_DATE (CAST ('2014-02-24 21:25:13.0' AS VARCHAR (26)), 'yyyy-MM-dd HH24:MI:SS')  )  AND CA.CATALOGVERSIONNUMBER = 1 AND CA.CATALOGATTRIBUTEDATATYPEID = CADT.ID  ORDER BY CA.attributePosition

This is caused by the incompatible driver for MS SQL Server 2008 (sqljdbc4.jar) . The size of the correct version of driver is 570 kb.

Download the latest version of MS SQL Server driver (Filename: sqljdbc4.jar attached)  from the following site.

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

Replace the old version of the driver and restart the MDM server.