6 Replies Latest reply: Oct 15, 2012 8:58 AM by Andy Coates RSS

    Issue With Dynamic Varible.....

    Avinash P
      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"))')}