|  |
 | | | | | | | | | | | |  | | | | | |  |
Joined: 22/02/2006
Posts: 22
|
| |
I have a simple Survey form that we created. When I go to generate a view (even with just the mandatory fields, historyid, instanceid, stateid, etc), the Report manager throughs an error:
Error while GenerateReportViewTable: CREATE VIEW dbo.EFV_6d17c082c2 AS SELECT I.formid , H.userid, I.userid AS ownerid, H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp" FROM dbo.EFFormInst I, dbo.EFFormInstHist H, dbo.EFTable_3 D, dbo.EFFormStateType ST WHERE I.formid = 3 AND H.state_id = ST.state_id AND I.instance_id = H.instance_id AND I.formid = 3 AND D.formid = 3 AND D.instance_id = I.instance_id AND D.hist_id = H.hist_id
Any Advice would be helpful... | |
|
| | | | |  |
Joined: 25/08/2005
Posts: 3802
|
| |
Could you run the complete SQL statement via SQL Server Management Studio (or via Host --> SQL with "Run as sccript" enabled) and let us know what the error message returned.
The SQL statement starts from CREATE VIEW to the end of the error message posted.
Enterprise Forms System Admin | |
|
| | | | | |
Joined: 22/02/2006
Posts: 22
|
| |
Thanks for your help,
Msg 4506, Level 16, State 1, Procedure EFV_dcf04904b7, Line 1
Column names in each view or function must be unique. Column name 'hist_id' in view or function 'EFV_dcf04904b7' is specified more than once.
Here is the entire query (again):
CREATE VIEW dbo.EFV_dcf04904b7 AS SELECT I.formid , H.userid, I.userid AS ownerid, H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", H.hist_id AS "hist_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", I.instance_id AS "instance_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", H.state_id AS "state_id", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", ST.state_name AS "state_name", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp", H.create_tstamp AS "create_tstamp" FROM dbo.EFFormInst I, dbo.EFFormInstHist H, dbo.EFTable_3 D, dbo.EFFormStateType ST WHERE I.formid = 3 AND H.state_id = ST.state_id AND I.instance_id = H.instance_id AND I.formid = 3 AND D.formid = 3 AND D.instance_id = I.instance_id AND D.hist_id = H.hist_id | |
|
| | | | | |
Joined: 22/02/2006
Posts: 22
|
| |
I posted the error yesteday. Either it didn't post, or you have an extremely long moderation period. The error again in brief is:
System.Data.SqlClient.SqlException: Column names in each view or function must be unique. Column name 'hist_id' in view or function 'EFV_5b37cfee6e' is specified more than once.
TIA | |
|
| | | | | |
Joined: 25/08/2005
Posts: 3802
|
| |
Which versions (exact numbers) of EF and DNN are you using? Could you also post the Edit Report Field screen for us to review?
Enterprise Forms System Admin | |
|
|
| | | | | | | | | | |
|
|
| |  |
|
 | |
