Перенесли БД на локальный сервер путем сохранение бэкапа и потом восстановления.
Все перенеслось и заработало, но VogbitReporter теперь не может сгенерировать отчет. Какие-то проблемы с правами, но не понимаю, чего сделать.. Пользователь перенесся вместе с БД, в администрировании SQL виден.
VOGBIT v1.1.52161.2005
Error: Невозможно выполнить в качестве участника базы данных, поскольку участник "VogbitReporter" не существует, этот тип участника не может проходить олицетворение, или отсутствует разрешение.
Ошибка при выполнении:
UserQuery DS
Cre ate table #TEMP ([Idx] int,[IsPrecise] nvarchar(max),[ComponentId] bigint,[NomenclatureId] bigint,[NomenclatureNotation] nvarchar(max),[NomenclatureName] nvarchar(max),[Quantity] nvarchar(max),[MeasureId] bigint,[Obj] nvarchar(max),[TechCard] nvarchar(max),[TaskNotation] nvarchar(max),[TaskId] bigint,[OperationNotation] nvarchar(max),[OperationId] bigint,[OperationComment] nvarchar(max),[OperationNumber] nvarchar(max),[UnitWorkersTaskId] bigint,[SortOrder] nvarchar(max),[UtObjectTaskId] bigint,[TcTask] nvarchar(max),[StartTime] nvarchar(max),[FinishTime] nvarchar(max),[Comment] nvarchar(max),[StandardHours] nvarchar(max),[StatusNotation] nvarchar(max),[StatusId] bigint,[ActualStandardHours] nvarchar(max),[PlaceTaskId] bigint,[PlaceTaskStatus] nvarchar(max),[VgbNomCheck] nvarchar(max),[ActualCount] bigint,[NmkBatch] nvarchar(max),[IsFromManExists] nvarchar(max),[Priority] float,[Importance] nvarchar(max),[PlanQuantity] float,[UnitTaskIdAsBarCode] nvarchar(max),[UnitWorkersIdAsBarCode] nvarchar(max)) declare @qs nvarchar(max) set @qs = (sel ect top 1 op.stringvalue fr om [Views].[ObjectParameters] as op where op.id = (SEL ECT TOP(1) ID FROM (SEL ECT
[Views].[ObjectParameters].[ID]
FR OM
[Views].[ObjectParameters]
WHERE
[Views].[ObjectParameters].[ID] = 158667) AS CQ)) ins ert #Temp execute (@qs) SELECT UTParameters_ShiftDate.ParameterValue AS UW_ShiftDate, UTParameters_ShiftNum.ParameterValue AS UW_ShiftNumber, UNIT_WORKERS.ID AS UW_ID, UNIT_WORKERS.Notation AS UW_Notation, UNIT_WORKERS.ExecutorID AS UW_ExecutorID, UNIT_WORKERS.ExecutorNotation AS UW_ExecutorNotation, LTrim(IsNull(UNIT_WORKERS.ExecutorNotation,'') + ' ' +UNIT_WORKERS .ExecutorName) AS UW_ExecutorName, UNIT_WORKERS.StatusID AS UW_StatusID, UNIT_WORKERS.StatusNotation AS UW_StatusNotation, (SEL ECT LEFT(TaskExecutors.ItemExecutor, LEN(TaskExecutors.ItemExecutor) - 1) FROM (SELECT (SEL ECT (EmployeeName + ', ') AS [*] FR OM Views.PlannedLabourResources AS LR INNER JOIN Views.Tasks ON UNIT_WORKERS.ID = LR.ObjectID AND LR.LinkTypeUID = 'LT_Executor' GROUP BY EmployeeName FOR XML PATH ('') ) AS ItemExecutor) AS TaskExecutors) AS UW_Executors, UNIT_PLACE.ID AS PT_ID, UNIT_PLACE.ExecutorID AS PT_ExecutorID, UNIT_PLACE.ExecutorNotation AS PT_ExecutorNotation, LTrim(IsNull(UNIT_PLACE.ExecutorNotation,'') + ' ' + UNIT_PLACE.ExecutorName) AS PT_ExecutorName, RT.TaskID AS UT_TaskID, RT.PlaceTaskStatus AS UT_StatusNotation, CAST(REPLACE(RT.StandardHours,',','.') AS decimal(10,3))AS UT_Hours, RT.ComponentId AS COMPS_ID, RT.NomenclatureId AS COMPS_NomenclatureID, ROW_NUMBER () OVER (ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID ) AS POS_NUMBER, RT.NomenclatureName AS COMPS_NomenclatureName, RT.NomenclatureNotation AS COMPS_NomenclatureNotation, (CASE WHEN ISNULL(Mes.Notation ,'шт') = 'шт' THEN CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),0) AS decimal(10) ) AS NVARCHAR(10)) ELSE CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),3) AS decimal(10,3)) AS NVARCHAR(10)) END) AS COMPS_Quantity, Mes.Notation AS COMPS_MeasureNotation, CAST (Round(COMPSParameters_Massa.FloatValue,3) AS decimal(10,3)) AS COMPS_Massa, RTrim(ISNULL(PR.Notation,'') + ' ' + ISNULL(PR.Name,'')) AS PPART, RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) AS ORDER_NAME, ISNULL(CC.NomenclatureID,'-1') AS ORDER_ID, (CASE WHEN DENSE_RANK() OVER (ORDER BY (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END )) = 1 THEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) ELSE 'Внеплановые' END) AS REPORT_ORDER_NAME, (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END ) AS GENERAL_ORDER, RTrim(ISNULL((SEL ECT TOP(1) [Comp].[Comment] FR OM [Views].[PlannedSteps] AS [PlannedSteps] LEFT JOIN [Views].[Components] AS [Comp] ON [PlannedSteps].[ComponentID] = [Comp].[ID] WH ERE [PlannedSteps].[TaskID] = RT.[PlaceTaskId]),'') + (CASE WHEN IsNull(rt.comment,'') = '' then '' else ' (' END) + ISNULL(RT.Comment,'') + (CASE WHEN isnull(rt.comment,'') = '' then '' else ')' END) ) AS Task_Comment, RT.OperationNotation, RT.UnitTaskIdAsBarCode as IdAsBarCodeString, RT.UnitWorkersIdAsBarCode AS UnitWorkersIdAsBarCode FROM #TEMP AS RT LEFT JOIN Views.Tasks AS UNIT_WORKERS ON UNIT_WORKERS.ID = RT.UnitWorkersTaskID LEFT JOIN Views.ObjectTasks AS UNIT_TASK ON RT.TaskId = UNIT_TASK.ID AND UNIT_TASK.LinkTypeUID = 'LT_Unit_Task' LEFT JOIN Views.Tasks AS UNIT_PLACE ON UNIT_PLACE.ID = RT.PlaceTaskId LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftDate ON UNIT_WORKERS.ID = UTParameters_ShiftDate.OwnerID AND UTParameters_ShiftDate.ParameterUID = 'VGB_SHIFT_DATE' LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftNum ON UNIT_WORKERS.ID = UTParameters_ShiftNum.OwnerID AND UTParameters_ShiftNum.ParameterUID = 'VGB_SHIFT_NUMBER' LEFT JOIN Views.ObjectParameters AS COMPSParameters_Massa ON RT.NomenclatureID = COMPSParameters_Massa.OwnerID AND COMPSParameters_Massa.ParameterUID = 'P_Mass_t' LEFT JOIN Views.Components AS COMPS ON RT.ComponentId = COMPS.ID LEFT JOIN Views.ComponentCollections AS CC ON COMPS.OwnerID = CC.ID LEFT JOIN Views.Measures AS Mes ON Mes.ID = RT.MeasureId LEFT JOIN Views.LinkedObjects AS PR ON COMPS.ID = PR.OwnerID AND PR.LinkTypeUID = 'LT_Production_Run' ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID DR OP TABLE #TEMP
Сообщение:
Невозможно выполнить в качестве участника базы данных, поскольку участник "VogbitReporter" не существует, этот тип участника не может проходить олицетворение, или отсутствует разрешение.
Ошибка при выполнении:
UserQuery DS
Cre ate table #TEMP ([Idx] int,[IsPrecise] nvarchar(max),[ComponentId] bigint,[NomenclatureId] bigint,[NomenclatureNotation] nvarchar(max),[NomenclatureName] nvarchar(max),[Quantity] nvarchar(max),[MeasureId] bigint,[Obj] nvarchar(max),[TechCard] nvarchar(max),[TaskNotation] nvarchar(max),[TaskId] bigint,[OperationNotation] nvarchar(max),[OperationId] bigint,[OperationComment] nvarchar(max),[OperationNumber] nvarchar(max),[UnitWorkersTaskId] bigint,[SortOrder] nvarchar(max),[UtObjectTaskId] bigint,[TcTask] nvarchar(max),[StartTime] nvarchar(max),[FinishTime] nvarchar(max),[Comment] nvarchar(max),[StandardHours] nvarchar(max),[StatusNotation] nvarchar(max),[StatusId] bigint,[ActualStandardHours] nvarchar(max),[PlaceTaskId] bigint,[PlaceTaskStatus] nvarchar(max),[VgbNomCheck] nvarchar(max),[ActualCount] bigint,[NmkBatch] nvarchar(max),[IsFromManExists] nvarchar(max),[Priority] float,[Importance] nvarchar(max),[PlanQuantity] float,[UnitTaskIdAsBarCode] nvarchar(max),[UnitWorkersIdAsBarCode] nvarchar(max)) declare @qs nvarchar(max) se t @qs = (sel ect top 1 op.stringvalue fr om [Views].[ObjectParameters] as op wh ere op.id = (SELECT TOP(1) ID FR OM (SELECT
[Views].[ObjectParameters].[ID]
FR OM
[Views].[ObjectParameters]
WH ERE
[Views].[ObjectParameters].[ID] = 158667) AS CQ)) ins ert #Temp execute (@qs) SELECT UTParameters_ShiftDate.ParameterValue AS UW_ShiftDate, UTParameters_ShiftNum.ParameterValue AS UW_ShiftNumber, UNIT_WORKERS.ID AS UW_ID, UNIT_WORKERS.Notation AS UW_Notation, UNIT_WORKERS.ExecutorID AS UW_ExecutorID, UNIT_WORKERS.ExecutorNotation AS UW_ExecutorNotation, LTrim(IsNull(UNIT_WORKERS.ExecutorNotation,'') + ' ' +UNIT_WORKERS .ExecutorName) AS UW_ExecutorName, UNIT_WORKERS.StatusID AS UW_StatusID, UNIT_WORKERS.StatusNotation AS UW_StatusNotation, (SELECT LEFT(TaskExecutors.ItemExecutor, LEN(TaskExecutors.ItemExecutor) - 1) FR OM (SELECT (SELECT (EmployeeName + ', ') AS [*] FR OM Views.PlannedLabourResources AS LR INNER JOIN Views.Tasks ON UNIT_WORKERS.ID = LR.ObjectID AND LR.LinkTypeUID = 'LT_Executor' GROUP BY EmployeeName FOR XML PATH ('') ) AS ItemExecutor) AS TaskExecutors) AS UW_Executors, UNIT_PLACE.ID AS PT_ID, UNIT_PLACE.ExecutorID AS PT_ExecutorID, UNIT_PLACE.ExecutorNotation AS PT_ExecutorNotation, LTrim(IsNull(UNIT_PLACE.ExecutorNotation,'') + ' ' + UNIT_PLACE.ExecutorName) AS PT_ExecutorName, RT.TaskID AS UT_TaskID, RT.PlaceTaskStatus AS UT_StatusNotation, CAST(REPLACE(RT.StandardHours,',','.') AS decimal(10,3))AS UT_Hours, RT.ComponentId AS COMPS_ID, RT.NomenclatureId AS COMPS_NomenclatureID, ROW_NUMBER () OVER (ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID ) AS POS_NUMBER, RT.NomenclatureName AS COMPS_NomenclatureName, RT.NomenclatureNotation AS COMPS_NomenclatureNotation, (CASE WHEN ISNULL(Mes.Notation ,'шт') = 'шт' THEN CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),0) AS decimal(10) ) AS NVARCHAR(10)) ELSE CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),3) AS decimal(10,3)) AS NVARCHAR(10)) END) AS COMPS_Quantity, Mes.Notation AS COMPS_MeasureNotation, CAST (Round(COMPSParameters_Massa.FloatValue,3) AS decimal(10,3)) AS COMPS_Massa, RTrim(ISNULL(PR.Notation,'') + ' ' + ISNULL(PR.Name,'')) AS PPART, RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) AS ORDER_NAME, ISNULL(CC.NomenclatureID,'-1') AS ORDER_ID, (CASE WHEN DENSE_RANK() OVER (ORDER BY (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END )) = 1 THEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) ELSE 'Внеплановые' END) AS REPORT_ORDER_NAME, (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END ) AS GENERAL_ORDER, RTrim(ISNULL((SELE CT TOP(1) [Comp].[Comment] FR OM [Views].[PlannedSteps] AS [PlannedSteps] LEFT JOIN [Views].[Components] AS [Comp] ON [PlannedSteps].[ComponentID] = [Comp].[ID] WH ERE [PlannedSteps].[TaskID] = RT.[PlaceTaskId]),'') + (CASE WHEN IsNull(rt.comment,'') = '' then '' else ' (' END) + ISNULL(RT.Comment,'') + (CASE WHEN isnull(rt.comment,'') = '' then '' else ')' END) ) AS Task_Comment, RT.OperationNotation, RT.UnitTaskIdAsBarCode as IdAsBarCodeString, RT.UnitWorkersIdAsBarCode AS UnitWorkersIdAsBarCode FR OM #TEMP AS RT LEFT JOIN Views.Tasks AS UNIT_WORKERS ON UNIT_WORKERS.ID = RT.UnitWorkersTaskID LEFT JOIN Views.ObjectTasks AS UNIT_TASK ON RT.TaskId = UNIT_TASK.ID AND UNIT_TASK.LinkTypeUID = 'LT_Unit_Task' LEFT JOIN Views.Tasks AS UNIT_PLACE ON UNIT_PLACE.ID = RT.PlaceTaskId LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftDate ON UNIT_WORKERS.ID = UTParameters_ShiftDate.OwnerID AND UTParameters_ShiftDate.ParameterUID = 'VGB_SHIFT_DATE' LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftNum ON UNIT_WORKERS.ID = UTParameters_ShiftNum.OwnerID AND UTParameters_ShiftNum.ParameterUID = 'VGB_SHIFT_NUMBER' LEFT JOIN Views.ObjectParameters AS COMPSParameters_Massa ON RT.NomenclatureID = COMPSParameters_Massa.OwnerID AND COMPSParameters_Massa.ParameterUID = 'P_Mass_t' LEFT JOIN Views.Components AS COMPS ON RT.ComponentId = COMPS.ID LEFT JOIN Views.ComponentCollections AS CC ON COMPS.OwnerID = CC.ID LEFT JOIN Views.Measures AS Mes ON Mes.ID = RT.MeasureId LEFT JOIN Views.LinkedObjects AS PR ON COMPS.ID = PR.OwnerID AND PR.LinkTypeUID = 'LT_Production_Run' ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID DR OP TABLE #TEMP
Исключение:
System.Exception
Источник:
Csdn.Vogbit.Reporter
Версия 1.1.52161 сборка 2005
Список вызовов:
в Csdn.Vogbit.Reporter.Reporter.GetDataSource_UserQuery(ExpressionItem expr)
в Csdn.Vogbit.Reporter.Reporter.GetDataSource(BlankItem blank)
в Csdn.Vogbit.Reporter.Reporter.ExecuteReport()
в Csdn.Vogbit.Reporter.Reporter.ExecReport(IExtensibleApplication vogbitApplication, String fileName, SqlQuery sqlCurrentQuery, DataTable currentItems)
Все перенеслось и заработало, но VogbitReporter теперь не может сгенерировать отчет. Какие-то проблемы с правами, но не понимаю, чего сделать.. Пользователь перенесся вместе с БД, в администрировании SQL виден.
VOGBIT v1.1.52161.2005
Error: Невозможно выполнить в качестве участника базы данных, поскольку участник "VogbitReporter" не существует, этот тип участника не может проходить олицетворение, или отсутствует разрешение.
Ошибка при выполнении:
UserQuery DS
Cre ate table #TEMP ([Idx] int,[IsPrecise] nvarchar(max),[ComponentId] bigint,[NomenclatureId] bigint,[NomenclatureNotation] nvarchar(max),[NomenclatureName] nvarchar(max),[Quantity] nvarchar(max),[MeasureId] bigint,[Obj] nvarchar(max),[TechCard] nvarchar(max),[TaskNotation] nvarchar(max),[TaskId] bigint,[OperationNotation] nvarchar(max),[OperationId] bigint,[OperationComment] nvarchar(max),[OperationNumber] nvarchar(max),[UnitWorkersTaskId] bigint,[SortOrder] nvarchar(max),[UtObjectTaskId] bigint,[TcTask] nvarchar(max),[StartTime] nvarchar(max),[FinishTime] nvarchar(max),[Comment] nvarchar(max),[StandardHours] nvarchar(max),[StatusNotation] nvarchar(max),[StatusId] bigint,[ActualStandardHours] nvarchar(max),[PlaceTaskId] bigint,[PlaceTaskStatus] nvarchar(max),[VgbNomCheck] nvarchar(max),[ActualCount] bigint,[NmkBatch] nvarchar(max),[IsFromManExists] nvarchar(max),[Priority] float,[Importance] nvarchar(max),[PlanQuantity] float,[UnitTaskIdAsBarCode] nvarchar(max),[UnitWorkersIdAsBarCode] nvarchar(max)) declare @qs nvarchar(max) set @qs = (sel ect top 1 op.stringvalue fr om [Views].[ObjectParameters] as op where op.id = (SEL ECT TOP(1) ID FROM (SEL ECT
[Views].[ObjectParameters].[ID]
FR OM
[Views].[ObjectParameters]
WHERE
[Views].[ObjectParameters].[ID] = 158667) AS CQ)) ins ert #Temp execute (@qs) SELECT UTParameters_ShiftDate.ParameterValue AS UW_ShiftDate, UTParameters_ShiftNum.ParameterValue AS UW_ShiftNumber, UNIT_WORKERS.ID AS UW_ID, UNIT_WORKERS.Notation AS UW_Notation, UNIT_WORKERS.ExecutorID AS UW_ExecutorID, UNIT_WORKERS.ExecutorNotation AS UW_ExecutorNotation, LTrim(IsNull(UNIT_WORKERS.ExecutorNotation,'') + ' ' +UNIT_WORKERS .ExecutorName) AS UW_ExecutorName, UNIT_WORKERS.StatusID AS UW_StatusID, UNIT_WORKERS.StatusNotation AS UW_StatusNotation, (SEL ECT LEFT(TaskExecutors.ItemExecutor, LEN(TaskExecutors.ItemExecutor) - 1) FROM (SELECT (SEL ECT (EmployeeName + ', ') AS [*] FR OM Views.PlannedLabourResources AS LR INNER JOIN Views.Tasks ON UNIT_WORKERS.ID = LR.ObjectID AND LR.LinkTypeUID = 'LT_Executor' GROUP BY EmployeeName FOR XML PATH ('') ) AS ItemExecutor) AS TaskExecutors) AS UW_Executors, UNIT_PLACE.ID AS PT_ID, UNIT_PLACE.ExecutorID AS PT_ExecutorID, UNIT_PLACE.ExecutorNotation AS PT_ExecutorNotation, LTrim(IsNull(UNIT_PLACE.ExecutorNotation,'') + ' ' + UNIT_PLACE.ExecutorName) AS PT_ExecutorName, RT.TaskID AS UT_TaskID, RT.PlaceTaskStatus AS UT_StatusNotation, CAST(REPLACE(RT.StandardHours,',','.') AS decimal(10,3))AS UT_Hours, RT.ComponentId AS COMPS_ID, RT.NomenclatureId AS COMPS_NomenclatureID, ROW_NUMBER () OVER (ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID ) AS POS_NUMBER, RT.NomenclatureName AS COMPS_NomenclatureName, RT.NomenclatureNotation AS COMPS_NomenclatureNotation, (CASE WHEN ISNULL(Mes.Notation ,'шт') = 'шт' THEN CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),0) AS decimal(10) ) AS NVARCHAR(10)) ELSE CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),3) AS decimal(10,3)) AS NVARCHAR(10)) END) AS COMPS_Quantity, Mes.Notation AS COMPS_MeasureNotation, CAST (Round(COMPSParameters_Massa.FloatValue,3) AS decimal(10,3)) AS COMPS_Massa, RTrim(ISNULL(PR.Notation,'') + ' ' + ISNULL(PR.Name,'')) AS PPART, RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) AS ORDER_NAME, ISNULL(CC.NomenclatureID,'-1') AS ORDER_ID, (CASE WHEN DENSE_RANK() OVER (ORDER BY (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END )) = 1 THEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) ELSE 'Внеплановые' END) AS REPORT_ORDER_NAME, (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END ) AS GENERAL_ORDER, RTrim(ISNULL((SEL ECT TOP(1) [Comp].[Comment] FR OM [Views].[PlannedSteps] AS [PlannedSteps] LEFT JOIN [Views].[Components] AS [Comp] ON [PlannedSteps].[ComponentID] = [Comp].[ID] WH ERE [PlannedSteps].[TaskID] = RT.[PlaceTaskId]),'') + (CASE WHEN IsNull(rt.comment,'') = '' then '' else ' (' END) + ISNULL(RT.Comment,'') + (CASE WHEN isnull(rt.comment,'') = '' then '' else ')' END) ) AS Task_Comment, RT.OperationNotation, RT.UnitTaskIdAsBarCode as IdAsBarCodeString, RT.UnitWorkersIdAsBarCode AS UnitWorkersIdAsBarCode FROM #TEMP AS RT LEFT JOIN Views.Tasks AS UNIT_WORKERS ON UNIT_WORKERS.ID = RT.UnitWorkersTaskID LEFT JOIN Views.ObjectTasks AS UNIT_TASK ON RT.TaskId = UNIT_TASK.ID AND UNIT_TASK.LinkTypeUID = 'LT_Unit_Task' LEFT JOIN Views.Tasks AS UNIT_PLACE ON UNIT_PLACE.ID = RT.PlaceTaskId LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftDate ON UNIT_WORKERS.ID = UTParameters_ShiftDate.OwnerID AND UTParameters_ShiftDate.ParameterUID = 'VGB_SHIFT_DATE' LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftNum ON UNIT_WORKERS.ID = UTParameters_ShiftNum.OwnerID AND UTParameters_ShiftNum.ParameterUID = 'VGB_SHIFT_NUMBER' LEFT JOIN Views.ObjectParameters AS COMPSParameters_Massa ON RT.NomenclatureID = COMPSParameters_Massa.OwnerID AND COMPSParameters_Massa.ParameterUID = 'P_Mass_t' LEFT JOIN Views.Components AS COMPS ON RT.ComponentId = COMPS.ID LEFT JOIN Views.ComponentCollections AS CC ON COMPS.OwnerID = CC.ID LEFT JOIN Views.Measures AS Mes ON Mes.ID = RT.MeasureId LEFT JOIN Views.LinkedObjects AS PR ON COMPS.ID = PR.OwnerID AND PR.LinkTypeUID = 'LT_Production_Run' ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID DR OP TABLE #TEMP
Сообщение:
Невозможно выполнить в качестве участника базы данных, поскольку участник "VogbitReporter" не существует, этот тип участника не может проходить олицетворение, или отсутствует разрешение.
Ошибка при выполнении:
UserQuery DS
Cre ate table #TEMP ([Idx] int,[IsPrecise] nvarchar(max),[ComponentId] bigint,[NomenclatureId] bigint,[NomenclatureNotation] nvarchar(max),[NomenclatureName] nvarchar(max),[Quantity] nvarchar(max),[MeasureId] bigint,[Obj] nvarchar(max),[TechCard] nvarchar(max),[TaskNotation] nvarchar(max),[TaskId] bigint,[OperationNotation] nvarchar(max),[OperationId] bigint,[OperationComment] nvarchar(max),[OperationNumber] nvarchar(max),[UnitWorkersTaskId] bigint,[SortOrder] nvarchar(max),[UtObjectTaskId] bigint,[TcTask] nvarchar(max),[StartTime] nvarchar(max),[FinishTime] nvarchar(max),[Comment] nvarchar(max),[StandardHours] nvarchar(max),[StatusNotation] nvarchar(max),[StatusId] bigint,[ActualStandardHours] nvarchar(max),[PlaceTaskId] bigint,[PlaceTaskStatus] nvarchar(max),[VgbNomCheck] nvarchar(max),[ActualCount] bigint,[NmkBatch] nvarchar(max),[IsFromManExists] nvarchar(max),[Priority] float,[Importance] nvarchar(max),[PlanQuantity] float,[UnitTaskIdAsBarCode] nvarchar(max),[UnitWorkersIdAsBarCode] nvarchar(max)) declare @qs nvarchar(max) se t @qs = (sel ect top 1 op.stringvalue fr om [Views].[ObjectParameters] as op wh ere op.id = (SELECT TOP(1) ID FR OM (SELECT
[Views].[ObjectParameters].[ID]
FR OM
[Views].[ObjectParameters]
WH ERE
[Views].[ObjectParameters].[ID] = 158667) AS CQ)) ins ert #Temp execute (@qs) SELECT UTParameters_ShiftDate.ParameterValue AS UW_ShiftDate, UTParameters_ShiftNum.ParameterValue AS UW_ShiftNumber, UNIT_WORKERS.ID AS UW_ID, UNIT_WORKERS.Notation AS UW_Notation, UNIT_WORKERS.ExecutorID AS UW_ExecutorID, UNIT_WORKERS.ExecutorNotation AS UW_ExecutorNotation, LTrim(IsNull(UNIT_WORKERS.ExecutorNotation,'') + ' ' +UNIT_WORKERS .ExecutorName) AS UW_ExecutorName, UNIT_WORKERS.StatusID AS UW_StatusID, UNIT_WORKERS.StatusNotation AS UW_StatusNotation, (SELECT LEFT(TaskExecutors.ItemExecutor, LEN(TaskExecutors.ItemExecutor) - 1) FR OM (SELECT (SELECT (EmployeeName + ', ') AS [*] FR OM Views.PlannedLabourResources AS LR INNER JOIN Views.Tasks ON UNIT_WORKERS.ID = LR.ObjectID AND LR.LinkTypeUID = 'LT_Executor' GROUP BY EmployeeName FOR XML PATH ('') ) AS ItemExecutor) AS TaskExecutors) AS UW_Executors, UNIT_PLACE.ID AS PT_ID, UNIT_PLACE.ExecutorID AS PT_ExecutorID, UNIT_PLACE.ExecutorNotation AS PT_ExecutorNotation, LTrim(IsNull(UNIT_PLACE.ExecutorNotation,'') + ' ' + UNIT_PLACE.ExecutorName) AS PT_ExecutorName, RT.TaskID AS UT_TaskID, RT.PlaceTaskStatus AS UT_StatusNotation, CAST(REPLACE(RT.StandardHours,',','.') AS decimal(10,3))AS UT_Hours, RT.ComponentId AS COMPS_ID, RT.NomenclatureId AS COMPS_NomenclatureID, ROW_NUMBER () OVER (ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID ) AS POS_NUMBER, RT.NomenclatureName AS COMPS_NomenclatureName, RT.NomenclatureNotation AS COMPS_NomenclatureNotation, (CASE WHEN ISNULL(Mes.Notation ,'шт') = 'шт' THEN CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),0) AS decimal(10) ) AS NVARCHAR(10)) ELSE CAST (CAST (Round(ISNULL(RT.PlanQuantity,0),3) AS decimal(10,3)) AS NVARCHAR(10)) END) AS COMPS_Quantity, Mes.Notation AS COMPS_MeasureNotation, CAST (Round(COMPSParameters_Massa.FloatValue,3) AS decimal(10,3)) AS COMPS_Massa, RTrim(ISNULL(PR.Notation,'') + ' ' + ISNULL(PR.Name,'')) AS PPART, RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) AS ORDER_NAME, ISNULL(CC.NomenclatureID,'-1') AS ORDER_ID, (CASE WHEN DENSE_RANK() OVER (ORDER BY (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END )) = 1 THEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) ELSE 'Внеплановые' END) AS REPORT_ORDER_NAME, (CASE WHEN RTrim(ISNULL(CC.NomenclatureNotation,'') + ' ' + ISNULL(CC.NomenclatureName,'')) = '' THEN 1 ELSE 0 END ) AS GENERAL_ORDER, RTrim(ISNULL((SELE CT TOP(1) [Comp].[Comment] FR OM [Views].[PlannedSteps] AS [PlannedSteps] LEFT JOIN [Views].[Components] AS [Comp] ON [PlannedSteps].[ComponentID] = [Comp].[ID] WH ERE [PlannedSteps].[TaskID] = RT.[PlaceTaskId]),'') + (CASE WHEN IsNull(rt.comment,'') = '' then '' else ' (' END) + ISNULL(RT.Comment,'') + (CASE WHEN isnull(rt.comment,'') = '' then '' else ')' END) ) AS Task_Comment, RT.OperationNotation, RT.UnitTaskIdAsBarCode as IdAsBarCodeString, RT.UnitWorkersIdAsBarCode AS UnitWorkersIdAsBarCode FR OM #TEMP AS RT LEFT JOIN Views.Tasks AS UNIT_WORKERS ON UNIT_WORKERS.ID = RT.UnitWorkersTaskID LEFT JOIN Views.ObjectTasks AS UNIT_TASK ON RT.TaskId = UNIT_TASK.ID AND UNIT_TASK.LinkTypeUID = 'LT_Unit_Task' LEFT JOIN Views.Tasks AS UNIT_PLACE ON UNIT_PLACE.ID = RT.PlaceTaskId LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftDate ON UNIT_WORKERS.ID = UTParameters_ShiftDate.OwnerID AND UTParameters_ShiftDate.ParameterUID = 'VGB_SHIFT_DATE' LEFT JOIN Views.ObjectParameters AS UTParameters_ShiftNum ON UNIT_WORKERS.ID = UTParameters_ShiftNum.OwnerID AND UTParameters_ShiftNum.ParameterUID = 'VGB_SHIFT_NUMBER' LEFT JOIN Views.ObjectParameters AS COMPSParameters_Massa ON RT.NomenclatureID = COMPSParameters_Massa.OwnerID AND COMPSParameters_Massa.ParameterUID = 'P_Mass_t' LEFT JOIN Views.Components AS COMPS ON RT.ComponentId = COMPS.ID LEFT JOIN Views.ComponentCollections AS CC ON COMPS.OwnerID = CC.ID LEFT JOIN Views.Measures AS Mes ON Mes.ID = RT.MeasureId LEFT JOIN Views.LinkedObjects AS PR ON COMPS.ID = PR.OwnerID AND PR.LinkTypeUID = 'LT_Production_Run' ORDER BY CC.NomenclatureID, RT.NomenclatureNotation,RT.NomenclatureName, RT.TaskID DR OP TABLE #TEMP
Исключение:
System.Exception
Источник:
Csdn.Vogbit.Reporter
Версия 1.1.52161 сборка 2005
Список вызовов:
в Csdn.Vogbit.Reporter.Reporter.GetDataSource_UserQuery(ExpressionItem expr)
в Csdn.Vogbit.Reporter.Reporter.GetDataSource(BlankItem blank)
в Csdn.Vogbit.Reporter.Reporter.ExecuteReport()
в Csdn.Vogbit.Reporter.Reporter.ExecReport(IExtensibleApplication vogbitApplication, String fileName, SqlQuery sqlCurrentQuery, DataTable currentItems)