cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query in Visual Composer 7.1.1 SP2

Former Member
0 Kudos

Hi all,

I want to use an SQL Query in Visual Composer 7.1.1 but I only can search for Stored Procedures. There is documentation available but not for VC 7.1.1. I also can not use the Query Wizard for this as the System does not show up in the list.

So how is it possible to use SQL Queries in Visual Composer 7.1.1.

Thank You

Nicolas

Accepted Solutions (1)

Accepted Solutions (1)

former_member203343
Contributor
0 Kudos

Hi Nicolas,

If you want to use SQL statements, you should use the BI JDBC capabilities of Visual Composer. For information on how to configure such system go to [http://help.sap.com/saphelp_nwce711/helpdata/EN/3f/0f883fed254875883290c98c0c20c1/content.htm|http://help.sap.com/saphelp_nwce711/helpdata/EN/3f/0f883fed254875883290c98c0c20c1/content.htm]

Once you have it configured you should be able to search for the tables in VC. For info about this refer to [http://help.sap.com/saphelp_nwce711/helpdata/EN/7d/a109d5efcc4644a9f2da2ab27e50dd/content.htm|http://help.sap.com/saphelp_nwce711/helpdata/EN/7d/a109d5efcc4644a9f2da2ab27e50dd/content.htm]

After you drag and drop a table to the storyboard, you can right click on it and select "SQL Editor" to edit the SQL statement.

I hope this helps,

Netanel

Former Member
0 Kudos

Hi Netanel,

I had already performed the steps for the system using the BI JDBC system template like in the guide you linked to, but it does not show up as a system in the search tab in Visual Composer. Connection tests are alway successfull.

The same configuration using the JDBC System Template does appear in the search tab but only provides access to the stored procedures not to the tables.

Best Regards Nicolas

former_member203343
Contributor
0 Kudos

Hi Nicolas,

One reason can be that user mapping is not defined for the user who is logged into VC, or that the BI JDBC system obhect's permissions are not defined well. You might be able to see the reason in the server's defaultTrace file. If you're striggling with it - open a customer message and you'll get your answers

Regards,

Netanel

Former Member
0 Kudos

Hi Netanel,

I have double chekced the user mapping as well as the objects permissions.

SO I think there is no way to circumvent the customer service message.

Thank you.

former_member203343
Contributor
0 Kudos

Hello Nicolas,

Yes. The answers is hidden in the defaultTrace files...

If you'd like, you can ask in the message to forward it to me (I'm from VC development). Make sure to reproduce the problem (i.e. log into VC and click on the search panel) and then attach the latest defaultTrace.

Regards,

Netanel Slomianski

Former Member
0 Kudos

Hi Netanel,

thanks for the support. I have had a look into the default trace. I came up with these two strange errors being related to the BI system objects and the VC. I have also experienced there is one BI System Object (BI Master Object) that I do not have access to. I have requested access to the system in the meantime, maybe this fixes the problem. But the I think there is an issue in the VC System List retrieval.

Best Regards Nicolas

VC-DevServer][While retrieving systems for Search Provider: BISearchProvider]null

[EXCEPTION]

com.sap.ds.core.services.search.VCSearchException

at com.sap.ip.vc.bi.search.BISearchProvider.getSystems(BISearchProvider.java:157)

at com.sap.search.SearchService$SystemsRetrieveJob.run(SearchService.java:380)

at java.lang.Thread.run(Thread.java:664)

Caused by: java.lang.NullPointerException

at com.sap.ip.vc.bi.search.BISearchProvider.getSystems(BISearchProvider.java:141)

... 2 more

null

[EXCEPTION]

java.lang.NullPointerException

at com.sap.ip.vc.bi.search.BISearchProvider.getSystems(BISearchProvider.java:141)

at com.sap.search.SearchService$SystemsRetrieveJob.run(SearchService.java:380)

at java.lang.Thread.run(Thread.java:664)

former_member203343
Contributor
0 Kudos

Hi Nicolas,

This exception means that there was something wrong in the process of creating the object that is supposed to fetch the BI systems. Can you please do the following:

1. Log in as an administrator to the portal.

2. Call <http https>://<j2ee_server>:<j2ee_port>/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.supportdesk.default

3. Refer to "BI Mastersystem" and "BI Portal System Permissions". Are they red?

Is there anything else suspicious in the log file? Usually the real problem is somewhere "near" the above exception.

Regards,

Netanel

Former Member
0 Kudos

Hi Netanel,

both items have been red, as I did not have access to the master system. Now as I have access I can see all BI systems including the BI JDBC Systems. So it is required to always have access to the BI Master System to get the complete List of BI JDBC Systems in Visual Comoser? The BI JDBC Systems I created a in no way related to the BI Master System.

Anyway it works now. Thanks for your support.

Thank You Nicolas

Former Member
0 Kudos

Hi Netanel,

I am sorry to bug you again. But there is no SQL Editor available on right click. I can only start a Query Editor that does not allow to enter SQL at any time. There is such button, but this is greyed out.

UPDATE: Figured it out. I have to not drag and drop the table from the search list, but I have to open the Query Designer from the Menu in VC.

Best Regards Nicolas

Edited by: Nicolas Loewe on Jul 15, 2009 3:11 PM

Answers (0)