Вот что пишет в ивент вьювере:
: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.
|