Database Error 911 At Opc
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 database error 50000 at opc Moderated Hi experts,we get the following error messages each monday morning:Database error 4860 at database error 15250 at opc 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 database error at opc db2 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. 7229Views 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
and Safety Management ) A&D (Aerospace & Defense) ABAP About SAP Android Announcement of Legal Change APO (Advanced Planner and Optimizer) Audit Management BASIS BCM (Business Communication Management) BI (Business Intelligence) BI Suite - Business Explorer BO (Business Objects) BODS (Business Objects Data Services) BOPF (Business Object Processing Framework) BPC (Business Planning and Consolidation) BPM (Business Process Management) Business ByDesign Business One Business Suite BW (Business Warehousing) CLM (Contract Lifecycle Management) Cloud CRM (Customer https://scn.sap.com/thread/1965053 Relationship Management) CS (Customer Service) Do It Yourself DSiM (Demand Signal Management) E-Recruitment EAM (Enterprise Asset Management) EC (Enterprise Controlling) EP (Enterprise Portal) ERP (Enterprise Resource Planning) Event Management EWM (Extended Warehouse Management) FICO (Financial Accounting & Controling) FIN-FSCM (Financial Supply Chain Management) Fiori FS-BA (Bank Analyzer) FS-CD (Collections and Disbursements) Governance GTS (Global Trade Services) GUI http://www.stechies.com/system-crash-due-to-function-db6admrunstats-failed-error-911/ (Graphical User Interface) GWM (Gateway for Microsoft) HANA HCM (HCM Human Capital Management) HR (Human Resource) Hybris (SAP E-Commerce Software) IdM (Identity Management) IFRS (International Financial Reporting Standards) IM (Investment Management) Integration Server IS (Industry Solutions) IT Management Java KW (Knowledge Warehouse) Landscape Transformation of Replication Server Logistics Information System Lumira MaxDB MDM (Master Data Management) ME (Manufacturing Execution) MM (Materials Management) Mobile MRS (Multi Resource Scheduling) MySAP MySQL NetWeaver OCM (Order Change Management) OM (Organisational Management) Oracle Oracle SQL PE (Product Enhancement) Photoshop PHP PI (Process Integration) PLM (Product Lifecycle Management) PM (Plant Maintenance) PO (Process Orchestration) Point-of-Sale (POS) Data Management (DM) Postalsoft PP (Production Planning) PPM (Portfolio and Project Management) Predictive Analytics Project Manager PS (Project Systems) QA (Quality Assurance) QM (Quality Management) SAP Office SAP User Experience (UX) SCM (Supply Chain Management) SD (Sales and Distribution) SEM (Strategic Enterprise Management Software) SEO (Search Engine Optimization) Shared Service Framework SOD (Segregation of Duties) Solution Manager SRM (Supplier Relationship Management) SSO (Single Sign-On) TAO (Test Acceleration and
Error 911 occurred. 2 replies Latest Post - 2004-12-27T12:25:07Z by SystemAdmin Display:ConversationsBy Date 1-3 of 3 Previous Next SystemAdmin 110000D4XK 7754 Posts Pinned topic Error 911 occurred. 2004-12-14T11:10:36Z | Tags: Answered question This https://www.ibm.com/developerworks/community/forums/thread.jspa?threadID=127201 question has been answered. Unanswered question This question has not been answered http://www.geekinterview.com/question_details/33960 yet. did anyone get this error messag when running an ETL job. I am running a PS_BANK_CD_TBL ETL job, and this is the error message. thanks aswini Log in to reply. Updated on 2004-12-27T12:25:07Z at 2004-12-27T12:25:07Z by SystemAdmin SystemAdmin 110000D4XK 7754 Posts Re: Error 911 occurred. 2004-12-14T13:25:41Z database error This is the accepted answer. This is the accepted answer. Hi, It appears to be a operating system memory error. May be you are trying to read or write to an address/location and you do not have correct permissions for doing it. I believe DataStage has a table which stores system messages and this message number should be listed database error 911 in it. DataStage Guru's can shed more light on it. Ketfos Log in to reply. SystemAdmin 110000D4XK 7754 Posts Re: Error 911 occurred. 2004-12-27T12:25:07Z This is the accepted answer. This is the accepted answer. thanks for the help, it looked like my Unix security was incorrect, as well as we did this to fix this error message. check (using sql) if you have a DECRLONG field on the source side and check the sqltype if it is LONG then check for the same filed in the ETL job (both on the source and the target) DESCRLONG field should be defaulting to LongVarchar and the length of the field might be 214748364, to fix the issue please make the following changes; change the field type to Varchar and length of the field to 2000. This should fix the Error 911 if it is causing by the Field type/length mismatch. Current version of the DRS doesn't support using LongVarchar. Log in to reply. Show: 10 25 50 100 items per page Previous Next Feed for this topic
Management Accounting Operating System Operating System Android iOS Microsoft Coding Programming J2EE Languages Database Database Data Warehousing Oracle Applications Applications Clarify CRM Oracle Apps Peoplesoft Siebel Software Testing Testing Testing Tools Miscelleanous Helpdesk Mainframe Networking SAP R/3 Web Interview Coaching Career Counseling Job Interview Interview eBooks Accounting eBook C eBook Citrix eBook Job Interview eBook Career Advice Career Change Jobs Help Projects Requests Resume Help Training Advice Engineering Chemical Engineering Civil Engineering Electrical Engineering Electronics Engineering Micro Processor Mechanical Engineering By Company Ask Question Home Interview QuestionsMainframeDB2 What is difference between 911 and 913 error code in DB2 ? Interview Candidate Sep 1st, 2006 4 20867 DB2 Answer First Prev Next Last Showing Answers 1 - 4 of 4 Answers Sam Sep 8th, 2006 The unit of work has been rolled back due to dead lock or commit-----SQL code 911 Was this answer useful?Yes Reply jayakumar Sep 10th, 2006 ABEND -911:A deadlock has occured and the rollback is done sucessfullyABEND -913A deadlock has occured ,but the rollback was unsucessfulcheers,jai Was this answer useful?Yes 1 Reply bnirmalraj Sep 26th, 2006 911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name913-UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, ANDRESOURCE NAME resource-name
Was this answer useful?Yes Reply sangramkc Nov 27th, 2006 for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are: o 00C90088 - deadlock o 00C9008E - timeout Thanks,SangramOm jai sai ram Was this answer useful?Yes Reply Give your answer: If you think the above answer is not correct, Please select a reason and add your answer below. - Reason - Answer is wrong Spelling Mistakes Duplicate Answer Inappropriate Answer Other Answe