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 ONE Support launchpad (Login required).

Search for additional results

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