Spacer
s
menu
menu
Spacer
Spacer
Login  |  Register search:  
Spacer
Spacer
Support Forum
Subject: Form Master 1.6.05 Throws a "System.Data.DuplicateNameException" when running a report
Prev Next
You are not authorized to post a reply.

AuthorMessages
Wakefly
Posts:4

11/17/2008 10:19 AM  
Form Master 1.6.05 gives the following error when trying to run a report:

Error: Form Master Edit is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: A column named 'address 2' already belongs to this DataTable. ---> System.Data.DuplicateNameException: A column named 'address 2' already belongs to this DataTable. at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column, DataTable table) at System.Data.DataColumn.set_ColumnName(String value) at Code5Systems.FormMaster.Business.FormDataController.GetDataSetFromFormResults(String xml, String modulePath, Boolean fromControl) at Code5Systems.FormMaster.Business.FormDataController.List(Int32 moduleId, DateTime dtStart, DateTime dtEnd, Int32 pageNum, Int32 pageSize, String modulePath, Boolean fromControl) at Code5Systems.FormMaster.FormReport.BindGrid() --- End of inner exception stack trace ---

Please help.

Thanks!
Sujay
Posts:387

11/17/2008 10:23 AM  
Hi,

Please try this one
http://www.code5systems.com/Support/Forum/tabid/55/forumid/36/tpage/1/view/topic/postid/2363/Default.aspx

Thanks & Regards,
Sujay
Wakefly
Posts:4

11/17/2008 11:24 AM  
I think I have identified the cause of the problem. The xml in the database adds an underscore to a field name if its a duplicate but the export function "GetDataSetFromFormResults" strips out the underscore so the name becomes a duplicate again:

current.ColumnName = current.ColumnName.Replace("_", " ").Trim();

Can we get a patch for this?
Code 5 Systems
Posts:86

11/17/2008 4:49 PM  
The problem with this issue is we have never been able to reproduce it in the development environment.

Could you please export your form and zip it up with a file from your server from

\DesktopModules\Code5Systems_FormMaster\assets\xslt\FormResultsDataSet.xslt

Thanks

Support

Code 5 Systems, LLC
Wakefly
Posts:4

11/18/2008 9:24 AM  
attached is the exported form and the xslt files.

Attachment: 1111824163871.zip

Wakefly
Posts:4

11/20/2008 9:54 AM  
Can you pleas provide me with a status update for this problem?

Thanks
Code 5 Systems
Posts:86

11/20/2008 12:26 PM  
We have examined your export and it was fine. We have not been able to reproduce the problem but are still working on it.

Support

Code 5 Systems, LLC
You are not authorized to post a reply.
Forums > Form Master for DNN4 > Form Master Version 1.6.x > Form Master 1.6.05 Throws a "System.Data.DuplicateNameException" when running a report



ActiveForums 3.7

Spacer
SpacerfooterSpacer
Spacer
Update :: January 07, 2009
Spacer