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