Thanks. Regards, Bade Iriabho Systems Analyst UAB Pathology - Informatics
-----Original Message----- From: Richard Cyganiak [mailto:[email protected]] Sent: Friday, May 25, 2012 3:40 AM To: Young Soo Song Cc: Egiebade Iriabho; d2rq-map-devel (E-mail) Subject: Re: [d2rq-dev] Duplicate d2rq:comlumn for property bridge error Hi, Just a quick update to let you know that a fix for this is in trunk, and will be in the v0.8.1 release. Now, the mapping generator will generate two different property bridge names for the two columns, for example: map:MGMT_BSLN_DATASOURCES_TARGET_UID map:MGMT_BSLN_DATASOURCES_TARGET__UID Best, Richard On 22 May 2012, at 00:49, Richard Cyganiak wrote: > 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 ------------------------------------------------------------------------------ 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
