Microsoft Sql Server Error 3930
Contents |
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server Error 3930 Visio 2010 > Visio General Questions and Answers for IT Professionals Question 0 Sign in to vote sql server the current transaction cannot be committed and cannot support operations Hi Everyone, I am getting the following error while inserting rows in a table
Sqlstate 42000] (error 3930
"Unexpected error: 3930-"The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the
The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File
transaction." The table has an index that is fired on update. Code BEGIN TRY INSERT INTO [dbo].[Sample_Table] ([Lang] ,[StuCode]
Xact_state
,[StuID] ,[StuName] ,[DisplayNameLocal] ,[DisplayNameInternational] ,[CityName] ,[RegionName] ,[CountryCode] ,[MetroCodeBool] ,[StatusCode] ,[UpdateDate] ,[LastUpdatedBy]) VALUES (@pLang ,@pStuCode ,@pStuID ,@pStuName ,@pDisplayNameLocal ,@pDisplayNameInternational ,@pCityName ,@pRegionName ,@pCountryCode ,@pMetroCodeBool ,@pStatusCode ,@pUpdateDate ,@pLastUpdatedBy); END TRY BEGIN CATCH select * from AirportNameLoc where AirportCode=@pAirportCode and LangID=@pLangID END CATCH Please help. Thanks!! Tuesday, August 26, 2014 9:39 AM Reply | Quote Answers 0 Sign in to vote Hi NiViV, I find a similar issue and post it here, hope it’s helpful. http://social.technet.microsoft.com/Forums/en-US/ebefc980-130d-4e28-a3e2-ef42296e5657/trigger-the-current-transaction-cannot-be-committed-and-cannot-support-operations-that-write-to?forum=transactsql This is a forum for Visio, not for SQL. If you want to receive about this issue, I suggest you posting it in SQL Server forum. http://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding. If there is any
log in tour help Tour Start 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 Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a https://social.technet.microsoft.com/Forums/office/en-US/492bd874-fc0b-4348-ba0f-d84a2eb17007/sql-server-error-3930?forum=visiogeneral minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Finding exact statement causing error 3930 up vote 4 down vote favorite 1 Lately I've been seeing errors in the SQL Server Log. Code:3930 Description:"The current transaction cannot be committed and cannot support operations that write to the http://dba.stackexchange.com/questions/28807/finding-exact-statement-causing-error-3930 log file. Roll back the transaction." Using SQL Profiler, how can I find the exact statement that is causing this error? Which column in SQL Profiler fills the "Message" column in the SQL Error log? Unfortunately, we are only getting this in production, so I will need to run a trace there with the lightest weight trace possible. What do you folks recommend to capture the offending code? sql-server profiler error-handling tracing share|improve this question edited Nov 16 '12 at 17:32 Aaron Bertrand♦ 114k14196337 asked Nov 16 '12 at 16:22 SomeGuy 63521127 2 What version of SQL Server? The lightest weight trace possible would probably not be a trace at all but extended events. –Martin Smith Nov 16 '12 at 17:26 This server is on SQL Server 2005. –SomeGuy Nov 16 '12 at 17:41 add a comment| 1 Answer 1 active oldest votes up vote 6 down vote accepted In Profiler, click "show all events" and go to the Errors and Warnings listing. You should be able to check Exception and User Error Message. The Exception class will show you the actual error and User Error Message will
and SafetyAsset NetworkAsset Operations and https://scn.sap.com/thread/3323217 MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125016 Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance sql server ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing the current transaction and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authenticatio
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Transact-SQL (2005) Execute a procedure within a procedure - Error Reply to Topic Printer Friendly Author Topic swathigardas Posting Yak Master 149 Posts Posted-05/04/2009: 09:07:53 HI i am trying to execute a procedure within a procedure. For this i am creating a temporary table and inserting the ouput of a stored procedure in it. The temporary table has the same number of columns as that of Stored procedure output. I used a Query like this Below - Create table #Temp (Employee_NBR INT,Employee_NM VARCHAR(100),Leave_type_NBR INT,Leave_Type_NM VARCHAR(50),Available_Leave Decimal(4,2))INSERT INTO #Temp (Employee_NBR,Employee_NM,Leave_Type_NBR,Leave_Type_NM,Available_Leave) EXEC [dbo].[USP_Get_Employee_Available_Leave] @Employee_NBR= 11,@Leave_Type_NBR=0,@User_NBR=11,@Page_NBR=40.But when i execute it i get an error like thisMsg 3930, Level 16, State 1, Procedure USP_Insert_Error_Log, Line 42The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.The SP USP_Insert_Error_Log is been created to insert the errors that comes from application in to a error log table. I dont understand this error message. Can anyone help me out.Thanks in advance sakets_2000 Flowing Fount of Yak Knowledge India 1472 Posts Posted-05/04/2009: 09:14:48 just try running the sp without the insert. I think theres an error inside