More Annotations

Favourite Annotations

Text

SHAREPOINT BULLETIN

MUHAMMAD RAJA

Put your WSDL file in somewhere accessible e.g. in this case I will put it in my C drive and getting output CS class in C drive too but you can change it. Type this command and press okay, C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>wsdl /l:C# /out:C:\OutPutClassName.cs C:\myWebService.wsdl. Above command will generate a CS class in SHAREPOINT BULLETIN: A CONTROL WITH ID 'TOPSITEMAP' COULD Be careful while using WSP Builder for some reason when you try to "Uninstall" a solution it removes dlls from gac and web app bin's folder, not sure about web.config but you should always keep a SHAREPOINT BULLETIN: GETTING SPUSER USING LOGIN NAME User can input anything (any string) so I need to validate if user name (s) exists or not, if user with login name provided has access to site collection page and at end if all previous are true then get SPUser object and add it to people picker field of custom list. string other = string.Format ("EXCEPTION! UserName ' {0}' provided doesn't

has

CERTIFICATE FOR SHAREPOINT WEBSITE WITH SSL I followed this blog post for installation of Certificate but you can just go to control panel, then add remove programs and then add system compnent or something like that, select certificate role. SHAREPOINT BULLETIN: RESTRICTING PICTURE SIZE IN If you want to restrict user from uploading a picture larger then specified size (width x height) then you can use code below. Please note it only works when user uploads a single picture file, when user uploads multiple files, SharePoint opens Microsoft picture manager to upload several pictures hence HTTP Context comes as null. SHAREPOINT BULLETIN: HOW TO CHECK ERROR'S ON K2 BLACK If you want to see data related to process instance e.g. Data or XML fields then go back to previous page and click on it's Process's Folio e.g. Empty Folio in this case, you can set process instance's folio in process to be more specific e.g. have some title or id instead of Empty Folio.Clicking on process instance Folio will display further details e.g. Activity Name, Status, and then SHAREPOINT BULLETIN: MAILBOX UNAVAILABLE. THE SERVER Mailbox unavailable. The server response was: 5.7.1 Unable to relay for Working on SharePoint 2013, running some custom code, which was trying to send an email through a shared SMTP server (virtual SMTP on IIS 6 as IIS7 doesn't supports it as far as I know, it's something I still need to look at so don't take my words on "it doesn't work on IIS7"), I received this error, SHAREPOINT BULLETIN: HOW TO CHECK IF A SPWEB EXISTS WITHIN SharePoint objects get bit tricky when it comes to check if an objects exists or not specially in SharePoint 2007. Today I came across a situation where I had to check if a web exists or not, so I SHAREPOINT BULLETIN: JULY 2013 If you want to see data related to process instance e.g. Data or XML fields then go back to previous page and click on it's Process's Folio e.g. Empty Folio in this case, you can set process instance's folio in process to be more specific e.g. have some title or id instead of Empty Folio.Clicking on process instance Folio will display further details e.g. Activity Name, Status, and then

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

Promp

SHAREPOINT BULLETIN: DEBUGGING WCF SERVICE USING Debugging web services can be pain, specially when they are hosted on a application server within a SharePoint farm. There are several ways one can debug web services though, e.g. using a visual studio remote debugger but what if it doesn't hit your web services breakpoints or your network administrator do? SHAREPOINT BULLETIN: DISABLING CONTROLS WITHIN A CSS CLASS This will definitely work when you have a div with class named as "myCSSClassName:input" it will disable all controls within this specific class. Other possible ways of disabling controls within a CSS class are mentioned below but they didn't worked for me, $ ('input.myClass').click (function (e) {. e.preventDefault (); SHAREPOINT BULLETIN: HOW TO CHECK ASSEMBLY RELATED ERRORS Click on settings and check box Log all binds to disk as shown, you can also select "Custom log path" but make sure directory exists. If your log was disabled before then you might need to do a IIS reset to make it start working. SHAREPOINT BULLETIN: FEBRUARY 2014 In some cases you will need to open the EXE file as administrator. Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: SHAREPOINT BULLETIN: STORED PROCEDURE TO QUERY DATA USING Working on this task required me to create a stored procedure which will get a list of strings, do some processing on them and then return

some data.

SHAREPOINT BULLETIN: SYSTEM.SERVICEMODEL ASSEMBLY IS NOT As soon as we changed the way we were calling custom WCF web services, we started getting this error, Description: Type 'System.ServiceModel.Dispatcher.NetDispatcherFaultException' in Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=""' is not marked as serializable. Server stack trace: SHAREPOINT BULLETIN: DIRECTORY SERVICES RESTORE MODE NIGHTMARE Directory Services Restore Mode NightMare. In short, I got a development virtual machine I run on my PC using virtual box, it's a stand alone SharePoint 2007 box along with SQL Server 2005 and K2 server 2003. I was testing something which actually hanged my VPC machine and as a result I had to power off it which is

SHAREPOINT BULLETIN

MUHAMMAD RAJA

Following several guides and going through many articles at last I am able to install SharePoint Apps on my environment, you will find several incomplete and confusing articles on internet. SHAREPOINT BULLETIN: CONVERT WSDL FILE TO A C# CLASS AND Put your WSDL file in somewhere accessible e.g. in this case I will put it in my C drive and getting output CS class in C drive too but you can change it. Type this command and press okay, C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>wsdl /l:C# /out:C:\OutPutClassName.cs C:\myWebService.wsdl. Above command will generate a CS class in SHAREPOINT BULLETIN: A CONTROL WITH ID 'TOPSITEMAP' COULD Be careful while using WSP Builder for some reason when you try to "Uninstall" a solution it removes dlls from gac and web app bin's folder, not sure about web.config but you should always keep a SHAREPOINT BULLETIN: DEBUGGING WCF SERVICE USING Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: Press Ctrl + O keys; Navigate to SdrConfigExample.e2e file to load log trace file in viewer. Step-5: SHAREPOINT BULLETIN: GETTING SPUSER USING LOGIN NAME User can input anything (any string) so I need to validate if user name (s) exists or not, if user with login name provided has access to site collection page and at end if all previous are true then get SPUser object and add it to people picker field of custom list. string other = string.Format ("EXCEPTION! UserName ' {0}' provided doesn't

has

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

SHAREPOINT BULLETIN

Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: Press Ctrl + O keys; Navigate to SdrConfigExample.e2e file to load log trace file in viewer. Step-5: SHAREPOINT BULLETIN: QUICK GUIDE FOR SETTING UP SHAREPOINT Following several guides and going through many articles at last I am able to install SharePoint Apps on my environment, you will find several incomplete and confusing articles on internet. CERTIFICATE FOR SHAREPOINT WEBSITE WITH SSL I followed this blog post for installation of Certificate but you can just go to control panel, then add remove programs and then add system compnent or something like that, select certificate role. SHAREPOINT BULLETIN: FEBRUARY 2014 In some cases you will need to open the EXE file as administrator. Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: SHAREPOINT BULLETIN: HOW TO CHECK ASSEMBLY RELATED ERRORS Click on settings and check box Log all binds to disk as shown, you can also select "Custom log path" but make sure directory exists. If your log was disabled before then you might need to do a IIS reset to make it start working. SHAREPOINT BULLETIN: JULY 2013 If you want to see data related to process instance e.g. Data or XML fields then go back to previous page and click on it's Process's Folio e.g. Empty Folio in this case, you can set process instance's folio in process to be more specific e.g. have some title or id instead of Empty Folio.Clicking on process instance Folio will display further details e.g. Activity Name, Status, and then SHAREPOINT BULLETIN: STORED PROCEDURE TO QUERY DATA USING Working on this task required me to create a stored procedure which will get a list of strings, do some processing on them and then return

some data.

SHAREPOINT BULLETIN: MARCH 2014 Today I have been working on a custom WCF web services which was trying to download a document from a SharePoint list to a workflow server, it worked perfectly until we decided to change the way our workflow server authenticates(for some reason), so we created a proxy which will be used to call custom WCF service from workflow server instead of adding a web reference. SHAREPOINT BULLETIN: DIRECTORY SERVICES RESTORE MODE NIGHTMARE Directory Services Restore Mode NightMare. In short, I got a development virtual machine I run on my PC using virtual box, it's a stand alone SharePoint 2007 box along with SQL Server 2005 and K2 server 2003. I was testing something which actually hanged my VPC machine and as a result I had to power off it which is SHAREPOINT BULLETIN: APRIL 2013 Few days back I needed to deploy few projects on production server's, since our SharePoint 2007 is properly customized and GAC is packed with custom solutions assemblies, and these solutions do get updated

regularly.

SHAREPOINT BULLETIN: A CONTROL WITH ID 'TOPSITEMAP' COULDAUTHOR:

MUHAMMAD RAJA

Be careful while using WSP Builder for some reason when you try to "Uninstall" a solution it removes dlls from gac and web app bin's folder, not sure about web.config but you should always keep a backup

copy of it.

SHAREPOINT BULLETIN: DEBUGGING WCF SERVICE USINGAUTHOR: MUHAMMAD RAJA Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: Press Ctrl + O keys; Navigate to SdrConfigExample.e2e file to load log trace file in viewer. Step-5: SHAREPOINT BULLETIN: GETTING SPUSER USING LOGIN NAME User can input anything (any string) so I need to validate if user name (s) exists or not, if user with login name provided has access to site collection page and at end if all previous are true then get SPUser object and add it to people picker field of custom list. string other = string.Format ("EXCEPTION! UserName ' {0}' provided doesn't

has

MUHAMMAD RAJA

copy of it.

has

some data.

SHAREPOINT BULLETIN: JULY 2013 If you want to see data related to process instance e.g. Data or XML fields then go back to previous page and click on it's Process's Folio e.g. Empty Folio in this case, you can set process instance's folio in process to be more specific e.g. have some title or id instead of Empty Folio.Clicking on process instance Folio will display further details e.g. Activity Name, Status, and then SHAREPOINT BULLETIN: SYSTEM.SERVICEMODEL ASSEMBLY IS NOT As soon as we changed the way we were calling custom WCF web services, we started getting this error, Description: Type 'System.ServiceModel.Dispatcher.NetDispatcherFaultException' in Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=""' is not marked as serializable. Server stack trace: SHAREPOINT BULLETIN: JUNE 2013 Today I was trying to update a web reference of custom web services in my project but because of some reason visual studio 2010 wasn't getting the latest methods I added even though I could see them using

browser.

SHAREPOINT BULLETIN: UPDATING RESOURCES IN 12 HIVE When we update resources in 12 hive Resources, we need to do a IIS reset to make changes get picked up by SharePoint. I was trying to create a new site using a custom Site Definition but because of wrong resource name of a list I was getting exception however when I changed resource and tried to create site again it didn't worked until I performed a IIS reset. SHAREPOINT BULLETIN: DIRECTORY SERVICES RESTORE MODE NIGHTMARE Directory Services Restore Mode NightMare In short, I got a development virtual machine I run on my PC using virtual box, it's a stand alone SharePoint 2007 box SHAREPOINT BULLETIN: A CONTROL WITH ID 'TOPSITEMAP' COULDAUTHOR:

MUHAMMAD RAJA

copy of it.

has

MUHAMMAD RAJA

copy of it.

has

some data.

browser.

MUHAMMAD RAJA

copy of it.

has

MUHAMMAD RAJA

copy of it.

has

SHAREPOINT BULLETIN: CONVERT WSDL FILE TO A C# CLASS AND Put your WSDL file in somewhere accessible e.g. in this case I will put it in my C drive and getting output CS class in C drive too but you can change it. Type this command and press okay, C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>wsdl /l:C# /out:C:\OutPutClassName.cs C:\myWebService.wsdl. Above command will generate a CS class in SHAREPOINT BULLETIN: SYSTEM.SERVICEMODEL ASSEMBLY IS NOT As soon as we changed the way we were calling custom WCF web services, we started getting this error, Description: Type 'System.ServiceModel.Dispatcher.NetDispatcherFaultException' in Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=""' is not marked as serializable. Server stack trace: SHAREPOINT BULLETIN: FEBRUARY 2014 In some cases you will need to open the EXE file as administrator. Step-3: Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file. Step-4: SHAREPOINT BULLETIN: MAILBOX UNAVAILABLE. THE SERVER Mailbox unavailable. The server response was: 5.7.1 Unable to relay for Working on SharePoint 2013, running some custom code, which was trying to send an email through a shared SMTP server (virtual SMTP on IIS 6 as IIS7 doesn't supports it as far as I know, it's something I still need to look at so don't take my words on "it doesn't work on IIS7"), I received this error, SHAREPOINT BULLETIN: HOW TO CHECK IF A SPWEB EXISTS WITHIN SharePoint objects get bit tricky when it comes to check if an objects exists or not specially in SharePoint 2007. Today I came across a situation where I had to check if a web exists or not, so I SHAREPOINT BULLETIN: SEPTEMBER 2013 In order to use this utility you need to have installed Microsoft SDKs or it gets installed when you installed visual studio. I have installed Visual Studio 2008 on Windows Server 2003 so my guide will be based on it. Open Visual Studio 2008 command prompt and navigate to directory. C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin>. SHAREPOINT BULLETIN: 2014 Debugging web services can be pain, specially when they are hosted on a application server within a SharePoint farm. There are several ways one can debug web services though, e.g. using a visual studio remote debugger but what if it doesn't hit your web services breakpoints or your network administrator do? SHAREPOINT BULLETIN: QUICK GUIDE FOR SETTING UP SHAREPOINT Following several guides and going through many articles at last I am able to install SharePoint Apps on my environment, you will find several incomplete and confusing articles on internet. CERTIFICATE FOR SHAREPOINT WEBSITE WITH SSL I followed this blog post for installation of Certificate but you can just go to control panel, then add remove programs and then add system compnent or something like that, select certificate role. SHAREPOINT BULLETIN: DEBUGGING WCF SERVICE USING Debugging web services can be pain, specially when they are hosted on a application server within a SharePoint farm. There are several ways one can debug web services though, e.g. using a visual studio remote debugger but what if it doesn't hit your web services breakpoints or your network administrator do? SHAREPOINT BULLETIN: HOW TO CHECK ASSEMBLY RELATED ERRORS Click on settings and check box Log all binds to disk as shown, you can also select "Custom log path" but make sure directory exists. If your log was disabled before then you might need to do a IIS reset to make it start working. SHAREPOINT BULLETIN: STORED PROCEDURE TO QUERY DATA USING Working on this task required me to create a stored procedure which will get a list of strings, do some processing on them and then return

some data.

browser.

SHAREPOINT BULLETIN

SharePoint Development and Configuration THURSDAY, 24 JULY 2014 VISUAL STUDIO DEPLOYMENT CONFIGURATION It happens to be the case when you want to make some changes to a feature and redeploy it using VS but sometimes it doesn't work the way it should or worked first time around. I tried to deploy a WSP solution containing 3 list definitions & instances, but VS 2012 kept trying to activate features when I don't need it, well at least at the time of solution deployment. PACKAGING EXPLORER DEPLOYMENT CONFIGURATION Visual Studio 2012 lets you use Packaging Explorer to configure WSP solution deployment. So to change them within the properties tab I set "Activate on Default" to False, but VS 2012 just ignored it and still tried to activate the feature and threw an error - which is another

story,

Did some research and figured out these properties within Packing Explorer are set to be used when we deploy the solution by command line or using Power Shell only e.g. VS ignores them. Ummm so does this means we can't change solution deployment configuration when deploying using VS 2012 then.... Answer is Yes, you can but at VS project level

!!

VISUAL STUDIO DEPLOYMENT CONFIGURATION While deploying a WSP solution VS follows steps provided within project specific deployment configuration setup for SharePoint as

shown below,

Just select the deployment steps you want VS to follow when deploying a WSP solution for a project and it should all work fine... Posted by Muhammad Raja at 03:02

No comments:

Email This

BlogThis!

to Twitter

to Facebook

to Pinterest

Labels: SharePoint 2013

,

Visual Studio

,

WSP Deployment

TUESDAY, 18 MARCH 2014 SYSTEM.SERVICEMODEL ASSEMBLY IS NOT MARKED AS SERIALIZABLE Most frustrating thing you ever going to come across is debugging web services, but not if you know the tricks & tools which you could use to get to the root of problem causing the error in the services at the first place. Web services related errors can be deceiving and forcing you to look at places that work perfectly. Today I have been working on a custom WCF web services which was trying to download a document from a SharePoint list to a workflow server, it worked perfectly until we decided to change the way our workflow server authenticates(for some reason), so we created a proxy which will be used to call custom WCF service from workflow server instead of adding a web reference. As soon as we changed the way we were calling custom WCF web services, we started getting this error, > Description: Type > 'System.ServiceModel.Dispatcher.NetDispatcherFaultException' in > Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, > PublicKeyToken=""' is not marked as serializable. > Server stack trace:

> at

> System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object > obj, ISurrogateSelector surrogateSelector, StreamingContext context, > SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, > ObjectWriter objectWriter, SerializationBinder binder) So looking at error initially, I thought it because we are not serializing the document who's details were wrapped up within a object, so I added this "" to our document class,

public class DocumentObject

{

public string documentName;

public byte data;

}

public interface IDocuments

{

DocumentObject GetDocumentsFromList(string listName, string documentNames);

}

On the other side when we tried to deserialize the document I still kept getting this error, > Type 'System.ServiceModel.Dispatcher.NetDispatcherFaultException' in > Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, > PublicKeyToken=f4tue731934e089' is not marked as serializable. > Server stack trace:

> at

> System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Write(WriteObjectInfo > objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo)

> at

> System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object > graph, Header inHeaders, __BinaryWriter serWriter, Boolean fCheck) Since the error saying that, something went wrong while deserializing the object but why though ? I tried using BinaryFormatter to desearlize the method's response from webservices but it didn't helped as same code worked when there was no proxy... anyway, I added includeExceptionDetailInFaults="true" to my custom application's web.config, which was calling the WCF web services, to get the inner

or real exception,

Adding above helped me get to the bottom of problem, which was the size of document it was trying to desearlize. Size limit was

exceeding,

> The InnerException message was 'There was an error deserializing the > object of type MySolution.WebServices.DocumentObject. The > maximum array length quota (16384) has been exceeded while reading

> XML data.

To fix the above, you can either change the web.config of your WCF service and change MaxArrayLength or you can do it within code, XmlDictionaryReaderQuotas readerQuotas = new XmlDictionaryReaderQuotas(); readerQuotas.MaxArrayLength = 1024 * 1024 * 102; //102 Mega bytes readerQuotas.MaxDepth = int.MaxValue; binding.ReaderQuotas = readerQuotas; This solved the issue for me. Posted by Muhammad Raja at 07:50

No comments:

Email This

BlogThis!

to Twitter

to Facebook

to Pinterest

Labels: Errors

, WCF

, Web

Services

TUESDAY, 4 MARCH 2014 MAILBOX UNAVAILABLE. THE SERVER RESPONSE WAS: 5.7.1 UNABLE TO RELAY

FOR

Working on SharePoint 2013, running some custom code, which was trying to send an email through a shared SMTP server (virtual SMTP on IIS 6 as IIS7 doesn't supports it as far as I know, it's something I still need to look at so don't take my words on "it doesn't work on IIS7"), I received this error, Mailbox unavailable. The server response was: 5.7.1 Unable to relay for me@myCompany.com Sending an email code was working on another server in the farm but not on mine, so a bit of googling find me this solution, 1) Go to Server where you or your Network Administrator setup

virtual SMTP server

2) Go to Administrative Tools and click on IIS 6.0 Manager 3) Right click "SMTP Virtual Server" 4) Select Access tab 5) Click on "Relay" in section Relay Restrictions 6) Add 127.0.0.1 if not already in list(for me it was there)and then your server IP address to the list 7) Click "OK" and job Done. I have followed these steps on a development machine and it made the code work for me perfectly, try these steps on Production server on

