Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Fatal SQL Error: 515 (Issue Screen 1002000)

Posted on by 635

Hello,

We are getting this error when trying to release a Issue Batch that was created by the Service Call Module, Generate Inventory Screen (SD30600). We are currently running 2011 FP1 SP2.

------------------------------------------------------------------------------------------

Processing: Batch: 155714
Fatal SQL Error:  515

Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.

Processing: Batch: 155714
Error occurred in Batch 155714, InTran record 800773 while executing the following procedure: SCMINTran - Invoice(#7)

Processing: Batch: 155714
Error occurred in Batch 155714, InTran record 800773 while executing the following procedure: SCMINTran - ReleaseTran(#8)

Processing: Batch: 155714
Error occurred in Batch 155714 while executing the following procedure: SCMBatch - ReleaseBatch(#2)

Processing: Batch: 155714
System Message 838: not released - it has been put on hold.

-------------------------------------------------------------------------------------------

Has anyone experienced this error before and corrected it?

Thanks

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Fatal SQL Error: 515 (Issue Screen 1002000)

    Hello,

    This is actually bug 16102, the KB tied to it is 3062706

    It basically give the workaround posted by Lewis H (Thank you Lewis)

    ----------------------------------------

    Alter the table that the error message indicates is causing the problem to allow null values for vendor_name.

    NOTE: Run this one to fix the error when printing the Check Register.

    ALTER TABLE AP03630MC_Wrk ALTER COLUMN Vendor_Name CHAR(30) NULL

    NOTE: Run this one to fix the error when printing the Detail Remittance report.

    ALTER TABLE AP03625_Wrk ALTER COLUMN Vendor_Name CHAR(30) NULL

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fatal SQL Error: 515 (Issue Screen 1002000)

    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

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Fatal SQL Error: 515 (Issue Screen 1002000)

    Dear Stuart,

    I can't find a link or reference to the article , except for this thread...which doesn't help.

    If you are in a supported version then I can suggest you create a case in MS support for SL so they can troubleshoot the batch

    Best Regards,

    Jana MacDonald

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fatal SQL Error: 515 (Issue Screen 1002000)

    Have a client experiencing the same issue, but can find no reference in the KB to this article. Can anyone provide a good link?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fatal SQL Error: 515 (Issue Screen 1002000)

    KB 962984 has a bug that might be what you are seeing.  If this doesn't help then a SQL Trace may point to what is happening.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans