Bug 1263723

Summary: Large transformation SQL is truncated in INDEX file.
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Hisanobu Okuda <hokuda>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED NOTABUG QA Contact: Matus Makovy <mmakovy>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-12-07 13:20:30 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Hisanobu Okuda 2015-09-16 14:06:21 UTC
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.

Comment 4 JBoss JIRA Server 2015-11-30 20:10:34 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Resolved

Comment 5 Barry LaFond 2015-12-07 13:20:30 UTC
Using only JIRA now.  Marking as closed

Comment 6 JBoss JIRA Server 2016-02-29 11:35:18 UTC
Matej Kralik <mkralik> updated the status of jira TEIIDDES-2414 to Closed

Comment 7 JBoss JIRA Server 2016-04-14 18:38:55 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Reopened

Comment 8 JBoss JIRA Server 2016-04-14 18:49:10 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2414 to Closed