]
Steven Hawkins commented on TEIIDDES-2414:
------------------------------------------
Just wanted to check what was the resolution here - are there any actions we need to take
on the Teiid side?
Large transformation SQL is not exported to INDEX file.
-------------------------------------------------------
Key: TEIIDDES-2414
URL:
https://issues.jboss.org/browse/TEIIDDES-2414
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export, Patch Release
Affects Versions: 8.3.4
Reporter: Hisanobu Okuda
Assignee: Paul Richardson
Fix For: 9.2.1
Attachments: reosurce-problem-marker.png, test.csv
A large transformation SQL of a view model is not exported to INDEX file.
I have a large transformation SQL > 8192 bytes in my view model. TDesigner fails to
convert the xmi to XXXXXXXXXX.INDEX file. There is no transformation SQL in the INDEX
file, therefore, deploying my vdb fails and the vdb is inactivated. When you deploy the
vdb, you can see the following message in a log file:-
{code}
17:16:11,632 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31079 View
ViewModel.new_table is not defined by a query expression.
17:16:11,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata
for the VDB test.1 is loaded, however it is not valid. Check models for errors. Correct
the metadata and re-deploy.
17:16:11,637 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB test.1 is
set to FAILED
{code}