your own risk ;).

Posted by Muhammad Raja at 08:13

No comments:

Email This

BlogThis!

to Twitter

to Facebook

to Pinterest

Labels: Errors

, SMTP

MONDAY, 17 FEBRUARY 2014 QUICK GUIDE FOR SETTING UP SHAREPOINT ENVIRONMENT FOR APPS Following several guides and going through many articles at last I am able to install SharePoint Apps on my environment, you will find several incomplete and confusing articles on internet. I followed VLAD CATRINESCU article which is to the point and actually works, it took me just 5 minutes to configure my test environment for installing apps from SharePoint online Store. Here's link to Vlad's article, http://www.scribd.com/doc/124831209/Configure-an-Environment-for-Apps-for-SharePoint-2013-Step-by-Step-Guide Since the above article gets into much details along with screenshots, I will just mention important points you need to go through to get it

working,

- Create a forward look-up zone with zone name e.g. "exampleapps.com" - Create a New Alias (CNAME) with name as "*" and FQDN for target host as full name of your SharePoint Server, e.g. www.exampleServer.com or whatever's your server's name is - Now on your try to ping Apps-23423423423.exampleapps.com and get the response, if it doesn't work then either you entered FQDN of target host wrong or your DNS server isn't locating your SharePoint web server. Put a comment if you get stuck here and I will try to help. - Create, configure and start SharePoint App management and Subscription server on your SharePoint server - Now Configure App URLs in Central Admin, App domain going to be exampleapps.com in this case and App prefix will be "Apps" - You will need to configure internet facing endpoints for apps, so I just enabled web application scoped feature named as "Apps that require accessible internet facing endpoints" on my port 80 web

application.

- Create a new web application on port 80, but keep the Host Header option empty and rest options as usual, now note, if you used SharePoint configuration wizard then you don't need to create a new web application because SharePoint configuration wizard by default creates a web application without host headers, so all you need to do is to create a root site collection. - Last but important step, delete Default Website in IIS Server, otherwise you will receive 404 errors for sharepoint apps. Note: I followed these steps on a development server, so try them on production on your own risk :-). MSDN article if you want to follow for setting up App domain. http://technet.microsoft.com/en-us/library/fp161236.aspx Posted by Muhammad Raja at 12:05

No comments:

Email This

BlogThis!

to Twitter

to Facebook

to Pinterest

Labels: configuratoin

,

SharePoint 2013

,

SharePoint Apps

SATURDAY, 15 FEBRUARY 2014 ERROR OCCURRED IN DEPLOYMENT STEP 'UNINSTALL APP FOR SHAREPOINT': THE LOCAL SHAREPOINT SERVER IS NOT AVAILABLE. Hmmm, was excited enough to deploy my first SharePoint hosted app but this error ruined the joys, > _Error occurred in deployment step 'Uninstall app for SharePoint': > The local SharePoint server is not available. Check that the server > is running and connected to the SharePoint farm._ Now what ? error doesn't help much at all, so lets look at logs, the way I debug any issue regarding SharePoint is, - Check event logs in Event Viewer. - If don't find anything in Event Viewer then ULS Viewer, check this

post

if you don't know how to debug using ULS Viewer. Other than that you can also use SVC_Trace exe or fiddler for debugging web services or client side code, anyway coming back to topic, in this case I find the real error in event viewer, > _SQL database login for 'TestServer01_Config' on instance > 'SQLTEST01' failed. Additional error information from SQL Server is > included below._ > _Login failed for user 'DEV\mr'._ So when we deploy a solution to SharePoint site using Visual Studio, it uses the account we are running Visual Studio as to deploy the solution, which in return makes changes to SharePoint config database, so if account doesn't have access to SP config, it will fail to deploy solution. As you would had figured out the solution, just give development account permission to SharePoint config database.

EDIT

I have given my development account SP_DATA_ACCESS

permissions

on all relevant databases as shown in picture below,

EDIT-2

Unfortunately above steps didn't solved the problem and lead to

another error,

>> _SQL Database 'WSS_Content_Dev' on SQL Server instance >> 'TESTSERVER01' not found. Additional error information from SQL >> Server is included below._

>

>> _Cannot open database "WSS_Content_Dev" requested by the login. >> The login failed._

>

>> _Login failed for user 'DEV\mr'._ Giving development user "dev\mr" in this case "SP_Data_Access" permissions on WSS_Content_Dev solved the problem :-). This solved the problem of deploying my first app to SharePoint

