Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: addicted2cognos on 02 Jul 2008 11:28:42 AM

Title: URGENT- NEED HELP Unable to connect to DB2 using framework manager
Post by: addicted2cognos on 02 Jul 2008 11:28:42 AM
The datasource we created is able to test successfully, but when i import metadata from FW mgr, try to connect to that datasource it gives me this error:

QE-DEF-0177 An error occurred while performing operation 'sqlOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlOpen".
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
[IBM][CLI Driver][AS] SQL0805N Package "NULLID .SYSSH200" was not found. SQLSTATE=51002

Please Help
Title: Re: URGENT- NEED HELP Unable to connect to DB2 using framework manager
Post by: cognosengine on 10 Jul 2008 10:19:00 AM
Catalog your database by running DB2 scripts on your local machine and ask your DB2 Administrator to give the scripts and also read /select previleges on the schema
Title: Re: URGENT- NEED HELP Unable to connect to DB2 using framework manager
Post by: lalithabmk on 25 Jun 2009 11:16:54 AM
Try to check if Datasource is working on the machine that Framework Mgr is loaded. 
Text only | Text with Images