I am seeing the following error when generating a report for the first time:
UDA-SQL-0532 Data Source is not accessible: “invalid data source”.[MySQL][ODBC 5.1 Driver][mysqld-5.0.80-enterprise-nt-log]Lost connection to MySQL server during queryRQP-DEF-0149
This is what I have found out so far: When I try to generate a report for the first time I receive the above message however this causes a connection to be opened to the datasource (mysql server) as is evident by running [show processlist;]. If I try to generate a report within the time that the connection to mysql is still open the reports generate with no problem. If the connection times out and closes or if I manully kill the process and then try to gerate a new report or regerate the same report I receive the above error again.
I have exhausted all resources and need a little assistance. In short my configuration is as follows:
3 tier distributed install
Web Server components on Server 2008 r2
Application Server components on Server 2008 r2
Content Manager on Server 2008 r2
Content Store on SQL 2005
Data Source on MySql running on Linux
This does not happen in my lab environment where the Content Manager and Application compoents are installed on the same server.
Thanks in advance
-Code
Going to go ahead and add a little more information regarding the configuration as I am begin to think this is more of a problem with the dispatchers…
Web Server settings:
COGNOS 8 Gateway
Dispatcher URI’s for gateway’s
-https://ebocm1:[port]/p2pd/servlet/dispatch/ext
-https://eboapp1:[port]/p2pd/servlet/dispatch/ext (originally I did not have this added as I want to use the content manager dispatcher to aleave as much load from the app servers as possible)
COGNOS 8 App/Presentation Server
Gateway URI
-http://eboweb1:[port]/cgi-bin/cognosisapi.dll
Internal/External Dispatcher
-https://eboapp1[port]/p2pd/servlet/dispatch
Dispatcher URI for external applications
-https://ebocm1:[port]/p2pd/servlet/dispatch/ext
Content Manager URI
-https://ebocm1:[port]/p2pd/servlet
COGNOS 8 Content Management Server
Internal/External Dispatcher
-https://ebocm1[port]/p2pd/servlet/dispatch
Dispatcher URI for external applications
-https://ebocm1:[port]/p2pd/servlet/dispatch/ext
Content Manager URI
-https://ebocm1:[port]/p2pd/servlet
okay so if I point the web server to the dispacther running the presentation service (the application server) then I get an error that the gateway cannot connect with the BI Server.
If I de-register the application server dispatcher then I get an error that the request to run a report could not be routed to a server with the presentation service. This error I would expect and could undertand. What I do not understand is what service exists on a server (where only content manager is installed) that handles the initial requests only from the gateway?
so in short each server application and content manager has a dipather installed by default. The content manager seems to be the server that has a service that handles all inital connections from the gateway and then distributes those requests to the correct dispatchers based on the request types and services installed/available on each dispatcher (be it application or cm)?
I apologize if this should be on a new thread…