SAP Knowledge Base Article - Preview

3813350 - Validation Import warning “Error on ACTION_TYPE of (I). Error: (50000): (59556) insert failed: (I). Error: (XXX): Cannot insert the value NULL into column 'TYPE', table 'XXXXXX_XXX.dbo.CT_VALIDATION_RULE_DATA_STAGING'”

Symptom

When I have uploaded the validation import file last night 0 records were processed and I have received the below warnings:
Error while processing file: 'evi_XXX.txt '. Exception Information: 0017-1: proc errorcode:50000 Encountered warning error code that matches one found in the feed definition config com.inet.tds.Tds4SQLException: Msg 50000, Level 16, State 1, Procedure CT_OID_DO_ACTION_CT_VALIDATION_RULE_DATA, Line 257, Sqlstate 01000 [SEAPR1DB0016](59556) Error on ACTION_TYPE of (I). Error: (50000): (59556) insert failed: (I). Error: (515): Cannot insert the value NULL into column 'TYPE', table 'xxxxx'.CT_VALIDATION_RULE_DATA_STAGING'

User-added image
 


Read more...

Environment

Expense > Jobs Import

Product

Concur Expense all versions

Keywords

I need assistance with warning in validation import file “Cannot insert the value NULL into column 'TYPE', table XXX.CT_VALIDATION_RULE_DATA_STAGING”. , KBA , CON-CA-TLS-IEM , Import / Extract Monitor , 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.