Database Error Number 515 Has Occurred
Contents |
360 games PC games error 515 sql server Windows games Windows phone games Entertainment All Entertainment
Bmxaa4211e Database Error Number 803
Movies & TV Music Business & Education Business Students & educators sql server error codes Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries. LTD Social Sitings Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites. Tag cloud .net asp.net azure book business intelligence c# database excel gotcha how to mongodb nosql performance security sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 ssis ssms https://support.microsoft.com/en-us/kb/248442 ssrs syndicated t-sql tip unit testing Authors SQLDenis (597)Ted Krueger (onpnt) (355)Jes Borland (191)Eli Weinstock-Herman (tarwn) (161)Koen Verbeeck (100)Alex Ullrich (55)George Mastros (gmmastros) (45)Axel Achten (axel8s) (28)Naomi Nosonovsky (27)David Forck (thirster42) (24)chopstik (20)Kevin Conan (18)Rob Earl (14)ThatRickGuy (12)SQLArcher (11) More... Categories All Blogs Architecture, Design and Strategy Data Management Desktop Developer Enterprise Developer IT Professionals IT Students and Researchers Management System Admins Uncategorized Web Developer Google Ads Expanding an Existing Azure VM http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/mssqlserveradmin/mds-a-database-error-has-occurred/ System Drive » « Overview of Published Articles - 2014Q1 1 MDS: A Database Error Has Occurred by Koen Verbeeck on April 18, 2014 in category Master Data Services (MDS) Microsoft SQL Server Microsoft SQL Server Admin. Article views: 12,756 TweetInstapaper I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS: 515: A database error has occurred. Please contact your system administrator Too bad I am the system administrator on that machine… Anyway, after some searching it came out the MDS stored procedure udpEntityStagingAllBatchesByModelGet throws a bit of a temper tantrum if one of the batch tags used in the staging process of a leaf member is NULL. You can check this in the table mdm.tblStgBatch. Simple delete the offending batches and you're good to go! T-SQL1 2 DELETE FROM mdm.tblStgBatch WHERE BatchTag IS NULL; DELETE FROM mdm.tblStgBatch WHERE BatchTag IS NULL; About the AuthorKoen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.Social Sitings Article views: 12,756 Read More Posts by Koen Verbeeck Tags: batch, error, mds, syndicat
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/9802693/sql-server-error-515 of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a database error minute: Sign up SQL Server error 515 up vote 1 down vote favorite I have a table SINVOICE and another table called SINVOICE_LINE. I need to put all columns of SINVOICE into SINVOICE_LINE. I have created the corresponding columns and was trying to copy the values. The primary key of SINVOICE is SINVOICE_CODE, while the primary key for SINVOICE_LINE is a composite database error number key (SINVOICE_CODE, SINVOICE_LINE_NUMBER). I wrote the following query: INSERT INTO SINVOICE_LINE (sinvoice.ITINERARY_CODE) SELECT sinvoice_line.ITINERARY_CODE FROM SINVOICE INNER JOIN sinvoice_line ON sinvoice.sinvoice_code = sinvoice_line.sinvoice_code; I get this error: Cannot insert the value NULL into column SINVOICE_CODE, table SINVOICE_LINE; column does not allow nulls. INSERT fails. I do not understand why I'm getting this error as I am not trying to insert any value in SINVOICE_CODE column. Thanks!!! sql sql-server insert sql-server-2008-r2 share|improve this question edited Mar 21 '12 at 12:44 marc_s 451k938641029 asked Mar 21 '12 at 10:28 user1264578 1815 "Hey guys I'm not inserting any value into SINVOICE_CODE and it says I can't insert empty values" Can you really not figure this one out on your own? –ta.speot.is Mar 21 '12 at 10:30 Please try formatting the TSQL in your question. It's really quite unreadable as it stands. –Barry Kaye Mar 21 '12 at 10:33 I'm not isnerting any value beacause I already have values in that column... –user1264578 Mar 21 '12 at 10:35 You're INSERTing a new row. You can't already have a value i