Qdabra Database Accelerator

Re: DBXL mapping error

Jim Cantwell — Wed, 10 Mar 2010 16:03:19 GMT

Can you generate sql scripts for the database tables, including foreign keys, indexes etc and email them to support(at)qdabra.com? This will allow us to identify the exact scenario that might cause the issue you are seeing.

Also, please include the version of SQL Server are you using.

Thanks,

Jim

Re: DBXL mapping error

orion — Wed, 10 Mar 2010 10:45:55 GMT

Hi,

I've attached a screenshot of my tables, they do look the same as yours so I'm not sure why it doesn't work.

Thanks.

Re: DBXL mapping error

ErnestoM — Tue, 09 Mar 2010 14:42:00 GMT

Hi orion,

At least the shredding is working correctly when you move the DocID, but it should still work.

I assume that we have a difference in how we created our primary keys in the tables. Can you compare my database table screenshot (a few posts above this one) to yours? How are you creating your primary keys in the database tables? Perhaps this is where we have a difference in our scenarios.

Thanks!

Re: DBXL mapping error

orion — Mon, 08 Mar 2010 11:08:50 GMT

Hi, you're right, there is no need to have TWDetails as a separate table. I have copied your setup and included those fields in TWHeader. I have changed my mapping so it looks exactly the same as yours but I still get the error I was getting previously when I try to reshred. If I just have IssueNumber as the foreign key and move DocID into the list of columns it works ok though and all the tables are updated correctly.

I've attached screenshots of both mappings in case you can see anything but as it does seem to work ok with the DocID not in the foreign key I'm happy to leave it like that.

Thanks for all your help.

Re: DBXL mapping error

ErnestoM — Sun, 07 Mar 2010 15:37:33 GMT

Hello, and thanks for your patience. I have been able to recreate this scenario, and it works, so we need to investigate why it's not working for you. I'm attaching a screenshot will all my setup; perhaps it'll help you out as you compare to your setup.

Also: Why is TWDetails necessary as a separate table? Because there is no repeating group under Details, there is a 1 to 1 relationship between the data in TWDetails and TWHeader. I believe the data in TWDetails can just be added as columns in TWHeader. That's why I did in my environment, but let me know if this is not acceptable.

Re: DBXL mapping error

Hilary Stoupa — Thu, 04 Mar 2010 22:35:19 GMT

Great, thanks for the additional information. We'll see if we can reproduce the issue.

Re: DBXL mapping error

orion — Thu, 04 Mar 2010 17:05:05 GMT

TWIssues had DocId and IssueNumber as the primary key. TWIssuesActions has DocID, IssueNumber and ActionNumber as the primary key. I have defined no relationships between the tables in sql.

Re: DBXL mapping error

ErnestoM — Thu, 04 Mar 2010 15:54:13 GMT

It might be possible to have two foreign keys defined in the database mapping (in DAT) but perhaps we need to look at your table in SQL too. What is defined as a Foreign Key in the table? What is defined as a Primary Key? Thanks for the additional info.

Re: DBXL mapping error

orion — Thu, 04 Mar 2010 14:43:39 GMT

Hi Ernesto and thanks for your reply.

I changed the foreign key to be just IssueNumber and moved DocID into the list of columns and populated it there and it all works ok now.

Is it not possible then to have more than one foreign key. It's just that the 2 tables link by DocID and IssueNumber, they are the unique key on TWIssues, and it seemed the right place to map those 2 columns.

Thanks.

Re: DBXL mapping error

ErnestoM — Thu, 04 Mar 2010 13:21:53 GMT

Hi orion,

I'm sorry that you're having issues. The problem might be that you have two keys set for the grandchild table (TWIssuesActions). You need just one key between the tables TWIssues and TWIssuesActions. Can you try that and let us know how it goes? Thanks.

DBXL mapping error

orion — Thu, 04 Mar 2010 10:36:02 GMT

Hi, I'm trying to complete my database map in DBXL but am getting an error after I add a mapping for one of my repeating tables. I have attached screenprints of my database map and my data source.
With the tables TWHeader, TWDetails and TWIssues the mapping is ok and all the tables are updated. As soon as I add TWIssuesActions and try to ReShred I get the error:
An error occurred while calling the ReshredAllDocuments method. ID501: Error parsing 1 documents out of 1. Error Shredding DocId 111: Error inserting a new record into the DB Check mapping for foreign keys on object TWIssues, and Node my:IssuesActionsRepeat.
This is the first mapping I have done so I'm probably making a very silly mistake, I hope someone can help.
Thanks.