11:59:21,876 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request QU8wBpeuF3NV.0 'TEIID30068 The function 'pg_catalog.lag(ALL GPDBDEV.kr_cust_team_target.target_amount)' is an unknown form.  Check that the function name and number of arguments is correct.'. Originally QueryResolverException ResolverVisitor.java:629. Enable more detailed logging to see the entire stacktrace.
11:59:38,091 INFO  [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) PostgreSQLExecutionFactory Commit=true;DatabaseProductName=PostgreSQL;DatabaseProductVersion=8.2.15;DriverMajorVersion=9;DriverMajorVersion=4;DriverName=PostgreSQL Native Driver;DriverVersion=PostgreSQL 9.4.1211;IsolationLevel=2
11:59:38,203 INFO  [org.teiid.PLANNER] (Worker0_QueryProcessorQueue1) 
============================================================================
USER COMMAND:
SELECT GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") FROM GPDBDEV.kr_cust_team_target

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") FROM GPDBDEV.kr_cust_team_target

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") FROM GPDBDEV.kr_cust_team_target

CANONICAL PLAN: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true})
  Source(groups=[GPDBDEV.kr_cust_team_target])


============================================================================
EXECUTING PlaceAccess

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true})
  Access(groups=[GPDBDEV.kr_cust_team_target], props={SOURCE_HINT=null, MODEL_ID=Schema name=GPDBDEV, nameInSource=null, uuid=mmuuid:3e9ef44c-7ac1-4f11-88ad-2cc390c2ebac})
    Source(groups=[GPDBDEV.kr_cust_team_target])


============================================================================
EXECUTING RaiseAccess
LOW [Relational Planner] Window function not supported by source GPDBDEV - LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") was not pushed

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true})
  Access(groups=[GPDBDEV.kr_cust_team_target], props={SOURCE_HINT=null, MODEL_ID=Schema name=GPDBDEV, nameInSource=null, uuid=mmuuid:3e9ef44c-7ac1-4f11-88ad-2cc390c2ebac})
    Source(groups=[GPDBDEV.kr_cust_team_target])


============================================================================
EXECUTING AssignOutputElements

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")]})
  Access(groups=[GPDBDEV.kr_cust_team_target], props={SOURCE_HINT=null, MODEL_ID=Schema name=GPDBDEV, nameInSource=null, uuid=mmuuid:3e9ef44c-7ac1-4f11-88ad-2cc390c2ebac, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"]})
    Source(groups=[GPDBDEV.kr_cust_team_target], props={OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"]})


============================================================================
EXECUTING CalculateCost

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], EST_CARDINALITY=-1.0})
  Access(groups=[GPDBDEV.kr_cust_team_target], props={SOURCE_HINT=null, MODEL_ID=Schema name=GPDBDEV, nameInSource=null, uuid=mmuuid:3e9ef44c-7ac1-4f11-88ad-2cc390c2ebac, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"], EST_CARDINALITY=-1.0})
    Source(groups=[GPDBDEV.kr_cust_team_target], props={OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"], EST_COL_STATS={GPDBDEV.kr_cust_team_target.team=[-1.0, -1.0], GPDBDEV.kr_cust_team_target.target_amount=[-1.0, -1.0], GPDBDEV.kr_cust_team_target."year"=[-1.0, -1.0], GPDBDEV.kr_cust_team_target."month"=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PlanSorts

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target])
  Access(groups=[GPDBDEV.kr_cust_team_target])
    Source(groups=[GPDBDEV.kr_cust_team_target])


============================================================================
EXECUTING CollapseSource

AFTER: 
Project(groups=[GPDBDEV.kr_cust_team_target], props={PROJECT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], HAS_WINDOW_FUNCTIONS=true, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")], EST_CARDINALITY=-1.0})
  Access(groups=[GPDBDEV.kr_cust_team_target], props={SOURCE_HINT=null, MODEL_ID=Schema name=GPDBDEV, nameInSource=null, uuid=mmuuid:3e9ef44c-7ac1-4f11-88ad-2cc390c2ebac, OUTPUT_COLS=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month" FROM GPDBDEV.kr_cust_team_target})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN = 
ProjectNode(0) output=[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")] [GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")]
  WindowFunctionProjectNode(1) output=[LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"), GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"] 
    AccessNode(2) output=[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"] SELECT g_0.team, g_0.target_amount, g_0."year", g_0."month" FROM GPDBDEV.kr_cust_team_target AS g_0

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(0) 
output=

[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")] 

[GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month")]

  WindowFunctionProjectNode(1) 
output=

[LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"), GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"]
 
    AccessNode(2) 
	output=
	
[GPDBDEV.kr_cust_team_target.team, GPDBDEV.kr_cust_team_target.target_amount, GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month"] SELECT g_0.team, g_0.target_amount, g_0."year", g_0."month" FROM GPDBDEV.kr_cust_team_target AS g_0

============================================================================

11:59:38,611 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue3) TEIID30019 Unexpected exception for request BWIVpfi0IyEK.0: java.lang.NullPointerException
	at org.teiid.query.function.FunctionDescriptor.newInstance(FunctionDescriptor.java:91) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.function.aggregate.UserDefined.<init>(UserDefined.java:44) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.GroupingNode.initAccumulator(GroupingNode.java:291) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.WindowFunctionProjectNode.initializeAccumulators(WindowFunctionProjectNode.java:414) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:339) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:232) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91]
	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]