# Unspecific errors when adding virtual graphs

**URL:** <https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436>\
**Category:** Support\
**Created:** [June 28, 2017, 7:52am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436 "2017-06-28T07:52:41Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 28, 2017, 7:52am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/1 "2017-06-28T07:52:41Z")

</div>

Hello,

I am trying to map a simple table from an Oracle database into Stardog. I put ojdbc6.jar into the server/dbms directory and restarted the service (I am on Windows, right now just for exploration).

On my first attempt I had a syntax error in my mapping (.ttl file). That step seems to get passed now.

Next, I get a message “There was an unexpected error on the server.” It probably comes from trying to connect to the database. My properties look like this:

```
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.username= ****
jdbc.password= ****
jdbc.url=jdbc:oracle:thin:@server:1571:instance

```

Oracle properties for JDBC look different (user vs. username, database vs. url), but that does not seem to make a difference. Any idea what I can try or how to find out a more detailed error message ?

Lars

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [June 28, 2017, 9:50am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/2 "2017-06-28T09:50:23Z")

</div>

There are probably more detailed information in the logs. Are there any errors or warnings in stardog.log and can you include them? What exact command are you running and what is the output of that command?

---

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 28, 2017, 10:32am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/3 "2017-06-28T10:32:27Z")

</div>

Hi Zachary,

thanks for your quick reply. The command generates no warning / error in stardog.log (only the errors related to syntax in the mapping file did). The command and exception look like this:

> D:\Apps\stardog-5.0\bin\> **stardog-admin virtual add d:\dev\DaVi\test.properties d:\dev\davi\test\_map.ttl -v**  
> There was an unexpected error on the server.  
> The detailed stack trace for the error is:  
> com.complexible.stardog.StardogException: There was an unexpected error on the server.  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:492)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.execute(BaseHttpClient.java:324)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:662)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:637)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addOrUpdate(HttpVirtualGraphAdminClientImpl.java:233)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addGraph(HttpVirtualGraphAdminClientImpl.java:202)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addGraph(HttpVirtualGraphAdminClientImpl.java:51)  
> at com.complexible.stardog.protocols.http.client.AbstractVirtualGraphAdminConnection.addGraph(AbstractVirtualGraphAdminConnection.java:86)  
> at com.complexible.stardog.virtual.cli.VirtualGraphAdd.performSecure(VirtualGraphAdd.java:107)  
> at com.complexible.stardog.cli.admin.SecureStardogAdminCommand.call(SecureStardogAdminCommand.java:60)  
> at com.complexible.stardog.cli.CLIBase.execute(CLIBase.java:55)  
> at com.complexible.stardog.cli.admin.CLI.main(CLI.java:182)

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [June 28, 2017, 11:19am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/4 "2017-06-28T11:19:25Z")

</div>

The -v flag should come before the properties file and it is probably just being ignored. You can try it in the correct place and see if it gives you some better info on what is going on.

Can you try changing to the directory with your mappings and running it from there?

C:\my\stardog\home\stardog-admin virtual add test.properties test\_map.ttl`

quote=“Lars, post:3, topic:436”]  
Stardog-admin virtual add d:\dev\DaVi\test.properties d:\dev\davi\test\_map.ttl -v  
[/quote]

---

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 28, 2017, 12:31pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/5 "2017-06-28T12:31:56Z")

</div>

It is now an error while initializing the virtual graph rather than an unexpected error. Does that point to what I am probably doing wrong ?

> D:\dev\DaVi\>d:\Apps\stardog-5.0\bin\stardog-admin.bat virtual add -v test.properties test.ttl  
> Error while initializing virtual graph  
> The detailed stack trace for the error is:  
> com.complexible.stardog.StardogException: Error while initializing virtual graph  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:492)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.execute(BaseHttpClient.java:324)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:662)  
> at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:637)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addOrUpdate(HttpVirtualGraphAdminClientImpl.java:233)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addGraph(HttpVirtualGraphAdminClientImpl.java:202)  
> at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminClientImpl.addGraph(HttpVirtualGraphAdminClientImpl.java:51)  
> at com.complexible.stardog.protocols.http.client.AbstractVirtualGraphAdminConnection.addGraph(AbstractVirtualGraphAdminConnection.java:86)  
> at com.complexible.stardog.virtual.cli.VirtualGraphAdd.performSecure(VirtualGraphAdd.java:107)  
> at com.complexible.stardog.cli.admin.SecureStardogAdminCommand.call(SecureStardogAdminCommand.java:60)  
> at com.complexible.stardog.cli.CLIBase.execute(CLIBase.java:55)  
> at com.complexible.stardog.cli.admin.CLI.main(CLI.java:182)

Lars

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [June 28, 2017, 1:37pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/6 "2017-06-28T13:37:42Z")

</div>

What type of license are you using? Virtual graphs are an enterprise feature so you’ll need to be using a de, /30-day eval, or enterprise license to use that feature.

---

<div class="post-metadata">

**Author:** ![stephen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/stephen/32/27_2.png) [@stephen](https://community.stardog.com/u/stephen)\
**Post date:** [June 28, 2017, 3:30pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/7 "2017-06-28T15:30:52Z")

</div>

Hi,

Especially given that this is a server error, your log (located at %STARDOG\_HOME%\stardog.log) should absolutely have a more detailed error message when you see this client-side.

Take a look at the output of `bin\stardog-admin server status` to see where the Stardog Home folder is, and the stardog.log in there should have more info for you.

---

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 28, 2017, 6:27pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/8 "2017-06-28T18:27:17Z")

</div>

Hi,

I am fairly confident that I downloaded the 30-day developer license. Can I confirm anywhere in the web interface ?

There is no further entry in the log after the error messages shown, sorry. I confirmed the home folder as suggested, but that log does not contain any new errors.

Lars

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [June 28, 2017, 6:45pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/9 "2017-06-28T18:45:06Z")

</div>

Try

`stardog-admin license info <license>`

in your case that would be

`stardog-admin license info %STARDOG_HOME%\stardog-license-key.bin`

---

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 28, 2017, 7:59pm UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/10 "2017-06-28T19:59:26Z")

</div>

All,

the license type is ok (evaluation). Also, I found useful error logs in STARDOG\_HOME/logs now (but nothing in stardog.log). This revealed that I was referring to a deprecated jdbc driver class in my properties file. I am (slowly) getting closer.

Looks like the connection to the database can be established now. I am now stuck with an AbstractMethodError in a call to T4CConnection.getSchema. From searching the web, this should only happen, when an old jdbc implementation \< version 4 is used and the code is compiled against a more recent version. I have ojdbc6 in my class path which should be ok. Need to go on searching.

Lars

---

<div class="post-metadata">

**Author:** ![Lars](https://avatars.discourse-cdn.com/v4/letter/l/74df32/32.png) [@Lars](https://community.stardog.com/u/Lars)\
**Post date:** [June 29, 2017, 10:03am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/11 "2017-06-29T10:03:44Z")

</div>

Hi again,

found the final problem - ojdbc7.jar is needed instead of ojdbc6.jar. The former is for JDK1.7+ and implements the needed getSchema method. I was confused because Oracle suggests ojdbc6.jar for use with 11.2g which is what I have,

Finally:

> Successfully added virtual graph mobacm1\_sppid

I now have a problem with the generated query, but will open a separate item on that one. This case here is solved for me. Many thanks for your help and input.

Lars

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [July 13, 2017, 10:03am UTC](https://community.stardog.com/t/unspecific-errors-when-adding-virtual-graphs/436/12 "2017-07-13T10:03:50Z")

</div>

Closed on July 13, 2017, 10:03am UTC

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
