Skip to Content
author's profile photo Former Member
Former Member

Data Server Connection Problem in MII 12.1 Version.

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/xappsxmiiear

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2011 at 12:05 PM

    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

    Connecting MII 12.1 to SQL Server 2008

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.