server.

NOTE:

I AM GIVING DEVELOPMENT ACCOUNT PERMISSIONS TO SHAREPOINT CONFIGURATION DATABASE BECAUSE IT'S A TEST ENVIRONMENT, HOWEVER IF ON PRODUCTION ENVIRONMENT, YOUR SHAREPOINT ADMINISTRATOR ACCOUNT SHOULD BE DEPLOYING THE SOLUTION AND SHOULD HAVE RIGHT PERMISSIONS ALREADY. Posted by Muhammad Raja at 02:18

No comments:

Email This

BlogThis!

to Twitter

to Facebook

to Pinterest

Labels: SharePoint App Development

,

SharePoint Errors

,

Visual Studio

THURSDAY, 6 FEBRUARY 2014 DEBUGGING WCF SERVICE USING SVCTRACEVIEW ON APPLICATION SERVER Debugging web services can be pain, specially when they are hosted on a application server within a SharePoint farm. There are several ways one can debug web services though, e.g. using a visual studio remote debugger but what if it doesn't hit your web services breakpoints or your network administrator do? Easiest way to figure out what's wrong with web services is to use SvcTraceViewer.exe e.g. why my code not able to find the hosted service or if the problem is with service account authentication. Not so difficult to set it up, all you need to do is to add a some tag in your hosted WCF services and then open the SvcTraceViewer to view

