Troubleshooting
Problem
User launches Controller. User receives an error message.
Symptom
Screen:
Error
An error occurred while trying to access the server
[OK]
Event Viewer (Application Log)
- Example #1:
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 05/07/2011
Time: 13:56:59
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrServerB: Thread ID: 5168 ,Logged: Error occured at 05/07/2011 13:56:59 in FrServerB, Error No=3706, Source=FrServerB.ServerInfo.GetDBRelease, Description=Provider cannot be found. It may not be properly installed., HelpFile= HelpContext=0
- Example #2:
Cause
The message "An error occurred while trying to access the server" is a generic one.
- For more examples of the cause of this error, see separate IBM Technote #1366724.
Instead, this IBM Technote shall specifically relate to the scenario where the Event Log contains the text "Provider cannot be found". In this scenario, the cause is that the database provider is not installed on the Controller application server.
Examples:
(1) In one example, the application server was configured to use the provider "SQLNCLI.1", but the corresponding provider (SQL 2005 client 32-bit) was not installed.
(2) In another example, the application server was configured to use the provider "IBMDADB2.DB2COPY1", but the corresponding provider (DB2 client 32-bit) was not installed.
Resolving The Problem
Ensure that the database provider has been installed on the Controller application server.
- NOTE: Controller is a 32-bit product, and therefore requires the 32-bit database client to be installed.
Example:
(1) For example, to install the SQL provider "SQLNCLI.1" you should install the 32-bit SQL 2005 client components by following these steps:
- Insert 32-bit SQL 2005 cd-rom and launch the autorun menu
- Choose 'Install - Server components, tools, Books Online, and samples'
- Accept all the default values during the wizard, *until* you reach the screen 'Components to Install'
- Tick the box 'Workstation components, Books Online and development tools', but leave all other boxes unticked
- Click 'Next', and then continue choosing all the default options
- After the product has finished installing, download latest service pack (e.g. SP4 = ' SQLServer2005SP4-KB2463332-x86-ENU.exe) from Microsoft
- Double-click to upgrade the client tools to SP4, then reboot application server
(2) For example, to install the DB2 provider "IBMDADB2.DB2COPY1" you should install the 32-bit DB2 client components by following these steps:
- TIP: These steps are based on Controller 10.1:
1. Insert the DB2 9.7 32-bit installation CD-ROM/media
2. Launch “setup.exe”
3. Inside the "DB2 Setup Launchpad", choose "Install a Product"
4. Underneath "IBM Data Server Client Version 9.7" choose "Install New"
5. Inside the "Select the installation type" choose "Custom"
6. Accept all the defaults *except* inside the "Enable operating system security for DB2 objects" untick the option "Enable operating system security" (see Technote 1504470 for why)
7. Finish the wizard
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21504544