R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
errors when installinf the Dr managment module
Last Post 01 Jan 1900 05:00 AM by . 16 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
chaloumUser is Offline
New Member
New Member
Posts:8

--
22 Oct 2007 06:22 AM  

How do I resolve this issue???



Package: Doctor Management 1.0.0 Author: Business Intelligence Force

Package Item Status
1. PhysiciansTables.sql - Creates the Tables required for using the Physicians example. Complete
2. PhysiciansData.sql - Inserts the data for Physicians. Complete
3. PhysiciansKeys.sql - Creates relationships between the Physicians tables. Complete
4. 17.gif Complete
5. GI_Cancel.gif Complete
6. GI_CancelDA.gif Complete
7. GI_CancelMD.gif Complete
8. GI_CancelMO.gif Complete
9. GI_Delete.gif Complete
10. GI_DeleteDA.gif Complete
11. GI_DeleteMD.gif Complete
12. GI_DeleteMO.gif Complete
13. GI_Edit.gif Complete
14. GI_EditDA.gif Complete
15. GI_EditMD.gif Complete
16. GI_EditMO.gif Complete
17. GI_Save.gif Complete
18. GI_SaveDA.gif Complete
19. GI_SaveMD.gif Complete
20. GI_SaveMO.gif Complete
21. GI_View.gif Complete
22. GI_ViewDA.gif Complete
23. GI_ViewMD.gif Complete
24. GI_ViewMO.gif Complete
25. icon8.gif Complete
26. people.gif Complete
27. S_SICKNE.gif Complete
28. TBI_Add.gif Complete
29. TBI_AddDA.gif Complete
30. TBI_AddMD.gif Complete
31. TBI_AddMO.gif Complete
32. TBI_Back.gif Complete
33. TBI_BackDA.gif Complete
34. TBI_BackMD.gif Complete
35. TBI_BackMO.gif Complete
36. TBI_Cancel.gif Complete
37. TBI_CancelDA.gif Complete
38. TBI_CancelMD.gif Complete
39. TBI_CancelMO.gif Complete
40. TBI_Clear.gif Complete
41. TBI_ClearDA.gif Complete
42. TBI_ClearMD.gif Complete
43. TBI_ClearMO.gif Complete
44. TBI_Delete.gif Complete
45. TBI_DeleteDA.gif Complete
46. TBI_DeleteMD.gif Complete
47. TBI_DeleteMO.gif Complete
48. TBI_Edit.gif Complete
49. TBI_EditDA.gif Complete
50. TBI_EditMD.gif Complete
51. TBI_EditMO.gif Complete
52. TBI_Export.gif Complete
53. TBI_ExportDA.gif Complete
54. TBI_ExportMD.gif Complete
55. TBI_ExportMO.gif Complete
56. TBI_Filter.gif Complete
57. TBI_FilterDA.gif Complete
58. TBI_FilterMD.gif Complete
59. TBI_FilterMO.gif Complete
60. TBI_Import.gif Complete
61. TBI_ImportDA.gif Complete
62. TBI_ImportMD.gif Complete
63. TBI_ImportMO.gif Complete
64. TBI_Save.gif Complete
65. TBI_SaveDA.gif Complete
66. TBI_SaveMD.gif Complete
67. TBI_SaveMO.gif Complete
68. Doctor Management.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

69. Hospitals.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

70. Hospital Detail.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

71. Physicians.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

72. Physician Detail.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

73. Specialties.tab Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_TabPermission'. Cannot insert duplicate key in object 'dbo.TabPermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTabPermission(Int32 TabID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.TabPermissionController.AddTabPermission(TabPermissionInfo objTabPermission) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at Bi4ce.Modules.xList.Packaging.Delivery.Tab_Install(PackageItem Item)

74. Administration Control Panel Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

75. Introduction Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

76. Filter Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

77. Toolbar Loading...
78. Hospitals Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

79. Edit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

80. [HospitalName] Details Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

81. Loading...
82. Loading...
83. Physicians Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

84. Specialties Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

85. Specialties Edit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

86. Physicians Edit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

87. Filter Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

88. Loading...
89. Physicians Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

90. Physician Edit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

91. Loading...
92. Professional Profile Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

93. Loading...
94. Hospitals Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

95. HospitalEdit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

96. Filter Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

97. Toolbar Loading...
98. Specialties Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

99. Edit Failed
Failure:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission, Int32 tabId) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at Bi4ce.Modules.xList.Packaging.Delivery.Module_Install(PackageItem Item)

Fetching Data...


Update Cancel Delete




robert_chumleyUser is Offline
Advanced Member
Advanced Member
Posts:592

--
22 Oct 2007 01:57 PM  
Hello chaloum,
The way to fix this problem is ugrading to the most recent version of Listx. The bug was solved in the current release.
Thanks,
Robert Chumley
R2Integrated
Robert Chumley<br>r2integrated (formally bi4ce)
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
25 Oct 2007 02:27 PM  
Hi robert_chumley!

