Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

java.lang.nullpointer excepiton -- urgent !!!

SOLVED
Go to solution
Highlighted
Sevilay
Collector

java.lang.nullpointer excepiton -- urgent !!!

Hi,

i'm trying to select data from a table which is in different database (other then PPM),but i defined this database and application server in environment.
in a workflow execution step ,i wrote the following query:

ksc_itg_run_sql QUERY_STRING="SELECT count(*) FROM DEFAULT_SGMQCTEST2_DB.BUG WHERE BG_USER_01 = 'Test'" ENV_NAME="QC_TEST_SERVER"
ksc_store REQ.P.QC_OPEN_DEFECT_COUNT = "[SQL_OUTPUT]","[SQL_OUTPUT]"

But when it is executed ,i'm getting the following error:java.lang.nullpointerexception.
In the server log :
"erver:com.kintana.crt.server.CRTExecutionManager Batch ID: 33159:com.kintana.core.executions:2010/06/17-14:13:45.265 EEST: java.lang.NullPointerException
at com.kintana.core.server.execution.CLStoreCommand.parse(CLStoreCommand.java:110)
at com.kintana.core.server.execution.CommandParser.parseCommands(CommandParser.java:288)
at com.kintana.core.server.execution.CommandExecutionAgent.parseCommands(CommandExecutionAgent.java:665)
at com.kintana.core.server.execution.BaseExecutionManager.executeBatchForRegularExecution(BaseExecutionManager.java:1095)
at com.kintana.core.server.execution.BaseExecutionManager.executeBatch(BaseExecutionManager.java:1038)
at com.kintana.core.server.execution.BaseExecutionManager.run(BaseExecutionManager.java:795)
at java.lang.Thread.run(Thread.java:619)" is written.

What can be the reason ? What am i doing wrong ?

Every attemp will be much appreciated.

Thanks.
2 REPLIES
Surendra Poosar
Frequent Visitor
Solution

Re: java.lang.nullpointer excepiton -- urgent !!!

Hello,

Please use this

ksc_itg_run_sql QUERY_STRING="SELECT count(*) FROM DEFAULT_SGMQCTEST2_DB.BUG WHERE BG_USER_01 = 'Test'" ENV_NAME="QC_TEST_SERVER"

ksc_set TEMP_VAR = "[SQL_OUTPUT]"

ksc_store REQ.P.QC_OPEN_DEFECT_COUNT = "[TEMP_VAR]","[TEMP_VAR]"


Thanks
Surendra
Sevilay
Collector

Re: java.lang.nullpointer excepiton -- urgent !!!

Thanks Poosarla,

i solved the problem yesterday in a similar way.

Have a good day.
//Add this to "OnDomLoad" event