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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Deadlock error with services

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server


I got the below error from application server.May know what is the cause?is this with SQL Server databse or application server.I am really worried about this error.

Here is the log :

2010-09-28 12:26:55,118 pool-2-thread-8 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] - <Getting transaction for [com.maximus.sdc.process.ProcessManagerService.getStepInstanceForReference]>
2010-09-28 12:26:55,118 pool-2-thread-8 DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate] - <Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@1d982af8] for iBATIS operation>
2010-09-28 12:26:55,118 pool-2-thread-8 DEBUG [java.sql.Connection] - <{conn-108743} Connection>
2010-09-28 12:26:55,118 pool-2-thread-8 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - <Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@6b7547a3] for key [org.apache.commons.dbcp.BasicDataSource@394300c8] bound to thread [pool-2-thread-8]>
2010-09-28 12:26:55,118 pool-2-thread-7 DEBUG [java.sql.PreparedStatement] - <{pstm-108741} Executing Statement:    SELECT         PROCESS_INSTANCE.PROCESS_INSTANCE_ID AS "PI.PROCESS_INSTANCE_ID",      PROCESS_INSTAN

View Complete Post

More Related Resource Links

Reporting Services Error



         This is the error I m getting. Can anyone tell me what exactly the problem is

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset "DataSet1".
ExecuteReader : CommandText property has not been initialized.


Error installing SharePointRS (Reporting Services AddIn)



I trying to install the SharePointRS AddIn on the SharePoint-Maschine. The installation runs and after the setup does something, it rollback the installation and informs me with just a message, that it was not successful. After searching for the installation log, I've found it in my temp folder. The error was:
"Install error: The 'Mapping' start tag on line 83 does not match the end tag of 'ByExtension'. Line 139, position 7.".
What means this error? How can I solve it?

Greetings, Anatoli.

The whole log file:

User: usrFarmAdmin
Installing Report Server feature.
Calling copyappbincontents command.


copyappbincontents command completed successfully.
Adding Report Server feature to farm.
Installed Report Server feature.
Activating Report Server feature to root level site collections.
Activating feature in web app 'SharePoint - 22222'
Web app 'SharePoint - 22222' does not have a root site collection.
Activating feature in web app 'SharePoint - 80'
Activating feature to root site collection: http://computername
Feature already activated in site collection http://computername
Activating feature in web app 'SharePoint - 8080'
Web app 'SharePoint - 8080' does not have a

Resume SharePoint Services Web Application and returns code 1387 error


Hello everyone! Newbie here. I would like to ask how to start the SharePoint Services Web Application on (WSS3.0,internal database, stanalone users) without getting error 1387 ?

I would love to provide more information regarding this issue but what I got is error 1387 displayed in the browser.

I look forward to seeing you guys feedback from your expertise angle.



Error in Replication: connection was chosen as the victim in a deadlock

I'm using a merge replication with SQL 2008 at server and SQL Express 2008 on subscribers. We are using around 100 subscribers. I'm getting the following error once two subscribers replicate at the same time. The final number of transaction uploaded to the server is always arong 100 and a similar number in the downloads, so the amount of transaction is not an issue. I'he been playing with the merge profile with no luck. The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200990) Get help: http://help/MSSQL_REPL-2147200990 A query executing on Publisher 'xxxxx' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 1205) Get help: http://help/1205 Any idea? This is getting to a critical point where transactions are not being uploaded to the server.  Additonally, there are a lot of blocks between the subscribers, and they are mainly associated with table MSmerge_partition_groups  

Error loading workflow services

Hello, I'm developing a service library using the new wf 4.0 and one of my requirements is that some activities have the ability to be resumed by a client, so i created a wcf resume service that could load a workflow definition and resume a bookmark of that workflow. One of the services i created was a flowchart that has a receive reply activites inside a sequence activity has a start point, after that i have another sequence that have another sequence, yes 2 sequence activities, and my custom activity that needs to be resumed by a client. The 2 nested sequence activites was a something i used only for testing, but if i had those 2 sequence activities nested i got an error when loading that workflow definition in my resume service: 'ObtemPareceres' is not of type 'Sequence'. When loading this instance you must ensure that the activity with name 'ObtemPareceres' implements 'Sequence'. The "ObtemPareceres" is my custom activity, and if i remove that second nested sequence everything works fine. Anyone has any idea of whats going where? thanksFrederico Regateiro

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

"An error occurred during printing. (0x8000405)" eror - reporting services issue

We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it. We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed. Let me know if you had a similar issue. thanks!

I am getting System.Web.Services.Protocols.SoapHeaderException: Server unavailable error?..

 Hi,    I am using WSE 3.0 for my applicaton. when run from the client end I am getting following error.System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message.  at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope)  at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message)  at System.Web.Services.Protocols.SoapServerProtocol.Initialize()  at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)  --- End of inner exception stack trace ---  --- End of inner exception stack trace ---         Help needed on this. re

Windows SharePoint Services v3.0 Database Error