I recieved the same error(s) as chaloum. Since then, I upgraded DNN (to 04.06.02) and ListX (to 1.9.8.8 /Snowcovered patch). This removed the above mentioned error(s). However, I now get the following:

<b> An exception was thrown while attempting to install this package. Please provide the following error to Technical Support: System.NullReferenceException: Object reference not set to an instance of an object. at Bi4ce.Modules.xList.Packaging.Package.Save(XmlDocument Installer) at Bi4ce.Modules.xList.Packaging.Package.Save(String Source) at Bi4ce.Modules.xList.Installer.lnkUpload_Click(Object sender, EventArgs e) </b>

After these phrases, ListX kills the installation of the LP. How can I procede?
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
26 Oct 2007 09:31 AM  
Upgrading ListX to 1.9.9 results in the same error as mentioned in my earlier post. Might it be a database related error? Maybe a permision, that is set or not set, of some sort?
dcampbellUser is Offline
Basic Member
Basic Member
Posts:197

--
26 Oct 2007 02:26 PM  
The problem it seems is the package is partially installed. Please remove all tabs that might have been created and then run the following SQL statements and then re-install

drop table lxExample_HospitalPhoneNumbers
drop table lxExample_HospitalPhysicians
drop table lxExample_HospitalSpecialties
drop table lxExample_Physicians
drop table lxExample_Hospitals
drop table lxExample_Specialty

declare @PackageID int
select @PackageID = PackageID from xlistsettings_package where UniqueID='4125567786567'


Delete from xlistsettings_packageitem where PackageID=@PackageID
Delete from xlistsettings_package where PackageID=@PackageID


Dave Campbell<br>Software Engineer<br>Business Intelligence Force, Inc. (bi4ce)
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
26 Oct 2007 03:27 PM  
Hi dcampbell,

Yes, YES! This works :-) Thanks! I ran into problems because I didn't have the Toolbar PA installed. The Doctor's Management installer kept on refreshing and got stuck at the "toolbar" items. After installing the Toolbar PA, this Doctor's module installed smoothly!

However, I, as well, don't have any data. I have no visible "Administration Control Panel", and so forth.

However, I now am at the point Larry-K is as well earlier then expected. Thanks again!

Do you happen to know how to actualy enter the Administration Control Panel? Or how to trace where it might go wrong? I'm sure it has something to do with the incorrect previous install efforts both I and Larry-K made.
dcampbellUser is Offline
Basic Member
Basic Member
Posts:197

--
26 Oct 2007 04:03 PM  
Back track a little. Remove all the tabs that were created. Empty the recycle bin for the site. So that the old tabs and the newer ones are removed, Then run the scripts above again.
Now reinstall the LP.

Dave
Dave Campbell<br>Software Engineer<br>Business Intelligence Force, Inc. (bi4ce)
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
29 Oct 2007 03:34 PM  
Hello Dave,

Thanks for all your trouble! The LP installed correctly after walking through the outlined procedure AND emptying the recycle bin. Marvelous!

Best regards,
- Alex.
robert_chumleyUser is Offline
Advanced Member
Advanced Member
Posts:592

--
29 Oct 2007 04:13 PM  
Hello AlexK,
That is great news! If you have other questions, then please write back.
Thanks,
Robert Chumley
R2Integrated
Robert Chumley<br>r2integrated (formally bi4ce)
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
29 Oct 2007 04:45 PM  
Hi Robert, I almost dare not say it, but I only have these tables:
- xListSettings
- xListSettings_log
- xListSettings_package
- xListSettings_packageitem
- xListSettings_repository
- xListSettingsDraft
This causes that no specialty, doctor or hospital can be added, because the table isn't there. The event viewer backs this up by listing error events. Can I manualy add the missing tables?
robert_chumleyUser is Offline
Advanced Member
Advanced Member
Posts:592

--
29 Oct 2007 10:34 PM  
Hello AlexK,
We are sill looking into this problem for you. We will let you know what we find.
Thanks,
Robert Chumley
r2integrated
Robert Chumley<br>r2integrated (formally bi4ce)
kevinmschreinerUser is Offline
Advanced Member
Advanced Member
Posts:729

--
30 Oct 2007 01:39 PM  
AlexK - is this a local install, or is it accessible remotely? If it can be accessed remotely - let me know and we can take a look. I'll contact by email if the system is accessible and we can obtain credentials through that means. I'd like to take a look and see what is occuring on your side, and the state of the package tables.

Thanks
robert_chumleyUser is Offline
Advanced Member
Advanced Member
Posts:592