the created file.

STEP-1:

Find hosted WCF service's web.config and add following tag to it within configuration tag. It will recycle the application pool of hosted service itself when you will save changes to web.config file.

type="System.Diagnostics.XmlWriterTraceListener" initializeData= "WcfConfigExample.e2e" />

STEP-2:
Find SvcTraceViewer.exe within installed Visual studio files, location might change depending on version of VS, however since I am using VS 2010 ultimate so I find EXE file at, C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0
Tools
In some cases you will need to open the EXE file as administrator.
STEP-3:
Do something to trigger WCF services and check folder where web.config file exists as that's where it will create "SdrConfigExample.e2e" log file, once you find it. just open the SvcTraceViewer.exe file.
STEP-4:
Press Ctrl + O keys; Navigate to SdrConfigExample.e2e file to load log trace file in viewer.
STEP-5:
Search for specific terms using Ctrl + F or just go through logs. You can also add custom logs to your WCF service and find them in here to figure out where exactly your code is getting exception at, You can find more about Trace Viewer at, http://msdn.microsoft.com/en-us/library/aa751795(v=vs.110).aspx Posted by Muhammad Raja at 01:35
No comments:
Email This
BlogThis!
Share
to Twitter
Share
to Facebook
Share
to Pinterest
Labels: Debugging
, WCF
, Web
Services
THURSDAY, 17 OCTOBER 2013 C# THE HANDLE IS INVALID I have been given a task to debug a SharePoint event receiver as it wasn't doing what was meant to do, so I started by looking at event
viewer logs.
Event viewer error didn't helped much other then saying; Error loading and running event receiver Assembly Details. Additional information is below. : The handle is invalid Searched google lot but couldn't find anything relevant in SharePoint context, but somehow figured out, this error "The handle is invalid" comes up when user doesn't have enough permissions to perform a task and in my case it was when event receiver tried to create a new event log or even when try to write a log to already created event log. Fixed the issue by putting code within SPSecurity.RunWithElevatedPrivileges(delegate(){ }); block, however couldn't figure out which exact permission was required to let user to write event logs but adding above fixed the issue for me, so all good. Posted by Muhammad Raja at 03:25
No comments:
Email This
BlogThis!
Share
to Twitter
Share
to Facebook
Share
to Pinterest
Labels: C#
, Errors
, Event
Receivers
Older Posts
Home
Subscribe to: Posts (Atom)
SEARCH THIS BLOG
BLOG ARCHIVE
* ► 2013 (30)
* ► January
(4)
* ► February
(2)
* ► March (5)
* ► April (2)
* ► May (4)
* ► June (2)
* ► July (2)
* ► August
(1)
* ► September
(6)
* ► October
(2)
* ▼ 2014 (6)
* ► February
(3)
* ► March (2)
* ▼ July (1)
* Visual Studio Deployment Configuration SHAREPOINT EXCHANGE PROFILE Simple theme. Powered by Blogger .

