I just removed it from the mapping and schema files and it appears to be working. Is this the best way though? I don't need these columns in my Ontology so maybe this is?
On May 20, 8:26 am, Mark <[email protected]> wrote: > Yes, thank you. After looking thru the log file more carefully it is > erroring out on a column that has the image datatype. What is the > best way around this error? Can I just remove these columns from the > schema and mapping file? Do I have to make a view to the table and > remove this column? > > On May 19, 4:56 pm, David Price <[email protected]> wrote: > > > > > > > > > This kind of error is often caused because there's a column datatype in > > a table being opened that D2RQ does not support. The details in the > > (Window, Show View) Error Log often explain the problem in more detail. > > > Cheers, > > David > > > On 5/19/2011 8:20 PM, Gokhan Soydan wrote: > > > > Mark, > > > > Can you open the Mapping or the Schema ontologies on their own? > > > > Gokhan > > > > On 5/19/2011 7:30 AM, Mark wrote: > > >> Hi Gokhan, > > > >> Yes, I used the Create Mapping files for D2RQ Relational Database > > >> option on import. I did not get an error on creating the import file > > >> and nothing in the error log. However when I load the -Test.rdf file > > >> I get the following error: > > > >> Operation failed. > > > >> On: May 19, 2011 10:23:42 AM > > > >> Reason: > > >> org.topbraidcomposer.core.io.FailedImportException: The following URIs > > >> could not be imported:<http://datamining.org/ProChain-Test.owl> > > > >> at org.topbraidcomposer.core.io.TBCIO.loadImportedModels(TBCIO.java: > > >> 225) > > > >> at org.topbraidcomposer.core.io.TBCIO$2$1.run(TBCIO.java:310) > > > >> at java.lang.Thread.run(Unknown Source) > > > >> Let me know if there's anything I can supply. > > > >> Thanks, > > >> Mark > > > >> On May 18, 4:51 pm, Gokhan Soydan<[email protected]> wrote: > > >>> Mark, > > > >>> Did you use "Create Mapping Files for D2RQ Relational Database > > >>> Interface" wizard of TopBraid Composer? Did you get any exception in > > >>> the > > >>> Error Log? Could you send the exception? > > > >>> Gokhan > > > >>> On 5/18/2011 12:00 PM, Mark wrote: > > > >>>> Hi new to TopBraid and running into a problem importing a SQL server > > >>>> database. From what I understand each table must have a primary key or > > >>>> a unique key. In the database I'm importing, each of the tables has a > > >>>> primary key several have foreign keys. It appears to import correctly, > > >>>> a mapping file, schema file all get created without errors... But when > > >>>> I go to load the test file to run some queries against I receive an > > >>>> error that it cannot load the mapping file and something about untyped > > >>>> data in an import file. If I look at the import tab it has not > > >>>> imported the mapping file. Anyone run into this? > > > -- > > Managing Director and Consultant > > TopQuadrant Limited. Registered in England No. 05614307 > > UK +44 7788 561308 > > US +1 336-283-0606 -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
