Exclude list views from search scope in Sharepoint

My search results show list views also while searching for a documents apart from real document name. i didnot want users to see the source of the document or source url.
for eg: it was showing http://sitename/listname/Forms/AllItems.aspx

fix: create new crawl rule from sharepoint search administration SSP not from search administration scope (Shared Services Administration: SharedServices1 > Search Administration > Crawl rules).
1) click on New Crawl Rule > in Path enter *://*allitems.aspx*> make sure exclude is selected> click OK
2) go to content sources in Search adminisration >select the content source > do a full crawl

do a search list view will not show in search results. you can do the same for all list views including custom list views and also i added *://*DispForm.aspx*

Change Service Accounts & Passwords for MOSS2007

For reference article microsoft

http://support.microsoft.com/kb/934838

run commands
stsadm -o updatefarmcredentials -identitytype NetworkService
iisreset

this didn't work for me even i changed the identity from IIS application pool property. no luck

FIX:

1. Go to Sharepoint Central Administration.
2. On the top navigation bar, click Operations.
3. On the Operations page, in the Security Configuration section, click Service accounts.
4. On the Service Accounts page, in the Credential Management section, under Select the component to update, select Web application pool.
5. In the Web service list, click a Web service.
6. In the Application pool list, click the application pool that you want associated with the Web application.
7. Under Select an account for this component, select one of the following:
8. Predefined. Select this option to use a predefined account, such as the Network Service account or the Local Service account.
9. Configurable. Select this option to specify a different account.
10. Click OK.

other references:
http://geekswithblogs.net/influent1/archive/2009/04/15/131231.aspx
http://ithinksharepoint.blogspot.com/2008/10/renaming-user-accounts-within.html

BizTalk : The published message could not be routed

when working with flat file in recieve port . don't forget to configure the send port filter to BTS.ReceivePortName = <receive port name>
otherwise biztalk will give error message

A message received by adapter "FILE" on receive location "Receive Location1" with URI "\\share\FileReceive\*.xml" is suspended.
 Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure. 
 MessageId:  {xxx...........}
 InstanceID: {xxx...........}

A subscriber is an orchestration or send port with a filter that matches the promoted properties in the message.if it is not configured when using flat file schema you get the above message.

BizTalk - WcfSendPort - BtsActionMapping - is invalid

I have been getting the below error when sending request message to oracle db from biztalk 2009 R2

The adapter failed to transmit message going to send port "WcfSendPort_OracleDBBinding_SCHEMA_View_VIEWNAME_Custom" with URL "oracledb://CONNECTIONSTRING/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.MetadataException: Argument <BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Operation Name="Select" Action="http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/View/VIEWNAME/Select" />
</BtsActionMapping> is invalid.
Server stack trace:
   at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)
Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result)".

Scenario: i auto generated schema from oracle db view. created orchestration(file receive-db req-db resp - transform(for final resp) - final response). deployed on biztalk 2009 successfully.
created output instance from the adapter generated schema with root reference "Select"

<ns0:Select xmlns:ns0="http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/View/VIEWNAME">
  <ns0:COLUMN_NAMES>*</ns0:COLUMN_NAMES>
  <ns0:FILTER></ns0:FILTER>
</ns0:Select>

used this xml in file receive location.in db req stage it is stuck . checked the binding, everything is fine since i imported the binding from the project i never suspected the <BtsActionMapping> tag.
changed EnableBizTalkCompatibiltyMode to True & UseAmbientTransaction to False. still no luck.
created a new DB request-response port removed the imported binding port.changed EnableBizTalkCompatibiltyMode to True & UseAmbientTransaction to False.didn't forget to set credentials username in CAPS,in SOAP Action header added only

http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/View/VIEWNAME/Select
without <BtsActionMapping> tag.

tried again

voila it works!!!

Oracle BIEE login problem

I got the following message when logging to BI dashboard
Logging in...... Please wait. it just hang there. i had many requests / connection from the main page .
from one of the OTN forums i got the solution as

"
This message will appear if the connection pool limit set in the repository has exceeded its maximum value.

If a particular dashboard has many pages/report requests, than a single run of the request can exhaust all the connections set in the repository connection pool.In such a case, until the dashboard has completed its run other users trying to log into the system simultaneously would be held up with this message.

This can be solved by increasing the maximum connection in the connection pool in the repository.
Also, effort can be put in designing the Dashboard where number of pages can be reduced.
"

Actually i had to restart my server as few other things also hanged in the system.after a restart everything worked fine. i guess the above solution could be a possible answer as i got lot of connections to the database from a single page. i have increased the maximum connections earlier for some other reason i do not remember.

Hope it will be helpful to someone and for me too in future :)

