[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.