Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

The query cannot be run for the following DataObject: InfoPath cannot run the specified query. Access is denied


Hi,

we got the above error while using a Web Service as a data connection.

This is the step we followed to resolve it

Go to Tools–>Form Options–>Select “Security and Trust ” and set it to “Full Trust”.

Bye..

The following users do not have e-mail addresses specified: . Alerts have been created successfully but these users will not receive e-mail notifications until valid e-mail addresses have been provided Set my e-mail address…


Hi,

We were receiving the above error while trying to use the “Alert Me” feature.

The reason was because email was not specified for the user. We can check it over here.

Click on Welcome User Name –> My Settings on the top right corner

There we can see “work e-mail“ as blank.

And if we click on “Edit Item” to edit that information, we can only see the account name and an option for attaching file. So that information cannot be edited over here and why so?

The reason for this is following, i found this in one of the forums for SharePoint

“There are actually 2 user profiles – one is a WSS profile and one is a MOSS profile. The WSS profile you access from Welcome user > My Settings page. The MOSS profiles are created when users are imported into the system from AD or LDAP. They are access from People Search or from a link off of your MySite.

The reason there are 2 is that you can install WSS without MOSS and they wanted a basic user profile. If you installed WSS without MOSS, you would see the profile (again, accessed through Welcome user > My Settings page) with about 3 properties.

If you install MOSS, do an import, and go to the WSS profile, you’ll see a bunch of properties added that MOSS adds. We now depricate the WSS profile. If you want to add property values to your profile, you need to go to your MOSS profile from your MySite (MySite > Details). You’ll be on the editprofile.aspx page. Add your properties. We then sync your properties to the WSS user list. You will see the values show up on the WSS profile after the sync happens.”

So as per the description we need to add the work email to our user profile first and then we need to sync that MOSS’s user profile to our WSS profile.

For this we will first open the Shared Services site,

than select User Profile and Properties—> Select View User Profile –> Select a particular user and edit it’s profile.

We will specify the value for Work e-mail property over there.

Followed by Save and Close.

Now we need to sync it back to WSS profile

For this we need to use the following command

Stsadm -o sync -synctiming m:5

It means that the schedule for the Profile Sync job to run is every five minutes. The default value is 1 hour.

Then run this command line:

Stsadm -o sync -sweeptiming m:1

  • -o -synctiming changes the Profile Sync job
  • -o -sweeptiming changes the Quick Profile Sync job

At times it might not work so we need to follow this step as well

stsadm -o sync -listolddatabases <n> 

stsadm -o sync -deleteolddatabases <n> 

The listolddatabases <n>option will list the databases that have not been successfully syncronized the last <n> days, and the deleteolddatabases <n>option will delete the syncronization information from the databases that are not successfully syncronized the last <n> days.

If this also doesn’t help than we need to do the server reboot. That would definitely work. At least that worked in my case 🙂

 

This article has got all the information http://sharepointnotes.wordpress.com/2008/05/05/syncing-wss-and-moss-user-profile-properties-with-active-directory/

Bye..

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) while deploying solution.


Hi,

We were receiving this error randomly while trying to deploy the solution from within Visual studio. This error used to crop up randomly. Sometimes after waiting for few seconds or minutes if we try again, things used to work properly without that error.

In one of the forums it was suggested that stopping the indexing service would resolve the issue.

I tried it and it really worked.

Check out that thread

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/8123068c-10ca-4271-b8bc-ac2e934531bf

Bye..

Unable to connect to the database SharePoint_Config on Server. Check the database connection information and make sure that the database server is running..


Hi,

While trying to open a SharePoint Site, we were getting the following error in the event log.

Unable to connect to the database SharePoint_Config on Server.  Check the database connection information and make sure that the database server is running..

The password of the  account that was specified within the Identity tab of App Pool of the site had changed.

Correcting it resolved the issue.

Bye..

Loading External JavaScript files


Suppose this is our external javascript file content.

(customscript.js)

It consist of a simple function

function SayHello()
{
    alert(‘Hello World’);

}



 


It is placed at the following path   ..\ISV\ExtJS. i.e. within ExtJS folder inside ISV.


Place the following code in the form load of an entity’s form.


var scriptElement=document.createElement("<script type=’text/javascript’>");

        
scriptElement.src="/isv/ExtJs/customscript.js";


document.getElementsByTagName("head")[0].insertAdjacentElement("beforeEnd",scriptElement); 


SayHello();






At times, it would work properly however sometimes it would throw “Object expected” error. It is because browser load JavaScript files asynchronously. If the script isn’t loaded we would get the error.


So here we need to make use of onreadystatechange event. 


So we would modify our script as following 


 


var scriptElement=document.createElement("<script type=’text/javascript’>");

        
scriptElement.src="/isv/ExtJs/customscript.js"; 


scriptElement.attachEvent("onreadystatechange",loadScript); 


document.getElementsByTagName("head")[0].insertAdjacentElement("beforeEnd",scriptElement); 


function loadScript()

        
{ 


if(event.srcElement.readyState=="loaded" || event.srcElement.readState=="complete")

        
{ 


    SayHello();

        
}


}


 


 


Or we could also using XmlHttp request object to load the external file.


var url="/isv/ExtJs/customscript.js"; 


var xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

        
xmlHttp.open("GET",url,false);


xmlHttp.send(); 


eval(xmlHttp.responseText); 


SayHello();


 


Bye..

	


	





	

		
		
PreAuthenticate and UnsafeAuthenticatedConnectionSharing Property of CrmService
	


	
	
	

		

Hi,


While trying to understand the use of these properties, i found this wonderful article !


Speed Racer – Call CRM at speeds that would impress even Trixie!


https://community.dynamics.com/product/crm/crmtechnical/b/billoncrm/archive/2008/10/07/blog-move-58-speed-racer-call-crm-at-speeds-that-would-impress-even-trixie.aspx


Do check it out !


Bye..