Steps to install and use BizTalk 2009 with Oracle Adapters

Here i will add the steps involved in installing BizTalk Server 2009 and SQL Server 2008 R2 Ent Edition as Database on Windows Server 2008 R2 Operating System in a standalone server with oracle adapters.

1. Windows Server 2008 R2
2. OS Language pack
3. IIS 7.0
4. MS Office Excel 2007
5. UltraISO
6. Visual Studio Pro 2008
7. Visual Studio 2008 SP1
1. VS90sp1-KB945140-ENU
8. SQL Server 2008 Ent R2
1. SW_DVD9_SQL_Svr_Enterprise_Edtn_2008_R2_English_MLF_X16-29540
9. SQL Notification Services
1. sqlncli_x64
2. SQLServer2005_XMO_x64
3. SQLServer2005_NS_x64
10. BizTalk Server 2009 Ent
1. SW_DVD5_BizTalk_Server_Ent_2009_English_Core_MLF_X15-46665
11. Oracle instantclient_11_2
1. ODBC Instant Client Release 11.2
12. Configure Environment Variables
1. ORACLE_HOME
2. TNS_ADMIN
3. NLS_LANG
13. Create ODBC connection & test
14. ODTwithODAC1110720 (this installation is required for BizTalk, refer my blog for details http://seenstechs.blogspot.com/2011/05/oracle-database-connection-problem.html )
1. 11.1.0.7.0
15. WCL LOB Adapter
1. AdapterFramework64
2. WCF LOB Adapter SDK SP1 x64
3. WCF LOB Adapter SDK SP2 x64
16. BizTalk Adapter Pack 2.0
1. SW_CD_BizTalk_Adapter_Pack_2.0_English_MLF_X15-49578 ( installed both x86 and x64 softwares . refer my blog http://seenstechs.blogspot.com/2011/05/biztalk-2009-adpter-pack-no-valid.html for details)
17. Run Visual Studio as Administrator and create a new biztalk project, add generated items you should be able to configure oracle binding and see the schemas.

To create WebService from the orchestration you need to deploy . Run BizTlak WebService Publishing Wizard and create WebService . test it with SoapUI software (i used version soapUI-x32-3_0_1)

My experience with the Installation of SQL Server 2005 on Windows Server 2008

As part of the SQL upgrade process i had to create an alternate setup for SQL Server on Windows Server 2008 . I had two choices

option1: install SQL Server 2005 Enterprise on windows Server 2008 R2 Standard

option2: install SQL Server 2008 Enterprise R2 on Windows Server 2008 R2 Standard

i choose option1 as i wanted to test the upgrade process to SQL Server 2008 later

so i started the installation of SQL Server 2005, during system configuration check i got the warning

-----------

IIS Feature Requirement (Warning) :



Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.



For installation IIS on Windows 2008 follow the article

http://support.microsoft.com/kb/920201/en-us and http://learn.iis.net/page.aspx/29/installing-iis-7-on-windows-server-2008-or-windows-server-2008-r2/

another reference http://blogs.technet.com/b/seanearp/archive/2008/07/01/installing-sql-server-2005-on-windows-server-2008.aspx

--------------

you can ignore the warning as IIS is required only for reporting services.the reason is because Windows Server 2008 have just been released and the operating system information on the page is not fully up to date .



According to Microsoft, SQL Server 2005 requires Microsoft SQL Server 2005 Service Pack 2 (SP2) to run on Windows Server 2008 and Windows Vista SP1. And the full release version of SQL Server 2005 has to be first installed before the SP2 can be applied.



After the successfull installation of SQL Server 2005 , i was able to install SP1 got a warning for analysis services to install hotfix 2047. i didnot do that as i am on the way to install SP2, hoping it will remove the warning. as expected the installation was successfull without any warning. did the SQL provisioning and restarted the server.so far good. tried to open database with SQL Server management studio, there comes the error. No instance, No database is shown. checked with ODBC data source database and instance exist.



followed the article http://decoding.wordpress.com/2008/04/18/how-to-install-sql-server-2005-on-windows-server-2008/

downloaded the hotfix from http://support.microsoft.com/kb/950636

no luck.got the message the update is not applicable to your computer .

installed the backup feature still the same error.

now the next option for me is to do an upgrade to sql server 2008 r2. the upgrade advisor tells me no reporting services is installed. ofcourse its not. will do it later.now continuing with upgrade.upgrade was successfull. but the sql server management studio cannot find the instances.



Now i did not want to spent more time on this process . so removed all installation of SQL 2005 and SQl 2008 and went for the option2. to those who don't have option2 can check the below reference as well



List of known issues when you install SQL Server 2005 on Windows Server 2008 :

http://support.microsoft.com/kb/936302