Details

Image Url

HTML Url

Moderation By

More Annotations

Maria Johnson

2020-04-22 02:41:46

Maria Johnson

2020-04-22 02:41:58

Maria Johnson

2020-04-22 02:42:10

Maria Johnson

2020-04-22 02:43:23

Maria Johnson

2020-04-22 02:43:34

Maria Johnson

2020-04-22 02:43:54

Maria Johnson

2020-04-22 02:44:29

Maria Johnson

2020-04-22 02:44:42

Maria Johnson

2020-04-22 02:44:53

Maria Johnson

2020-04-22 02:45:21

Maria Johnson

2020-04-22 02:45:38

Maria Johnson

2020-04-22 02:46:05

Favourite Annotations

Maria Johnson

2019-11-06 14:53:35

Maria Johnson

2019-11-06 14:53:49

Maria Johnson

2019-11-06 14:54:19

Maria Johnson

2019-11-06 14:54:33

Maria Johnson

2019-11-06 14:54:40

Maria Johnson

2019-11-06 14:55:13

Maria Johnson

2019-11-06 14:55:27

Maria Johnson

2019-11-06 14:55:52

Maria Johnson

2019-11-06 14:56:24

Maria Johnson

2019-11-06 14:56:49

Maria Johnson

2019-11-06 14:56:52

Maria Johnson

2019-11-06 14:57:14

Text

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

Promp

some data.

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

SHAREPOINT BULLETIN

MUHAMMAD RAJA

has

SHAREPOINT BULLETIN

some data.

regularly.

MUHAMMAD RAJA

copy of it.

has

MUHAMMAD RAJA

copy of it.

has

some data.

browser.

MUHAMMAD RAJA

copy of it.

has

MUHAMMAD RAJA