Failed to Update the Vulnerability DataBase

Failed to Update the Vulnerability DataBase

Recently installed MEDC (V9 Build 91043) and found that I cannot sync the patch vulnerability database - it fails with the error in the title

I'm not using a proxy (Direct to internet)
Looking at the logs, it downloads the SQL Files, and then when it tries to update the database it fails.

In the crslog0 file there is a java exception error when talking to postgres


[08:28:10:433]|[07-14-2015]|[CRSLogger]|[INFO]|[144]: Updating Desktop Central database with latest patch information...|
[08:29:12:446]|[07-14-2015]|[CRSLogger]|[INFO]|[144]: Error while Dumping data in DB|
[08:29:12:446]|[07-14-2015]|[CRSLogger]|[SEVERE]|[144]: Caught exception while updating sqls to DB[{DEFINITION_NAME=mssecure, relativeLocation=dccrs\definitiondata\patchdata\1.1398\mssecure_pg.sql, DEFINITION_FILE_NAME=mssecure_pg.sql, DEFINITION_ID=10}, {DEFINITION_NAME=msnonsecure, relativeLocation=dccrs\definitiondata\patchdata\1.873\msnonsecure_pg.sql, DEFINITION_FILE_NAME=msnonsecure_pg.sql, DEFINITION_ID=11}, {DEFINITION_NAME=tusecure, relativeLocation=dccrs\definitiondata\patchdata\1.831\tusecure_pg.sql, DEFINITION_FILE_NAME=tusecure_pg.sql, DEFINITION_ID=12}, {DEFINITION_NAME=avsecure, relativeLocation=dccrs\definitiondata\patchdata\1.1132\avsecure_pg.sql, DEFINITION_FILE_NAME=avsecure_pg.sql, DEFINITION_ID=13}, {DEFINITION_NAME=product, relativeLocation=dccrs\definitiondata\patchdata\1.3720\product_pg.sql, DEFINITION_FILE_NAME=product_pg.sql, DEFINITION_ID=14}, {DEFINITION_NAME=macsecure, relativeLocation=dccrs\definitiondata\patchdata\1.224\macsecure_pg.sql, DEFINITION_FILE_NAME=macsecure_pg.sql, DEFINITION_ID=17}, {DEFINITION_NAME=spsecure, relativeLocation=dccrs\definitiondata\patchdata\1.21\spsecure_pg.sql, DEFINITION_FILE_NAME=spsecure_pg.sql, DEFINITION_ID=19}]| 
java.sql.BatchUpdateException: Batch entry 2 INSERT into Checks values ('124654','36','$x64$HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Microsoft-Windows-Foundation-Package~31bf3856ad364e35~amd64~~6.0.6000.16386','CurrentState','7','-','-') was aborted.  Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:750)
at com.adventnet.sym.server.patch.util.CommandExecutor.dumpData(CommandExecutor.java:205)
at com.adventnet.sym.server.crawler.DBSyncHandler.populateSql(DBSyncHandler.java:1366)
at com.adventnet.sym.server.crawler.DBSyncHandler.populateSql(DBSyncHandler.java:1280)
at com.adventnet.sym.server.crawler.DBSyncHandler.updateSQLToDB(DBSyncHandler.java:980)
at com.adventnet.sym.server.crawler.DBSyncHandler.synchorinizeModule(DBSyncHandler.java:391)
at com.adventnet.sym.server.patch.task.UpdateDBTask.downloadSQLData(UpdateDBTask.java:466)
at com.adventnet.sym.server.patch.task.UpdateDBTask.executeTask(UpdateDBTask.java:175)
at com.me.devicemanagement.onpremise.server.scheduler.SchedulerExecutionTask.invokeMethodInClass(SchedulerExecutionTask.java:60)
at com.me.devicemanagement.onpremise.server.scheduler.SchedulerExecutionTask.executeTask(SchedulerExecutionTask.java:51)
at com.adventnet.taskengine.internal.SchedulerBean.executeTask(SchedulerBean.java:584)
at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:115)
at com.sun.proxy.$Proxy2.executeTask(Unknown Source)
at com.adventnet.taskengine.internal.ScheduleExecutor.executeNextTask(ScheduleExecutor.java:147)
at com.adventnet.taskengine.internal.ScheduleExecutor.run(ScheduleExecutor.java:81)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[08:29:12:462]|[07-14-2015]|[CRSLogger]|[WARNING]|[144]: Failed to update db with downloaded data|
 
I've tried installing Java 8u45, but this has had no effect. 

I'm running it on Windows Server 2012 R2
 
Any help would be gratefully received

                New to ADSelfService Plus?