SAP Knowledge Base Article - Preview

2367494 - Error 'cannot insert NULL or update to NULL exception' when saving data

Symptom

When end use saves data for a supply planning related key figure in planning view, the below errors can be found in Excel front end and index sever log:

  •  Excel front end

             An unexpected error occurred. To avoid losing your keyfigure changes, save your planning view in a local folder, re-login and try Save again.

  • Index sever log

            Cannot insert NULL or update to NULL exception: cannot insert NULL or update to NULL: TrexUpdate failed on table 'SAPSOPG:SOPDD_TIMESERIES_XXX' with error: constraint NOT NULL violation;checkIntColumn(): found NULL on pos 0, column 'TSCHANGEIDFR', table 'SAPSOPG:SOPDD_TIMESERIES_XXX', rc=56, errorCode=UNEXPECTED_SAVE_ERROR.


Read more...

Environment

  • SAP Supply Chain Management (SCM)
  • SAP Sales and Operations Planning (SCM-SOP)

Product

SAP Sales and Operations Planning all versions

Keywords

save data, supply planning, unexpected error, change history, NULL exception, TSCHANGEIDFR, UNEXPECTED_SAVE_ERROR, SOP3.0 , KBA , SCM-SOP , Sales & Operations Planning , 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.