Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You receive SQL error 515 ‘Cannot insert the value NULL into column 'Vendor_Name'’ when you run the Check Register and Detailed Remittance Advice report

You receive SQL error 515 ‘Cannot insert the value NULL into column 'Vendor_Name'’ when you run the Check Register and Detailed Remittance Advice report

View products that this article applies to.

Symptoms

You run the Detailed Remittance Advice (03.625) report and the report does not run or you receive this error:


Error: 515, Severity: 16, State: 2

Cannot insert the value NULL into column 'Vendor_Name', table 'SLWinDemoApp60.dbo.AP03625_Wrk'; column does not allow for nulls. INSERT fails.

NOTE: because of how/what SQL errors are reported to end-users, the end-user might not actually see the error, but in a SQL trace you see the 515 error.

NOTE: You can receive this same error when you run the Check Register (03.630) report.

↑ Back to the top

Resolution

Run these scripts on your application database:

Run this script to fix the error when you print the Check Register (03.630) report.

ALTER TABLE AP03630MC_Wrk ALTER COLUMN Vendor_Name CHAR(30) NULL


Run this script to fix the error when you print the Detailed Remittance Advice (03.625) report.

ALTER TABLE AP03625_Wrk ALTER COLUMN Vendor_Name CHAR(30) NULL

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3062706
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 346