Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: librabee on 12 Sep 2005 12:28:56 AM

Title: [Error] Server Connectivity Issue with Error Code QE-DEF-0285
Post by: librabee on 12 Sep 2005 12:28:56 AM
Hi All,

I am facing Server connectivity issue with error code QE-DEF-0285, in Cognos Configuration I have mentioned all the details (SQL SERVER NAME AND DATABASE NAME in Content Manager) eventhough while accessing the database from SQL Server through Cognos Reportnet test connection existing as FAILED with the error code.

Could anybody help me on this issue?

Thanks n Regards,
librabee

[Topic subject moderated]
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: ratikant on 12 Sep 2005 01:28:18 AM
can you explain where exactly you are getting this error?

Check the port number for your SQL Server...
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: librabee on 12 Sep 2005 02:25:31 AM
Ronaldo,

Yes, I have checked my SQL Server port. The existing port is 1433 and also the same port applied in cognos configuration.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: librabee on 12 Sep 2005 02:30:45 AM
This error occurs after creating Data source and checking the connectivity by "Test the connection" option. Where the source cannot be pulled from SQL Server.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: ratikant on 12 Sep 2005 10:06:54 AM
Check your connection string. In the time of Datasource creation, did u provide the correct parameters or not.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: librabee on 13 Sep 2005 04:12:37 AM
I am giving correct connecting string.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: cognosfreelancer on 13 Sep 2005 09:11:52 AM
Hello librabee

Let me get you right are you having problem connecting to the SQL server through ReportNet as well as appying the Cognos configuration.

If both then is the Cognos configuration for FrameWork manager on your client machine or is it the configuration for ReportNet server

NKT
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: librabee on 13 Sep 2005 11:32:21 PM
Hi Cognosfreelance,


It is not for FrameWork Manager, this error appears it in the configuration for Reportnet Server.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: Draoued on 14 Sep 2005 05:24:46 AM
Are you defining the SQL server to be your Content store ??

Do you have a tool outside Reportnet application ( like Toad for example) to test if your server is able to open a connection to your sql database.
You need to have a database connector installed and configured in your reportnet server to be able to address a database, either a native one or an ODBC one.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: Draoued on 14 Sep 2005 05:33:19 AM
One addition:
Have you checked the Cognos Knowledge database in Cognos support ?

There are couple of issues listed when doing a search on QE-DEF-0285.
case 1 (http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=1006697&version_id=1)
case2 (http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=1006349&version_id=1)

There are some others also.
You need a supported account to be able to see the links.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285..Very Urgent**
Post by: sir_jeroen on 20 Sep 2005 04:39:22 AM
Have you installed SQL Server SP 3a?

In some case this will solve some connections problems.
Title: Re: Reportnet - Server Connectivity Issue with Error Code QE-DEF-0285
Post by: scraynon on 25 Oct 2005 10:34:36 AM
Install the updated JCE files available for download from the Cognos Support site.
Text only | Text with Images