.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

The function START: has failed. No transaction cookie was returned

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

I am inconsistently getting following excepiton while running the application with JDBC2 driver. This exception is specially seen when mutiple threads of application are running.

An unexpected exception has occurred while trying to create report with roster id 2.
Hibernate operation: could not insert: [com.core.processing.impl.model.TempResource]; uncategorized SQLException for SQL [insert into RESOURCE_REGISTER (RR_DATABASE, RR_OWNER_ID, RR_RESOURCE_NAME, RR_RESOURCE_TYPE, RR_RUN_ID) values (?, ?, ?, ?, ?)]; SQL state [null]; error code [0]; error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource metadata1 in state ACCESSIBLE wrapping SQLServerXAConnection:1 on  ProxyConnectionID:1; nested exception is java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource metadata1 in state ACCESSIBLE wrapping SQLServerXAConnection:1 on  ProxyConnectionID:1
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator translate 83
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator translate 80
org.springframework.orm.hibernate3.HibernateAccessor convertJdbcAccessException 424
org.springframework.orm.hibernate3.HibernateAccessor convertHibernateAccessException 410
org.springfram


View Complete Post


More Related Resource Links

Workflow "Failed on Start (retrying)" when new item created by BizTalk SharePoint Adapter

  

We've been using the BizTalk SharePoint Adapter to load various different contents into a MOSS 2007 Document Library. The library has a Microsoft Office SharePoint Designer 2007 workflow (sequential workflow created in Designer) which starts automatically when a new item is added to the Document Library. Or, at least, it eventually starts automatically.

 

For some unknown reason--and this is what we're hoping some of you may have some ideas on--the workflow fails to start on the first try, producing the "Failed to Start (retrying)" message. When the timer job comes back the second time, the workflow starts successfully, but this causes us to loose five minutes of potential work time (not to mention making us look bad to the VPs and CTO because they see the failure message).

 

In checking the log, I find the following pair of error messages each time the "Failed to Start (retrying)" status occurs:

 

08/27/2007 13:49:43.24  w3wp.exe (0x0CA0)                        0x1438 Windows SharePoint Services    Workflow Infrastructure        72fs Unexpected RunWorkflow: Microsoft.SharePoint.SPException: <Error><CompilerError Line="1" Column="1" Text="The root activity type is invalid.&q

VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit

  

I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines


[OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment fa

  
Ok, i have seen tons of articles on the error, but still can't figure it out. This is being executed through nested procedure calls, until it is roughly 3 levels deep, then makes a call to Sybase using dynamic SQL and OPENROWSET. The message that is returned is listed below. Yes, i looked up all I could find on it. The thing I find interesting is I can simply take the dynamic SQL and the openrowset call out and run it in query analyzer just fine. but when I run it through the procedure it generates the errors. Any thoughts?   [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment failed.] Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Load of XA library failed.] OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

sql server start service error "The request failed or the service didn't respond in a timely fashio

  
I cannot start sql server 2008 after repair windows. sql server (MSSQLSERVER) not start dialog message "The request failed or the service didn't respond in a timely fashion.Consult the event log or other applicable error logs for details"  I open even log (control panel >> administration >> event viewer) find error log with sql server it notice Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(failed to retrieve text for this error. Reason: 1815) I open file ERRORLOG.5 but I don't understand where I should fix?  I copy errorlog.5 on this webboard  Please help me! thank you   2010-08-20 08:16:52.89 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)  Jul  9 2008 14:43:34  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) 2010-08-20 08:16:52.89 Server      (c) 2005 Microsoft Corporation. 2010-08-20 08:16:52.89 Server      All rights reserved. 2010-08-20 08:16:52.89 Server      Server process ID is 2248. 2010-08-20 08:16:52.89 Server      Authentication mode is MIXED. 2010-08-20 08:16:52.89 Server  &

SQL2008 Installation error Service SQLBrowser start request failed

  
This relates to the Enterprise SQL 2008 Failover Cluster installation. After the initial setup reaches a near completion point the Setup receives the following Error has occurred: Service 'SQLBrowser start request failed. Click Retry to retry the failed action, or click Cancel to cancel this action and continue setup.

Failed on Start (retrying)

  
hi, my workflow is in state failed on start (retrying) after some minutes, the workflow goes in progress and then completed;   an other workflow (allready running) works fine after start but needs looooong time to complete;   even a simple test workflow --> onitemactivated --> set state complete fails on start....   but there too, after some time, the workflow completes...     whats wrong there???  

Approval Workflow Failed to Start

  
they are the standard worflows in sharepoint we have suddenly starting getting the message Workflow Failed to Start retrying. the workflows it says not started we are the manually able to start them i tried deleting and recreating the workflows but still come up with this message there are 8 sites and they all have the same problems i had a look in the log and have this error 8e2r    Medium      Possible mismatch between the reported error with code = 0x81070504 and message: "There is no Web named "/Claims/default.aspx"." and the returned error with code 0x80070002.      01/29/2010 09:46:06.62     w3wp.exe (0x16C8)                           0x0288    Windows SharePoint Services       General                           8e2s    Medium      Unknown SPRequest error occurred. More information: 0x80070001   

Implementing Transaction in SSIS Package - [Execute SQL Task] Error: Failed to acquire connection "<

  
I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server. When I execute this package It works fine. So far so good. Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error. [Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection. "NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all DTC settings on the dev as well as Database server. Please respond if anyone has any solution. Thanks! Anand

The SQL Server service failed to start

  
Hi, I'm trying to install SQL Server2005 Express but get the following error:       The SQL Server service failed to start Attempts to start the service manually have failed. Pse advice. Thanks,tonyKM #######################################################Error Signature:####################################################### EventType: sql90setup  P1 : do_sqlscript  P2 : 0x733fP3: sqls__service__start P4 : 0x42b  P5 : sqlsetuplib_service.cpp@301 P6 : sqlca.dll@2005.90.1399.0 P7 : sqlrun_sql.msi@9.00.1399.06 #######################################################LOG File####################################################### Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time            : Mon Dec 05 17:18:40 2005  MKE303 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.Machine         : MKE303 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install        

Session "WSSUSAGESESSION14" failed to start with the following error: 0xC0000022

  

Getting this error in event log. Anyone seen this before?

 


The server failed to resume the transaction. Desc:4800000002

  

Hi friends !

I have a problem with SQL Server 2008. When I insert / update into DB then exception is thrown:

   The server failed to resume the transaction. Desc:4800000002

Pls help me solve this problem.

Thank u

 


The remote server returned an error: (401) Unauthorized. Failed to execute web request for the speci

  

Hi,

I am creating reports using SQL business intelligence 2008.

Connection string 'http://<SharepointServer>/_vti_bin/lists.asmx '.

And i have created a data set using the below xml query.

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems </SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/ " Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{GUID of the list}</DefaultValue>      
         </Parameter>      
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

 

When I try to execute th

SharePoint Workflow : Failed to Start when a document is added to library from server-side object mo

  

When I add a document using my server-side object model code, I get an exception "The type or namespace name 'Office' does not exist in the namespace 'Microsoft'" in the server logs and in the library I can see the Workflow status as "Failed to Start".

...

myLibrary.Files.Add(...);

myLibrary.Update();

...

Interestingly, when I add a document to the same library from sharepoint site portal, it works just fine, the workflow kicks off with the state : in-progress.

Also, I modified the task form for the Approval workflow template from SharePoint Designer using infopath.(Not sure if that be a problem as adding from portal works fine.)

What am I missing out here??

 Details of the exception:

09/29/2010 18:11:19.15  w3wp.exe (0x2508)                        0x2710 SharePoint Foundation          Workflow Infrastructure        98d8 Unexpected Microsoft.SharePoint.SPException: <Error><CompilerError Line="0" Column="20" Text="The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (a

The SQL Server(2005 express) service failed to start. Error 29503

  

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.

Initially the SQL Server was running over there, later one day it stopped. When trying to start manually I got "The process terminated unexpectedly" error. Tthen I uninstalled it and tried to install again, but got "Error 29503. The SQL Server service failed to start" error while installation and installation rolled back. If I install it using Local System and without "Enable User Instance" I get same error but after multiple retry it started. However my desktop application is not running and giving error message "Failed to generate a user instance of SQL Server due to a failure process for the user instance. The connection will be closed".

I tried "sp_Configure .......... " and "Reconfigure" to enable user instance but still got "Failed to generate......" error.

Another problem is that SQL Server service starts in multiple retry.

I have tried most of the forum solutions however I am still getting the same error in my desktop application. Mos

The SQL Server(2005 express) service failed to start.

  
subject:The SQL Server(2005 express) service failed to start.

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.


I have tried most of the forum solutions however I am still getting the same error in my desktop application. Most of the experts on the forum usually ask for the log where the reason might be. So I am pasting my error log below.
I went through the whole log but I couldnt figure out anything in this. Can anyone help us out trying to figure out whats wrong by checking this below.
Its been a week I am trying to figure out whats going on. 


=== Verbose logging started: 9/13/2010  19:14:48  Build type: SHIP UNICODE 3.01.4001.5512  Calling process: c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (04:38) [19:14:48:875]: Resetting cached policy values
MSI (c) (04:38) [19:14:48:875]: Machine policy value 'Debug' is 0
MSI (c) (04:38) [19:14:48:875]: ******* RunEngine:
           ******* Product: c:\83b6a4866f90056a547

SP2 failed only on the Database engine; the MSSQLSERVER service cannot start

  

  I tried to apply the SP2 on a newly installed SQL Server 2005 Developer edition. The installation failed and the MSSQLSERVER service does not start. I work on 32 bits Windows Server 2003 Standard Edition SP1 with all the patches up to date. I downloaded SQL Server 2005 SP2 on March 15, 2007.

Here are the error messages from 2 of the log files:

Summary.txt:

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number              : 29534
Error Description         : MSP Error: 29534  Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (-2146885

StartResourceService: Failed to start SQLSERVERAGENT service

  

Dear all,

We have problem with SQL Server Agent service running on Fail-Over Cluster at Windows Server 2003 R2 Enterprise Edition. Agent service won't started. These error founded in Event Viewer :


System Event Log
================
Event Type: Error
Event Source: ClusSvc
Event Category: Failover Mgr
Event ID: 1069
Date:  1/11/1990
Time:  5:48:55 PM
User:  N/A
Computer: JSXDBET1
Description:
Cluster resource 'SQL Server Agent' in Resource Group 'MSDTC Group' failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Application Event Log
=====================
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Failover
Event ID: 53
Date:  1/11/1990
Time:  5:48:55 PM
User:  N/A
Computer: JSXDBET1
Description:
[sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1


For more information, see Help and Support Center at

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend