This discussion is archived
6 Replies Latest reply: Oct 15, 2012 6:58 AM by Andy Coates RSS

Issue With Dynamic Varible.....

Avinash P Newbie
Currently Being Moderated
Hi All,

I have Create Dynamic Varible MONTH_NAME It Returns The Currnt Month value.when i Excute in Sql It Working Fine.
But Whn I am Applying On Column It Getting Follwing Error.

Please Let Me Know How To Arrchive This Error

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 23005] The repository variable, MONTH_NAME, has no value definition. (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT "Time"."Month Name" saw_0, "Service Request"."Area" saw_1, "Service Request Facts"."# of SRs" saw_2, "Service Request Facts"."# of Open SRs" saw_3, "Service Request Facts"."# of SRs" -"Service Request Facts"."# of Open SRs" saw_4, ("Service Request Facts"."# of Open SRs" /"Service Request Facts"."# of SRs")*100 saw_5, (("Service Request Facts"."# of SRs" -"Service Request Facts"."# of Open SRs" )/"Service Request Facts"."# of SRs")*100 saw_6 FROM "Service - CRM Service Requests" WHERE ("Service Request"."Area" = ''Complaints'') AND ("Time"."Month Name" = VALUEOF("MONTH_NAME"))')}

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points