No, it doesn’t. All operations over UCS database are processed by Universal Contact Server.
Could you check UCS log if there is any error?
Not an error but I found this very strange:
12:19:05.161 Dbg 29999 [68.90.45:24] Beginning Transaction txn-32 for DataSource Main with Connection : txn-32 12:19:05.161 Trc 21132 [68.90.45:24] Inserting persistent object from class 'com.genesyslab.icc.api.contactserver.persistent.EmailOut'. 12:19:05.161 Dbg 29999 [68.90.45:24] Executing request : insert into EmailOut WITH (ROWLOCK) (EmailOut.Forward, EmailOut.Id) values (?, ?) in transaction : txn-32 with timeout=0 12:19:05.177 Trc 21132 [68.90.45:24] Inserting persistent object from class 'com.genesyslab.icc.api.contactserver.persistent.Interaction'. 12:19:05.177 Dbg 29999 [68.90.45:24] Executing request : insert into Interaction WITH (ROWLOCK) (Interaction.StartDate, Interaction.EntityTypeId, Interaction.Id, Interaction.TypeId, Interaction.TenantId, Interaction.CreatorAppId, Interaction.SubtypeId, Interaction.ThreadId, Interaction.Status, Interaction.MediaTypeId, Interaction.CanBeParent, Interaction.Timeshift) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) in transaction : txn-32 with timeout=0 12:19:05.192 Dbg 29999 [68.90.45:24] Commit Transaction txn-32 for Connection : txn-32 12:19:05.192 Dbg 29999 [68.90.45:24] [Main DS] Returning connection into the pool. 12:19:05.192 Dbg 29999 [68.90.45:24] Transaction duration: 31 ms (32) 12:19:05.192 Trc 21100 [68.90.45:24] Entity EmailOut 00001a4G40KE003M created
Are the “? ? ? ? ?” supposed to be like that?
For me it looks like there is a : character in the ack name?
Names of Knowledge Manager objects can consist only of alphanumeric characters (A–Z, a–z, 0–9), hyphen
(-), underscore (_), and space.
1 Like
Hum, nop only letters used.
Hi Cavagnaro,
The question marks in UCS log don’t represent any issue as UCS uses so called prepared statements. You can change the option “interpret-prepared-statements” on DAP object to “true” if you want to see real values.
Do you still have problems described in previous posts?
R.
Yeah…have no idea what happened…customer by luck doesn’t need the service at this moment as he his changing service methods. However I want to fix this ASAP…don’t like to have deads above…
For me it looks like the acknowledgement is called “Autorespues:a” in the picture you uploaded?
Are you using Oracle or Microsoft SQL as db? Have you checked db for locks?
It is “AutoRespuesta” (Autoanswer).
I’m using MSSQL, I deleted all the DB and started from scratch running all sql scripts…same problem.
Cavagnaro,
Could you post here following information:
- exact version of Interaction Server, Universal Contact Server, Email Server Java, URS
- type and version of database system
R.
Hey René,
Versions in the JPEG file
MS SQL 2000 SP4 Enterprise Edition
Thanks
Hi Cavagnaro,
Could you please set the option “interpret-prepared-statements = true” on UCS DAP and repeat the test. I’m pretty sure the issue relates to database e.g. conflict with configured database regional setting etc.
R.
Hum…I enabled that option and restarted DBServer and now acknowledge began to arrive…???
I have now a more solid idea on how this stuff works…will keep doing some further tests…
Thanks a lot René!
:o
That’s really strange. Have you restarted Genesys DBServer or database server (MSSQL)? UCS connects to the database directly using JDBC driver and don’t use DBServer…
R.
Well, yesterday we did a complete server restart but for another issue…maybe that is what I needed to do before. I was restarting only DBServer and MCR components and yesterday didn’t test that as was no part of our problem.
Interesting to know that UCS connects directly to DB.
As usual very helpful René 