# Getting "cannot resolve '\`statisticalTestTail\`'" error when processing evidence files for release 23.02

**URL:** https://community.opentargets.org/t/getting-cannot-resolve-statisticaltesttail-error-when-processing-evidence-files-for-release-23-02/972
**Category:** Technical Support
**Tags:** ot-platform
**Created:** [25 February 2023 18:00 UTC](https://community.opentargets.org/t/getting-cannot-resolve-statisticaltesttail-error-when-processing-evidence-files-for-release-23-02/972 "2023-02-25T18:00:28Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![thondeboer](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/thondeboer/32/329_2.png) [@thondeboer](https://community.opentargets.org/u/thondeboer)
#### Post date: [25 February 2023 18:00 UTC](https://community.opentargets.org/t/getting-cannot-resolve-statisticaltesttail-error-when-processing-evidence-files-for-release-23-02/972/1 "2023-02-25T18:00:28Z")

</div>

When trying to process the “evidence” files with the opentargets-etl-backend program, I run into an error I cannot figure out what to do with.

```auto
Exception in thread "main" org.apache.spark.sql.AnalysisException: cannot resolve '`statisticalTestTail`' given input columns: [alleleOrigins, allelicRequirements, ancestry, ancestryId, beta, betaConfidenceIntervalLower, betaConfidenceIntervalUpper, biologicalModelAllelicComposition, biologicalModelGeneticBackground, biologicalModelId, biomarkerName, biomarkers, biosamplesFromSource, clinicalPhase, clinicalSignificances, clinicalStatus, cohortDescription, cohortId, cohortPhenotypes, cohortShortName, confidence, contrast, datasourceId, datatypeId, diseaseCellLines, diseaseFromSource, diseaseFromSourceId, diseaseFromSourceMappedId, diseaseId, diseaseModelAssociatedHumanPhenotypes, diseaseModelAssociatedModelPhenotypes, drugFromSource, drugId, drugResponse, excludedBiotype, literature, log2FoldChangePercentileRank, log2FoldChangeValue, mutatedSamples, oddsRatio, oddsRatioConfidenceIntervalLower, oddsRatioConfidenceIntervalUpper, pValueExponent, pValueMantissa, pathways, pmcIds, projectId, publicationFirstAuthor, publicationYear, reactionId, reactionName, resolvedDisease, resolvedTarget, resourceScore, sex, significantDriverMethods, sourceId, statisticalMethod, statisticalMethodOverview, studyCases, studyCasesWithQualifyingVariants, studyId, studyOverview, studySampleSize, studyStartDate, studyStopReason, studyStopReasonCategories, targetFromSource, targetFromSourceId, targetId, targetInModel, targetInModelEnsemblId, targetInModelMgiId, targetModulation, textMiningSentences, urls, variantAminoacidDescriptions, variantFunctionalConsequenceFromQtlId, variantFunctionalConsequenceId, variantHgvsId, variantId, variantRsId]; line 1 pos 0;
'Project [datasourceId#123, targetId#676, alleleOrigins#101, allelicRequirements#102, ancestry#103, ancestryId#104, beta#105, betaConfidenceIntervalLower#106, betaConfidenceIntervalUpper#107, biologicalModelAllelicComposition#108, biologicalModelGeneticBackground#109, biologicalModelId#110, biomarkerName#111, biomarkers#112, biosamplesFromSource#113, clinicalPhase#114L, clinicalSignificances#115, clinicalStatus#116, cohortDescription#117, cohortId#118, cohortPhenotypes#119, cohortShortName#120, confidence#121, contrast#122, ... 59 more fields]

```

It seems some data-dependent error, but not sure how to check for that or how to fix…This is the 23.02 release data and the most recent JAR I compiled myself (15FEB2023 commit)

---

<div class="post-metadata">

### Author: ![hcornu](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/hcornu/32/716_2.png) [@hcornu](https://community.opentargets.org/u/hcornu)
#### Post date: [3 May 2023 14:08 UTC](https://community.opentargets.org/t/getting-cannot-resolve-statisticaltesttail-error-when-processing-evidence-files-for-release-23-02/972/2 "2023-05-03T14:08:36Z")

</div>

Hi @thondeboer!

Have you managed to resolve this? If not, please could you provide more details so someone on the team can take a look?

Thank you!

---

<div class="post-metadata">

### Author: ![Ricardo\_Martinez](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/ricardo_martinez/32/420_2.png) [@Ricardo\_Martinez](https://community.opentargets.org/u/Ricardo_Martinez)
#### Post date: [10 May 2023 10:38 UTC](https://community.opentargets.org/t/getting-cannot-resolve-statisticaltesttail-error-when-processing-evidence-files-for-release-23-02/972/3 "2023-05-10T10:38:03Z")

</div>

Hi @thondeboer,

This is due to a configuration issue from a missing key called data-sources-exclude for the evidence step. To fix this issue please run the ETL using the file [platform.conf](https://github.com/opentargets/platform-etl-backend/blob/master/configuration/2023/23_02_platform.conf)

Thank you!
