The Xlsx templates (onedrive, google) Report makes error for Related sheet ForEachRowIntable ! ( It works only with Docs (PDF) templates :-( )

[RadimSochor]

Errors:

Audit Log Details:
Error: “System.InvalidOperationException: Part does not exist.\r\n at OfficeOpenXml.Packaging.ZipPackage.GetPart(Uri partUri)\r\n at OfficeOpenXml.Packaging.ZipPackage.DeletePart(Uri Uri)\r\n at OfficeOpenXml.ExcelWorksheet.Save()\r\n at OfficeOpenXml.ExcelWorkbook.Save()\r\n at OfficeOpenXml.ExcelPackage.Save()\r\n at OfficeOpenXml.ExcelPackage.SaveAs(Stream OutputStream)\r\n at Nirvana.Data.WorkflowTemplate.SaveAsBytes() in d:\a\1\s\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 708\r\n at Nirvana.Data.WorkflowTemplate.Replace(Context context, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 680\r\n at Nirvana.Data.WorkflowActionEmail.GetAttachment(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 228\r\n at Nirvana.Data.WorkflowActionEmail.Create(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, ActionDefinition actionDefinition, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 49\r\n at Nirvana.Data.WorkflowRuleEvaluator.CreateActionResults(Context context, WorkflowActionBase workflowAction, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 168\r\n at Nirvana.Data.WorkflowRuleEvaluator.PerformActions(Context context, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 367\r\n at Nirvana.Data.WorkflowRuleEvaluator.ProcessRule(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 504”

Audit Log Details
Error:
“System.InvalidOperationException: Part already exist\r\n at OfficeOpenXml.Packaging.ZipPackage.CreatePart(Uri partUri, String contentType, CompressionLevel compressionLevel)\r\n at OfficeOpenXml.ExcelWorkbook.Save()\r\n at OfficeOpenXml.ExcelPackage.Save()\r\n at OfficeOpenXml.ExcelPackage.SaveAs(Stream OutputStream)\r\n at Nirvana.Data.WorkflowTemplate.SaveAsBytes() in d:\a\1\s\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 708\r\n at Nirvana.Data.WorkflowTemplate.Replace(Context context, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 680\r\n at Nirvana.Data.WorkflowActionEmail.GetAttachment(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 228\r\n at Nirvana.Data.WorkflowActionEmail.Create(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, ActionDefinition actionDefinition, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 49\r\n at Nirvana.Data.WorkflowRuleEvaluator.CreateActionResults(Context context, WorkflowActionBase workflowAction, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 168\r\n at Nirvana.Data.WorkflowRuleEvaluator.PerformActions(Context context, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 367\r\n at Nirvana.Data.WorkflowRuleEvaluator.ProcessRule(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 504”
Properties:
{
“AppId”: “1eac74c9-36c2-421b-8a9e-571e153f9f76”,
“AppTemplateVersion”: “5.700521”,
“RuleName”: “New Report 3”,
“EventType”: “Scheduled”,
“InvokedBy”: “EditorRunButton”,
“Server”: “produ3c1a0000F2”,
“IgnoreSecurityFilters”: false,
“EventMatch”: “Workflow event successfully matched”,
“ForTableNameRows”: “Table or slice ‘DZ jen Aktivní k hromadným reportům’ returned 2 rows”,
“AppTemplateName”: “OptiSmCareGama-557628”,
“Operation”: “Scheduled report rule”,
“Performance”: “{“Version”:1,“Time”:“00:00:14.8318855”,“PerformanceTimingRoot”:{“Mid”:123,“Params”:{“ParamList”:[{“Pid”:15,“Value”:“New Report 3”}]},“Timer”:{“Time”:“00:00:14.8318855”},“Children”:[{“Mid”:341,“Params”:{“ParamList”:[{“Pid”:15,“Value”:“New Report 3”}]},“Timer”:{“Time”:“00:00:14.8317877”},“Children”:[{“Mid”:360,“Params”:{“ParamList”:[{“Pid”:19,“Value”:“dz”}]},“Timer”:{“Time”:“00:00:14.8317575”},“Children”:[{“Mid”:343,“Params”:{“ParamList”:[{“Pid”:19,“Value”:“dz”}]},“Timer”:{“Time”:“00:00:14.8317292”},“Children”:[{“Mid”:283,“Timer”:{“Time”:“00:00:09.8705549”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:01.8567428”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Databáze Klienti”}]},“Timer”:{“Time”:“00:00:01.8567148”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:00.7269640”},“Children”:[{“Mid”:30,“Timer”:{“Time”:“00:00:00.1450163”}},{“Mid”:25,“Timer”:{“Time”:“00:00:00.1437665”}},{“Mid”:30,“Timer”:{“Time”:“00:00:00.1456747”}},{“Mid”:29,“Timer”:{“Time”:“00:00:00.1481829”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.1440821”}}]},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“147”}]},“Timer”:{“Time”:“00:00:01.1286023”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:01.1200387”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.3955708”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.3954906”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.7242706”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.7153461”}},{“Mid”:239,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“147”},{“Pid”:3,“Value”:“176”}]},“Timer”:{“Time”:“00:00:00.0088369”}}]}]},{“Mid”:15,“Timer”:{“Time”:“00:00:00.0084768”}}]}]}]},{“Mid”:216,“Timer”:{“Time”:“00:00:08.0092634”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:08.0091154”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related CVPPs”}]},“Timer”:{“Time”:“00:00:05.6908265”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related CVPPs”}]},“Timer”:{“Time”:“00:00:05.6907744”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:05.6907028”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related CVPPs”}]},“Timer”:{“Time”:“00:00:05.6906705”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:05.3261087”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“CVPP”}]},“Timer”:{“Time”:“00:00:05.3260773”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“18606”}]},“Timer”:{“Time”:“00:00:05.3253729”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:05.1685424”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.9018728”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.9017335”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:04.2631483”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:02.9560325”}},{“Mid”:239,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“18742”},{“Pid”:3,“Value”:“66”}]},“Timer”:{“Time”:“00:00:01.3057546”}}]}]},{“Mid”:15,“Timer”:{“Time”:“00:00:00.1565965”}}]}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Informace ke shromážděnís”}]},“Timer”:{“Time”:“00:00:00.8362729”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Informace ke shromážděnís”}]},“Timer”:{“Time”:“00:00:00.8361836”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.8360923”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Informace ke shromážděnís”}]},“Timer”:{“Time”:“00:00:00.8360626”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.8326479”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Informace ke shromáždění”}]},“Timer”:{“Time”:“00:00:00.8326216”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“137”}]},“Timer”:{“Time”:“00:00:00.8323536”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:00.8308587”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.5001303”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.5000521”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.3305904”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.3293971”}}]}]}]}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Klienti Detailys”}]},“Timer”:{“Time”:“00:00:00.8005453”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Klienti Detailys”}]},“Timer”:{“Time”:“00:00:00.8004598”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.8003762”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Klienti Detailys”}]},“Timer”:{“Time”:“00:00:00.8003444”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.7972845”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Klienti Detaily”}]},“Timer”:{“Time”:“00:00:00.7972581”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“44”}]},“Timer”:{“Time”:“00:00:00.7970594”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:00.7963275”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.4003553”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.4002817”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.3958015”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.3955278”}}]}]}]}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Přístupys”}]},“Timer”:{“Time”:“00:00:00.6813408”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Přístupys”}]},“Timer”:{“Time”:“00:00:00.6812574”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.6811031”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Přístupys”}]},“Timer”:{“Time”:“00:00:00.6810709”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.6785288”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Přístupy”}]},“Timer”:{“Time”:“00:00:00.6785012”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“67”}]},“Timer”:{“Time”:“00:00:00.6778338”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:00.5848659”},“Children”:[{“Mid”:95,“Timer”:{“Time”:“00:00:00.3777740”},“Children”:[{“Mid”:94,“Timer”:{“Time”:“00:00:00.3776900”}}]},{“Mid”:238,“Timer”:{“Time”:“00:00:00.2069315”},“Children”:[{“Mid”:240,“Timer”:{“Time”:“00:00:00.2053624”}}]}]},{“Mid”:15,“Timer”:{“Time”:“00:00:00.0928858”}}]}]}]}]}]}]}]}]}]}]},{“Mid”:157,“Timer”:{“Time”:“00:00:04.9479206”},“Children”:[{“Mid”:158,“Timer”:{“Time”:“00:00:04.9423175”},“Children”:[{“Mid”:189,“Timer”:{“Time”:“00:00:04.4568181”},“Children”:[{“Mid”:29,“Timer”:{“Time”:“00:00:00.6970332”}},{“Mid”:337,“Timer”:{“Time”:“00:00:02.8897753”},“Children”:[{“Mid”:31,“Timer”:{“Time”:“00:00:02.8897486”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:01.8861683”},“Children”:[{“Mid”:30,“Timer”:{“Time”:“00:00:00.1455665”}},{“Mid”:25,“Timer”:{“Time”:“00:00:00.1436911”}},{“Mid”:30,“Timer”:{“Time”:“00:00:00.1436970”}},{“Mid”:29,“Timer”:{“Time”:“00:00:01.3013488”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.1516352”}}]}]}]},{“Mid”:323,“Timer”:{“Time”:“00:00:00.8698801”},“Children”:[{“Mid”:366,“Timer”:{“Time”:“00:00:00.8698511”},“Children”:[{“Mid”:31,“Timer”:{“Time”:“00:00:00.8698035”},“Children”:}]}]}]},{“Mid”:190,“Timer”:{“Time”:“00:00:00.4850080”},“Children”:[{“Mid”:368,“Timer”:{“Time”:“00:00:00.4779800”},“Children”:[{“Mid”:368,“Timer”:{“Time”:“00:00:00.4774900”},“Children”:[{“Mid”:216,“Timer”:{“Time”:“00:00:00.4486131”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:00.4485097”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Popis sloučený”}]},“Timer”:{“Time”:“00:00:00.1688368”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Popis sloučený”}]},“Timer”:{“Time”:“00:00:00.1688012”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.1687370”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Popis sloučený”}]},“Timer”:{“Time”:“00:00:00.1686990”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Databáze Klientis”}]},“Timer”:{“Time”:“00:00:00.2796142”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Databáze Klientis”}]},“Timer”:{“Time”:“00:00:00.2795625”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.2794819”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Databáze Klientis”}]},“Timer”:{“Time”:“00:00:00.2794471”}}]}]}]}]}]}]}]}]}]}]},{“Mid”:157,“Timer”:{“Time”:“00:00:00.0131772”},“Children”:[{“Mid”:158,“Timer”:{“Time”:“00:00:00.0131396”},“Children”:[{“Mid”:190,“Timer”:{“Time”:“00:00:00.0127188”},“Children”:[{“Mid”:368,“Timer”:{“Time”:“00:00:00.0121082”},“Children”:[{“Mid”:368,“Timer”:{“Time”:“00:00:00.0117633”},“Children”:}]}]}]}]}]}]}]}]},“IsEmpty”:false}”,
“Result”: “Failure”
}

[Steve]

Please contact support@appsheet.com directly for help with this.