Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Filippe on June 03, 2015, 02:25:48 PM

Title: Troubles with UCS DB
Post by: Filippe on June 03, 2015, 02:25:48 PM

Hi guys,
Im facing a trouble with UCS database, that returns the following error:

12:56:29.488 Std 20017 [MsgIn-16] <pop-client1> An exception occurred in Genesys E-mail Server.
com.genesyslab.icc.esp.ESPException: 15:56:29.487 Server: UCSP Msg: Unexpected error (java.sql.SQLException: Error executing stmt [select EmailIn.Id, Interaction.TenantId from Interaction, EmailIn where ((Interaction.ExternalId = ?) and (EmailIn.Mailbox like ? ESCAPE UNISTR('') )) and (EmailIn.Id = Interaction.Id) and (ROWNUM <= 2) in transaction : 330852004@txn-null with timeout=60] - ORA-01425: [b]escape character must be character string of length 1 [/b]
Constraint=Constraint on : class com.genesyslab.icc.api.contactserver.persistent.EmailIn
Attributes :
class com.genesyslab.icc.api.contactserver.persistent.EmailIn Id [null]
class com.genesyslab.icc.api.contactserver.persistent.EmailIn TenantId [null]
Constraints :
( class com.genesyslab.icc.api.contactserver.persistent.EmailIn ExternalId EQUAL java.lang.String[<SNT148-W79EBAC5D55ED45FCC1D5C4B1FC0@phx.gbl>] AND class com.genesyslab.icc.api.contactserver.persistent.EmailIn Mailbox LIKE java.lang.String[*ventas@cablevision.com.ar*] )
Joins : NONE
Orders : NONE
- Vendor Code=0, SQLSate=null)
at com.genesyslab.icc.emailserver.contactserver.ESPContactServer.sendRequestToClient(ESPContactServer.java:187)
at com.genesyslab.icc.emailserver.contactserver.ESPContactServer.countInboundInteraction(ESPContactServer.java:1404)
at com.genesyslab.icc.emailserver.InboundMessagingClient$MessageHandler.handleMessage(InboundMessagingClient.java:1548)
at com.genesyslab.icc.emailserver.InboundMessagingClient$MessageHandler.run(InboundMessagingClient.java:1375)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at com.genesyslab.util.concurrent16.NamedThreadFactory$1.run(NamedThreadFactory.java:55)
at java.lang.Thread.run(Thread.java:701)

This log is from E-mail Server, but in UCS log we saw the same error!
[b]ORA-01425: escape character must be character string of length 1 [/b]
It is very weird!
[b]we are using linux Rad hat 6.x (UCS)
Genesys eServices version 8.1.3.xx
DB ORACLE 10g (server)
client (11g)[/b]

anybody can help me??

Thanx

Title: Re: Troubles with UCS DB
Post by: Kubig on June 03, 2015, 02:36:16 PM

Did you try to execute the query directly through the database? It can be caused by mismatch of client and server version of Oracle. It is not recommended to use different version of client and server.

Title: Re: Troubles with UCS DB
Post by: Filippe on June 03, 2015, 02:40:06 PM

Yes, but the client its ok!

Title: Re: Troubles with UCS DB
Post by: Kubig on June 03, 2015, 02:51:21 PM

And within the database the query result was? I did say that the client is not ok, but it is not recommended to use mismatch version - it should work, but can leads to some tricky issues.