1.3.3 TEST_USER_STDCIF_EXECUTEQUERY

This topic provides details of the file TEST_USER_STDCIF_EXECUTEQUERY.


[20210621 12:52:39 718]FCClientHandler.doPost-->User Debug true - pdpDbg_chk true
[20210621 12:52:39 718]FCClientHandler.doPost-->Processing FCJ screen
[20210621 12:52:39 718]FCClientHandler.doPost-->contentLength=776
[20210621 12:52:39 718]FCClientHandler.doPost:param_operation-->Validating the CSRF token
[20210621 12:52:39 718]FCClientHandler.doPost-->msgType=null
[20210621 12:52:39 719]FCClientHandler.doPost-->Validating request xml with validateJavascript
[20210621 12:52:39 720]FCClientHandler.doPost-->userID=TEST_USER
[20210621 12:52:39 720]FCClientHandler.doPost-->FunctionId=STDCIF
[20210621 12:52:39 720]FCClientHandler.doPost-->Operation=EXECUTEQUERY
[20210621 12:52:39 720]FCClientHandler.doPost:param_operation-->PARAM_OPERATIONnull
[20210621 12:52:39 720]FCClientHandler.doPost-->DbUpload=FALSE
[20210621 12:52:39 720]FCClientHandler.doPost-->dmsRefNo=null
[20210621 12:52:39 721]FCClientHandler.Trace Value fetched from SMTB_USER_FUNCTION_TRACE
[20210621 12:52:39 721]FCClientHandler.doPost-->PDP check - Time capture started
[20210621 12:52:39 721]FCClientHandler.doPost-->PDP check - Debug capture started
[20210621 12:52:39 721]BranchLogger.renameDebugFile-->Log File rename successfull - TEST_USER_2021-06-21_12-52-39
[20210621 12:52:39 721]FCClientHandler.doPost-->refreshing the request XML header with session variables.
[20210621 12:52:39 725]FCClientHandler.doPost-->calling callHostServerNew
[20210621 12:52:39 725]FCClientHandler.doPost-->calling callHostServerNew for New or Modify or ExecuteQuery
[20210621 12:52:39 725]ToHostDispatcher.callHostServer-->calling callHostServer
[20210621 12:52:39 725]CentralizedCall.CentralizedCall-->calling host upload servlet in centralized mode...
[20210621 12:52:39 725]CentralizedCall.CentralizedCall.callHostServer-->oprationCode=EXECUTEQUERY
[20210621 12:52:39 726]HostUpload.processMsg-->***** APPSERVER LOG START *****
[20210621 12:52:39 726]HostUpload.processMsg-->getting FCUserGlobals from FCApplicationGlobals.getFCUserGlobals
[20210621 12:52:39 726]HostUpload.processLaunchScreen-->Calling isLoginValid
[20210621 12:52:39 726]FCJSMSBean.isLoginValid-->userId = TEST_USER branchCode = 000
[20210621 12:52:39 726]SMSOracleDAO.getUserLogStatus-->userId = TEST_USER
[20210621 12:52:39 726]SMSOracleDAO.getUserLogStatus-->signOnSerial = 38996
[20210621 12:52:39 727]SMSOracleDAO.getUserLogStatus-->loginCount = 1
[20210621 12:52:39 727]HostUpload.processLaunchScreen-->txnBranch=000
[20210621 12:52:39 727]HostUpload.processMsg-->Creating FCControllerSMS
[20210621 12:52:39 727]HostUpload.processMsg-->Creating FCControllerSMS.handleRequest
[20210621 12:52:39 727]FCControllerMaint.handleRequest-->just Entered
[20210621 12:52:39 727]FCControllerMain.handleRequest-->checking smsActionAccess in smsLocal
[20210621 12:52:39 727]FCControllerMain.handleRequest-->bActionAccess=true
[20210621 12:52:39 727]FCControllerMain.handleRequest-->calling fcController.handleRequest -- NEWROUTE
[20210621 12:52:39 727]FCController.handleRequest-->calling parseRequest
[20210621 12:52:39 727]FCHandlerMaintenance.execute-->creating fcjejb and miscjjb
[20210621 12:52:39 727]FCHandlerMaintenance.execute-->calling StaxParseUtility
[20210621 12:52:39 728]FCHandlerMaintenance.processMsgUBS-->just Entered
[20210621 12:52:39 728]FCHandlerMaintenance.processMsgUBS-->calling preProcessMessage
[20210621 12:52:39 728]FCHandlerMaintenance.preProcessMsg-->Inside preProcessMsg
[20210621 12:52:39 728]XmlAttachmentsParser.getUserName--> just Entered
[20210621 12:52:39 728]FCHandlerMaintenance.processMsgUBS-->calling processBasedonRoutingType
[20210621 12:52:39 728]FCHandlerMaintenance.processBasedonRoutingType-->Inside processBasedonRoutingType
[20210621 12:52:39 729]FCHandlerMaintenance.processBasedonRoutingType-->Tanking is not Enabled,calling processJavaSrcRouter
[20210621 12:52:39 729]FCHandlerMaintenance.processJavaSrcRouter-->Calling gwpksServiceRouter.processReqMsg
[20210621 12:52:39 729]GwpksServiceRouter.ProcessReqMsg()-->Just Entered..
[20210621 12:52:39 729]FCUtilityBean.getReleasetSmtbParameters()-->Query=select /*+ result_cache */ nvl(release_type,'CUSTOM') from smtb_parameters
[20210621 12:52:39 730]CspksReqGlobal().MsgInit()-->ReleaseType=CUSTOM
[20210621 12:52:39 730]GwpksServiceRouter.ProcessReqMsg()-->Calling PrInitHeader()..
[20210621 12:52:39 730]GwpksServiceRouterMain.PrInitHeader()-->Initializing Headers..
[20210621 12:52:39 730]GwpksServiceRouterMain.extractAddlTag()-->JustEntered..
[20210621 12:52:39 730]GwpksServiceRouterMain.extractAddlTag()-->Executes When Source="FLEXBRANCH"
[20210621 12:52:39 730]GwpksServiceRouterMain.extractAddlTag()-->return success from fn_extract_addl_tag()
[20210621 12:52:39 730]GwpksServiceRouterMain.extractAddlTag()-->Returning from Extract_Addl_Tag..
[20210621 12:52:39 730]GwpksServiceRouter.ProcessReqMsg()-->Calling populateMsgID()..
[20210621 12:52:39 730]FCUtilityBean.getPopulateMsgId()-->Query : SELECT fcj_incoming.NEXTVAL from dual
[20210621 12:52:39 732]GwpksServiceRouterMain.populateMsgID()-->Message ID=6121172000076994
[20210621 12:52:39 732]GwpksServiceRouter.ProcessReqMsg()-->Calling dedupeLogMsg()..
[20210621 12:52:39 732]GwpksServiceRouter.ProcessReqMsg()-->Calling enrichHeader()..
[20210621 12:52:39 732]GwpksServiceRouterMain.enrichHeader()-->Just Entered..
[20210621 12:52:39 732]GwpksServiceRouterMain.enrichHeader()-->Processing for Functionid and Action..
[20210621 12:52:39 732]GwpksServiceRouterMain.enrichHeader()-->Calling getRoutingTypeSmtbsMenu
[20210621 12:52:39 732]FCUtilityBean.getRoutingTypeSmtbsMenu()-->Query=SELECT /*+ result_cache */ nvl(routing_type, 'O'),nvl(logging_reqd, 'N'),type_string, nvl(Tank_modifications,'N') from smtbs_menu WHERE  function_id= ? 
[20210621 12:52:39 733]GwpksServiceRouterMain.enrichHeader()-->lRoutingType=X
[20210621 12:52:39 733]GwpksServiceRouterMain.enrichHeader()-->lRoutingType=X
[20210621 12:52:39 733]GwpksServiceRouterMain.enrichHeader()-->ENTERED
[20210621 12:52:39 733]GwpksServiceRouter.ProcessReqMsg()-->setting the enriched header into reqGlobal
[20210621 12:52:39 733]GwpksServiceRouter.ProcessReqMsg()-->STDCIF,EXECUTEQUERY
[20210621 12:52:39 733]GwpksServiceRouter.ProcessReqMsg()-->Calling processRequests()..
[20210621 12:52:39 733]GwpksServiceRouter.processRequests()-->calling ProcessRequest()
[20210621 12:52:39 733]GwpksServiceRouter.ProcessRequest()-->The Operation/Action isnull/EXECUTEQUERY
[20210621 12:52:39 733]GwpksServiceRouter.ProcessRequest()-->Calling cspksReqHandler.processMsg()..
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->Preparing ~ seperated Header nodes and Values..
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->25956930 :: l_msg_id :: 
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->FCUBS_MSG_ID :: 6121172000076994
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->25956930 :: inside if :: 
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->headerNames-->SOURCE~USERID~BRANCH~SERVICE~OPERATION~MULTITRIPID~FUNCTIONID~ACTION~MSGSTAT~MODULEID~MSGID~DEBUG_MODE~PKVALS~SOURCE_OPERATION~MSG_XCHANGE_PATTERN~MFA_AUTHENTICATED~MAKERREMARKS~CHECKERREMARKS~SNAPSHOTID~CORRELID~CORRELATION_PATTERN~EXT_TRIP_ID~
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->headerValues-->FLEXCUBE~TEST_USER~000~~~6121172000076994~STDCIF~EXECUTEQUERY~~ST~6121172000076994~N~~~IOFS~N~~~~~~~
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->calling cspksXmlParser.fcdataParser()
[20210621 12:52:39 733]CspksXmlParser.fcDataParser()-->JustEntered..
[20210621 12:52:39 733]CspksReqHandler.processMsg()-->calling cspksReqWrapper.processmsg()
[20210621 12:52:39 733]CspksReqWrapper.processmsg()-->Just Entered..
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->Just Entered..
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->tagNames=null
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->tagValues=N~000022~I~~~~~~~~~000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~N~~~~~~~~~~~~~~N~~~~~N~~~~~~~~~~~~~
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->parentsList=BLK_CUSTOMER
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->Calling processDBMain
[20210621 12:52:39 734]CspksReqWrapper.execFun()-->request passing to dbmain..<?xml version="1.0" encoding="UTF-8"?><FCUBS_REQ_ENV><FCUBS_HEADER><SOURCE>FLEXCUBE</SOURCE><UBSCOMP>FCUBS</UBSCOMP><USERID>TEST_USER</USERID><BRANCH>000</BRANCH><SERVICE/><OPERATION/><MULTITRIPID/><FUNCTIONID>STDCIF</FUNCTIONID><ACTION>EXECUTEQUERY</ACTION><MSGSTAT/><MODULEID>ST</MODULEID><MSGID/><DEBUG_MODE>N</DEBUG_MODE><ENTITY>ENTITY_ID1</ENTITY><MAKERREMARKS/><MAKEROVDREMARKS/><CHECKERREMARKS/><SNAPSHOTID/><PKVALS>000022~000</PKVALS><PKFIELDS>BLK_CUSTOMER__CUSTNO~BLK_CUSTOMER__LBRN</PKFIELDS><SQNO>38997</SQNO></FCUBS_HEADER><FCUBS_BODY><REC TYPE="BLK_CUSTOMER" RECID="1"><FV><![CDATA[N~000022~I~~~~~~~~~000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~N~~~~~~~~~~~~~~N~~~~~N~~~~~~~~~~~~~]]></FV></REC><MISC><REMARKS/></MISC></FCUBS_BODY></FCUBS_REQ_ENV>
[20210621 12:52:39 734]FCMainProcEJBBean.execFun()-->Just Entered..
[20210621 12:52:39 734]FCMainProcEJBBean.execFun()-->processDBMain-->calling  GWPKS_RESET_PKG.PR_RESET_PKG()***
[20210621 12:52:39 735]FCMainProcEJBBean.execFun()-->Setting Auto Commit to False..
[20210621 12:52:39 735]FCMainProcEJBBean.execFun()-->OracleConnection before wrap:null
[20210621 12:52:39 735]FCMainProcEJBBean.execFun()-->OracleConnection in if:weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@18743ab
[20210621 12:52:39 736]FCMainProcEJBBean.execFun()-->l_storedProcedureName=cspks_req_global_wrapper.Pr_Process_RequestJ***
[20210621 12:52:39 737]FCMainProcEJBBean.execFun()-->gatewayType::
[20210621 12:52:39 737]FCMainProcEJBBean.execFun()-->DB_TIMEOUT::0
[20210621 12:52:40 374]FCMainProcEJBBean.execFun()-->Executed Sucessfully
[20210621 12:52:40 375]FCMainProcEJBBean.execFun()-->EXT Call Required:null
[20210621 12:52:40 375]FCMainProcEJBBean.execFun()-->Calling Commit
[20210621 12:52:40 377]FCMainProcEJBBean.execFun()-->Commit is done
[20210621 12:52:40 377]FCMainProcEJBBean.execFun()-->Sucesfully returned from Main Package
[20210621 12:52:40 377]FCMainProcEJBBean.execFun()-->Setting SetAutoCommit true
[20210621 12:52:40 377]FCMainProcEJBBean.execFun()-->Setting of SetAutoCommit done
[20210621 12:52:40 377]CspksReqHandler.processMsg()-->ADDLINFO NAMES=KEY_ID>TANKED_DATA, ADDLINFO VALUES=~STTM_CUSTOMER~000022~>FALSE
[20210621 12:52:40 377]CspksCreator.create()-->In Create
[20210621 12:52:40 377]CspksCreator.create()-->Calling in CreateFcXml()..
[20210621 12:52:40 377]CspksCreator.createFcXml()-->Just Entered..
[20210621 12:52:40 377]CspksCreator.buildHeader()-->PSTATUS :S
[20210621 12:52:40 377]CspksCreator.buildHeader()-->Just Entered..
[20210621 12:52:40 377]CspksCreator.buildHeader()-->25956930 :: l_msgId : 
[20210621 12:52:40 377]CspksCreator.buildHeader()-->FCUBS_MSG_ID : 6121172000076994
[20210621 12:52:40 377]CspksCreator.buildHeader()-->CORRELATION_PATTERN:
[20210621 12:52:40 377]CspksCreator.buildHeader()-->CORRELID 1:
[20210621 12:52:40 377]CspksCreator.buildHeader()-->CORRELID 2:*
[20210621 12:52:40 377]CspksCreator.buildHeader()-->pstatus ->S, Fcdata req :Y
[20210621 12:52:40 377]CspksCreator.buildErrorNodes()-->Just Entered..
[20210621 12:52:40 377]CspksReqHandler.processMsg()-->calling cspksReqUtils.populateAuditLog()
[20210621 12:52:40 377]CspksReqHandler.processMsg()-->calling cspksReqUtils.updateOvdRemarks()
[20210621 12:52:40 377]CspksReqUtils.updateOvdRemarks()-->Just Entered6121172000076994/1/EXECUTEQUERY
[20210621 12:52:40 378]CspksReqUtils.updateOvdRemarks()-->Maker/Checkler Remarks :/
[20210621 12:52:40 378]CspksReqUtils.updateOvdRemarks()-->calling cspksReqWrapperDao.updateRemarksCstbRequestOvdMaster
[20210621 12:52:40 378]FCUtilityBean.updateRemarksCstbRequestOvdMaster()-->Query : Update Cstb_Request_Ovd_Master set Maker_Remarks = Nvl(?, Maker_Remarks),Checker_Remarks = Nvl(?, Checker_Remarks) where Msg_Id = ? AND Req_Seq_No = ?
[20210621 12:52:40 378]CspksReqUtils.updateOvdRemarks()-->Maker and Checker remarks Updated
[20210621 12:52:40 378]CspksReqUtils.updateOvdRemarks()-->Returning Success in updateOvdRemarks>>>>>
[20210621 12:52:40 378]GwpksServiceRouter.ProcessReqMsg()-->Calling logMessage()..
[20210621 12:52:40 379]FCUtilityBean.insertCstbsMsgLog()-->Query=insert into cstbs_msg_log(msg_id,source_code,msg_type,request, response,fc_response,status) values(?, ?, ?, ?, ?,?,?)
[20210621 12:52:40 383]GwpksServiceRouterMain.logMessage()-->Inserted CSPKS Req and CSPKS Res
[20210621 12:52:40 383]GwpksServiceRouter.ProcessReqMsg()-->Calling dedupeLogMsg()..
[20210621 12:52:40 383]FCHandlerMaintenance.processMsgUBS-->calling postProcessMessage
[20210621 12:52:40 383]FCHandlerMaintenance.inside postProcessMsg
[20210621 12:52:40 383]FCHandlerMaintenance.processMsgUBS-->processing for function=STDCIF
[20210621 12:52:40 383]FCHandlerMaintenance.processMsgUBS-->getting response SUCCESS
[20210621 12:52:40 383]FCHandlerMaintenance.processMsgUBS-->calling fcCtx.destroyContext
[20210621 12:52:40 383]FCJMISCEJBBean.getSMSDAO-->Creating connection
[20210621 12:52:40 383]FCJMISCEJBBean.getSMSDAO--> connection created
[20210621 12:52:40 383]SMSOracleDAO.getActionOnSequence-->select SMSQS_SMS_ACTION_LOG.nextval from dual 
[20210621 12:52:40 384]HostUpload.appendDebugs-->Calling insertActionLog
[20210621 12:52:40 384]FCJMISCEJBBean.getSMSDAO-->Creating connection
[20210621 12:52:40 384]FCJMISCEJBBean.getSMSDAO--> connection created
[20210621 12:52:40 384]FCJMISCEJBBean.insertActionLog-->sequence=169330
[20210621 12:52:40 384]FCJMISCEJBBean.insertActionLog-->msgStatus= SUCCESS
[20210621 12:52:40 384]FCJMISCEJBBean.insertActionLog-->Calling insertSmtbActionLog
[20210621 12:52:40 384]SMSOracleDAO.insertSmtbActionLog-->Query=insert into SMTB_SMS_ACTION_LOG (SEQUENCE_NO, ACTION_SEQUENCE_NO,ACTION, EXITFLAG, DESCRIPTION,PKVALS, CURR_BRANCH, HOME_BRANCH, TXN_BRANCH, REQ_TIME,OBIEE_STATUS,USER_ID,LOGIN_SEQUENCE_NO,MODULE_CODE,REQ_XML,RESP_XML) values(?,?, ?, ?, ?,?,?,?,?,?,?,?,?,?,?,?)
[20210621 12:52:40 388]FCClientHandler.doPost-->Checking respXML
[20210621 12:52:40 388]FCClientHandler.doPost-->calling updateToRES_FCUBS
[20210621 12:52:40 392]FCClientHandler.doPost-->PDP check - Time Captured Successfully
[20210621 12:52:40 392]FCClientHandler.doPost-->PDP check - Logs Captured Successfully