linvicch Posted January 29, 2010 Share Posted January 29, 2010 Hi,when i go to http://127.0.0.1:8081/jasperserver/xmlaI get the following error.HTTP method GET is not supported by this URLHow do I view the wsdl for this webservice?Is there any security configuration I have to set up in tomcat?What I am trying to achieve is to connect excel with ODBO to mondrian xml/A using simba odbo driver. I have been able to succesfully connection, view cube etc but at the final stage of set up, the issue occur when it trys to read data from the xml/A source. the following error occured"Initialization of the data source failed."Kindly provide some advice on troubleshooting this Link to comment Share on other sites More sharing options...
andrewsok Posted January 29, 2010 Share Posted January 29, 2010 This URL does not present WebServices interface.It gets handled by a normal HTTP Servlet (see web.xml).The functionality is provided by Mondrian, and it does not support GET method. Could you post more details where you get the exception (stack trace, etc.)? Link to comment Share on other sites More sharing options...
linvicch Posted January 31, 2010 Author Share Posted January 31, 2010 Hi Andrew,I can't seem to find any more detail on the exception. The error I received is from excel. I am going to work on the assumption that jaspersoft doesn't like simba odbo very much and perhaps give jasper odbo a shot.As mentioned on my first post, everything seem to connect find, i am able to "see" the cube and when I use excel 2007, it gave me the same error but if I keep on trying, eventually it will allow me through.I have a tcp trace if that help. It says authentication error, but i have provide all the necessary authentication required which is require thats why I am able to view the cube. HTTP/1.1 100 ContinueHTTP/1.1 401 UnauthorizedServer: Apache-Coyote/1.1Set-Cookie: JSESSIONID=1B421DA5DB004D0CD151FA0F2F44D4D3; Path=/jasperserver-proWWW-Authenticate: Basic realm="Protected Area"Content-Type: text/html;charset=utf-8Content-Length: 1119Date: Fri, 29 Jan 2010 02:53:22 GMTHTTP Status 401 - Full authentication is required to access this<html><head><title>Apache Tomcat/5.5.28 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 401 - Full authentication is required to access this resource</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Full authentication is required to access this resource</u></p><p><b>description</b> <u>This request requires HTTP authentication (Full authentication is required to access this resource).</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/5.5.28</h3></body></html>HTTP/1.1 100 Continue Post Edited by linvicch at 01/31/2010 04:44 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now