10:21 a.m.
Vineela Gampa created TEIID-2222:
------------------------------------
Summary: NPE thrown when dynamic sql is used in foreach clause
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
--
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
1:17 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2222:
---------------------------------------
Can you fill out the details of this issue and does it still occur on 8.1?
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
--
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
1:19 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Steve
I havent tried on 8.1. We are migrating codebase from 7.7 to 8.1 and its on its way.
Currently working codebase is on 7.7.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
--
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
1:21 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa updated TEIID-2222:
---------------------------------
Description:
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause || '=
''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue296)
ASSIGNMENT INSTRUCTION: setclause The variable setclause in the variablecontext is updated
with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue296)
Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue296)
Executing dynamic sql UPDATE security_ldap.baseuser SET security_ldap.baseuser.NAME=
'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue296)
Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue296)
Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
Forum Reference: https://community.jboss.org/thread/205481?tstart=0 (was:
https://community.jboss.org/thread/205481?tstart=0)
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
5:29 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa edited comment on TEIID-2222 at 9/24/12 6:29 PM:
---------------------------------------------------------------
I tested it on teiid 8 and dynamic sql worked fine on teiid 8.I couldnt use the same vdb
as our codebase is not migrated completely but used something on the lines.
<model visible = "true" type = "VIRTUAL" name =
"viewupdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE test() AS
BEGIN ATOMIC
EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END
]]>
</metadata>
</model>
was (Author: gamvi01):
I tested it on teiid 8 and dynamic sql worked fine on teiid 8.
<model visible = "true" type = "VIRTUAL" name =
"viewupdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE test() AS
BEGIN ATOMIC
EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END
]]>
</metadata>
</model>
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
5:29 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
I tested it on teiid 8 and dynamic sql worked fine on teiid 8.
<model visible = "true" type = "VIRTUAL" name =
"viewupdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE test() AS
BEGIN ATOMIC
EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END
]]>
</metadata>
</model>
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
5:31 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa edited comment on TEIID-2222 at 9/24/12 6:29 PM:
---------------------------------------------------------------
I tested it on teiid 8 and dynamic sql worked fine on teiid 8.I couldnt use the same vdb
as our codebase is not migrated completely but used something on the same lines.
<model visible = "true" type = "VIRTUAL" name =
"viewupdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE test() AS
BEGIN ATOMIC
EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END
]]>
</metadata>
</model>
was (Author: gamvi01):
I tested it on teiid 8 and dynamic sql worked fine on teiid 8.I couldnt use the same
vdb as our codebase is not migrated completely but used something on the lines.
<model visible = "true" type = "VIRTUAL" name =
"viewupdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE test() AS
BEGIN ATOMIC
EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END
]]>
</metadata>
</model>
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
1:21 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2222.
-----------------------------------
Fix Version/s: 8.2
Resolution: Done
The issue is specific to dynamic sql in a trigger, and does not affect procedures.
Addressed by adding the virtual group / update type to the generated proc command. Also
needed to correct the types on the changing variables.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
4:47 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Hi Steve,
we need the fix to 7.7.1 version. As per your resolved status its done to 8.2.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
4:55 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2222:
-------------------------------------
We *only* provide the fixes whatever is latest version. We do not provide fixes for older
version. If you want you can look at the patch that Steve did and back port into your
version of Teiid. Look under "source" tab for the changed files.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
3:21 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Hi
Iam still facing the issue. Now i get a different exception though.Didnt find where to
attach the sample vdb, hence copying down below.
<model name="Accounts">
<!--
JDBC Import settings
importer.useFullSchemaName directs the importer to drop the source
schema from the Teiid object name, so that the Teiid fully qualified name
will be in the form of <model name>.<table name>
-->
<property name="importer.useFullSchemaName"
value="false"/>
<!--
This connector is defined to reference the H2 localDS"
-->
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
</model>
<model visible = "true" type = "VIRTUAL" name =
"viewTriggerUpdate">
<source name="h2-connector" translator-name="h2"
connection-jndi-name="java:/accounts-ds"/>
<metadata type="DDL"><![CDATA[
CREATE VIEW hello1 (
SchemaName varchar(255) PRIMARY KEY ,
Name varchar(255)
) OPTIONS(UPDATABLE TRUE) AS
SELECT SchemaName,Name from sys.tables;
CREATE TRIGGER ON hello1 INSTEAD OF UPDATE
AS FOR EACH ROW
BEGIN ATOMIC
EXECUTE IMMEDIATE 'UPDATE accounts.account SET TYPE=''INACTIVE''
WHERE ACCOUNT_ID=19980002';
END;
]]></metadata>
</model>
error iam seeing..
Caused by: java.lang.IllegalArgumentException: Constant type should never be null
at org.teiid.query.sql.symbol.Constant.<init>(Constant.java:135)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.createVariableValuesMap(ExecDynamicSqlInstruction.java:264)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:169)
at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:379)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:306)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:280)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:143)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:109)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:143)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:109)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:384)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)
... 8 more
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
7:05 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2222:
---------------------------------------
Thanks Vineela,
Yes, there was still an issue with the new/old group symbols that I missed by only having
a dynamic delete test case. This has been corrected on trunk and will be in 8.2 Beta1.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
7:47 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
I performed the test by downloading teiid 8.2 alpha from teiid downloads site. I still
face the same issue. Do i need to build from your sources ?
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
8:01 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2222:
-------------------------------------
Vineela, two options; either wait for Beta1; or build from trunk version of the Teiid from
svn
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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:31 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Ramesh
I see compilation failure for ObjectTranslator module.
[11:08:18]: [Step 2/4] [INFO] Object Translator ................................. FAILURE
[12.690s]
[11:08:18]: [Step 2/4] [INFO] Runtime Engine .................................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] Adminshell ........................................ SKIPPED
[11:08:18]: [Step 2/4] [INFO] Hibernate Dialect ................................. SKIPPED
[11:08:18]: [Step 2/4] [INFO] teiid-jboss-integration ........................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] Integration Tests ................................. SKIPPED
[11:08:18]: [Step 2/4] [INFO] Common Integration Tests .......................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] DB Dependent Integration Tests .................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] Performance Integration Tests ..................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] Client JDK15 ...................................... SKIPPED
[11:08:18]: [Step 2/4] [INFO] Build ............................................. SKIPPED
[11:08:18]: [Step 2/4] [INFO]
------------------------------------------------------------------------
[11:08:18]: [Step 2/4] [INFO] BUILD FAILURE
[11:08:18]: [Step 2/4] [INFO]
------------------------------------------------------------------------
[11:08:18]: [Step 2/4] [INFO] Total time: 14:40.661s
[11:08:18]: [Step 2/4] [INFO] Finished at: Sat Sep 29 01:08:18 EST 2012
[11:08:19]: [Step 2/4] [INFO] Final Memory: 182M/393M
[11:08:19]: [Step 2/4] [INFO]
------------------------------------------------------------------------
[11:08:21]: [Step 2/4] [ERROR] Failed to execute goal
org.apache.maven.plugins:maven-compiler-plugin:2.3.2:compile (default-compile) on project
translator-object: Compilation failure: Compilation failure:
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/infinispan/InfinispanBaseExecutionFactory.java:[35,34]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: package org.teiid.translator.object
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/mapcache/MapCacheExecutionFactory.java:[34,34]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: package org.teiid.translator.object
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/infinispan/InfinispanBaseExecutionFactory.java:[176,6]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: class
org.teiid.translator.object.infinispan.InfinispanBaseExecutionFactory
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/infinispan/InfinispanBaseExecutionFactory.java:[176,48]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: class
org.teiid.translator.object.infinispan.InfinispanBaseExecutionFactory
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/mapcache/MapCacheExecutionFactory.java:[104,4]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: class
org.teiid.translator.object.mapcache.MapCacheExecutionFactory
[11:08:21]: [Step 2/4] [ERROR]
/root/build/r3/teiidSVNtoRTCforTrunk/Teiid-trunk-src/trunk/connectors/translator-object/src/main/java/org/teiid/translator/object/mapcache/MapCacheExecutionFactory.java:[104,46]
cannot find symbol
[11:08:21]: [Step 2/4] [ERROR] symbol : class JavaBeanMetadataProcessor
[11:08:21]: [Step 2/4] [ERROR] location: class
org.teiid.translator.object.mapcache.MapCacheExecutionFactory
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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:41 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2222:
---------------------------------------
The latest object translator check-in was incomplete. We'll prompt Van to complete
it.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
11:16 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa edited comment on TEIID-2222 at 9/28/12 12:15 PM:
----------------------------------------------------------------
Sure let us know. Is there some other way to get the teiid zip with your changes.
was (Author: gamvi01):
Sure let us know. Is there some other way to get the teiid zip
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
11:16 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Sure let us know. Is there some other way to get the teiid zip
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
11:45 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2222:
-------------------------------------
check now, it should be corrected. Also, check under the "source" tab for the
changes that Steve did, as we mentioned before you can back patch your 7.7.1 version if u
want, but you are on your own for doing that task.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
11:58 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
yes right now testing on the latest version, planning to patch them. Will run the build
now.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
3:13 p.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2222:
--------------------------------------
Few tests were failing and we got the build right by skipping them. Now dynamic sqls are
working inside a trigger.
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
8:23 a.m.
[
https://issues.jboss.org/browse/TEIID-2222?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2222.
---------------------------------
NPE thrown when dynamic sql is used in foreach clause
-----------------------------------------------------
Key: TEIID-2222
URL: https://issues.jboss.org/browse/TEIID-2222
Project: Teiid
Issue Type: Bug
Affects Versions: 7.7.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 8.2
NPE occurred when using dynamic sql in foreach clause of trigger. Stacktrace is pasted
below.
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
IF (CHANGING.NAME)
BEGIN
setclause = 'security_ldap.baseuser.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' || setclause ||
'= ''NEW.NAME'' WHERE security_ldap.baseuser.DN =
''NEW.USERID''';
END
OR
Even using "USING" Yielded the same
FOR EACH ROW
BEGIN
DECLARE string setclause = null;
DECLAR string whereclause = ' WHERE security_ldap.baseuser.DN =
USING.USERID'
IF (CHANGING.NAME)
BEGIN
setclause =
'security_ldap.baseuser.NAME=USING.NAME';
END
EXECUTE IMMEDIATE 'UPDATE security_ldap.baseuser SET ' ||
setclause || whereclause || USING NAME=NEW.NAME,USERID=NEW.USERID;
END
I see my command got resolved well. But i seeing an NPE during validatioin -
context.pushCall(parentProcCommand.getVirtualGroup().getCanonicalName()); -
parentProcCommand.getVirtualGroup() is null.
20 Sep 2012 16:15:54,670 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) ASSIGNMENT INSTRUCTION: setclause The variable setclause
in the variablecontext is updated with the value : security_ldap.baseuser.NAME
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing instruction ExecDynamicSqlInstruction
20 Sep 2012 16:15:54,671 PDT TRACE [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Executing dynamic sql UPDATE security_ldap.baseuser SET
security_ldap.baseuser.NAME= 'NEW.NAME' WHERE security_ldap.baseuser.DN =
'NEW.USERID'
20 Sep 2012 16:15:54,678 PDT TRACE [org.teiid.PLANNER.RESOLVER]
(Worker15_QueryProcessorQueue296) Resolving command UPDATE security_ldap.baseuser SET NAME
= 'NEW.NAME' WHERE security_ldap.baseuser.DN = 'NEW.USERID'
20 Sep 2012 16:15:54,681 PDT DEBUG [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Request Thread U0W5vGKiU+f+.0 - error occurred
java.lang.NullPointerException
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:328)
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171)
at
org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:384)
at
org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:312)
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:285)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:119)
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
20 Sep 2012 16:15:54,682 PDT DEBUG [org.teiid.COMMAND_LOG]
(Worker15_QueryProcessorQueue296) ERROR USER COMMAND: endTime=2012-09-20
16:15:54.682 requestID=U0W5vGKiU+f+.0 txID=TransactionImple < ac, BasicAction:
a8458a5:e104:505ba20c:17 status: ActionStatus.RUNNING > sessionID=U0W5vGKiU+f+
principal=gamvi01@chorus-teiid-security vdbName=Chorus vdbVersion=1
finalRowCount=null
20 Sep 2012 16:15:54,682 PDT ERROR [org.teiid.PROCESSOR]
(Worker15_QueryProcessorQueue296) Unexpected exception for request U0W5vGKiU+f+.0
java.lang.NullPointerException
--
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
4200
days inactive
4260
days old
21 comments
3 participants
participants (3)
-
Ramesh Reddy (JIRA) -
Steven Hawkins (JIRA)
-
Vineela Gampa (JIRA)