Database Error 4860 Sap
on SQL ServerWhere is this place located?All Places SAP on SQL Server 1 Reply Latest reply: May 31, 2011 9:13 AM by Clas Hortien Tweet Database error 4860 / 911 at OPC Basti D. May 31, 2011 8:42 AM Currently Being Moderated Hi experts,we get the following error messages each monday morning:Database error 4860 at OPC> [Microsoft][SQL Server Native Client 10.0][SQL Server]Cann> bulk load. The file "C:\Program Files\Microsoft SQL> Server\MSSQL10.MSSQLSERVER\MSSQL\CCMS_CHECK_DB_HIST_2011.txt> does not exist.Database error 4860Database error 911 at OPC> [Microsoft][SQL Server Native Client 10.0][SQL> Server]Database 'mssqlsystemresource' does not exist. Make> sure that the name is entered correctly.Database error 911We found this error messages on two independent ECC 6.0 systems which both run MS SQL Server since activating early watch reports. At this time data for the early watch report is collected, maybe this is the trigger for this error. But I think that the real cause for this error is located somewhere in the database configuration.By the way there is no shortdump or any additional information in the EWA report.Any ideas or hints? Thank you in advance. 7225Views Re: Database error 4860 / 911 at OPC Clas Hortien May 31, 2011 9:13 AM (in response to Basti D.) Currently Being Moderated Hi,i assume, that the early watch report wants to read the file CCMS_CHECK_DB_HIST_2011.txt. This is the log of a database check job, which you can schedule in db13. If you do not have this job scheduled, the file will not exist. You can ignore the error, but if you want to fix it, just schedule the DB check job (at least one time) or just create a textfile at this path with this name. Btw, you should run a DB check anyway from time to time to ensure the physical consistency of your database. Recommened is a run every week.The mssqlsystemresource database is a hidden system database, which cannot be accessed directly. I assume that the report scan through all databases (select * from sys.databases) and tries to get more information about this databases then. The error is not severe and can be ignored. If you want to have it fixed, open an OSS message for the EWA tool.Best regards Clas Alert Moderator Like (0) Tweet Actions Login to follow, like, comment, share and bookmark content. Login Register Follow SCNJive Software Version: 5.0.6.2 , revision: 201308121150.54f5b14.release_5_0_6_2
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies 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 minute: Sign up error -4861 - I do a BULK INSERT the contents of a csv file into a table through stored procedure up vote 0 down vote favorite could you please help me? I have an application, in which I BULK https://scn.sap.com/thread/1965053 INSERT the contents of a csv file into a table through stored procedure. The stored Procedure uses BULK INSERT (SQL Server 2005). This works fine in a standalone system. However when I use the same in a multitier architecture (Web server, Application Server and DB Server) it is throwing 4861 error. Could you please help? The files are stored on the Web Server. The translated error message is: Error – 2147217900:4861: Since it can not be opened for the file \\Servername\c$\Folder1\Folder2\Folder3\file.csv, It can http://stackoverflow.com/questions/2591780/error-4861-i-do-a-bulk-insert-the-contents-of-a-csv-file-into-a-table-through not be loaded with large capacity. Operation system error code is 5 (error not ……….) Thanks Regards, Chandru sql sql-server-2005 share|improve this question edited Apr 7 '10 at 11:25 APC 86.9k1383184 asked Apr 7 '10 at 10:57 Chandru 111 possible duplicate of stackoverflow.com/questions/852117/… –APC Apr 7 '10 at 11:29 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote That's probably a security issue. If you're running the bulk insert from a SQL Server job, make sure the user account of the SQL Server Agent service has rights to open the file. If you're running the query from a regular connection, SQL Server will impersonate you and then try to read the file. However, by default, SQL Server is not allowed to act as someone else. See this answer by Remus Rusanu for more details. share|improve this answer answered Apr 7 '10 at 11:02 Andomar 154k23223271 We are accessing the csv file through stored procedure call from Web application –Chandru Apr 7 '10 at 11:05 1 @Chandru: Then it's probably the nasty delegation issue. Answer edited with a link to a good explanation –Andomar Apr 7 '10 at 11:06 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agr
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22921 We've restricted the ability to create new threads on these forums. SQL Server http://computerfixerphiladelphia.com/windows-sap-database-error-4860.php Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) Error msg 4860 Reply to Topic Printer Friendly Author Topic Dibs Starting Member Ireland 2 database error Posts Posted-01/10/2003: 09:47:23 Hi Using the procedure available in the article "Using BULK INSERT to Load a text file" (ItemID 3207) I am trying to load a text file. However, when I try to execute it, the following error is generated:Server: Msg 4860, Level 16, State 1, Line 1Could not bulk insert. File 'c:\TxtFile1.txt' does not exist.The file TxtFile1.txt does exist in the database error 4860 specified directory so I cannot understand why this is being produced. Can anyone offer me an explanation/solution??CheersAdrian. nr SQLTeam MVY United Kingdom 12543 Posts Posted-01/10/2003: 10:04:25 Is it on the correct server?Not sure how dts handles bulk inserts (as I can't think of a good reason to use it for them) but I suspect this will be relative to the server rather than the client.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. AjarnMark SQL Slashing Gunting Master USA 3246 Posts Posted-01/10/2003: 15:14:47 Could also be a permissions issue at the OS level...------------------------------------------------------The more you know, the more you know you don't know. tkizer Almighty SQL Goddess USA 38200 Posts Posted-01/10/2003: 15:59:19 BULK INSERT requires that the file be located on a local drive on the server, so you will need to copy the file to the server. This is why I prefer bcp (or even DTS, but usually bcp).Edited by - tduggan on 01/10/2003 15:59:45 jasper_smith SQL Server MVP & SQLTeam MVY United Kingdom 846 Posts Posted-01/11/2003: 11:57
it! Causes of the error: Windows Windows Sap Database Error 4860 are caused by misconfigured system files. So, from my experience, If you received a Windows Sap Database Error 4860 message then there is a 97.5% chance that your computer has registry problems. The Windows Windows Sap Database Error 4860 are easy to repair. By downloading and running the registry repair tool RegCure Pro, you can quickly and effectively fix this problem and prevent others from occuring. Simply click the links below for your free download. To Fix the problem you need to follow the 3 steps : STEP 1: Download & Install RegCure Pro for Free. NOTE: If the download link doesn't work you may need to Download it Directly from a Mirror Here. STEP 2: Click "Quick Scan" Button to Scan Your Computer. STEP 3: Click the "Repair All" Button to Repair Your PC! That's All! Scott Chan Technical Description of System Error(for Experts only): Microsoft Windows [Version 5.2.4630] (C) Copyright 1985-2014 Microsoft Corp. C:\Documents and Settings\Administrator>RegCure Pro.exe Windows Windows Sap Database Error 4860 may caused by some of the following errors Windows Explorer ErrorsJavascript ErrorsHardware MalfunctionError Symptom include:Can not printing fileBlue ScreenIO errorShutdown problemsHttp error Tags: Windows Windows Sap Database Error 4860 4 Response to “RegCure Pro ” ColettaSays: at 9:22 PM Thank you so much! After spending countless hours on this stupid windows sap database error 4860 problem I almost gave up. RegCure worked like a charm on the first try. It took a bit longer than 10 minutes, closer to 30, but by the time it was finished my PC worked great again. Fran Says: at 3:47 AM Just ran this on my wife's computer and for the first time in a long time, it finally works again! Regcure found over 2500 errors including the Windows Sap Database Error 4860 and fixed them all. I'm not a PC guru by any stretch, but this was a godsend. Cheers! Stevie Says: at 4:48 AM worked just like it said. no more errors and officially back in action. ty ty ty Tu Says: at 9:12 AM it worked!!!!!!! Download Now: Windows Error Repair Tool *RegCure Pro will repair Windows Error and registry data errors on your PC Compatible with ALL Versions of Windows Including Windows 7