Can't export data

Hello,

I’m getting an error while trying to export data. I’m using latest server version 22.02.6 (build 32441) and i also tried running Procedure M1 and deleted the temporary export schemas. This did not solve the issue. I can see the uploaded surveys in the “interviews” tab, but i can’t export those surveys.

The export log output is below:
2022-05-02 16:53:37.449 +00:00 [ERR] Error during job run [ {“ExportSettings”:{“JobId”:null,“ExportFormat”:2,“QuestionnaireId”:{“Id”:“60925bc9ae654174afb4e819ae80593b$22”},“Status”:null,“FromDate”:null,“ToDate”:null,“Tenant”:{“BaseUrl”:“http://3.0.229.196/fansep",“Id”:{“Id”:“84848b3a-0562-4d4d-9e1e-1a9ad8a2270d”},“Name”:“hq_fansep”,“ShortName”:“hq”,“Workspace”:“fansep”},“Translation”:null,“IncludeMeta”:true,“NaturalId”:"84848b3a-0562-4d4d-9e1e-1a9ad8a2270d$All$STATA$60925bc9ae654174afb4e819ae80593b$22$EMPTY FROM DATE$EMPTY TO DATE$No translation”},“Status”:{“CreatedDate”:“0001-01-01T00:00:00”,“BeginDate”:null,“EndDate”:null,“LastUpdateDate”:“0001-01-01T00:00:00”,“Status”:2,“JobStatus”:0,“ProgressInPercents”:0,“IsRunning”:false,“TimeEstimation”:null,“Error”:null},“ArchivePassword”:null,“NaturalId”:“NoExternal$84848b3a-0562-4d4d-9e1e-1a9ad8a2270d$All$STATA$60925bc9ae654174afb4e819ae80593b$22$EMPTY FROM DATE$EMPTY TO DATE$No translation”,“AccessToken”:null,“RefreshToken”:null,“StorageType”:null,“ProcessId”:0,“ShouldDropTenantSchema”:false} ]
System.AggregateException: One or more errors occurred. (Something wrong with export logic, answer’s count is less then required by template. Was ‘3’, expected ‘0’)
—> System.InvalidOperationException: Something wrong with export logic, answer’s count is less then required by template. Was ‘3’, expected ‘0’
at WB.Services.Export.CsvExport.Exporters.ExportQuestionService.GetExportedQuestion(InterviewEntity question, ExportedQuestionHeaderItem header)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.GetExportValues(InterviewLevel interviewLevel, HeaderStructureForLevel headerStructureForLevel)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.BuildRecordsForHeader(InterviewData interview, HeaderStructureForLevel headerStructureForLevel, QuestionnaireDocument questionnaire)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.CreateInterviewDataExportView(QuestionnaireExportStructure exportStructure, InterviewData interview, QuestionnaireDocument questionnaire)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.ExportSingleInterview(InterviewToExport interviewToExport, List1 interview, QuestionnaireExportStructure exportStructure, QuestionnaireDocument questionnaire, String basePath) at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.<>c__DisplayClass11_1.<ExportInterviewsAsync>b__2(InterviewToExport interviewToExport) at System.Threading.Tasks.Parallel.<>c__DisplayClass33_02.b__0(Int32 i)
at System.Threading.Tasks.Parallel.<>c__DisplayClass19_01.<ForWorker>b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion) --- End of stack trace from previous location --- at System.Threading.Tasks.Parallel.<>c__DisplayClass19_01.b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion)
at System.Threading.Tasks.TaskReplicator.Replica1.ExecuteAction(Boolean& yieldedBeforeCompletion) at System.Threading.Tasks.TaskReplicator.Replica.Execute() --- End of inner exception stack trace --- at System.Threading.Tasks.TaskReplicator.Run[TState](ReplicatableUserAction1 action, ParallelOptions options, Boolean stopOnFirstFailure)
at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally) --- End of stack trace from previous location --- at System.Threading.Tasks.Parallel.ThrowSingleCancellationExceptionOrOtherException(ICollection exceptions, CancellationToken cancelToken, Exception otherException) at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally)
at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IList1 list, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Action3 bodyWithStateAndIndex, Func4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func1 localInit, Action1 localFinally)
at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable1 source, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Action3 bodyWithStateAndIndex, Func4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func1 localInit, Action1 localFinally)
at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable1 source, Action1 body)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.ExportInterviewsAsync(TenantInfo tenant, List1 interviewIdsToExport, String basePath, QuestionnaireExportStructure questionnaireExportStructure, QuestionnaireDocument questionnaire, ExportProgress progress, CancellationToken cancellationToken) at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.DoExportAsync(TenantInfo tenant, QuestionnaireExportStructure questionnaireExportStructure, QuestionnaireDocument questionnaire, String basePath, List1 interviewIdsToExport, ExportProgress progress, CancellationToken cancellationToken)
at WB.Services.Export.CsvExport.Exporters.InterviewsExporter.ExportAsync(TenantInfo tenant, QuestionnaireExportStructure questionnaireExportStructure, QuestionnaireDocument questionnaire, List`1 interviewsToExport, String basePath, ExportProgress progress, CancellationToken cancellationToken)
at WB.Services.Export.CsvExport.Implementation.TabularFormatExportService.ExportInterviewsInTabularFormatAsync(ExportSettings settings, String tempPath, ExportProgress progress, CancellationToken cancellationToken)
at WB.Services.Export.ExportProcessHandlers.Implementation.Handlers.TabBasedFormatExportHandler.CreateTabularDataFilesAsync(ExportState state, CancellationToken cancellationToken)
at WB.Services.Export.ExportProcessHandlers.Implementation.Handlers.StataFormatExportHandler.ExportDataAsync(ExportState state, CancellationToken cancellationToken)
at WB.Services.Export.ExportProcessHandlers.Implementation.ExportProcessHandler.ExportDataAsync(DataExportProcessArgs process, CancellationToken cancellationToken)
at WB.Services.Export.Jobs.ExportJob.ExecuteAsync(DataExportProcessArgs pendingExportProcess, CancellationToken cancellationToken)
at WB.Services.Scheduler.Services.Implementation.JobExecutor.ExecuteAsync(JobItem job, CancellationToken token)
at WB.Services.Scheduler.Services.Implementation.JobExecutor.ExecuteAsync(JobItem job, CancellationToken token)

It looks like there is an issue with your data.
There are a lot of versions of questionnaire and probably one of the assignments migrations went wrong.
We need more information to understand the cause of the problem.

@odbayar Thank you for your report. This is an issue in the application.
A new version will be released very soon to address this issue.

Version 22.02.7 has been released to address this issue.

@vitalii

Thank you for the great and fast support. The issue is now fixed with version 22.02.7.

image

Hi vitalii
i get the same problem when trying to export data. i’m using version 22.02.7.
what can i do?

@botidavid , you can attach the log file like odbayar did in the above to allow to give possible recommendations.

Best, Sergiy