SAP Knowledge Base Article - Preview

2324782 - SMP monitor db error -195: Column 'id' in table 'mms_data_change_notification' cannot be NULL


  • The following error appears in the SMP server log:

    2016-02-24 08:29:13.271 ERROR MMS Thread-61 [com.sybase.sup.server.monitoring.MonitoringDBUtil] [] []
    com.sybase.jdbc4.jdbc.SybBatchUpdateException: JZ0BE:
    BatchUpdateException: Error occurred while executing batch statement:
    SQL Anywhere Error -195: Column 'id' in table 'mms_data_change_notification' cannot be NULL
    at com.sybase.jdbc4.jdbc.ErrorMessage.raiseBatchUpdateException (
    at com.sybase.jdbc4.jdbc.SybStatement.batchLoop(
    at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeBatch(
    at com.sybase.sup.server.monitoring.MonitoringDBUtil.executeBatchUpdate(
    at com.sybase.sup.server.monitoring.MonitoringDBUtil.flushDataToDB(
    at com.sybase.sup.server.monitoring.MonitoringDBUtil_DJC.access$501(
    at com.sybase.sup.server.monitoring.MonitoringDBUtil_DJC$6.invoke(
    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(
    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(
    at com.sybase.sup.server.monitoring.MonitoringDBUtil_DJC.flushDataToDB(
    at com.sybase.sup.server.monitoring.StartMonitoringService$

  • Data is no longer being entered into the monitordb database.



  • SMP 2.3.x
  • SMP MBO runtime server 3.0.x


SAP Mobile Platform 2.3 ; SAP Mobile Platform 3.0


SMP monitordb SQLAnywhere error 195 column null primary key autoincrement , KBA , MOB-ONP , SAP Mobile Platform on Premise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.