Probably the D2RQ mapping generator accidentally generated the same property
bridge ID for two different columns. This can happen when you have two
different columns in two different tables with almost the same name, perhaps:
MGMT_BSLN_DATASOURCES.TARGET_UID
MGMT_BSLN_DATASOURCES_TARGET.UID
The mapping generator apparently generates the same ID
“map:MGMT_BSLN_DATASOURCES_TARGET_UID” for both.
In D2RQ v0.8, the best you can do really is to find some way to open the
mapping file in a text editor, find the two property bridge definitions, and
change one of them to use a different ID, like
“map:MGMT_BSLN_DATASOURCES_TARGET_UID2” for example.
In the upcoming D2RQ v0.8.1 it will be possible to exclude selected tables and
columns when running the mapping generator (using the --skip-tables option for
example). But that's not yet released.
Best,
Richard
On 21 May 2012, at 23:46, Young Soo Song wrote:
> Hi,
>
>
>
> We autogenerate a mapping file from oracle db, whose size is about 50M.
>
> When we ran a server, the following error came out.
>
> I wonder why those errors occured. Does it mean that there are two
> d2rq:column with the same value?
>
> Because the mapping file is over 50MB. It's hard to open it.
>
> I'm afraid that it's not working well after fixing those problems.
>
> Thanks.
>
>
>
> Young Soo Song
>
>
>
>
>
> 17:24:34 INFO Server :: jetty-8.1.1.v20120215
> 17:24:35 INFO StandardDescriptorProcessor :: NO JSP Support for , did not
> find org.apache.jasper.servlet.JspServlet
> 17:24:35 INFO ContextHandler :: started
> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
> 17:24:35 INFO ContextHandler :: started
> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
> 17:24:35 INFO D2RServer :: using config file:
> file:/var/d2rq/v0.8/oakoracle.ttl
> 17:24:53 WARN WebAppContext :: Failed startup of context
> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
> de.fuberlin.wiwiss.d2rq.D2RQException: Duplicate d2rq:column for
> d2rq:PropertyBridge map:MGMT_BSLN_DATASOURCES_TARGET_UID (E16)
> at
> de.fuberlin.wiwiss.d2rq.map.MapObject.assertNotYetDefined(MapObject.java:36)
> at
> de.fuberlin.wiwiss.d2rq.map.PropertyBridge.setColumn(PropertyBridge.java:55)
> at
> de.fuberlin.wiwiss.d2rq.parser.MapParser.parsePropertyBridge(MapParser.java:499)
> at
> de.fuberlin.wiwiss.d2rq.parser.MapParser.parsePropertyBridges(MapParser.java:486)
> at de.fuberlin.wiwiss.d2rq.parser.MapParser.parse(MapParser.java:104)
> at de.fuberlin.wiwiss.d2rq.GraphD2RQ.<init>(GraphD2RQ.java:73)
> at de.fuberlin.wiwiss.d2rq.ModelD2RQ.<init>(ModelD2RQ.java:60)
> at
> de.fuberlin.wiwiss.d2rq.server.AutoReloadableDataset.initD2RQDatasetGraph(AutoReloadableDataset.java:86)
> at
> de.fuberlin.wiwiss.d2rq.server.AutoReloadableDataset.forceReload(AutoReloadableDataset.java:58)
> at de.fuberlin.wiwiss.d2rq.server.D2RServer.start(D2RServer.java:224)
> at
> de.fuberlin.wiwiss.d2rq.server.WebappInitListener.contextInitialized(WebappInitListener.java:36)
> at
> org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:764)
> at
> org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
> at
> org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:756)
> at
> org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
> at
> org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1213)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:699)
> at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:454)
> at
> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
> at org.eclipse.jetty.server.Server.doStart(Server.java:263)
> at
> org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
> at
> de.fuberlin.wiwiss.d2rq.server.JettyLauncher.start(JettyLauncher.java:72)
> at d2rq.server.startServer(server.java:85)
> at d2rq.server.main(server.java:56)
> 17:24:53 INFO AbstractConnector :: Started
> [email protected]:2020
> 17:24:53 INFO ContextHandler :: stopped
> o.e.j.w.WebAppContext{,file:/var/d2rq/v0.8/webapp/},webapp
> 17:24:53 WARN server :: [[[ Server startup failed, see
> messages above ]]]
>
>
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats.
> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> d2rq-map-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
