![]() |
#6 |
Участник
|
Вот что пишет в ивент вьювере:
:Cannot insert duplicate key row in object 'Datamart.DimensionValuesWithDefinitions' with unique index 'CI_DimensionValuesWithDefinitions'. The duplicate key value is (<NULL>, 1, 11010|MAINACCOUNT). DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. 0 staged scenarios updated with organization id 2015-12-29 08:49:17.1418868 0 staged scenarios updated with id 2015-12-29 08:49:17.1418868 0 staged scenarios found requiring recalculation 2015-12-29 08:49:17.1418868 0 scenarios merged 2015-12-29 08:49:17.1730866 0 out-of-date child/parent scenario associations deleted 2015-12-29 08:49:17.2042864 0 scenario child/parent associations inserted 2015-12-29 08:49:17.2354862 0 dimensions updated with organization id 2015-12-29 08:49:17.2666860 0 accounts updated with account category id 2015-12-29 08:49:17.2822859 0 accounts updated with exchange rate id 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers updated with organization id 2015-12-29 08:49:17.2978858 0 fact type qualifiers merged 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers deleted 2015-12-29 08:49:17.2978858 Beginning transaction. Beginning transaction. Caution: Changing any part of an object name could break scripts and stored procedures. Committing transaction. Beginning transaction. Rolling back transaction. Cannot insert duplicate key row in object 'Datamart.DimensionValuesWithDefinitions' with unique index 'CI_DimensionValuesWithDefinitions'. The duplicate key value is (<NULL>, 1, 11010|MAINACCOUNT). DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. 0 staged scenarios updated with organization id 2015-12-29 08:49:17.1418868 0 staged scenarios updated with id 2015-12-29 08:49:17.1418868 0 staged scenarios found requiring recalculation 2015-12-29 08:49:17.1418868 0 scenarios merged 2015-12-29 08:49:17.1730866 0 out-of-date child/parent scenario associations deleted 2015-12-29 08:49:17.2042864 0 scenario child/parent associations inserted 2015-12-29 08:49:17.2354862 0 dimensions updated with organization id 2015-12-29 08:49:17.2666860 0 accounts updated with account category id 2015-12-29 08:49:17.2822859 0 accounts updated with exchange rate id 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers updated with organization id 2015-12-29 08:49:17.2978858 0 fact type qualifiers merged 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers deleted 2015-12-29 08:49:17.2978858 Beginning transaction. Beginning transaction. Caution: Changing any part of an object name could break scripts and stored procedures. Committing transaction. Beginning transaction. Rolling back transaction. Originating procedure: ProcessReferenceDataChangesAffectingBalances. :Cannot insert duplicate key row in object 'Datamart.DimensionValuesWithDefinitions' with unique index 'CI_DimensionValuesWithDefinitions'. The duplicate key value is (<NULL>, 1, 11010|MAINACCOUNT). DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. 0 staged scenarios updated with organization id 2015-12-29 08:49:17.1418868 0 staged scenarios updated with id 2015-12-29 08:49:17.1418868 0 staged scenarios found requiring recalculation 2015-12-29 08:49:17.1418868 0 scenarios merged 2015-12-29 08:49:17.1730866 0 out-of-date child/parent scenario associations deleted 2015-12-29 08:49:17.2042864 0 scenario child/parent associations inserted 2015-12-29 08:49:17.2354862 0 dimensions updated with organization id 2015-12-29 08:49:17.2666860 0 accounts updated with account category id 2015-12-29 08:49:17.2822859 0 accounts updated with exchange rate id 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers updated with organization id 2015-12-29 08:49:17.2978858 0 fact type qualifiers merged 2015-12-29 08:49:17.2978858 0 staged fact type qualifiers deleted 2015-12-29 08:49:17.2978858 Beginning transaction. Beginning transaction. Caution: Changing any part of an object name could break scripts and stored procedures. Committing transaction. Beginning transaction. Rolling back transaction. Component: Microsoft.Dynamics.Integration.Common.TraceLog User: DOMAIN\ax12mr Короче гора ошибок с самой базой, насколько я поянл DBCC пытается ее полечить - и безрезультатно. Я пробовал сносить сервис и удалять базы манаджмент репортера и с нуля ставить такие же ошибки дальше продолжают выбрасываться с dublicate key. с менеджемент репортером, что шел с Axapta 2012 R3 CU8 в комплекте - таких ошибок небыло. может это проблема с сборкой, которую отдельно я скачал Management reporter 2012 CU14? Или иные идеи будут? Данные ошибки валятся после интеграции с аксаптой. база данных ManagementReporterDM Последний раз редактировалось sv_igor; 29.12.2015 в 12:52. |
|