Genesys Engage on-premises

 View Only

Discussion Thread View

  • 1.  Report not updated on GIM

    Posted 04-08-2021 07:07
    Dear Experts , 

    Since a month reporting data's are not updating to GIM database , i am not able get any report for these period through  GI2 BI tool . your kind input will help to resolve this 


    Regads
    #Reporting/Analytics

    ------------------------------
    Noufal Ibrahim
    SMASCO
    ------------------------------


  • 2.  RE: Report not updated on GIM

    GENESYS
    Posted 04-08-2021 10:23
    Hi Ibrahim,

    Please open a case with Care so we could check gim_etl logs on what is the reason for delay

    Regards,
    Sergii

    ------------------------------
    Sergii Prokhorov
    Genesys - Employees
    ------------------------------

    Original Message


  • 3.  RE: Report not updated on GIM

    Posted 04-08-2021 11:11
    i have no active support for this 

    logs shows below error

    021-04-08 13:34:19,051 DEBUG ecp-1-6311 35000 CLOSE: 1733469965; count 1
    2021-04-08 13:34:19,051 WARN ecp-1-6311 20049 Job step 'CORE_VOICE' failed. com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: batchUpdate; Uncategorized SQLException for SQL [INSERT INTO dbo.TMP_IRF_V (INTERACTION_RESOURCE_ID,INTERACTION_ID,PREV_IRF_ID,START_DATE_TIME_KEY,END_DATE_TIME_KEY,INTERACTION_SDT_KEY,PREV_IRF_SDT_KEY,RES_PREV_SM_STATE_FACT_SDT_KEY,MEDIATION_SEGMENT_SDT_KEY,LAST_MEDIATION_SEGMENT_SDT_KEY,RECEIVED_FROM_IXN_RES_SDT_KEY,TENANT_KEY,INTERACTION_TYPE_KEY,MEDIA_TYPE_KEY,TECHNICAL_DESCRIPTOR_KEY,MEDIATION_SEGMENT_ID,MEDIATION_RESOURCE_KEY,MEDIA_RESOURCE_KEY,RESOURCE_KEY,PLACE_KEY,LAST_RP_RESOURCE_KEY,LAST_QUEUE_RESOURCE_KEY,LAST_VQUEUE_RESOURCE_KEY,LAST_IVR_RESOURCE_KEY,RESOURCE_GROUP_COMBINATION_KEY,STRATEGY_KEY,ROUTING_TARGET_KEY,REQUESTED_SKILL_KEY,CREATE_AUDIT_KEY,UPDATE_AUDIT_KEY,GIDB_GIR_UPDATE_AUDIT_KEY,RES_PREVIOUS_SM_STATE_KEY,RES_PREVIOUS_SM_STATE_FACT_KEY,MEDIATION_START_DATE_TIME_KEY,MEDIATION_GUID,START_TS,END_TS,INTERACTION_RESOURCE_ORDINAL,IRF_ANCHOR,ANCHOR_FLAGS_KEY,LAST_INTERACTION_RESOURCE,LAST_MEDIATION_SEGMENT_ID,RECEIVED_FROM_IXN_RESOURCE_ID,LEAD_CLIP_DURATION,TRAIL_CLIP_DURATION,ROUTING_POINT_DURATION,QUEUE_DURATION,IVR_PORT_DURATION,HANDLE_COUNT,CUSTOMER_HANDLE_COUNT,PREVIOUS_MEDIATION_DURATION,MEDIATION_DURATION,MEDIATION_COUNT,MET_SERVICE_OBJECTIVE_FLAG,SHORT_ABANDONED_FLAG,DIAL_COUNT,DIAL_DURATION,RING_COUNT,RING_DURATION,TALK_COUNT,TALK_DURATION,HOLD_COUNT,HOLD_DURATION,AFTER_CALL_WORK_COUNT,AFTER_CALL_WORK_DURATION,CUSTOMER_DIAL_COUNT,CUSTOMER_DIAL_DURATION,CUSTOMER_RING_COUNT,CUSTOMER_RING_DURATION,CUSTOMER_TALK_COUNT,CUSTOMER_TALK_DURATION,CUSTOMER_HOLD_COUNT,CUSTOMER_HOLD_DURATION,CUSTOMER_ACW_COUNT,CUSTOMER_ACW_DURATION,POST_CONS_XFER_RING_COUNT,POST_CONS_XFER_RING_DURATION,POST_CONS_XFER_TALK_COUNT,POST_CONS_XFER_TALK_DURATION,POST_CONS_XFER_HOLD_COUNT,POST_CONS_XFER_HOLD_DURATION,CONF_INIT_TALK_COUNT,CONF_INIT_TALK_DURATION,CONF_INIT_HOLD_COUNT,CONF_INIT_HOLD_DURATION,CONF_JOIN_RING_COUNT,CONF_JOIN_RING_DURATION,CONF_JOIN_TALK_COUNT,CONF_JOIN_TALK_DURATION,CONF_JOIN_HOLD_COUNT,CONF_JOIN_HOLD_DURATION,CONS_INIT_DIAL_COUNT,CONS_INIT_DIAL_DURATION,CONS_INIT_TALK_COUNT,CONS_INIT_TALK_DURATION,CONS_INIT_HOLD_COUNT,CONS_INIT_HOLD_DURATION,CONS_RCV_RING_COUNT,CONS_RCV_RING_DURATION,CONS_RCV_TALK_COUNT,CONS_RCV_TALK_DURATION,CONS_RCV_HOLD_COUNT,CONS_RCV_HOLD_DURATION,CONS_RCV_ACW_COUNT,CONS_RCV_ACW_DURATION,AGENT_TO_AGENT_CONS_COUNT,AGENT_TO_AGENT_CONS_DURATION,PURGE_FLAG,CALLID,START_CALLID,PARENTCALLID,CALL_TERMINATED_TS,CALL_STOP_REASON,IRID,ENDPOINT_ID,ENDPOINT_TYPE,PARTYGUID,STATE,START_MSEC,STOP_ACTION,CONFERENCE_INITIATED_COUNT,CSEQ,START_CSEQ,REAL_END_TS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQLSTATE

    ------------------------------
    Noufal Ibrahim
    SMASCO
    ------------------------------

    Original Message


  • 4.  RE: Report not updated on GIM

    Posted 04-09-2021 09:14
    Noufal,

    • What version if ICON are you using?
    • What version of GIM are you using?
    • What are the expiration parameters around your ICON instance for CORE_VOICE?
    It looks like your ETL job doesn't like something that's in the GIM Database while it's trying to do transforms in your TMP_IRF_V table.

    If you're not getting your data into the system now, you could try flushing your GIDB tables.  Or restore from a backup taken prior to your impairment.  However, I would suggest that you follow Sergii's advice and open a case with Care.  If you do not have support on your product, it's all best effort and it seems likely you'll lose call data.

    ------------------------------
    Ivan Ullmann
    Global Technology Solutions, LLC
    ------------------------------

    Original Message


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources