It's a Teiid Designer bug occurring in JBoss Developer Studio Integration Stack 8.0.3 A large transformation SQL of a view model is not exported to INDEX file. I have a large transformation SQL 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:- 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 See $WORKSPACE/.metadata/.plugins/org.teiid.designer.core/XXXXXXXXXXXX.INDEX. There is a truncated transformation SQL in it.
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Resolved
Using only JIRA now. Marking as closed
Matej Kralik <mkralik> updated the status of jira TEIIDDES-2414 to Closed
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Reopened
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Closed