I need your help regarding an weird issue I have been facing for last couple of days. My platform is ICM 7.2(7), CVP 3.1, CCM 4.2. UCCE is collecting/quering data from Oracle DB through Application GatewayHost provided by Cisco itself through ODBC connections. I can query fine and get data through GatewayHost (I have tested it #1.From GatewayHost Simulator, #2.Call Trace on ICM Script). But the problem is sometime CVP can't play the data correctly(and play 'zero' instead of correct data) and even sometime the VRU node just fails. I have 5 CVPs so I'm guessing 1/2 of them can't play the data correctly while the call is routing to them. But I can't find the failure events on CVP Monitor consoles, so may be my guessing is wrong, i'm not sure!
I think I have explained the issue clearly, can anyone advice me how to troubleshoot? Where the issue can be, at CVP, VRU PG or even the DB Connections? I'm still confident on ICM script and even the database connections.