Using CVP 11.6 I am working on a simple DB lookup app that will match the area code to state and return that state to ICM. In Call Studio I am able to define session data when debugging to replicate what will be received from ICM successfully. My issue is after I deploy the app dial in. From the ActivityLog I see the parameter "area" being defined, however in the 'num_rows_processed' it is showing 0 results. From Call Studio I am showing 'num_rows_processed' as 1. From ICM I am calling the following application:
"application=AreaCode;area=Call.user.cvpapp.variable0"
I have dumped the contents of Call.user.cvpapp.variable0 into a PV and verified it is showing the correct value. I am not really sure what else to check as the CVP logs are not offering any insight into the issue and the ErrorLog dows not generate. Any guidance on this would be great. This is my first CVP app so maybe I missed something simple?