Troubles with UCS DB

Voice & Telephony
1

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

12:56:29.488 Std 20017 [MsgIn-16] 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(‘e’) )) and (EmailIn.Id = Interaction.Id) and (ROWNUM <= 2) in transaction : 330852004@txn-null with timeout=60] - ORA-01425: escape character must be character string of length 1
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[<[email removed]>] AND class com.genesyslab.icc.api.contactserver.persistent.EmailIn Mailbox LIKE java.lang.String[[email removed]] )
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!
ORA-01425: escape character must be character string of length 1
It is very weird!
we are using linux Rad hat 6.x (UCS)
Genesys eServices version 8.1.3.xx
DB ORACLE 10g (server)
client (11g)

anybody can help me??

Thanx

2

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.

3

Yes, but the client its ok!

4

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.