Bug 1034475
| Summary: | Unable to import SAP NW-Gateway OData using sap-nw-gateway translator | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | wgibson | ||||
| Component: | Tooling | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.0.0 | CC: | mharvey, vhalbert | ||||
| Target Milestone: | ER6 | ||||||
| Target Release: | 6.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: |
When using Teiid Designer to import SAP NW-Gateway OData, user is presented with an Import Message: "Error encountered while importing the DDL - No difference report was found".
|
Story Points: | --- | ||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2014-02-06 15:37:04 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: | |||||||
| Attachments: |
|
||||||
|
Description
wgibson
2013-11-25 22:45:07 UTC
Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1955 I was able to reproduce - attaching the exported DDL. (Can use the DDL importer with the attached DDL to reproduce without teiid connection importer) I've observed two problems so far 1) If you choose to 'auto-select' the dialect, DdlParsers chooses 'POSTGRES' dialect instead of 'TEIID' 2) If you choose TEIID dialect, parser npes with the supplied stacktrace. Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1955 I updated Modeshape jars in my local workspace. Then was able to finish the import. After import, I create a connection profile and set it on the imported model. Then attempted preview. There are a couple issues on preview that Teiid team should look at: 1) BookingCollection - The preview results never returned. In the server log I see: 09:42:28,408 WARN [org.teiid.SECURITY] (New I/O worker #1) TEIID40011 Processing exception 'TEIID40042 Invalid Session 2smjnjwLfmFd. Session may have already been terminated.' for session 2smjnjwLfmFd. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:355). Enable more detailed logging to see the entire stacktrace. 2) NotificationCollection - Preview error. Returned with error: TEIID30504 SAPODataMdl: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1955 I updated Modeshape jars in my local workspace. Then was able to finish the import. After import, I create a connection profile and set it on the imported model. Then attempted preview. There are a couple issues on preview that Teiid team should look at: ========================== 1) BookingCollection - ========================== The preview results never returned. In the server log I see: 09:42:28,408 WARN [org.teiid.SECURITY] (New I/O worker #1) TEIID40011 Processing exception 'TEIID40042 Invalid Session 2smjnjwLfmFd. Session may have already been terminated.' for session 2smjnjwLfmFd. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:355). Enable more detailed logging to see the entire stacktrace. Eventually got this: 09:49:42,936 ERROR [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue32) Connector worker process failed for atomic-request=TepnqZ3eJKXZ.0.0.8: com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in start tag at [row,col {unknown-source}]: [1,25857050] at com.ctc.wstx.sr.StreamScanner.throwUnexpectedEOF(StreamScanner.java:677) at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:1037) at com.ctc.wstx.sr.StreamScanner.getNextChar(StreamScanner.java:785) at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2810) at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1072) at org.codehaus.stax2.ri.Stax2EventReaderImpl.nextEvent(Stax2EventReaderImpl.java:255) at org.odata4j.stax2.staximpl.StaxXMLFactoryProvider2$StaxXMLEventReader2.nextEvent(StaxXMLFactoryProvider2.java:111) at org.odata4j.format.xml.AtomFeedFormatParser.parseProperties(AtomFeedFormatParser.java:189) at org.odata4j.format.xml.AtomFeedFormatParser.parseDSAtomEntry(AtomFeedFormatParser.java:272) at org.odata4j.format.xml.AtomFeedFormatParser.parseEntry(AtomFeedFormatParser.java:382) at org.odata4j.format.xml.AtomFeedFormatParser.parseFeed(AtomFeedFormatParser.java:168) at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:156) at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:44) at org.teiid.translator.odata.BaseQueryExecution.parse(BaseQueryExecution.java:91) at org.teiid.translator.odata.BaseQueryExecution.executeWithReturnEntity(BaseQueryExecution.java:123) at org.teiid.translator.odata.ODataQueryExecution.execute(ODataQueryExecution.java:92) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:113) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45] at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45] 09:49:42,940 WARN [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue33) TEIID30020 Processing exception for request TepnqZ3eJKXZ.0 'TEIID30504 SAPODataMdl: Unexpected EOF in start tag at [row,col {unknown-source}]: [1,25857050]'. Originally TeiidProcessingException StreamScanner.java:677. Enable more detailed logging to see the entire stacktrace. ========================== 2) NotificationCollection - ========================== Preview error. Returned with error: TEIID30504 SAPODataMdl: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1955 I updated Modeshape jars in my local workspace. Then was able to finish the import. After import, I create a connection profile and set it on the imported model. Then attempted preview. There are a couple issues on preview that Teiid team should look at: ========================== 1) BookingCollection - ========================== The preview results never returned. In the server log I see: 09:42:28,408 WARN [org.teiid.SECURITY] (New I/O worker #1) TEIID40011 Processing exception 'TEIID40042 Invalid Session 2smjnjwLfmFd. Session may have already been terminated.' for session 2smjnjwLfmFd. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:355). Enable more detailed logging to see the entire stacktrace. Eventually got this: 09:49:42,936 ERROR [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue32) Connector worker process failed for atomic-request=TepnqZ3eJKXZ.0.0.8: com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in start tag at [row,col {unknown-source}]: [1,25857050] at com.ctc.wstx.sr.StreamScanner.throwUnexpectedEOF(StreamScanner.java:677) at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:1037) at com.ctc.wstx.sr.StreamScanner.getNextChar(StreamScanner.java:785) at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2810) at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1072) at org.codehaus.stax2.ri.Stax2EventReaderImpl.nextEvent(Stax2EventReaderImpl.java:255) at org.odata4j.stax2.staximpl.StaxXMLFactoryProvider2$StaxXMLEventReader2.nextEvent(StaxXMLFactoryProvider2.java:111) at org.odata4j.format.xml.AtomFeedFormatParser.parseProperties(AtomFeedFormatParser.java:189) at org.odata4j.format.xml.AtomFeedFormatParser.parseDSAtomEntry(AtomFeedFormatParser.java:272) at org.odata4j.format.xml.AtomFeedFormatParser.parseEntry(AtomFeedFormatParser.java:382) at org.odata4j.format.xml.AtomFeedFormatParser.parseFeed(AtomFeedFormatParser.java:168) at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:156) at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:44) at org.teiid.translator.odata.BaseQueryExecution.parse(BaseQueryExecution.java:91) at org.teiid.translator.odata.BaseQueryExecution.executeWithReturnEntity(BaseQueryExecution.java:123) at org.teiid.translator.odata.ODataQueryExecution.execute(ODataQueryExecution.java:92) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:113) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45] at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45] 09:49:42,940 WARN [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue33) TEIID30020 Processing exception for request TepnqZ3eJKXZ.0 'TEIID30504 SAPODataMdl: Unexpected EOF in start tag at [row,col {unknown-source}]: [1,25857050]'. Originally TeiidProcessingException StreamScanner.java:677. Enable more detailed logging to see the entire stacktrace. ========================== 2) NotificationCollection - ========================== Preview error. Returned with error: TEIID30504 SAPODataMdl: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> Server Log: 10:01:21,326 WARN [org.teiid.CONNECTOR] (Worker9_QueryProcessorQueue47) Connector worker process failed for atomic-request=NPSSHrgrj5az.0.0.11: org.teiid.translator.TranslatorException: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> at org.teiid.translator.odata.BaseQueryExecution.buildError(BaseQueryExecution.java:198) at org.teiid.translator.odata.BaseQueryExecution.executeWithReturnEntity(BaseQueryExecution.java:131) at org.teiid.translator.odata.ODataQueryExecution.execute(ODataQueryExecution.java:92) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:113) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-5.jar:8.4.1-redhat-5] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45] at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45] Caused by: java.lang.RuntimeException: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> at org.odata4j.core.Throwables.propagate(Throwables.java:11) at org.odata4j.stax2.staximpl.StaxXMLWriter2.startElement(StaxXMLWriter2.java:77) at org.odata4j.stax2.staximpl.StaxXMLWriter2.startElement(StaxXMLWriter2.java:61) at org.odata4j.stax2.util.StaxUtil.writeStartElement(StaxUtil.java:87) at org.odata4j.stax2.util.StaxUtil.writeXml(StaxUtil.java:71) at org.odata4j.stax2.util.StaxUtil.innerXml(StaxUtil.java:59) at org.odata4j.stax2.util.StaxUtil.innerXml(StaxUtil.java:54) at org.odata4j.format.xml.AtomErrorFormatParser.parse(AtomErrorFormatParser.java:37) at org.odata4j.format.xml.AtomErrorFormatParser.parse(AtomErrorFormatParser.java:13) at org.teiid.translator.odata.BaseQueryExecution.buildError(BaseQueryExecution.java:194) ... 15 more Caused by: javax.xml.stream.XMLStreamException: Trying to output second root, <errordetails> at com.ctc.wstx.sw.BaseStreamWriter.throwOutputError(BaseStreamWriter.java:1522) at com.ctc.wstx.sw.BaseStreamWriter.throwOutputError(BaseStreamWriter.java:1529) at com.ctc.wstx.sw.BaseStreamWriter.reportNwfStructure(BaseStreamWriter.java:1557) at com.ctc.wstx.sw.BaseNsStreamWriter.checkStartElement(BaseNsStreamWriter.java:469) at com.ctc.wstx.sw.SimpleNsStreamWriter.writeStartOrEmpty(SimpleNsStreamWriter.java:252) at com.ctc.wstx.sw.BaseNsStreamWriter.writeStartElement(BaseNsStreamWriter.java:317) at org.codehaus.stax2.ri.Stax2EventWriterImpl.add(Stax2EventWriterImpl.java:97) at org.odata4j.stax2.staximpl.StaxXMLWriter2.startElement(StaxXMLWriter2.java:74) ... 23 more Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1955 Problem VDB Barry LaFond <blafond> updated the status of jira TEIIDDES-1955 to Resolved Barry LaFond <blafond> made a comment on jira TEIIDDES-1955 Tested importing the DDL. Correct Modeshape jars (3.3.6) are in our build/kit. Verified import works. Barry LaFond <blafond> updated the status of jira TEIIDDES-1955 to Closed |