# Getting a error - while trying to create a mapping with .ttl file **URL:** \ **Category:** Support\ **Created:** [August 22, 2021, 7:41pm UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213 "2021-08-22T19:41:20Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sam](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@Sam](https://community.stardog.com/u/Sam)\ **Post date:** [August 22, 2021, 7:41pm UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213/1 "2021-08-22T19:41:20Z")
Hi Team, I'm trying to create a virtual graph from mysql data source . I have created a virtual graph through the Stardog studio with auto generated mappings and then made some changes in the default mappings (namespaces and few other predicates) , with that i'm able to write a sparql and get the results. Attached mapping file. References : [map.ttl](https://community.stardog.com/uploads/short-url/lozYN0eI75LO3p5WGlzdBf0HXSb.ttl) (612 Bytes)[sqldb.txt](https://community.stardog.com/uploads/short-url/ffJJpsl5TySqUykID7ClQ5mnlpa.txt) (111 Bytes) ![image](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/9/9fc6c897e26d9af534ba526d97d73d96cd8f4e57.png) Trying to create a same with cmd line by loading the map.ttl file in the following command. ```auto stardog-admin virtual add --name sqlds sqldb.properties map.ttl ``` Getting below error ```auto WARN 2021-08-22 19:26:16,369 [stardog-user-1] com.complexible.stardog.protocols.http.server.StardogUndertowErrorHandler:accept(68): Unexpected exception was handled by the server com.stardog.stark.io.InvalidRDF: Expected ':', found ' ' [L8] at com.stardog.stark.io.ParserContext.error(ParserContext.java:232) ~[stardog-stark-io-api-7.7.1.jar:?] at com.stardog.stark.io.ParserContext.error(ParserContext.java:220) ~[stardog-stark-io-api-7.7.1.jar:?] at com.stardog.stark.io.IOParserContext.verifyCharacterOrFail(IOParserContext.java:226) ~[stardog-stark-io-api-7.7.1.jar:?] at com.stardog.stark.io.turtle.TurtleParser.parseQNameOrBoolean(TurtleParser.java:634) ~[stardog-stark-io-turtle-7.7.1.jar:?] at com.stardog.stark.io.turtle.TurtleParser.parseValue(TurtleParser.java:507) ~[stardog-stark-io-turtle-7.7.1.jar:?] at com.stardog.stark.io.trig.TrigParser.parseGraph(TrigParser.java:121) ~[stardog-stark-io-trig-7.7.1.jar:?] at com.stardog.stark.io.trig.TrigParser.parseStatement(TrigParser.java:72) ~[stardog-stark-io-trig-7.7.1.jar:?] at com.stardog.stark.io.turtle.TurtleParser.parse(TurtleParser.java:97) ~[stardog-stark-io-turtle-7.7.1.jar:?] at com.stardog.stark.io.RDFParsers.read(RDFParsers.java:340) ~[stardog-stark-io-api-7.7.1.jar:?] at com.complexible.stardog.virtual.api.StardogMappingSyntaxParser.parse(StardogMappingSyntaxParser.java:128) ~[stardog-virtual-api-7.7.1.jar:?] at com.complexible.stardog.virtual.api.StardogMappingSyntaxParser.parse(StardogMappingSyntaxParser.java:111) ~[stardog-virtual-api-7.7.1.jar:?] at com.complexible.stardog.virtual.api.StardogMappings.read(StardogMappings.java:47) ~[stardog-virtual-api-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.rdbms.RdbmsMappings.parseOrGenerateMappings(RdbmsMappings.java:124) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.rdbms.RdbmsMappings.parseOrGenerateMappings(RdbmsMappings.java:107) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.rdbms.RdbmsMappings.parseOrGenerateMappings(RdbmsMappings.java:92) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.rdbms.RdbmsVirtualGraphFactory.createInternal(RdbmsVirtualGraphFactory.java:98) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.rdbms.RdbmsVirtualGraphFactory.createInternal(RdbmsVirtualGraphFactory.java:44) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.AbstractVirtualGraphFactory.createWithAvailability(AbstractVirtualGraphFactory.java:120) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.vega.AbstractVirtualGraphFactory.create(AbstractVirtualGraphFactory.java:100) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.DefaultVirtualGraphRegistry.createVirtualGraph(DefaultVirtualGraphRegistry.java:658) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.DefaultVirtualGraphRegistry.createVirtualGraph(DefaultVirtualGraphRegistry.java:644) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.DefaultVirtualGraphRegistry.addGraphInternal(DefaultVirtualGraphRegistry.java:387) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.DefaultVirtualGraphRegistry.addGraph(DefaultVirtualGraphRegistry.java:321) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.virtual.SecuredVirtualGraphRegistry.addGraph(SecuredVirtualGraphRegistry.java:204) ~[stardog-virtual-core-7.7.1.jar:?] at com.complexible.stardog.protocols.http.server.virtual.admin.VirtualGraphHttpService.addVG(VirtualGraphHttpService.java:570) ~[stardog-virtual-protocols-http-server-7.7.1.jar:?] at com.complexible.stardog.protocols.http.server.virtual.admin.VirtualGraphHttpService.addVG(VirtualGraphHttpService.java:287) ~[stardog-virtual-protocols-http-server-7.7.1.jar:?] at com.stardog.http.server.undertow.jaxrs.ExtractRoutes.lambda$handleIt$5(ExtractRoutes.java:192) ~[stardog-protocols-http-server-7.7.1.jar:?] at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120) [shiro-core-1.7.1.jar:1.7.1] at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108) [shiro-core-1.7.1.jar:1.7.1] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292] ``` Could any one please advise, why the same mapping data (file) is working if loaded in stardog studio, but giving an error while using it in the stardog-admin cmd line ? ---
**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\ **Post date:** [August 22, 2021, 8:09pm UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213/2 "2021-08-22T20:09:03Z")
Can you try to specify the mapping format with the `-f` argument? Is it R2RML or Stardog syntax? ---
**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\ **Post date:** [August 22, 2021, 8:10pm UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213/3 "2021-08-22T20:10:14Z")
Sorry I just saw you included the file. Responding from the phone. 😀 This is the newer Stardog format. If you change the extension from ttl to sms, it should be detected properly. ---
**Author:** ![Sam](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@Sam](https://community.stardog.com/u/Sam)\ **Post date:** [August 23, 2021, 11:51am UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213/4 "2021-08-23T11:51:49Z")
Thanks @jess. That Works 😀 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\ **Post date:** [September 6, 2021, 11:52am UTC](https://community.stardog.com/t/getting-a-error-while-trying-to-create-a-mapping-with-ttl-file/3213/5 "2021-09-06T11:52:12Z")
Closed on September 6, 2021, 11:52am UTC This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.