Configure framework manager client to communicate with cognos server installed on another machine

Here I am explaining you how to install and configure framework manager  on a client computer.The steps to perform this operation is given below

1.Install framework manager on the client machine
2.Open the cognos configuration
3.Click on the Environment in the explorer
4.Change the Gateway URI to the http://ip:80/cognos8/cgi-bin/cognos.cgi(ip=ip address of the cognos server)
5.Change the Dispatcher URI for external applications to http://ip:9300/p2pd/servlet/dispatch
6.save the settings
7.Close the cognos configuration and open the framework manager and enjoy the work

CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value of '2'.

Error

CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value of '2'.

Description

When I am trying to install and configure Cognos8.4 I got the above error on XP machine.My installation was successful but while starting the cognos configuration I got the above error.

Solution

The error is raised because of the prevention of registering a cognos service by Mcafee antivirus.I fixed the problem by stoping the Mcafee then configured cognos succefully then restarted Mcafee .Later i added cognos in Mcafee exception list.You can fix it by just adding cognos in the exception list

creating a stored procedure query subject in cognos8 framework manager

In order to create a stored procedure query subject in framework manager you have to create a stored procedure which returning a reference ref_cursor for the result set.Here i giving the code sample

step1
create a package with one reference cursor

create or replace package pkg_ref_cursor
as
type ref_cursor is ref cursor;
end;
/

step2
create a procedure to actually do the task and return the result set

create or replace procedure tfp.getData( p_ref_cursor in out pkg_ref_cursor.ref_cursor,text in varchar2)
as
Begin
-- some code
insert into tfp.tempTable select sysdate,text from DUAL;
-- the result set to return
open p_ref_cursor for SELECT * from TFP.tempTable;
end;
/

step3
now you can directly import this procedure in framework manager and use for creating reports
similar as a table or view

Start and stop cognos service using bat file

startcognos.bat

%ECHO OFF
echo "Starting Cognos 8"
net start "Cognos 8"

stopcognos.bat

%ECHO OFF
ECHO "Stopping Cognos 8"
net stop "Cognos 8"

Cognos Certification Dumps

Latest Cognos8 Business Intelligence Dumps for all of the tests listed below


   1.  Test BI0 -  210 - IBM Cognos 8 BI Professional
   2.  Test COG-105 - IBM Cognos 8 BI Technical Specialist
   3.  Test COG-112 - IBM Cognos 8 BI Author
   4.  Test COG-122 - IBM Cognos 8 BI Administrator
   5.  Test COG-125 - IBM Cognos 8 BI Data Warehouse Developer
   6.  Test COG-132 - IBM Cognos 8 BI Metadata Model Developer
   7.  Test COG-135 - IBM Cognos 8 BI OLAP Developer
   8.  Test COG-145 - IBM Cognos 8 BI Multidimensional Author
   9.  Test COG-180 - IBM Cognos 8 BI Professional
   10.Test COG-300 - IBM Cognos TM1 Analyst
   11.Test COG-310 - IBM Cognos TM1 Developer
   12.Test COG-400 - IBM Cognos 8 Planning Application Consultant
   13.Test COG-480 - IBM Cognos 8 Planning Professional


Please contact me for cognos dumps at   kvrajith@gmail.com