# All API components failed on daily run and was fine the next day

**URL:** <https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369>\
**Category:** Matillion ETL\
**Created:** [June 14, 2021, 6:45am UTC](https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369 "2021-06-14T06:45:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nils](https://avatars.discourse-cdn.com/v4/letter/n/d6d6ee/32.png) [@Nils](https://matillioncommunity.discourse.group/u/Nils)\
**Post date:** [June 14, 2021, 6:45am UTC](https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369/1 "2021-06-14T06:45:41Z")

</div>

We had an strange issue on Saturday.

All the API components failed with the error:

(Same error for different APIs on different schedules)

&nbsp;

Parameter Validation Failure:

Data Source - Could not retrieve a data source.

Data Selection - A valid data source is required.

&nbsp;

The next run on Sunday was fine again.

No changes before or after.

&nbsp;

Looking at the catalina logs I found this messages:

&nbsp;

com.matillion.bi.emerald.component.implementation.orchestration.PropertiesLoader.runSchemasLookup Error running schema lookup

&nbsp;

com.matillion.bi.emerald.shared.component.implementation.ComponentParamImplementation.checkParameterStates Parameter did not validate successfully. Slot: 6. Name: Data Source. Message: Could not retrieve a data source.. State: INPUT\_INVALID

&nbsp;

&nbsp;com.matillion.bi.emerald.server.model.util.jdbc.JDBCQueryHelper.getQueryMetadataBasic Retrieving basic mode column metadata for table&nbsp;

&nbsp;

com.matillion.bi.emerald.component.implementation.orchestration.PropertiesLoader.getAvailableQueryColumnNames Could not determine result columns for query

&nbsp;

&nbsp;

We are on version 1.53.9 on Snowflake.

&nbsp;

Had anyone an similar failure in the past?

This is the first issue we encountered and some of them are running for over a year now..

Even one job that did 4 retries failed.

&nbsp;

---

<div class="post-metadata">

**Author:** ![Nils](https://avatars.discourse-cdn.com/v4/letter/n/d6d6ee/32.png) [@Nils](https://matillioncommunity.discourse.group/u/Nils)\
**Post date:** [June 18, 2021, 6:26am UTC](https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369/2 "2021-06-18T06:26:02Z")

</div>

I just want to give an update.

This issue appeared again today.

So this time I was able to check it myself. I could fix this issue by restarting the server.

I opened a ticket now.

I attached a screenshot how it looks like in the ui.

The profile can be selected but the data source selection is not working.

I will keep you updated if we find the root cause of this issue.

&nbsp;

---

<div class="post-metadata">

**Author:** ![SB699925](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/sb699925/32/1180_2.png) [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)\
**Post date:** [February 22, 2023, 12:41am UTC](https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369/3 "2023-02-22T00:41:21Z")

</div>

Hey there - we just experienced the same issue last night.

Our Matillion server "wakes up" each night (running on AWS EC2 instance) to run some updates and last night all our jobs scheduled at 2:30 am failed with the same error message.

It was in various jobs and data sources, no consistency.

I'm suspecting there was an internal issue with Matillion to cause this.

We are on Version: 1.61.6 (build a392342-2471)

[@MatillionProductTeam](https://matillioncommunity.discourse.group/u/MatillionProductTeam)​ Any thoughts on this? I can provide logs if necessary...

---

<div class="post-metadata">

**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\
**Post date:** [June 21, 2021, 7:55am UTC](https://matillioncommunity.discourse.group/t/all-api-components-failed-on-daily-run-and-was-fine-the-next-day/1369/4 "2021-06-21T07:55:29Z")

</div>

Thanks for keeping the community updated on this and please do let us know what the support team advises and in the meantime if you need anything else, please do not hesitate to ask.

&nbsp;

Kind regards, Joe