Currently Teiid does not provide any way define the timeout for materialization load. I believe it could be a good enhancement to make. As per reloading after failed attempt should follow.
We're still investigating why the materialized view gets stuck in loading state. It seems that the either the translator or data source times out under some conditions and the translator throws an exception. Under our application's production configuration, that exception is transformed by a delegating translator into a result set warning and under the app's debug configuration, the exception is passed along to Teiid. Under both configurations, it the materialized view remains in loading state. Any suggestions where we might begin looking? We haven't had a chance yet to put together a test case to examine Teiid's behavior under these conditions.
Typically when an exception occurs during the load its gets moved to LOAD FAILED state. May be the translator delegation interrupting this process?
Thanks. I wouldn't have thought to include delegation in the test case. We'll give that a shot.