Tuesday, January 26, 2010

Uploading a InfoPath form which is an Administrator Approved Template for SharePoint 2007

As i described in my previous post once we finished saving a InfoPath form which prompted us “Administrator must approve this form template before it can be filled out by using a browse” at the time when we followed the normal usual way to publish a InfoPath form in SharePoint library, as the next step we have to upload this template to the SharePoint via Central Administration.

Browse to the Central Administration home page and go to Application Management, Under InfoPath Form Services Click on Upload Form Template.

image 

Find the location of the template and browse to it.  (If you saved it to SharePoint you'll need to save a local copy on your computer and upload from there.)

image

to be continued…

An Administrator must approve this form template before it can be filled out by using a browser.

Currently i was working with InfoPath forms for me to design some form templates and later which will be published in SharePoint to enable nintex workflow. Most of time we were used to develop InfoPath forms which is compatible with browser. In other words browser compatible InfoPath forms.

I came across a situation where we need to get the current IP address of the logged in user to the InfoPath form. So at that time i had to write some C# codes in InfoPath form. Upon finished with the codes when i tried to publish the form, mid of the publishing wizard it didn't allow me to publish the InfoPath template directly to the SharePoint library, instead it forced me save it in locally informing “Administrator must approve this form template before it can be filled out by using a browser”.

image

the reason was :

This behavior occurs because a Microsoft Visual Studio 2005 Tools for the Microsoft Office System form contains managed code by default.

Note: If a form template contains managed code, the Publishing Wizard lets you click only the Administrator-approved form template (advanced) option.

the only way in this situation is to save the InfoPath template locally and to upload the same template via the Central Administration.

Friday, January 15, 2010

Error creating package - Failed to save package file “\path” with error 0x80040154 "Class not registered"

When I tried to create a new SSIS package in the BIDS, I received an error saying : “Failed to save package file “\path of the file" with error 0x80040154 "Class not registered".

It was due to MSXML6 setup package did not get installed in my machine properly or due to some reason it should have corrupted.  So you have 'MSXML 6.0 Parser' in Add/Remove Programs, click Change and then Repair. If it does not exist in your Add/Remove Programs - rerun the SQL Setup, then it should install it.

Wednesday, January 13, 2010

Adding SQL Server Reporting Services Report Viewer Web Part - SharePoint

Once i have installed the Reporting Services add in for the SharePoint by default the SQL Server Reporting Services Report Viewer web part should be enabled in SharePoint web part library. But in my case it was not added and listed in the library. So i had to add it manually.

follow the steps as below:

clip_image002

clip_image004

clip_image006

clip_image008

clip_image010

After adding the web part to your page just configure the same to view your report.

clip_image012

you can download the addin from the following link:

http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

Tuesday, January 05, 2010

Biztalk Poster

Biztalk poster (Silverlight enabled) -

Check this out :

http://www.microsoft.com/biztalk/capabilities/reader/ .

Scroll/Zoom + click on a section where the help and various MSDN articles come up. really helpful for us. :)

Monday, December 07, 2009

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

to resolve above mentioned error while opening any of hyperlinks in Ms Excel, Outlook, etc just follow this step :

For Windows XP (Service Pack 1 and higher)

    * Click Start, Control Panel, double-click Add or Remove Programs
    * Click Set Program Access and Defaults
    * Click Custom
    * Under Choose a default Web browser, select Internet Explorer
    * Click OK

For Windows Vista

    * Click Start, and click Default Programs
    * Click Set program access and computer defaults
    * Click Custom, select Internet Explorer and click OK
    * Close and re-open Microsoft Outlook

Thursday, December 03, 2009

Service Unavailable and SharePoint Error: Some or all identity references could not be translated

Currently i was working with some BizTalk test projects using a Virtual Machine installed with Windows 2003. I have installed BizTalk 2006 in the same machine in which i was doing some SharePoint projects. For me to install BizTalk 2006 i had to install DNS and the Active Directory. Prior to installing this BizTalk, SharePoint was working fine without giving me any headache.

After installing BizTalk it started to give me problems when i tried to access the SharePoint Central Administration. It prompted me for Service Unavailable error, Grr rrrr (at that time i was thinking if i need to redo these things again such as installing windows 2003 in a new virtual machine, after that installing DNS, installing Active Directory, installing MOSS 2009 and installing BizTalk 2009 - it will waste my time for sure).

So i know it was due to the installation of the Active Directory and i had to reset the permission in Application Pools in IIS (go to IIS, browse Application Pools and select your Application => right click and go to properties => from there select the Identity Tab and change the User Name and accordingly change the password.

image

Once its over when i tried to browse for SharePoint sites another error was prompting me saying “Some or all identity references could not be translated” (Hard Luck). So i was searching to resolve this problem. so Finally the utility STSADM was there to help us. You can find this tool under C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN and just execute this command by replacing the proper login with the domain name followed by the password.

"stsadm.exe -o updatefarmcredentials -userlogin domainname\username –password yourpassword "

image

Once you executed the above command please make sure to do iisreset –noforce

Hurray!!! now everything works fine without any hassle. Hassle free of life.

Make sure to re-run the SharePoint Products and Technologies wizard once the above said steps are finished.

image

guys for more information please refer this URLs:

http://www.neilrichards.net/blog/?p=73

http://coolsubhash-tech.blogspot.com/2007/05/some-or-all-identity-references-could.html

http://www.keirgordon.com/post/SharePoint-Server-Error-Some-or-all-identity-references-could-not-be-translated.aspx

Failed to add resource(s). Resource () is already in store and is either associated with another application or with another type

image

when i was working with biztalk orchestration, there was an error prompted at the time when i did the deployment : “

Error 1 Failed to add resource(s). Resource (-Type="System.BizTalk:BizTalkAssembly" -Luid="BizTalkServerTestProjectAmmar, Version=1.0.0.0, Culture=neutral, PublicKeyToken=dda761d103beeac0") is already in store and is either associated with another application or with another type. 0 0 “

I thought we should just deploy the way that we are doing with other applications. But when researched about this if we didn't specify any value for the Application Name in the Deployment properties page, then VS used to deploy the orchestration in BizTalk Server named with BizTalk Application 1.

image

To overcome the above said error i had to remove the resource file located under Resources folder as below:

image

once its done, the orchestration was deployed in the BizTalk Server successfully. :)

To avoid this in future, set explicitly deployment target application in the Visual Studio project properties by: right click - Configuration properties - Deployment - Application Name.

Monday, November 23, 2009

Microsoft Biz Talk Server 2009

Simply we can say the BizTalk is a Messaging Based Integration Tool and uses XML as the common data exchange language for eCommerce and application integration in the WWW. 

In other words we can say that BizTalk is the main interface in between multiple systems and based on some definitions we can say as "BizTalk Server is Microsoft's central platform for Enterprise Application Integration (EAI) and Business Process Management (BPM) and embodies the integration and automation capabilities of XML and Web Services technologies. BizTalk Server functions as a process execution engine and as a multi-transport hub for messaging and document transformations. It is a Windows Server System product that helps customers efficiently and effectively integrate systems, employees and trading partners".

Biz2009 BizTalk_bt_1

you can understand what is happening inside BizTalk by viewing the following animated jpeg file :

 get_image.php

if you can’t view the animation please do not hesitate to click this link:http://farm3.static.flickr.com/2718/4127256189_0da73842e3_o.gif