[JBoss JIRA] Resolved: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1443.
-----------------------------------
Fix Version/s: 7.5
Resolution: Done
reapplying the fix to 7.4.1/7.5
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.1
> Environment: RHEL 5
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.4.1, 7.5, 7.3, 7.1.1
>
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Updated: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1443:
----------------------------------
Fix Version/s: 7.3
7.1.1
Affects Version/s: 7.1
(was: 7.4.1)
Note that the fix missed 7.4 Final. The workaround of using exactly the mixed case name as the invocation name.
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.1
> Environment: RHEL 5
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.1.1, 7.3, 7.4.1
>
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Commented: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1443:
---------------------------------------
The forward merge never happened from 7.3.x. That seems odd.
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.4.1
> Environment: RHEL 5
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.4.1
>
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Updated: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-1443:
-------------------------------
Fix Version/s: 7.4.1
(was: 7.3)
Affects Version/s: 7.4.1
(was: 7.1.1)
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.4.1
> Environment: RHEL 5
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.4.1
>
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Reopened: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Van Halbert reopened TEIID-1443:
--------------------------------
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.1.1
> Environment: RHEL 5
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.3
>
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Resolved: (TEIID-1712) Support different length records in files for modeling
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1712?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1712.
-----------------------------------
Fix Version/s: 7.4.1
7.5
Resolution: Done
Changed the logic to allow partial delimited lines
> Support different length records in files for modeling
> -------------------------------------------------------
>
> Key: TEIID-1712
> URL: https://issues.jboss.org/browse/TEIID-1712
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 7.1.1
> Environment: Fedora 14, OpenJDK 1.6, JBDS 4 GA
> Reporter: Joel Tosi
> Assignee: Van Halbert
> Priority: Minor
> Fix For: 7.4.1, 7.5
>
>
> If I try and model a file where there are differing length records, I get an error, i.e.
> No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...
> Instead I would expect to see null values.
> For example, if this is my file (CSV)
> HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
> Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on
> I can read the file in but trying to model it gives me the error mentioned above.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Assigned: (TEIID-1712) Support different length records in files for modeling
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1712?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-1712:
-------------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> Support different length records in files for modeling
> -------------------------------------------------------
>
> Key: TEIID-1712
> URL: https://issues.jboss.org/browse/TEIID-1712
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 7.1.1
> Environment: Fedora 14, OpenJDK 1.6, JBDS 4 GA
> Reporter: Joel Tosi
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 7.4.1, 7.5
>
>
> If I try and model a file where there are differing length records, I get an error, i.e.
> No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...
> Instead I would expect to see null values.
> For example, if this is my file (CSV)
> HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
> Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on
> I can read the file in but trying to model it gives me the error mentioned above.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Commented: (TEIID-1712) Support different length records in files for modeling
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1712?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1712:
---------------------------------------
What is the desired target release for this? The code change is quite simple to allow null values for non-existent columns, unless we want to preserve the exceptional behavior - in which case a new TEXTTABLE switch is needed.
> Support different length records in files for modeling
> -------------------------------------------------------
>
> Key: TEIID-1712
> URL: https://issues.jboss.org/browse/TEIID-1712
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 7.1.1
> Environment: Fedora 14, OpenJDK 1.6, JBDS 4 GA
> Reporter: Joel Tosi
> Assignee: Van Halbert
> Priority: Minor
>
> If I try and model a file where there are differing length records, I get an error, i.e.
> No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...
> Instead I would expect to see null values.
> For example, if this is my file (CSV)
> HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
> Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on
> I can read the file in but trying to model it gives me the error mentioned above.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] Moved: (TEIID-1712) Support different length records in files for modeling
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1712?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3270 to TEIID-1712:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1712 (was: SOA-3270)
Affects Version/s: 7.1.1
(was: 5.2.0 ER1)
Component/s: Misc. Connectors
(was: EDS)
Security: (was: Public)
> Support different length records in files for modeling
> -------------------------------------------------------
>
> Key: TEIID-1712
> URL: https://issues.jboss.org/browse/TEIID-1712
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 7.1.1
> Environment: Fedora 14, OpenJDK 1.6, JBDS 4 GA
> Reporter: Joel Tosi
> Assignee: Van Halbert
> Priority: Minor
>
> If I try and model a file where there are differing length records, I get an error, i.e.
> No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...
> Instead I would expect to see null values.
> For example, if this is my file (CSV)
> HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
> Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on
> I can read the file in but trying to model it gives me the error mentioned above.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months