cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in integrating xMII with VC

Former Member
0 Kudos

hi Experts,

My xMII server Version is <b>11.5</b>

I followed this document:

<b>https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d8033</b> for integrating xMII with VC.

Connection URL: http://<myXMIIServerName>/Lighthammer/ALL_TEMPLATES?version=<b>11.5</b>&trace=true

Driver Class Name: <b>com.sap.xmii.custom.integration.jdbc.SAPxMIIJDBCDriver</b>

System Alias: <b>XMII_JDBC</b>

Connection test is <b>successful</b>, after configured System.

I am getting error while <b>FindData Seach</b> in VC,

Inputs given are,

System: XMII_JDBC (this is my system)

Look for: Look for a table

the error is, <b>Error-2305 Cannot retrive catalogs and schemas; check the connection to the selected systems Cannot access JDBC metadata </b>

I think i made mistake in connectionURL, but connection test is successful.

Please guide me, where i made mistake.

Points will be Awarded.

Thanks & Regards,

Chinnadurai R

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Chinnadurai,

When I updated the JDBC driver, the original 11.5 code was untouched, didn't want to break anything existing. The ALL_TEMPLATES modifier only works for v12 connections since its a new feature. The connection test works because the system and it's information are correct.

Since you're using v11.5 of xMII you have to specify a <b>templates</b> directory for the driver to work. It should traverse the directory structure through all of the child directories and return them as well, not sure though didn't write that one. If you need access to more than one directory then you have to create a separate connection for each.

Hope this helps.

Sam

Former Member
0 Kudos

Hi Sam,

Thanks for your reply... I am also think that i made mistake in comnnection URL ,

I have created some querys under Samples/Reports,

I gave like this::

<b>http://<myXMIIServerName>/Lighthammer/Templates/Samples/Reports?version=11.5&trace=true</b> and <b>http://<myXMIIServerName>/Lighthammer/Templates/Samples/Reports?</b>

and then like this

<b>http://<myXMIIServerName>/Lighthammer/Illuminator/Templates/Samples/Reports?version=11.5&trace=true</b>

I tried using all the URL shown above, but it is not listing the Querys in VC .

Can u guide me how can i form that Connection URL ..

Thanks & Regards,

Chinnadurai R

0 Kudos

Chinnadurai,

In the <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/311a90f0-0901-0010-fe9e-f88e9da0ffbe">v11.5 jdbc document</a> the url is:

jdbc:sapxMII://xMII servername<:port>/PathToTemplateFolder?version=11

This is shown on page 20 of the doc, hope this helps.

Sam

0 Kudos

Chinnadurai,

In the v12 document the connection URL should start with jdbc:sapxMII but it does not, my mistake I will update it. However it still works with the http:// prefix but it's just not a standard JDBC Server URL. My suggestion is to look in the NetWeaver logs and find out what the actual error message is. My guess is that you have not properly setup the User Mapping and the connection does not properly authenticate.

Hope this helps to explain a bit more.

Sam

Former Member
0 Kudos

Hi Sam,

Thanks for ur reply..

I saved some Queries under Reports.

I gave URL like this:

jdbc:sapxMII://<Server Name >:<Server Port>/Lighthammer/Illuminator/ Templates/Samples/Reports?version=11

but, the VC showing the same exception. It did not get the queries.

Can u track the problem.

Regards,

chinnadurai R

0 Kudos

Chinnadurai,

The URL should be:

jdbc:sapxMII://xMII servername<:port>/Samples?version=11

This way you will see whatever is in Samples and Reports.

Sam

Former Member
0 Kudos

Thanks Sam,

Problem solved.. I have assigned points..

VC listed the Queries..

If i get any other problem, i wil ask you..

Regards,

Chinnadurai R

Answers (0)