[JBoss JIRA] (TEIIDDES-1945) Creating a VDB with XML document model results in error
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1945?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1945:
----------------------------------------
The Project set contains Employees.xsd and Employees.xmi models.
The vdb.xml model elements strip off the file extension, so it tries to create 2 models with identical *Employees" names and it fails.
> Creating a VDB with XML document model results in error
> -------------------------------------------------------
>
> Key: TEIIDDES-1945
> URL: https://issues.jboss.org/browse/TEIIDDES-1945
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3
> Reporter: Ramesh Reddy
> Attachments: RecursiveXMLTest.tar.gz
>
>
> Followed the E2eRecursiveXmlTextSourceTestScript_Teiid7.odt test and created various models. When it came to creating the VDB on step 5.23 the vdb creation failed with below exception.
> There is no way to further proceed with the test without a VDB. I will also attach the MPS.
> {code}
> java.lang.RuntimeException: javax.xml.bind.MarshalException
> - with linked exception:
> [org.xml.sax.SAXParseException: Duplicate unique value [Employees] declared for identity constraint of element "vdb".]
> at org.teiid.core.designer.CoreModelerPlugin.toRuntimeException(CoreModelerPlugin.java:76)
> at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:50)
> at org.teiid.designer.vdb.Vdb.save(Vdb.java:919)
> at org.teiid.designer.vdb.ui.editor.VdbEditor.doSave(VdbEditor.java:1768)
> at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:150)
> at org.eclipse.ui.internal.SaveableHelper$5.run(SaveableHelper.java:276)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.ui.internal.WorkbenchWindow$13.run(WorkbenchWindow.java:1818)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:1815)
> at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:284)
> at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:263)
> at org.eclipse.ui.internal.SaveableHelper.savePart(SaveableHelper.java:155)
> at org.eclipse.ui.internal.WorkbenchPage.saveSaveable(WorkbenchPage.java:3769)
> at org.eclipse.ui.internal.WorkbenchPage.saveEditor(WorkbenchPage.java:3782)
> at org.eclipse.ui.internal.handlers.SaveHandler.execute(SaveHandler.java:53)
> at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
> at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
> at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
> at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
> at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
> at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
> at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
> at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)
> at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1392)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3742)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3363)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
> Caused by: javax.xml.bind.MarshalException
> - with linked exception:
> [org.xml.sax.SAXParseException: Duplicate unique value [Employees] declared for identity constraint of element "vdb".]
> at com.sun.xml.internal.bind.v2.runtime.MarshallerImpl.write(MarshallerImpl.java:317)
> at com.sun.xml.internal.bind.v2.runtime.MarshallerImpl.marshal(MarshallerImpl.java:243)
> at javax.xml.bind.helpers.AbstractMarshallerImpl.marshal(AbstractMarshallerImpl.java:75)
> at org.teiid.designer.vdb.Vdb$4.tryToDo(Vdb.java:948)
> at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:40)
> ... 60 more
> Caused by: org.xml.sax.SAXParseException: Duplicate unique value [Employees] declared for identity constraint of element "vdb".
> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131)
> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384)
> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:423)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3188)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$UniqueValueStore.checkDuplicateValues(XMLSchemaValidator.java:3823)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$ValueStoreBase.addValue(XMLSchemaValidator.java:3549)
> at com.sun.org.apache.xerces.internal.impl.xs.identity.Field$Matcher.matched(Field.java:178)
> at com.sun.org.apache.xerces.internal.impl.xs.identity.XPathMatcher.startElement(XPathMatcher.java:331)
> at com.sun.org.apache.xerces.internal.impl.xs.identity.Selector$Matcher.startElement(Selector.java:225)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2083)
> at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(XMLSchemaValidator.java:711)
> at com.sun.org.apache.xerces.internal.jaxp.validation.ValidatorHandlerImpl.startElement(ValidatorHandlerImpl.java:551)
> at org.xml.sax.helpers.XMLFilterImpl.startElement(XMLFilterImpl.java:527)
> at com.sun.xml.internal.bind.v2.runtime.output.SAXOutput.endStartTag(SAXOutput.java:113)
> at com.sun.xml.internal.bind.v2.runtime.output.ForkXmlOutput.endStartTag(ForkXmlOutput.java:91)
> at com.sun.xml.internal.bind.v2.runtime.XMLSerializer.endAttributes(XMLSerializer.java:274)
> at com.sun.xml.internal.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:663)
> at com.sun.xml.internal.bind.v2.runtime.property.ArrayElementNodeProperty.serializeItem(ArrayElementNodeProperty.java:54)
> at com.sun.xml.internal.bind.v2.runtime.property.ArrayElementProperty.serializeListBody(ArrayElementProperty.java:157)
> at com.sun.xml.internal.bind.v2.runtime.property.ArrayERProperty.serializeBody(ArrayERProperty.java:141)
> at com.sun.xml.internal.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:306)
> at com.sun.xml.internal.bind.v2.runtime.XMLSerializer.childAsSoleContent(XMLSerializer.java:561)
> at com.sun.xml.internal.bind.v2.runtime.ClassBeanInfoImpl.serializeRoot(ClassBeanInfoImpl.java:290)
> at com.sun.xml.internal.bind.v2.runtime.XMLSerializer.childAsRoot(XMLSerializer.java:462)
> at com.sun.xml.internal.bind.v2.runtime.MarshallerImpl.write(MarshallerImpl.java:314)
> ... 64 more
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1954) Syntactic error in INSERT SQL of relational view table which supports update
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1954?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1954:
------------------------------------------
Is that sql something that designer is generating or part of a test script? If it's the latter, then the script just needs updated as it looks like it was never fully converted over from the older mmx style update procedures.
> Syntactic error in INSERT SQL of relational view table which supports update
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-1954
> URL: https://issues.jboss.org/browse/TEIIDDES-1954
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: teiid designer 8.3.0.beta3, JBDS 7.1.0CR1, JBTools 4.1.3.Beta5, DV6 ER4
> Reporter: Lucie Fabrikova
> Attachments: TwoSources.zip
>
>
> I have relational view model with table "UpdateParts", which has Supports Update option checked. The INSERT sql:
> FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO PartsOne.SUPPLIER_PARTS (SUPPLIER_ID, PART_ID, QUANTITY, SHIPPER_ID) VALUES ("INPUT".SUPPLIER_ID, "INPUT".PART_ID, "INPUT".QUANTITY, "INPUT".SHIPPER_ID);
> INSERT INTO PartsTwo.SHIP_VIA (SHIPPER_ID, SHIPPER_NAME) VALUES ("INPUT".SHIPPER_ID, "INPUT".SHIPPER_NAME);
> DECLARE integer VARIABLES.ROWS_UPDATED;
> VARIABLES.ROWS_UPDATED = VARIABLES.ROWCOUNT;
> END
> Generates ERROR: TEIID31119 Symbol "INPUT".SUPPLIER_ID is specified with an unknown group context
> Additionaly, an error from DELETE sql tab is showed under this error message (ERROR: TEIID31100 Parsing error: Encountered "; IF([*]HAS[*] CRITERIA ON" at line 4, column 12.
> Was expecting: "char" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" | "false" | "hour" | "insert" ... ).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1954) Syntactic error in INSERT SQL of relational view table which supports update
by Lucie Fabrikova (JIRA)
Lucie Fabrikova created TEIIDDES-1954:
-----------------------------------------
Summary: Syntactic error in INSERT SQL of relational view table which supports update
Key: TEIIDDES-1954
URL: https://issues.jboss.org/browse/TEIIDDES-1954
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 8.3
Environment: teiid designer 8.3.0.beta3, JBDS 7.1.0CR1, JBTools 4.1.3.Beta5, DV6 ER4
Reporter: Lucie Fabrikova
Attachments: TwoSources.zip
I have relational view model with table "UpdateParts", which has Supports Update option checked. The INSERT sql:
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO PartsOne.SUPPLIER_PARTS (SUPPLIER_ID, PART_ID, QUANTITY, SHIPPER_ID) VALUES ("INPUT".SUPPLIER_ID, "INPUT".PART_ID, "INPUT".QUANTITY, "INPUT".SHIPPER_ID);
INSERT INTO PartsTwo.SHIP_VIA (SHIPPER_ID, SHIPPER_NAME) VALUES ("INPUT".SHIPPER_ID, "INPUT".SHIPPER_NAME);
DECLARE integer VARIABLES.ROWS_UPDATED;
VARIABLES.ROWS_UPDATED = VARIABLES.ROWCOUNT;
END
Generates ERROR: TEIID31119 Symbol "INPUT".SUPPLIER_ID is specified with an unknown group context
Additionaly, an error from DELETE sql tab is showed under this error message (ERROR: TEIID31100 Parsing error: Encountered "; IF([*]HAS[*] CRITERIA ON" at line 4, column 12.
Was expecting: "char" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" | "false" | "hour" | "insert" ... ).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1954) Syntactic error in INSERT SQL of relational view table which supports update
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1954?page=com.atlassian.jira.plu... ]
Lucie Fabrikova updated TEIIDDES-1954:
--------------------------------------
Attachment: TwoSources.zip
> Syntactic error in INSERT SQL of relational view table which supports update
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-1954
> URL: https://issues.jboss.org/browse/TEIIDDES-1954
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: teiid designer 8.3.0.beta3, JBDS 7.1.0CR1, JBTools 4.1.3.Beta5, DV6 ER4
> Reporter: Lucie Fabrikova
> Attachments: TwoSources.zip
>
>
> I have relational view model with table "UpdateParts", which has Supports Update option checked. The INSERT sql:
> FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO PartsOne.SUPPLIER_PARTS (SUPPLIER_ID, PART_ID, QUANTITY, SHIPPER_ID) VALUES ("INPUT".SUPPLIER_ID, "INPUT".PART_ID, "INPUT".QUANTITY, "INPUT".SHIPPER_ID);
> INSERT INTO PartsTwo.SHIP_VIA (SHIPPER_ID, SHIPPER_NAME) VALUES ("INPUT".SHIPPER_ID, "INPUT".SHIPPER_NAME);
> DECLARE integer VARIABLES.ROWS_UPDATED;
> VARIABLES.ROWS_UPDATED = VARIABLES.ROWCOUNT;
> END
> Generates ERROR: TEIID31119 Symbol "INPUT".SUPPLIER_ID is specified with an unknown group context
> Additionaly, an error from DELETE sql tab is showed under this error message (ERROR: TEIID31100 Parsing error: Encountered "; IF([*]HAS[*] CRITERIA ON" at line 4, column 12.
> Was expecting: "char" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" | "false" | "hour" | "insert" ... ).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1948) Usability: When wanting to add transformation source, no options until input set is open
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1948?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1948:
----------------------------------------
The behavior of the XML Mapping Class transformation editing has not changed. The Top -level XML Mapping diagram is a "Coarse" view and allows showing the entire map between Mapping classes and the XML Document. Double-clicking a Mapping class opens the "Detailed" mapping view, which shows the column-to-XMLelement mapping and doubles as the Transformation Diagram.
> Usability: When wanting to add transformation source, no options until input set is open
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1948
> URL: https://issues.jboss.org/browse/TEIIDDES-1948
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Usability
> Affects Versions: 8.3
> Reporter: Van Halbert
> Priority: Minor
>
> Trying to map the mapping class to the source model, but there's no visible option (unlike in Designer 7.x) to add transformation source. Not until I accidentally clicked on the mapping class, which then displays the input set, is the option then made available. The option needs to be made available without the Input Set being visible.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1949) Unable to create function from the reconciler
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1949?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1949:
----------------------------------------
Van, can you clarify?
1) Did you add a custom function for your use-case?
2) Did you just try and use the simple string concat() functions?
> Unable to create function from the reconciler
> ----------------------------------------------
>
> Key: TEIIDDES-1949
> URL: https://issues.jboss.org/browse/TEIIDDES-1949
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 8.3
> Reporter: Van Halbert
> Priority: Blocker
>
> Description of problem: Trying to create a function to concatenate last and first names, but nothing would return from dialog after pressing OK. Looking in the log, NPE was found:
> java.lang.NullPointerException
> at org.teiid.query.function.FunctionTree.getFunction(FunctionTree.java:386)
> at org.teiid.query.function.FunctionLibrary.findFunction(FunctionLibrary.java:141)
> at org.teiid.query.function.FunctionLibrary.findFunction(FunctionLibrary.java:1)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel.syncFunction(ReconcilerPanel.java:725)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel.expressionButtonPressed(ReconcilerPanel.java:681)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel$6.widgetSelected(ReconcilerPanel.java:364)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months