InfoPath Dev

I have the DBXL trial downloaded...., I have the MyFormsWebPart installed.....

I have the webservice installed and I am going through the Getting Started document.

When I try to shred my documents I get the error message.

I9999: An unhandled exception was thrown - No Transaction is active.

I have uninstalled the accelerator, ane re-installed it.  I have checked which login used for SQL Authentication. The login has server roles of sysadmin and dbcreator; and ALL roles for the DB it is trying to shred to, and QdabraDBXL and Qdabarasamples.

I have looked in the event viewer and the error message is

Caught exception on shredding document (DocType = 'qdabrademo', DocId = 11) encountered a critical error and needs attention:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Qdabra.Dbxl.Domain.DocumentType.SaveDocumentToTables(Document doc, XmlDocument xmlDoc, XmlNamespaceManager nsMgr)
   at Qdabra.Dbxl.Domain.Document.OnSaved()

The stack trace was:    at Qdabra.Dbxl.Domain.DocumentType.SaveDocumentToTables(Document doc, XmlDocument xmlDoc, XmlNamespaceManager nsMgr)
   at Qdabra.Dbxl.Domain.Document.OnSaved().

I am afraid this does not help me - can some one please interpret.

Thank you

Catharine

It is hard to know without seeing your form data source and table.

Do you have some related tables? It is possible that a relationship is broken.

I would look at your main table.

Make sure it has a primary key.

Use the DBXL:DocID as the key or make sure you have a unique ID.

Just shred a couple fields initially and make sure that is working, then add more.

You can always reshred and update more fields.

Thank you for the reply 

At the moment I only have one table I am trying to shred to.  It has a primary key. - I am only trying to shred the primary key and 3 other fields. 

I have changed my primary key for the DBXL:DocID and I get the same error. - If it tells me I have no transaction - surely that is indicating that the 'process' isn't getting far enough to crash through key errors ?  I have attached a jpg with data source, table, and mapping

I am beginning to get the feeling this will never work !   :-s

Catharine

OK - I have junked my existing tables and started again (not something I relish doing if this was on a live system !) 

I have created a new table with 4 fields - one of them the primary key (ApplicationId)..... and I can get it to shred - Yippeee.

I have created a second table with 2 fields one is a foreign key (ApplicationId) and one is the variable

These need to be fed from a repeating field on the Infopath form.

I need the ApplicationId and Alias to be a combinded key for the table - there should be no duplicates.

I have mapped the table, and ApplicationId as a foreign key (identity), and Alias as a key.

If I try to reshred all I get the No transaction is active message.

If I try to reshred any single document I get the message - Cannot insert the value NULL into column ApplicationID, table 'Application Index.dbo.QdApAlias'; column does not allow nulls - INSERT fails.

- Ok so - I need to have a primary key on my second table - and a primary key cannot be null - my primary key is ApplicationID/Alias combo.....  How do I get this to work ?

I have mapped the table, and ApplicationId as a foreign key (column), and Alias as a key.

I get no error messages on shredding - but I only get one Alias per form - Alias is a repeating field and I need a one to many relationship.  I am really tearing my hair out here....

Grateful for any help.

Catharine

Hi Catharine,

Your setup looks correct. Setting up the combined key where one of the items is a foreign key is an interesting scenario (and not one that I have seen before). I'm going to ask our testers to look into it. In the meantime, can you just create a separate int column in the child table that is a primary key and have it increment automatically? You can remove the combined key but still use ApplicationId as a foreign key. Alias can just be a separate column.

Hi Catharine,

I want to reproduce this scenario locally and would like more information on the data types you are using for each column. I see some nvarchars in the screenshot, but for the others the type isn't clear.

Thank you.

Hi, Sorry for the delay in replying.

This is a test environment for me - all of the fields are nchar.

I have changed the table set up - now I have 3 fields, a generated number for a key, Application(a foreign key from parent table), and the value I want to keep. 

Can you please advise what the difference between DocID and RefID and standard identities in SQL... and when one should use which and for what purpose.

Catharine