This discussion is archived
9 Replies Latest reply: Jan 21, 2013 3:36 PM by user571093 RSS

Error 500--Internal Server Error in Oracle SPARQL Service Endpoint

user571093 Newbie
Currently Being Moderated
Hi,

I followed the instructions of "Setting Up the SPARQL Service" in the developer's guide. However, after I finished all the steps and click "Submit Query" button in Oracle SPARQL Service Endpoint using Joseki page, I got this error message:

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

I can't figure out what's wrong with the service. Can anybody pls help me solve the problem? Thanks in advance.

Kind Regards,
Hong
  • 1. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    alwu Pro
    Currently Being Moderated
    Well, you need to provide a bit more information including:

    WLS version,
    Joseki version,
    Jena version,
    Jena Adapter version,
    Database version,

    and the exact error trace. You should be able to find it in your log file.

    Thanks,

    Zhe
  • 2. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    user571093 Newbie
    Currently Being Moderated
    hi zhe,

    sorry for the late reply. i checked my configuration again and found the installed jena adaptor is not the version for oracle 11.2.0.1. maybe it is the reason caused the problem. WLS: 10.3.3.0; Joseki: 3.4.0; jena:2.6.2; jena adapter:not very sure which version installed but it is not for oracle 11.2.0.1; oracle:11.2.01; java home enviroment is set to jdk1.5; eclipse:indigo for testing jena queries. i am goin to reinstall jena adapter again to see what's going to happen. thanks a lot.

    regards,
    hong
  • 3. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    user571093 Newbie
    Currently Being Moderated
    hi zhe,

    i installed the right version of jena adapter for oracle 11.2.01 and recreated the data source in WLS. however, i still got the same error when click joseki sparql service end point. but, the first error message is different than the second time. it is shown below:

    first time:
    Error 500--Internal Server Error

    java.lang.NoSuchMethodError: com.hp.hpl.jena.sparql.util.StringUtils.join

    (Ljava/lang/String;[Ljava/lang/String;)Ljava/lang/String;
         at org.joseki.Configuration.makeQuery(Configuration.java:827)
         at org.joseki.Configuration.readConfFile(Configuration.java:176)
         at org.joseki.Configuration.(Configuration.java:82)
         at org.joseki.Dispatcher.setConfiguration(Dispatcher.java:130)
         at org.joseki.Dispatcher.initServiceRegistry(Dispatcher.java:100)
         at org.joseki.http.Servlet.init(Servlet.java:112)
         at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run

    (StubSecurityHelper.java:283)
         at weblogic.security.acl.internal.AuthenticatedSubject.doAs

    (AuthenticatedSubject.java:321)
         at weblogic.security.service.SecurityManager.runAs

    (SecurityManager.java:121)
         at weblogic.servlet.internal.StubSecurityHelper.createServlet

    (StubSecurityHelper.java:64)
         at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance

    (StubLifecycleHelper.java:58)
         at weblogic.servlet.internal.StubLifecycleHelper.

    (StubLifecycleHelper.java:48)
         at weblogic.servlet.internal.ServletStubImpl.prepareServlet

    (ServletStubImpl.java:539)
         at weblogic.servlet.internal.ServletStubImpl.execute

    (ServletStubImpl.java:243)
         at weblogic.servlet.internal.ServletStubImpl.execute

    (ServletStubImpl.java:183)
         at weblogic.servlet.internal.WebAppServletContext

    $ServletInvocationAction.doIt(WebAppServletContext.java:3686)
         at weblogic.servlet.internal.WebAppServletContext

    $ServletInvocationAction.run(WebAppServletContext.java:3650)
         at weblogic.security.acl.internal.AuthenticatedSubject.doAs

    (AuthenticatedSubject.java:321)
         at weblogic.security.service.SecurityManager.runAs

    (SecurityManager.java:121)
         at weblogic.servlet.internal.WebAppServletContext.securedExecute

    (WebAppServletContext.java:2268)
         at weblogic.servlet.internal.WebAppServletContext.execute

    (WebAppServletContext.java:2174)
         at weblogic.servlet.internal.ServletRequestImpl.run

    (ServletRequestImpl.java:1446)
         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
         at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    thanks a lot.

    regards,
    hong
  • 4. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    user571093 Newbie
    Currently Being Moderated
    hi zhe,

    the installed wls version is 10.3.3.; but i can't find wls 10.3.1 in oralce's download website. is this version 10.3.3 not compatible with oracle 11.2.0.1? thanks a lot.

    regards,
    hong
  • 5. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    alwu Pro
    Currently Being Moderated
    Hi,

    This does not appear to be a WLS problem.

    The error message you posted seems to suggest that there is a mismatch between the Joseki version
    you use and the Jena/ARQ version.

    java.lang.NoSuchMethodError: com.hp.hpl.jena.sparql.util.StringUtils.join
    (Ljava/lang/String;[Ljava/lang/String;)Ljava/lang/String;
    at org.joseki.Configuration.makeQuery(Configuration.java:827)

    The Joseki 3.4.0 seems to be bundled with jena-2.6.0.jar and arq-2.8.0.jar.

    Hope it helps,

    Zhe Wu
  • 6. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    user571093 Newbie
    Currently Being Moderated
    hi zhe,

    i tried jena 2.6.0 with no luck. i still got the same error message. my current configuration is as follows:

    oracle 11.2.0.1; jena 2.6.0; jena_adpater_for_oracle11.2.0.1; wls 10.3.3; java_home environmental variable is set to jdk 1.6; joseki 3.4.0. the jar files contained in joseki.war/web_inf/lib folder in the autodeploy directory of wls is as follows:
    arq-2.8.0; arq-2.8.0; jena-2.6.0; jenatest-2.6.0; joseki-3.4.0; ojdbc6; sdordf; sdordfclient, and... etc.

    apprently this configuration doesn't work. any ideas? thanks lot.

    regards,
    hong
  • 7. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    alwu Pro
    Currently Being Moderated
    Hi,

    Please send an email to alan dot wu at oracle dot com. Let's take this offline and post a solution later on.

    Thanks,

    Zhe Wu
  • 8. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    alwu Pro
    Currently Being Moderated
    Haven't got your email.

    Note that Jena Adapter for 11.2.0.1 was built using Jena 2.6.2 and ARQ 2.8.1. The version of Joseki that bundles jena 262 and ARQ 281 is Joseki 3.4.1.

    Please use Joseki 3.4.1 with Jena 2.6.2 and ARQ 2.8.1.

    Hope it helps,

    Zhe
  • 9. Re: Error 500--Internal Server Error in Oracle SPARQL Service Endpoint
    user571093 Newbie
    Currently Being Moderated
    Hi Zhe,

    Sorry for the late reply because I am just back from holiday. I will try your suggestion asap. Thanks.

    Hong

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points