Forum Discussion

jgao's avatar
jgao
Regular Visitor
2 years ago
Solved

Semantic model refresh error

Hi team,   My Semantic model got refreshed hourly by a Azure Databricks workflow. The data source is Databricks as well. The refresh works normally most of the time except a same error happens ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jgao ,

    Please try below steps:

    1. Review Databricks Cluster Logs: Since the error mentions GetCrossReference finished with operation state: INITIALIZED_STATE, it's crucial to review the logs of your Databricks cluster around the time the error occurred.

     

    2. Optimize Databricks Queries: The error could be a result of timeouts or resource constraints. Optimizing your Databricks queries to be more efficient might help. Consider reviewing your queries for any potential optimizations, such as filtering unnecessary data early in the query or using more efficient join types.

     

    3. Adjust Retry Settings and Timeout: If the issue persists, consider adjusting the retry settings and timeout for the refresh operation.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jgao ,

Please try below steps:

1. Review Databricks Cluster Logs: Since the error mentions GetCrossReference finished with operation state: INITIALIZED_STATE, it's crucial to review the logs of your Databricks cluster around the time the error occurred.

 

2. Optimize Databricks Queries: The error could be a result of timeouts or resource constraints. Optimizing your Databricks queries to be more efficient might help. Consider reviewing your queries for any potential optimizations, such as filtering unnecessary data early in the query or using more efficient join types.

 

3. Adjust Retry Settings and Timeout: If the issue persists, consider adjusting the retry settings and timeout for the refresh operation.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.