AdminTools Query Designer Returns No Results

[Former Member]

I am part of our Administrators group in our BOBJ platform. When I run any query I simply get told the server returned no data. I wondered if there was something obvious I was missing. When I search the problem I don't find too many similar posts so I'm at a loss as to where to look for the issue and it makes me think it might just be me missing something.

[Former Member]

I have gotten a little further in diagnosing the issue. I get results back if I use http://localhost:8080/AdminTools/ on the server browser but still nothing if I use a browser from any other computer.

[denis_konovalov]

on other computers you need to use http://servername:8080/AdminTools  where server name is the domain name of your server machine

[Former Member]

Thanks for the reply. If you see the discussion above you'll see that what you describe is where I started. For some reason it won't work from any other computers. Everything else works fine with the BI platform. CMC, BI, etc are all good.

I'm trying to figure out how to get it working on other computers when it won't return anything except when using it on the local machine.

Just so you don't think I'm confused I'm using the FQDN when trying on other computers. I'm just using the localhost path on the server.

[former_member191664]

Can you apply http://www.youtube.com/watch?v=mqMvrGnqA3A and delete Chrome extensions? Hope this helps, Jin-Chong

[Former Member]

Thanks for the reply. Unfortunately that doesn't appear to the be issue. The query doesn't return results in any browser so resetting Java settings and deleting temp files in Chrome doesn't appear to make a difference.

[Former Member]

Hello Robert,

Could you access Query Builder page of some other working environment and try to login into the problematic environment?

In other words, we will use web tier of other working environment; however this time you need to enter the old system name and port no. which is not working.

- Mahesh

[Former Member]

I can already login fine. It's just that the query doesn't return any results when it is ran. So it doesn't appear to be any kind of access issue at this time.

[former_member191664]

Check out InfoStore Query Builder (with export to Excel) on http://bukhantsov.org/2012/03/query-builder-with-export-to-excel/ to see if your CMS query actually works and return data into Excel or not. If not, rework your SQL query. Regards, Jin-Chong

[Former Member]

Thanks for your reply. I'm a new Admin for the system so I'm still coming up to speed on using it myself. Where do I go to get to the InfoStore Query Builder?

[Former Member]

Robert

you can download it from here

BO XI 3.1: Download and unpack http://bukhantsov.org/tools/QueryBuilder.zip

BO BI 4.0: Download and unpack http://bukhantsov.org/tools/QueryBuilder4.zip

and

you can read how it works

InfoStore Query Builder (with export to Excel)

[Former Member]

It is showing the exact same screen as my previous error when I run it with your custom app.

[Former Member]

Thanks! I didn't realize it was a separate app that had been built. At first I thought the post was referring to something inside the BI platform.

I ran it and got the same results as before when using the standard Query Builder. See screenshot below.

[Former Member]

CMC and BILaunchPad working fine ?

[Former Member]

Yep! Everything else seems to be working alright. The system shows itself as healthy. No user complaints about reports not working. Any development and reporting we do works fine. The only thing is that when I run a query in the AdminTools query builder nothing comes back.

[CdnConnection]

Robert,

   Try this

http://<SERVER NAME>:Port/AdminTools/

Only type AdminTool, the rest is dynamically filled in based on browser

Ajay

[Former Member]

Thanks for the reply. That's the link I am using here locally. I get the right screen for building the query. It's just that when I submit the query it returns no results no matter what I do.

[former_member184512]

Hi,

can you try with IE 9  if you are on SAP B I 4.0 SP4...

can you check Java version on your machine..

We had similar issue with BI, we resolved by adding website into trusted, matched supportable java version and IE version to SAP BI

Then it worked fine..

[Former Member]

I cannot check with IE9 unfortunately. We are on 11 here at work. I don't have it available. We are on 4.1. Java versions I have check out from everything I can tell. Site is already in trusted site.

I should say the rest of the BOBJ BI works just fine. I don't have any problems logging any anywhere else and using the system. It's just the AdminTools Query Builder that doesn't display anything.

Fiddler Trace basically says the server returned no data.

HTTPWatch says the connection is reset but that's only in IE.

[Former Member]

For Microsoft IE 11 desktop version(*1)  , you need  Oracle JRE 7 or 8  version. Do you have the same ?

[Former Member]

Hi Robert,

Please answer two more questions:

• What if you login as Administrator/or any other user, does it returns the result set?
• Did you tried to login to Query Builder on another machine?

Above tests would isolate whether the issue is machine specific or user specific, so you can troubleshoot the issue in that direction.

- Mahesh

[Former Member]

I do.

[Former Member]

I logged with an Administrator account and it still acted the same. I also tried on a colleagues machine and got the same result.

[Former Member]

Are you using the similar URL in 4.0

http://xxxxxxxxxxxxxxxxxxx:8080/AdminTools/querybuilder/logonform.jsp

[Former Member]

I can login to the interface. It's just that no matter what query I run it returns the blank page above. I used the same login you did and it works fine up to that point.

[Former Member]

Did you tried with any other browser ? I think its a browser related issue. Which version you are using?

Can you try in the BO server machine?

Can you add the URL into trusted sites and try ?

[Former Member]

Tried in the latest versions of IE and Chrome and got the same result. The url has already been added to trusted sites as a default profile parameter.

[Former Member]

did you check the compatability of IE , OS and BO server?

please send details

[Former Member]

I have and I answered below on a similar question.