Data Server Connection Problem in MII 12.1 Version.

[Former Member]

Hello Experts,

I am using two instances of MII 12.1.8 Build (20), at which am recently facing problems in the Data Server Connections.

Am not able to connect to the Data Servers using connectors [IDBC, Virtual IDBC].

When I checked the status of the servers, it is showing the status as running but there is no available connections.

When trying to create the query templates I dont get the available tables list populated too.

The driver details for jdbc used are the default ones,

For IDBC,

JDBC Driver : com.inet.tds.TdsDriver

ServerURL : jdbc:inetdae:<ip_addr>:1433?database=<db_name>&sql7=true

For virtual IDBC,

ServerPackage: com.sap.xmii.Illuminator.connectors.Proxy

The error that we got in the LogViewer.

Log Record Details

-

---

Message: Unable to get a connection from the pool

Date:

Time:

Category: /Applications/XMII

Location: com.sap.xmii.Illuminator.tools.database.ConnectionHolder

Application: sap.com/xapps_xmiiear

Thread: Thread[HTTP Worker [@2017129105],5,Dedicated_Application_Thread]

Data Source: j2ee\cluster\server0\log\applications_00.log

Arguments:

DSR Transaction: 603b4f9bad3011e0c6f000001b57fb82

Actually the connections were working fine, in both the MII instances am working on (of the same build).

Now they both have gone down, all of a sudden

Please suggest the checks and corrections, I should do to overcome this hurdle.

Thanks for any help in Advance.

J Linovaz

[Former Member]

HI Lino,

have you tried to connect with sql server jdbc drive?

which version of sql server you are using

check these links for reference.

/people/abesh.bhattacharjee/blog/2008/01/23/xmii-120-connecting-to-a-microsoft-sql-server-2000

[Former Member]

Hi Anshul,

Thank you for your kind response.

I am uisng SQL SERVER 2005 and I have also tried with MS JDBC driver versions 2.0 and 3.0.

and

Connection Status in DATA SERVER tab.

-

---

Server Name ABC

Connector Type SQL

Status Running

No. of Used Connections

No. of Available Connections

Max. No. of Used Connections

Max. Wait Time

-

---

This is the status that i am getting and there are no available connections..

Everything was working fine before two days and we are not trying anything new

[Former Member]

Hey Linovaz..

Try adding the new connection with the same details and then check the status.

Best Regards,

Kedar

[Former Member]

Hi Kedar,

Thanks for the Reply.

Have also tried to create new connection with the same configurations, still problem persists.

Thanks and Regards,

R linovaz