Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: KuroiKat on April 28, 2014, 11:36:25 PM

Title: Info Mart CONTACT_ATTEMPT_FACT Table
Post by: KuroiKat on April 28, 2014, 11:36:25 PM

Hello,

I am trying to setup Info Mart. I have that working so far and I tried making a test call. However I do not see any data in the CONTACT_ATTEMPT_FACT table, is this suppose to populate? How do I get data into the table ?


Thanks in advance

Title: Re: Info Mart CONTACT_ATTEMPT_FACT Table
Post by: Kubig on April 29, 2014, 05:33:36 AM

Was the test call outbound campaign? What says logs - do you see that the OCS sent the data to the ICON and ICON properly received data? What about content of go_* tables? Little bit more information, please...

Title: Re: Info Mart CONTACT_ATTEMPT_FACT Table
Post by: KuroiKat on April 29, 2014, 03:31:29 PM

Sorry I am still new to this. What are the GO_* tables for? They are all empty. Looking at the log files, I don't see any error messages.
My OCS db server log has something like this:
09:22:09.275 Dbg 10741 'App: 2' has put request id='26376' type='MSG_EXECSQL' into queue
09:22:09.275 Dbg 10739 select T.* from #ReadyRecord R, Jarrod T where R.chain_id=T.chain_id and T.record_status = 2  order by T.chain_id,T.chain_n
09:22:09.275 Dbg 10737 Forwarding request '26376' from 'App: 2' to 'MS SQL: 2.1'
09:22:09.275 Dbg 10743 'MS SQL: 2.1' is spare
09:22:09.275 Dbg 10749 Forwarding response '26376.1' from 'MS SQL: 2.1' to 'App: 2'
09:22:09.275 Dbg 10739 ODBC: id='2.1' req='26376' SQL: select T.* from #ReadyRecord R, Jarrod T where R.chain_id=T.chain_id and T.record_status = 2  order by T.chain_id,T.chain_n
+0000  Executed SQL statement 'SELECT', start retrieve records...
+0000  MSG_RETRIEVED status='DBM_EMPTY'

09:22:09.275 Dbg 10741 'App: 2' has put request id='26377' type='MSG_EXECSQL' into queue
09:22:09.275 Dbg 10739 TRUNCATE TABLE #ReadyRecord
09:22:09.275 Dbg 10737 Forwarding request '26377' from 'App: 2' to 'MS SQL: 2.1'
09:22:09.275 Dbg 10743 'MS SQL: 2.1' is spare
09:22:09.290 Dbg 10749 Forwarding response '26377.1' from 'MS SQL: 2.1' to 'App: 2'
09:22:09.290 Dbg 10739 ODBC: id='2.1' req='26377' SQL: TRUNCATE TABLE #ReadyRecord
+0016  MSG_SQLEXECUTED status='DBM_SUCCESS'


In my ICON db server log I do have a warning:
WARNING: Unable to bind server to 4051, rebind schedules in 10 seconds.


Thank you

Title: Re: Info Mart CONTACT_ATTEMPT_FACT Table
Post by: Kubig on April 30, 2014, 08:39:13 AM

New in Genesys as I see ..

What version if GIM are you using? As I ask before, what about communication between OCS a related ICON ( I do not mean DB server operations)? I suggest to check ICON logs covering the test calls and find out if there are information from OCS or not, and if ICON works properly with them