which is the MYSQL version compatible with SAP PI 7.0

[Former Member]

Dear friends,

can any body tell me which is the MYSQL version compatible with SAP PI 7.0, i m getting the below error , some body told me, may be the MYSQL version is not compatible with PI 7.0

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://192.168.51.50:3306/stagingdb': SAPClassNotFoundException: com.mysql.jdbc.Driver

rgds

mojib

[Former Member]

Hi,

This error not related to version, this is related to connection or database space.

please check DB & table space in reciver system.

Thanks

Sivaram

[Former Member]

Hi Mojib,

This is not related to the version.

The error saying that it is unable to establish the connection to the data base. so check the connection and URL of the data base

or

May be database reached maximum no. of pooled resources, so you (DB side guys) have to cancle the old connections.

For more details check this thread

Regards

Ramesh

[Former Member]

Hi Raja & Venkat,

interfaces were running successfully and all of a sudden , this error started coming , so question of driver wrongly installed or wrong URL doesn't seeems to arise.

more comments please

thanks

mojib

[Former Member]

Hi

if the interface was running fine and suddenly stop working ...and as per the error log u have pasted here ....99% chances are due to connection problem ...check whether TCP/IP connection for port 1433 is working finr or not ,,....do Xi system is able to make the telnet from SQL server or not...may be any firewall get enable ..........

just check with this blog also .....same thing happensa with me once also fora client .....

(/people/charu.agarwal/blog/2009/07/02/problems-faced-while-connecting-to-sql-server-using-jdbc-adapter-in-pi)

Regards

Abhishek

[former_member200962]

Unable to create Resource pool is a problem with free resources available in the DB....better contact your DBA and ask him either to increase the number of available resources or to free the existing ones....you can check my similar answer here:

Regards,

Abhishek.

[rajasekhar_reddy14]

Hi ,

I dont think you are getting error because of version of MYSQL,i think driver properly not installed or check the connection details in communication chennel.PI supports 4.0 and 5.0 ..and older version too..

Regards,

Raj