.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

WSS 3.0 - Unknown SQL Exception 156 occurred.

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :SharePoint


I frequently have this error un my WSS logs. Is there a patch ?



WSS 3.0 French SP2 version

Log :

Une exception SQL inconnue 156 s'est produite. Des informations supplémentaires sur l'erreur provenant de SQL Server sont décrites ci-dessous.
Syntaxe incorrecte vers le mot clé 'AND'.
Pour plus d'informations, consultez le centre Aide et support à l'adresse http://go.microsoft.com/fwlink/events.asp.

10/12/2010 16:11:11.45 w3wp.exe (0x1418)            0x0840 Windows SharePoint Services  Database            880i High   System.Data.SqlClient.SqlException: Syntaxe incorrecte vers le mot clé 'AND'.   à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)   à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   à System.Data.SqlClient.SqlDataReader.ConsumeMetaData()   à System.Data.SqlClient.SqlDataReader.get_MetaData()   à System.Data.SqlClient.SqlComma

View Complete Post

More Related Resource Links

An unhandled exception of type 'System.Net.Sockets.SocketException' occurred in system.dll

Additional information: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respondThis error occurs when i was executing a vc++.net program implementing ICMP....Error occurs when executing this statement... iRet=st->ReceiveFrom(RecvByte,RecvByte->Length,SocketFlags::None,&senderRemote);How to solve this problem????

Error: A native exception has occurred in my_file.exe

Hello everyone,   This error is occurring with me when I am working with SSCE in my pocket PC. Can anyone tell me why?   Thanks!

A first chance exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll

I've read a bit about this error and maybe I have nothing to worry about.  BUT ... my simple little app gets 7 of these before it even gets to the first Dim statement in the Class Form1!  I found and followed instructions on how to have the Debugger intercept these exceptions but it seems that they are not being intercepted.  I only know that they have happened because of the messages in the Immediate Window.  In the Designer all I have is 5 Labels and 5 TextBoxes.   Any thoughts on how I could get to the cause of these messages? Thanks,  Bob

An exception occurred during the operation, making the result invalid

Hi I am using WCF services with WPF, both are .net 4 versions. I am calling asynchronously, During method calls, sometimes I get the following error Void RaiseExceptionIfNecessary()---An exception occurred during the operation, making the result invalid. Check InnerException for exception details. at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary() I tried alot to find the reason , but unable to find as it is unpredictable and inconsistent. Seeking for kind help from WCF guruzzz... Regards Zee

Getting Error " Error occurred in deployment step 'Add Solution': Exception from HRESULT: 0x810702

i'm getting the following error when deploying my sharepoint project i've created 3 site templates by adding according to this article http://www.sharepointbits.com/blog/sharepoint-2010-custom-site-templates.html but when i deployed my project i got the following Error occurred in deployment step 'Add Solution': Exception from HRESULT: 0x8107026E

Exception of type 'System.ServiceModel.FaultException`1' occurred in WCF library

Hi, While Throwing Custom Fault Exception, am getting the warning message as An exception of type 'System.ServiceModel.FaultException`1' occurred in IAuthentication.DLL but was not handled in user code But Fault Exception handled in Client Side Please let me know, How Can I suppress this warning? Regards, Ganesh

System.Net.WebException:an Exception occurred during a Webclient request.

Hi, I have a winforms application where in i want to access the application folder. I am workign on a vista pc. When i try to access the folder, i am getting he folllowing error: System.Net.WebException:an Exception occurred during a Webclient request. ---->System.UnauthorizedaccessException:Accessto the path "C:\ProgramFiles\...\setup.exe" is denied. How can i change this? Is there anyway i can give permissions from within the code? Or is there any other way to resolve this issue? Thanks

An unhandled exception of type 'System.Net.WebException' occurred in system.dll Additional inform

Hi , I am giving my functioon below. I am getting the error when  executing  "       streamInput = HTTPWebRequest.GetRequestStream                "   error is  An unhandled exception of type 'System.Net.WebException' occurred in system.dll  Additional information: The underlying connection was closed: Could not establish secure channel for SSL/TLS.  Sorry for my bad english  Private Function GetXMLMarkIntnlResponse(ByVal strRequest As String) As String         Dim HTTPWebRequest As HttpWebRequest         Dim HTTPWebResponse As HttpWebResponse         Dim Encoding As System.Text.UTF8Encoding         Dim byte1 As Byte()         Dim streamInput, streamOutPut As Stream         Dim strmReader As StreamReader         Dim strURL As String = "https://beta.triseptapi.com/9.0/vax.asmx"         HTTPWebRequest = CType(WebRequest.Create(strURL), HttpWebRequest)         HTTPWebRequest.Method = "Post"         HTTPWebRequest.ProtocolVersion = HttpVersion.Version11         HTTPWebRequest.C

an unhandled exception occurred in the silverlight application sharepoint 2010

An unhandled exception occurred on the page when Try to create the Announcement List in SP 2010 site which is upgraded from SP 2007,Any body have faced this issue?

An exception occurred when trying to issue security token: The trusted login provider did not supply

We are facing the issue after got authenticated by OpenID and forwarded back to Sharepoint, it crashed at the /_trust/ page the error "Operation is not valid due to the current state of the object." and event log shows this:   "An exception occurred when trying to issue security token: The trusted login provider did not supply a token accepted by this farm... "    

An unhandled exception has occurred, NEED HELP

Event code: 3005  Event message: An unhandled exception has occurred.  Event time: 9/18/2010 8:35:46 AM  Event time (UTC): 9/18/2010 1:35:46 PM  Event ID: 480e384289004c2cbdee1d9c2cf7792e  Event sequence: 243392  Event occurrence: 1013  Event detail code: 0    Application information:      Application domain: /LM/W3SVC/9/ROOT-1-129291951636879194      Trust level: Full      Application Virtual Path: /      Application Path: D:\Websites\123Tagged_New\      Machine name: HOST361488    Process information:      Process ID: 6016      Process name: w3wp.exe      Account name: IIS APPPOOL\123tagged    Exception information:      Exception type: ChangeConflictException      Exception message: Row not found or changed.    Request information:      Request URL: http://www.123tagged.com/Comments.aspx?Cat=Good_Morning      Request path: /Comments.aspx      User host address:      User:       Is authenticated: False      Authentication Type:       Thread account name: I

Sys.WebForms.PageRequestManager ServerErrorException: An unknown error occurred while processing the



I am executing a SSRS 2008 report from report manager so it opens in a web browser. Since it is a big report it takes some time for execution. During this time i get an error icon on the left bottom of the web browser and the execution stops. When I click open the error icon to see the details it says,

"Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12029." 

I have no clue what it is up to. Please help me on this.

The other relatively smaller reports are coming up successfully without any issue.

I am using SQL Server 2008 R2 64 bit ent. edition and the OS is Win Server 2003 64 bit SP 2.


Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the



 I am using Ajax RC 1.0

Initially my application was simple ASP.NET 2.0 application and later on client decided for implementing AJAX.

My form is containg datagridview inside UpdatePanel and one textbox also. datagridview is having all rows editable. I have master page implemented.

I am updating records on lost focus of any text box(inside datagridview  and outside also) 

Problem is that I am able to run my application locally without any problem. But when I am publishing my website on server it is giving me following error:

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500

I have uploaded following DLL's on server: AjaxControlToolkit.dll, AJAXExtensionsToolbox.dll, Microsoft.Web.Extensions.Design.dll and Microsoft.Web.Extensions.dll

Please let me know the solution of this problem.

MembershipUser.UnlockUser() throws exception: A constraint violation occurred. (Exception from HRESU



I'm having some problems getting code to work that'll re-enable a locked out account. Below is my code:

public bool ChangeAccountStatus(string username, bool enable)

                if (AzMan.CheckAccess(Operations["ChangeAccountStatus"], null) == false)
                    throw new SecurityException();

                MembershipUser user = Membership.GetUser(username);
                if (enable)
                    user.IsApproved = true;
                    if (user.IsLockedOut)
                    user.IsApproved = false;

                return enable;
            catch (Exception e)
                return !enable;

Enabling a disabled account works fine but when the account is locked out, I hit the user.UnlockUser() line and get the following exception:

Message "A constraint violation occurred. (Exception from HRESULT: 0x8007202F)"

StackTrace " at System.DirectoryServices.DirectoryEntry.CommitChanges()\r\n


Error When Joining Reporting Server to Farm: "Task configdb has failed with an unknown exception" an


This is apparently a very common error message, as I see numerous posts about it on these forums.  Unfortunately, none of the solutions have worked for me.  So I'm hoping somebody knows what is happening in my case.

CURRENT FARM (all in same domain):

Server Web3, Windows Server 2003 R2 (x86) <- WFE, WSS 3.0, SP2
Server Web4, Windows Server 2003 R2 (x86) <- WFE, WSS 3.0, SP2 (also Central Admin host)
Server SQL2, Windows Server 2003 R2 (x64) <- Database server for WSS installation (SQL 2008)
Server SQL5, Windows Server 2008 R2 (x64) <- New reporting server (SQL 2008), WSS 3.0 SP2 - unjoined from farm

- Reporting server database is configured in Sharepoint integrated mode.
- All WSS servers are at SP2.  I have double, triple, and quadruple checked this.  Build on all three servers is 12.0.6425.1000 (as retrieved from Add/Remove Programs and Programs and Features, respectively.)
- No additional hotfixes were applied after SP2.

When trying to join my new server (SQL5) to the existing farm using the configuration wizard, I get the following error...

10/11/2010 19:21:16  8  ERR                      Task configdb has failed with an unknown exception

Cannot start sharepoint workflow using "SPWorkflowManager.StartWorkflow" - unknown exception is thro



I have been working on a sharepoint project for a month now and it seems nothing just works right off the bat even if I go online and copy from someone's implementation.

I read about starting workflows programmatically from this site and I am currently using the following code to start my workflow.



    SPListItem item = workflowProperties.Item;

                    SPWorkflowManager objWorkflowManager = item.Web.Site.WorkflowManager;

                    SPWorkflowAssociationCollection associatedWorkflows = item.ParentList.WorkflowAssociations;

                    SPWorkflowAssociation workflow = associatedWorkflows.GetAssociationByName(

                        "ConfirmationFlow", System.Globalization.CultureInfo.CurrentCulture);


                    //Find the GUID for the workflow association 

                    string strSerializedParams = Utils.Serialize(r, new XmlSerializer(typeof(MyType)));


SharePoint (MOSS2007) + Office2003 + IE 6 => crash: "unknown software exception (0xc06d007f)"


We use MOSS2007 and all users use Office2003. Some users cannot enter the SharePoint pages as IE6 crashes when they try to (generally enter not just commit changes or whatsoever).

Although it is technically possible to perform changes on the OWSSUPP.DLL the users are far away and not very skilled. This would be the last measure to take if nothing else works.

There were related topics already discussed Related topics already discussed as having been patched but here everything gets a bit difficult. I cannot make the users perform updates that have not been specified by an internal institution. It is thus not enough for us that this issue has been fixed in updates. I have to know which patches or updates are necessary so that I can request them to be installed.

I would be really great if someone would share further details on the necessary updates.

Thank you very much.

With kind regards,


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