Version 05.01.06 Workflow Manager Enhancements Template Manager Enhancements Report Manager Enhancements Other Enhancements & Fixes
- Enhancement - allow sub-form (state-form) to be printed even if has not been submitted
- Fixed - issue with the [OWNER] namespace does not parse properly in the NEW workflow state
- Fixed - issue with Report Manager performing LIKE comparison instead of EQUAL operations for list type fields
- Fixed - issue databound fields do not persist between pages
- Fixed - issue PRINT button not displaying of no action buttons available
- Fixed - issue with Custom Form Roles being cached even after a user role update
- Fixed - issue with The base class includes the field 'FormLinksPanelTR' for cettain environments
Minimum Requirements: - Dotnetnuke versions 4.8 - 5.4 inclusive.
- Microsoft SQL Server 2005 or later
Version 05.00.18 Workflow Manager Enhancements - Multi-templates Support - added support for managing multiple form templates per Workflow Manager module instance
- Multi-template Support - added the ability to view My Forms, Worklist and All Forms for multiple form templates
- Multi-template Support - added support for filtering to a specific form template in multi-template mode
- XML Data Export - added support for exporting form data to XML format. (XML format compatible with standard .NET Data table object)
- Reminder Notification - Added support for send reminder notifications if form is not submitted after a certain date
- Read-only mode - changed disabled fields in read-only when viewing form in Print and Read-only mode
- Print mode - Removed required image from fields in Print mode
- Date Range - added support for Date Range search in Workflow Search view
Template Manager Enhancements - Template Views - added support for filtering different Views of Form Template listing
- Workflow Conditional Visibility - added support for Conditional Visibility on Workflow actions
- Template Usage Dashboard - added support for dashboard like view of Form Template Usage
- View Access Log - added support for Viewing complete Access Log for form instances
- Edit Form - overhauled the Edit Form Layout page (05.00.02)
- Edit Field Element, Edit Cell Properties and Form Preview popups have been Ajaxified and are now displayed in the same Browser window
- Reordered page properties to provide more estate for designing forms
- Added the ability to customize the styling in both the Workflow Action Buttons and Form Page Navigation buttons bar
Report Manager Enhancements - Date Range - added support for Date Range search in Reports
- XML Data Export - added support for exporting report data to XML format. (XML format compatible with standard .NET Data table object)
- Text Size limit - added support to display free-text fields with more than 4000 characters
Other Enhancements & Fixes
- Added - support for non-standard FORM tokens in Reminder Notification
- Added - support for default values for checkboxlist, radiobuttonlist and selectlist when using databinding
- Added - the ability to assign Tab Index to data entry field elements (05.00.02)
- Added - the ability to remember focus position upon an Ajax callback (05.00.02)
- Added - the ability lock form template upon an Instant Development action (05.00.02)
- Added - the ability to Preview Form in the same window in the main Template Listing and Template Details pages. (05.00.02)
- Added - StartUpScript field element to support Javascript calls upon ajax callbacks (05.00.03)
- Changed - Ajax popup windows to utilize maximun window size of the browser (05.00.03)
- Fixed - issue Custom Report Templates not saving after Default Template is generated
- Fixed - issue with Conditional Visibility (page level) not updating upon post back under certain condition
- Fixed - issue with Workflow States in lookup lists not being populated after added or removed
- Fixed - issue with Form Creator able to use Instant Publish to approve and publish form templates
- Fixed - issue with Change Form Owner advanced workflow processing task when used in initial workflow
- Fixed - issue caching under certain conditions in DNN 5.0
- Fixed - issue with Conditional Visibility with file upload element
- Fixed - issue with upload file type filter for file upload element
- Fixed - issue with Reminder Notification when Notification Owner is not selected
- Fixed - issue with validation on conditionally hidden or disabled fields in multi-page forms (05.00.02)
- Fixed - issue with multiple conditional visibility fields exists in single form cell (05.00.02)
- Fixed - issued with workflow Forms Details (via Workflow Manager and Report Manager) not displaying correctly for workflow steps that have advanced workflow processing tasks involved (05.00.02)
- Fixed - issue with Javascript error when editing Cell Properties (05.00.03)
- Fixed - issue Action Buttons not showing when Hide Action Buttons is enabled for certain pages (05.00.03)
- Fixed - issued with ajax windows not centering properly for certain Skins in DNN 5.0 (05.00.03)
Version 04.02.02 - New Feature - Data Archival: the ability to archive form data for import and export between environments
- New Feature - Field Element Tooltip: ability to assign a tooltip to a individual form field elements
- Enhancements - Form Layout Designer: added compatibility support for new default skin in DNN 4.9 or later
- Enhancements - Look & Feel: modified the general look & feel to be inline with DNN standards
- Bug fix: fixed issue with download attachments for anonymous user.
Click here to view the full change log Version 05.01.06 Workflow Manager Enhancements Template Manager Enhancements Report Manager Enhancements Other Enhancements & Fixes
- Enhancement - allow sub-form (state-form) to be printed even if has not been submitted
- Fixed - issue with the [OWNER] namespace does not parse properly in the NEW workflow state
- Fixed - issue with Report Manager performing LIKE comparison instead of EQUAL operations for list type fields
- Fixed - issue databound fields do not persist between pages
- Fixed - issue PRINT button not displaying of no action buttons available
- Fixed - issue with Custom Form Roles being cached even after a user role update
- Fixed - issue with The base class includes the field 'FormLinksPanelTR' for cettain environments
Minimum Requirements: - Dotnetnuke versions 4.8 - 5.4 inclusive.
- Microsoft SQL Server 2005 or later
Version 05.00.18 Workflow Manager Enhancements - Multi-templates Support - added support for managing multiple form templates per Workflow Manager module instance
- Multi-template Support - added the ability to view My Forms, Worklist and All Forms for multiple form templates
- Multi-template Support - added support for filtering to a specific form template in multi-template mode
- XML Data Export - added support for exporting form data to XML format. (XML format compatible with standard .NET Data table object)
- Reminder Notification - Added support for send reminder notifications if form is not submitted after a certain date
- Read-only mode - changed disabled fields in read-only when viewing form in Print and Read-only mode
- Print mode - Removed required image from fields in Print mode
- Date Range - added support for Date Range search in Workflow Search view
Template Manager Enhancements - Template Views - added support for filtering different Views of Form Template listing
- Workflow Conditional Visibility - added support for Conditional Visibility on Workflow actions
- Template Usage Dashboard - added support for dashboard like view of Form Template Usage
- View Access Log - added support for Viewing complete Access Log for form instances
- Edit Form - overhauled the Edit Form Layout page (05.00.02)
- Edit Field Element, Edit Cell Properties and Form Preview popups have been Ajaxified and are now displayed in the same Browser window
- Reordered page properties to provide more estate for designing forms
- Added the ability to customize the styling in both the Workflow Action Buttons and Form Page Navigation buttons bar
Report Manager Enhancements - Date Range - added support for Date Range search in Reports
- XML Data Export - added support for exporting report data to XML format. (XML format compatible with standard .NET Data table object)
- Text Size limit - added support to display free-text fields with more than 4000 characters
Other Enhancements & Fixes
- Added - support for non-standard FORM tokens in Reminder Notification
- Added - support for default values for checkboxlist, radiobuttonlist and selectlist when using databinding
- Added - the ability to assign Tab Index to data entry field elements (05.00.02)
- Added - the ability to remember focus position upon an Ajax callback (05.00.02)
- Added - the ability lock form template upon an Instant Development action (05.00.02)
- Added - the ability to Preview Form in the same window in the main Template Listing and Template Details pages. (05.00.02)
- Added - StartUpScript field element to support Javascript calls upon ajax callbacks (05.00.03)
- Changed - Ajax popup windows to utilize maximun window size of the browser (05.00.03)
- Fixed - issue Custom Report Templates not saving after Default Template is generated
- Fixed - issue with Conditional Visibility (page level) not updating upon post back under certain condition
- Fixed - issue with Workflow States in lookup lists not being populated after added or removed
- Fixed - issue with Form Creator able to use Instant Publish to approve and publish form templates
- Fixed - issue with Change Form Owner advanced workflow processing task when used in initial workflow
- Fixed - issue caching under certain conditions in DNN 5.0
- Fixed - issue with Conditional Visibility with file upload element
- Fixed - issue with upload file type filter for file upload element
- Fixed - issue with Reminder Notification when Notification Owner is not selected
- Fixed - issue with validation on conditionally hidden or disabled fields in multi-page forms (05.00.02)
- Fixed - issue with multiple conditional visibility fields exists in single form cell (05.00.02)
- Fixed - issued with workflow Forms Details (via Workflow Manager and Report Manager) not displaying correctly for workflow steps that have advanced workflow processing tasks involved (05.00.02)
- Fixed - issue with Javascript error when editing Cell Properties (05.00.03)
- Fixed - issue Action Buttons not showing when Hide Action Buttons is enabled for certain pages (05.00.03)
- Fixed - issued with ajax windows not centering properly for certain Skins in DNN 5.0 (05.00.03)
Version 04.02.02 - New Feature - Data Archival: the ability to archive form data for import and export between environments
- New Feature - Field Element Tooltip: ability to assign a tooltip to a individual form field elements
- Enhancements - Form Layout Designer: added compatibility support for new default skin in DNN 4.9 or later
- Enhancements - Look & Feel: modified the general look & feel to be inline with DNN standards
- Bug fix: fixed issue with download attachments for anonymous user.
Click here to view the full change log |
| | |
|
|
|