Im trying to migrate the packges and reports form a Cognos 10 to Cognos 11.0. But because i got the error:
RSV-VAL-0010 Failed to load the report specification. 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: ISIM UDA-SQL-0432 Unable to locate the gateway "libcogudajd-d2".
when i validate them I thougth to create the Datasource connection from the Administrator Console to have the connection be the same as in Cognos 10.
I though that i had to use the database name of the db i want to connect to for the field "DB2 database name", but after testing i get the error:
.UDA-SQL-0129 Invalid login information was detected by the underlying database.[IBM][CLI Driver] SQL1013N The database alias name or database name database_name could not be found.
I saw in the previous installation where this worked that in the Cognos server there was a database that was a perfect copy of the database we were connecting to get the reports. And if i create a database with the same name and credentials in the machine where cognos 11 is installed this error doensn't happen, But i ca0 find the reason for this working.
How should i configure this step?
If i use the original connection that i created the first time to make a model and a report it works just fine. So i don understand why this errors are happening.
Thank you.
------------------------------
Alejandro Gutierrez
------------------------------
#CognosAnalyticswithWatson