Cognos connection failed

[harykrisi]

Hi All,

We are getting the following error message on scheduled reports. while the report is executed manually they are running fine which rules out the possibility that the connection cannot be set to the database.

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    xxxxx

UDA-SQL-0031 Unable to access the "xxxxx" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
ORA-21561: OID generation failed
I have searched the forum but could not find any post related to OID generation failure
Any help is appreciated.

[harykrisi]

Adding more info..

Oracle Client version . 10.2.0.4
Cognos version 8.3

[koharish]

Hi All,

We are getting the following error message on scheduled reports. while the report is executed manually they are running fine which rules out the possibility that the connection cannot be set to the database.

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    xxxxx

UDA-SQL-0031 Unable to access the "xxxxx" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
ORA-21561: OID generation failed
I have searched the forum but could not find any post related to OID generation failure
Any help is appreciated.

Hi harykrisi

This is Harish
i spent so much time to research
for installing cognos 8.4
i don't want to be others waste their time to know how to install
that's why i recorded my installation through out as 6 parts you can view them in youtube
you have facility to download those

http://www.youtube.com/koharish

i clearly recorded from scratch to run report
i think it will help
here i used  windows XP as OS
oracle 10.2 as Database
its working fine
i have informatica as well cognos on the same db
no problem its nice to be Oracle as database

thank you

Regards

Harish Kotte

[dlafrance]

From http://oratip.com/ORA-21561.html

ORA-21561 OID generation failed
Cause

The handles passed in may not be valid
Action

Check the validity of the env, svc handles


You should talk with your dba about this issue..

[tupac_rd]

maybe the connection got corrupted. try delete & recreate

[harykrisi]

Thanks for the replies guys.
We have raised support tickets with both Oracle and IBM. expecting them to provide a solution.

@dlafrance - we tested the connection and it is successfull. but only when we schedule or run reports this error comes up. Also this is not an issue that happens all the time. it is like it happens now and after ten minutes the same report runs fine.

@tupac_rd - probably worth a try, but if connection is corrupted it should not allow any connections at all right.

@Harish - very thoughtful, will checkout the video.

[PRIT AMRIT]

have u got any reply from IBM Cognos Support team?

I have been experiencing the same since this morning, all the reports were running find Yesterday though.

Tested the Connection and it is successful. But when running the reports seeing the error...

Thanks
P

[cognostechie]

It happens every day in our environment in the evening because at that time, the database ie being refershed so it is in a single user mode. It's not a Cognos issue. At that time, I point the Data Source to use a different connection that points to another schema and the same report runs fine.

When you test the connection, it does not actually try to read the data from the tables so there is a difference between 'Testing' the connection and actually accessing the data.

[PRIT AMRIT]

Correct.

Today morning i ran the same reports and everything is running fine. When the DB is down or refreshing this happens.

[venkys4u]

how to notify the users about the database down if the scheduled report by trigger ,doesnt run because of DB down?