[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2414:
--------------------------------------
Assignee: Paul Richardson
> 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
> Affects Versions: 8.3.4
> Reporter: Hisanobu Okuda
> Assignee: Paul Richardson
> Fix For: 9.0.5, 9.3
>
> Attachments: 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}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2414:
-----------------------------------
Fix Version/s: 9.0.5
9.3
> 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
> Affects Versions: 8.3.4
> Reporter: Hisanobu Okuda
> Assignee: Paul Richardson
> Fix For: 9.0.5, 9.3
>
> Attachments: 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}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2663) Document Optimal JDBC Parameters for SAP HANA Import
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2663?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2663:
--------------------------------
Description:
In order to import SAP HANA metadata, there are a couple of parameter values that help decrease the import time.
For example:
schemaPattern={targetSchema}
tableTypes=TABLE
was:
In order to import SAP HANA metadata, there are a couple of parameter values that help decrease the import time.
For example:
schemaPattern={targetSchema}
tableTypes=
> Document Optimal JDBC Parameters for SAP HANA Import
> ----------------------------------------------------
>
> Key: TEIIDDES-2663
> URL: https://issues.jboss.org/browse/TEIIDDES-2663
> Project: Teiid Designer
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.0.4
> Reporter: Ted Jones
> Assignee: David Le Sage
> Fix For: 9.0.5
>
>
> In order to import SAP HANA metadata, there are a couple of parameter values that help decrease the import time.
> For example:
> schemaPattern={targetSchema}
> tableTypes=TABLE
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2663) Document Optimal JDBC Parameters for SAP HANA Import
by Ted Jones (JIRA)
Ted Jones created TEIIDDES-2663:
-----------------------------------
Summary: Document Optimal JDBC Parameters for SAP HANA Import
Key: TEIIDDES-2663
URL: https://issues.jboss.org/browse/TEIIDDES-2663
Project: Teiid Designer
Issue Type: Task
Components: Documentation
Affects Versions: 9.0.4
Reporter: Ted Jones
Assignee: David Le Sage
Fix For: 9.0.5
In order to import SAP HANA metadata, there are a couple of parameter values that help decrease the import time.
For example:
schemaPattern={targetSchema}
tableTypes=
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2495) Allow "No Timeout" Value for the Teiid Connection Importer
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2495?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2495:
-----------------------------------
Labels: release_notes verified_jbdsis-8.0.4.CR1 (was: )
> Allow "No Timeout" Value for the Teiid Connection Importer
> ----------------------------------------------------------
>
> Key: TEIIDDES-2495
> URL: https://issues.jboss.org/browse/TEIIDDES-2495
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Affects Versions: 9.0.1
> Reporter: Ted Jones
> Assignee: Mark Drilling
> Labels: release_notes, verified_jbdsis-8.0.4.CR1
> Fix For: 9.0.4, 9.2
>
>
> Allow a "No Timeout" value in the Teiid Connection importer (something like 0 or -1) that will allow the import to continue until finished or canceled. The current override value only goes to 999 which may not be long enough for some sources.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ]
Matus Makovy reopened TEIIDDES-2469:
------------------------------------
This does not seem to be included in 9.0.x branch. I don't see the changes in TD 9.0.4. Reopening to change fix version.
> [Usability] Problem importing SOAP web service via URL
> ------------------------------------------------------
>
> Key: TEIIDDES-2469
> URL: https://issues.jboss.org/browse/TEIIDDES-2469
> Project: Teiid Designer
> Issue Type: Quality Risk
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 9.0.4, 9.2
>
> Attachments: define-rest-procedure-tags-dialog.png
>
>
> Conversation:
> [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url
> [09:45] <jmarley> we are getting hung up on creating relational model
> [09:45] <jmarley> vhalbert: nevermind,
> [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with
> [09:47] <vhalbert> jmarley, hm
> [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected
> [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2607) delete object fails.
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2607?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2607.
----------------------------------
I am not able to reproduce this either. Closing this issue.
> delete object fails.
> --------------------
>
> Key: TEIIDDES-2607
> URL: https://issues.jboss.org/browse/TEIIDDES-2607
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Windows 7 Pro
> JBDS:
> Version: 8.1.0.GA
> Build id: GA-v20150327-1349-B467
> Build date: 20150327-1349
> Teiid Designer 9.0.2.Final-v20150615-1425-B1128 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> Reporter: Tom Johnston
> Assignee: Mark Drilling
> Fix For: 9.0.4
>
>
> I created a physical procedure (for native query)
> It created a result set with one column with type object.
> I tried to delete the column it showed me a "Progress Information" window with a very little of "Green" on the progress bar.
> After about a minute the Progress windows disappears and nothing happened.
> I looked on the "Error log" tab and there was an empty message bu the timestamp was inline.
> Error log shows:
> java.lang.reflect.InvocationTargetException
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:423)
> at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:527)
> at org.teiid.designer.ui.actions.workers.DeleteWorker.executeCommand(DeleteWorker.java:211)
> at org.teiid.designer.ui.actions.workers.DeleteWorker.execute(DeleteWorker.java:131)
> at org.teiid.designer.ui.actions.ModelObjectAction.doRun(ModelObjectAction.java:62)
> at org.teiid.designer.ui.actions.DeleteEObjectAction.doRun(DeleteEObjectAction.java:88)
> at org.teiid.designer.ui.common.actions.AbstractAction$1.run(AbstractAction.java:544)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)
> at org.teiid.designer.ui.common.actions.AbstractAction.run(AbstractAction.java:547)
> at org.teiid.designer.ui.actions.DeleteAction.doRun(DeleteAction.java:335)
> at org.teiid.designer.ui.common.actions.AbstractAction$1.run(AbstractAction.java:544)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)
> at org.teiid.designer.ui.common.actions.AbstractAction.run(AbstractAction.java:547)
> at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.handleKeyPressed(ModelExplorerResourceNavigator.java:1731)
> at org.eclipse.ui.views.navigator.ResourceNavigator$7.keyPressed(ResourceNavigator.java:507)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:167)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1085)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1070)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1112)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1108)
> at org.eclipse.swt.widgets.Widget.wmKeyDown(Widget.java:1831)
> at org.eclipse.swt.widgets.Control.WM_KEYDOWN(Control.java:4975)
> at org.eclipse.swt.widgets.Tree.WM_KEYDOWN(Tree.java:6156)
> at org.eclipse.swt.widgets.Control.windowProc(Control.java:4642)
> at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6024)
> at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
> at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
> at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
> Caused by: java.lang.StackOverflowError
> at org.teiid.designer.core.workspace.ModelFileUtil.getXmiHeader(ModelFileUtil.java:216)
> at org.teiid.designer.core.workspace.ModelFileUtil.isModelFile(ModelFileUtil.java:86)
> at org.teiid.designer.core.workspace.ModelUtil.isModelFile(ModelUtil.java:769)
> at org.teiid.designer.core.workspace.ModelResourceFilter.accept(ModelResourceFilter.java:25)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil$FileResourceCollectorVisitor.visit(WorkspaceResourceFinderUtil.java:1188)
> at org.eclipse.core.internal.resources.Resource$2.visit(Resource.java:126)
> at org.eclipse.core.internal.resources.Resource$1.visitElement(Resource.java:85)
> at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:82)
> at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
> at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
> at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:127)
> at org.eclipse.core.internal.resources.Resource.accept(Resource.java:95)
> at org.eclipse.core.internal.resources.Resource.accept(Resource.java:52)
> at org.eclipse.core.internal.resources.Resource.accept(Resource.java:124)
> at org.eclipse.core.internal.resources.Resource.accept(Resource.java:108)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getProjectFileResources(WorkspaceResourceFinderUtil.java:408)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:720)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
> at org.teiid.designer.core.workspace.WorkspaceResourceFinderUtil.getResourcesThatUse(WorkspaceResourceFinderUtil.java:747)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months