Hi Below is the error from event viewer on the server based on the Above Event Type:     Error Event Source:  Windows SharePoint Services 3 Event Category:          Database Event ID:         3758 Date:               3/18/2009 Time:               4:38:40 PM User:                N/A Computer:       FIB-PORTAL Description: Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.   Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.   For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type:     Error Event Source:  MSSQL$OFFICESERVERS Event Category:          (2) Event ID:         1827 Date:               3/18/2009 Time:               4:38:40 PM User:                FIRSTINLAND\sharepointadmin Computer:       FIB-PORTAL Description: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.Any ideas on the Solution to the Above Issue...Best Regards,Adeoye...

SharePoint Web Services - IIS 7 - Error 503, Service not Available

System: Server 2008 R2 Ent all patched up, SharePoint 2010 Ent with 2 web applications installed and no other sites. The SharePoint Web Services Site in IIS 7.0 has a question mark on its icon. Whe I browse the site either from IIS or my PC I get a generic white Service Unavailable - HTTP Error 503. The service is unavailable. All other sites including Central Administration are good. 

Error calling sharepoint web services from .net 3.5 WCF client...

Code Snippet                 using (OCUserProfileService.UserProfileServiceSoapClient service =                     new TestAndDestroy.OCUserProfileService.UserProfileServiceSoapClient(GetWcfBinding())) {                     service.ClientCredentials.Windows.AllowedImpersonationLevel = TokenImpersonationLevel.Impersonation;                                     PropertyData[] properties = service.GetUserProfileByName("domain\\user.name");                     foreach (PropertyData p in properties) {                        Console.WriteLine(p.Name);                        Console.WriteLine(p.Values);                    }       produces....The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://microsoft.com/webservices/SharePointPortalServer/UserProfileService:GetUserProfileByNameResponse. The InnerException message was 'Error in line 1 position 392. 'Element' 'IsPrivacyChanged' from namespace 'http://microsoft.com/webservices/SharePointPortalServer/UserProfileService' is not expected. Expecting element 'Name | Privacy'.'.  Please see InnerException for more details.   I'm totally stumped, any ideas???

Excel Services 2010 Error - "The workbook cannot be opened."

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error "The workbook cannot be opened." when the page loads. The trusted file locations are set up appropriately. We are using Kerberos authentication. My event viewer showed this "Critical" event (ID: 3760): SQL Database 'Prod_WSS_Content' on SQL Server instance 'servername' not found. Additional error information from SQL Server is included below. Cannot open database "Prod_WSS_Content" requested by the login. The login failed. Login failed for user 'domain\user'. In other words, the service account that ECS was running under did not have permission to the content database. So I granted the user read permission on the database. Then I got the same error and this "Error" level event in the event viewer (ID: 5617): There is a compatibility range mismatch between the Web server and database "Prod_WSS_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to

Analysis Services - Query returns a #error result

Hi, I have a cube - which i had backed up and just retored it. After the restoration, when i try to reply the cube e.g: select [Time].&[200503] on 0 , {[Process].[All process]} on 1 from [myConsolidations] - i recieve an a result showing #error only. What could be the cause of this?

SQL Reporting Services 2008 Role in SCCM 2007 R2 has error component status message (SMS SRS web ser

SQL Reporting Services 2008 (SMS SRS web service is not running on SRS Reporting point server) with SCCM 2007 R2 -error component status message My environment is (x86) Windows Server 2008 SCCM 2007 R2 with SQL 2008.  The configuration is as follows: SCCM Configuration 1.The reporting Point role on SCCM is installed (SMSSRSRP Setup log is states the install was successful)2.DataSource Settings are SCCMSERVER\SCCM_DB  Test Connection Succeeded3.Database Authentication is set to use (Credentials Stored Securely on the Report Server) I've configured the same credentials in the Reporting Services Configuration ManagerI can access SQL Reporting Services without issue and run reports, etc; but I'm continuing to receive these error status messages..  SRSRP.log Repeats the following: Timed Out... SMS_SRS_REPORTING_POINT 4/17/2009 1:01:58 PM 2076 (0x081C)STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SMS Server SITE=SITE_CODE PID=2748 TID=2076 GMTDATE=Fri Apr 17 17:01:59.165 2009 ISTR0="SMS Server" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 4/17/2009 1:01:59 PM 2076 (0x081C)Failures reported during periodic health check by the SRS Server SMS Server. Will retr

Visio Services on Sharepoint error

Hello I have seen other posts regarding this problem but no real solution other than using an RTM version of Visio. When I publish Visio drawings (.vdw) to our Sharepoint 2010 server, I get the following error Visio Services was unable to load this diagram because it was published with an older version of Visio. To resolve this issue, republish this diagram with an updated version of Visio. However my version is 14.0.476.1000 (32bit) which is newer than those mentioned in the other posts. The document makes it to the server just fine and can be opened in Visio from the server but when trying to view on Sharepoint, the error above is returned. Can someone please help? Thanks Thanks

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

SharePoint 2010 Reporting Services Integrated-mode Error

I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?
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