[SQL Processing] Datamodel not found on Unified SQL Processing
Description
CAPL - Bug default text according to the team DoR (Definition of Ready)
01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):
@Geny Isam Hamud Herrera
02 - PROBLEM (WHAT'S THE ISSUE?):
During some of the SQL Processing jobs we are getting errors saying that the Entity Template was not found.
03 - STEPS TO REPRODUCE (STEP (1...N), VIDEO, SCREENSHOTS, LOGS FOLDER, HEARTBEAT, ETC. – IF IS NOT POSSIBLE TO REPRODUCE EXPLAIN THE REASON):
04 - LINKS (ADD A LINK TO THE BUG OR TO THE TENANT):
https://cloudlogging.app.goo.gl/KyEUc2cWiGohii389
05 - EXPECTED BEHAVIOR (LIST THE EXPECTED BEHAVIORS TO CONSIDER THIS BUG AS DONE):
- Validate if this is invalidating the fanOut process also;
- Avoid the exception
- Log on the task that there’s a problem on fanOut for tenant XYZ because the entity template does not exists
- REFINEMENT: Possible cenario for Customer that delete the Datamodel on the Customer Tenant
- REFINEMENT: Log as a WARNING on the SQL Processing task that we are excluding this Customer Tenant from the Fanout process because the Datamodel was not found.