R2rml help needed

Support
1

Hi,

I’m trying to see how the R2RM support works. I have created a very simple mappings (map.ttl) as follows:

@prefix rr: <http://www.w3.org/ns/r2rml#>.
@prefix ex: <http://example.com/ns#>.

<#TriplesMap1>
    rr:logicalTable [ rr:tableName "prod.pm_offering" ];
    rr:subjectMap [
        rr:template "http://borna.example.com/offering/{offering_id}";
        rr:class ex:Offering;
    ].

I run this command:
stardog-admin virtual add jdbc.properties map.ttl

I always get the following error: “The mapping collection is empty”. It only complains about malformed ttl mapping files. It never checks my jdbc connection.

Any help is appreciated,

Thanks,

Borna

2

Hi Borna,

The virtual add command expects mappings in Stardog Mapping Syntax (SMS) by default. Quoting the documentation:

The add command by default assumes the mappings are using the Stardog Mapping Syntax. Mappings in standard R2RML syntax can be used by adding the --format r2rml option in the above command

Hope this helps.
Jess

3

Thanks for the quick response. Now that I add "--format r2rml " to the end of the command, I get "Not Found!". Any help with that?

thanks

4

Look at this example from the man page:

Register a new virtual graph with the mappings written in standard R2RML Turtle syntax
$ stardog-admin virtual add --format r2rml myGraph.properties myGraph.ttl

5

Thanks. Here is the verbose version of the error. I have disabled security. Do you think it has something to do with that? If not, is there a way to know which resource does not exist?

com.complexible.stardog.security.ResourceNotFoundException: Not Found!
        at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:488)
        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)
6

The inability to create a new virtual graph when security is disabled is a known issue. It will be fixed in a future version of Stardog. In the meantime, I would recommend enabling security at least in order to create the virtual graph.

Jess

7

Thanks. Still the same issue after activating security. I wonder what resource is not found. Cheers.

8

Which version of Stardog are you using?

9

I am using 5.0-RC1 version

10

How did you enable security?

11

i don’t use “–disable-security” :slight_smile: Now I think that is incorrect :slight_smile:

12

Did you restart the Stardog server? What do you see if you run:

stardog-admin server status | grep Security

13

Security Disabled: false

14

Ok. Let me check further and I will get back to you.

15

Can you share the last error shown in stardog.log?

16

This is what I get by “tail stardog.log”. The error at the bottom is relevant to an incorrect CLI query (I think):

INFO  2017-06-12 14:39:58,442 [main] com.complexible.stardog.cli.impl.ServerStart:call(228): Memory options
INFO  2017-06-12 14:39:58,444 [main] com.complexible.stardog.cli.impl.ServerStart:call(229): Min Heap Size: 2.0G
INFO  2017-06-12 14:39:58,444 [main] com.complexible.stardog.cli.impl.ServerStart:call(230): Max Heap Size: 27G
INFO  2017-06-12 14:39:58,444 [main] com.complexible.stardog.cli.impl.ServerStart:call(231): Max Direct Mem: 27G
INFO  2017-06-12 14:39:58,445 [main] com.complexible.stardog.cli.impl.ServerStart:call(232): Max Mapped Mem: 3.6G
INFO  2017-06-12 14:39:58,445 [main] com.complexible.stardog.cli.impl.ServerStart:call(233): System Memory: 252G
ERROR 2017-06-12 14:44:38,005 [XNIO-1 task-27] com.complexible.stardog.protocols.http.server.StardogHttpServiceLoader:accept(225): An exception was handled by the server: Lexical error at line 1, column 28.  Encountered: <EOF> after : "p}"
17

What is the exact command you are sending when you receive the verbose text of the error?

18

stardog-admin virtual add --format r2rml jdbc.properties map.tll -v

19

What type of license are you using?

20

I am using the Community license