--
30 Oct 2007 04:13 PM  
Hello AlexK,
I was able to get the Dr Module to install after running into the same issues you were having. We will be updating the notice on the DR Module to say that you must have the NukeDK Toolbar module installed in order to install this module. Please make sure your DNN site has this module.

Then, Run the scripts that were posted by dcampbell. In order to delete the entire module and tab, go to the 'Doctor Management' tab that was initially installed. Then select 'delete' for that tab. Go to the recycle bin and click remove items until no errors about dependencies come up. This will make sure the tab and the dependencies are removed.

After you do all this, the LP should install again in the correct location. I checked my database and the tables are there. Like I said, we will be updating the documentation for this module to include instructions on how to uninstall and install again if you initially installed without the NukeDK Toolbar module.

Thanks,
Robert Chumley
R2Integrated
Robert Chumley<br>r2integrated (formally bi4ce)
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
01 Nov 2007 11:41 AM  
Hello Kevin, Robert,

I just finnished running through your instructions. All tabs were removed, tables deleted. I logged out of DNN, and back in again. Then I installed the newest (patch) versions of ListX, Toolbar and Breadcrumbs, just to make sure.

Next was installing the Doctor's LP. This went smooth. No errors, everything went fine. All the tables I missed earlier are there. They also contain data; I noticed three hospitals in there, for example. However, when I visit the pages, no data is shown, nor can I add new data. No hospitals, doctors or specialties can be entered. Well, entering is not the problem, its the storing part. The data is not stored into the database.

Kevin asked for setup details, it still is a local development machine I'm working on. The site that this application/module will be a part of is not yet publicly available. The configuration details I can give you.

The development machine is a Windows XP box, running IIS as web server software. All Service Packs have been applied. The database is located on a different server somewhere in the LAN. It is a Microsoft SQL Server 2005 (9.0.3042) database, running on a Windows 2003 Server box.

As I said, there is data present in the tables. I have the following tables present after installation of the LP:
- lxExample_HospitalPhoneNumbers
- lxExample_HospitalPhysicians
- lxExample_Hospitals
- lxExample_HospitalSpecialties
- lxExample_Physicians
- lxExample_Specialty
"Specialties" are read, the drop down is filled with the specialties in the database. Its the hospitals, physicians and specialties that are missing from the presentation. They are present in the database. The "Add" functionality has no effect.

What information can I supply you more with? I'll enclose the text of the last listed event regarding this situation below. Maybe it tells you anything?

Best regards,
- Alex.

----------- event -----------
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: ListX Execute Action Error: System.Data.SqlClient.SqlException: Invalid object name 'lxExample_Specialty'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText) at Bi4ce.Modules.xList.SqlDataProvider.GetDataset(String Connection, String Query, Int32 ConnectionTimeout) at Bi4ce.Modules.xList.Engine.GetData_SQL(Boolean isSubQuery, String Query, String FilterField, String FilterText, Debugger& DebugWriter, Boolean isRendered, Int32 timeout, String CustomConnection, Boolean& IsSuccessful, String& FailureMessage)
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Exception: ListX Execute Action Error: System.Data.SqlClient.SqlException: Invalid object name 'lxExample_Specialty'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText) at Bi4ce.Modules.xList.SqlDataProvider.GetDataset(String Connection, String Query, Int32 ConnectionTimeout) at Bi4ce.Modules.xList.Engine.GetData_SQL(Boolean isSubQuery, String Query, String FilterField, String FilterText, Debugger& DebugWriter, Boolean isRendered, Int32 timeout, String CustomConnection, Boolean& IsSuccessful, String& FailureMessage)
Source:
Server Name: PC096
--------- end of event ---------
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
01 Nov 2007 09:06 PM  
Robert, Kevin,

It suddenly hit me ... better yet; starred me right in the eye. It's the DNN objectQualifier! The objectQualifier is not taken into account in the queries that are prepared in the Doctor's LP! I do use this object Qualifier, so the queries query a table that isn't there, obviously. It was the event log that gave it away, eventually. I'll change all the queries and let you know if all went well ...

Regards,
- Alex.
AlexKUser is Offline
Basic Member
Basic Member
Posts:128

--
02 Nov 2007 10:40 AM  
That was it. I have the Doctor's LP working now. The queries need to be altered if one uses an ObjectQualifier. Unfortunately this little fact didn't struck my eye earlier. Wow, I'm relieved! Now I can finally witness and learn ... Thanks for your time and effort in this matter! I'm sure I'll be back in other sections of this forum before long ;-)

Best regards,
- Alex.
dcampbellUser is Offline
Basic Member
Basic Member
Posts:197

--
02 Nov 2007 01:03 PM  
Glad you got it working. Good Luck.
Dave Campbell<br>Software Engineer<br>Business Intelligence Force, Inc. (bi4ce)
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share