MCR for email handling help

[René]

Hi Cavagnaro,

It seems to me there is some issue on database side. What version of UCS server and database is used by the customer? Have you made any upgrade of UCS in the past?

R.

[cavagnaro]

Yup, from db 7.2 to 7.5 and now 7.6...but between 7.5 and 7.6 was very fast (2 weeks) and I don't remember really if they tested on 7.5...
What would you recommend? To recreate the DB? I have no problem with that...

Thanks a lot René, as always

[René]

Hi,

I assume you did but have to ask - have you applied update SQL scripts against UCS 7.2 database when doing upgrade of UCS? It could be a cause of your issue if you didn't.

R.

[cavagnaro]

Yeah I remember I did...at least on 7.6...
Will re-run them and see if any error raises on SQL...

[cavagnaro]

Deleted all DB, recreated (MCR_UCS, MCR_UCS_Archive and MCR_IS) and still have the error. MCR_EmailJavaServer has connections to:
MCR_UniversalContactServer
MCR_InteractionServer

Does EJS needs connection to a DBServer?

[René]

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?

[cavagnaro]

Not an error but I found this very strange:

[quote]
12:19:05.161 Dbg 29999 [68.90.45:24] <Genesys_Desktop_760> Beginning Transaction txn-32 for DataSource Main with Connection : txn-32
12:19:05.161 Trc 21132 [68.90.45:24] <Genesys_Desktop_760 txn-32> Inserting persistent object from class 'com.genesyslab.icc.api.contactserver.persistent.EmailOut'.
12:19:05.161 Dbg 29999 [68.90.45:24] <Genesys_Desktop_760 txn-32> 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] <Genesys_Desktop_760 txn-32> Inserting persistent object from class 'com.genesyslab.icc.api.contactserver.persistent.Interaction'.
12:19:05.177 Dbg 29999 [68.90.45:24] <Genesys_Desktop_760 txn-32> 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] <Genesys_Desktop_760 txn-32> Commit Transaction txn-32 for Connection : txn-32
12:19:05.192 Dbg 29999 [68.90.45:24] <Genesys_Desktop_760 txn-32> [Main DS] Returning connection into the pool.
12:19:05.192 Dbg 29999 [68.90.45:24] <Genesys_Desktop_760 txn-32> Transaction duration: 31 ms (32)
12:19:05.192 Trc 21100 [68.90.45:24] <Genesys_Desktop_760 00001a4G40KE003M> Entity EmailOut 00001a4G40KE003M created
[/quote]

Are the "? ? ? ? ?" supposed to be like that?

[catanirex]

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.

[cavagnaro]

Hum, nop only letters used.

[René]

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.

[cavagnaro]

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...

[catanirex]

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?

[cavagnaro]

It is "AutoRespuesta" (Autoanswer).
I'm using MSSQL, I deleted all the DB and started from scratch running all sql scripts...same problem.

[René]

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.

[cavagnaro]

Hey René,
Versions in the JPEG file
MS SQL 2000 SP4 Enterprise Edition

Thanks