Thursday, August 18, 2011

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 :)


Sunday, August 14, 2011

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)




Tuesday, August 9, 2011

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