UCS DB Entries and Primary IXN and Backup IXN Server

[upk_singhm]

Hi All,
Can you tell if the DB entries in the Interactions table in the UCS DB are anyhow linked the Primary or Backup IXN server?

The challenge that I'm facing is thru my custom built search I'm not able to search records for a particular date in Sep-15. And on that day my Primary IXN server had gone and the system made a switch to the backup IXN Server. So on that day all the entries in the UCS DB were happening through the backup IXN server.

I'm just trying to figure out if at all there's a link between the two or when running this search do I have to mention something else for these records to be searchable. My Search module is built on top .NET using Genesys PSDK 8.X.

Appreciate your help.

Regards,
Upkar S

[Kubig]

Within the IXN database are just interactions, which are currently processed by the IXN component at the moment. Within UCS database should be all interactions processed within your environment. The only relation between that are on ID parameter.

[cavagnaro]

In other words, when IXN processes the interaction it is deleted from its database, remaining only on UCS one for historical purposes

[upk_singhm]

Hi Kubig,
I just found out what could be causing this, it could be related to the UCS index on Primary and Backup UCS application Servers. I guess the best practices as mentioned by Genesys in it's documentation for such a setup needs to be applied.

I will keep you posted if that helps me anyhow.

Thanks for your response though.

[Kubig]

If you are using index, you have to store them on some "shared" folder to have one access from both UCS instance. Just follow the docs. BUT, indexing is not necessary to storing the data to the database, so I think this should be not a root-cause.

[upk_singhm]

Yes that's exactly the content I was referring to, but the data is there in the DB but just not showing through the search.

That's why I was trying to find out if there's any link between the Primary/BKUP UCS or IXN server and the way IXNs get stored with in the UCS DB.

As I'm able to search the contact if I use the contact index but not through the interaction index, that's why I think that best practice might be reason here, let me find out more about the setup and I will let you all know the findings.

Appreciate your help.

[Kubig]

Understand, if you have build your app based on UCS API (where Lucene query are used), you have to configured index on UCS level properly, to allow you to search interactions/data through the Lucene query.

Check your index (index.interaction) configuration and the current status. You can easily rebuilt the index on demand.

[upk_singhm]

Hey Guys,
I found out what's the problem, (Is there a way to mark a thread as solved.).

Anyhow, you see when you configure an Lucene Indexing on UCS application server in a HA environment one thing has to be considered which is to host the indexing on a common storage so that even if your system hops from Primary to Backup your indexes are getting written to a common place to which your desktop application can refer to irrespective of which app server is Active one at the moment. This is detailed inside a Multimedia documentation under 8.X series.

Hope I was of help to someone...

You guys are my best help when it comes Genesys, keep up the good work.

Regards,
Upkar S

[Kubig]

This is just for 8.1 eServices, I guess. Within 8.5.1 is the index located locally under each UCS instance, so the shared folder is no longer required.

[upk_singhm]

Hi Kubig,
If I get your response or question right, that's the thing whether 8.1 or 8.5 if you have UCS in HA, then if the Index is stored on the local instance of each UCS's own file system then when the backup to Primary switch happens then any index stored on the backup instance isn't available on the Primary, so when Primary becomes active again any user doing the search will not have access to indexes on the backup. Hence the need to have shared index location.

Hope it helps.

Thanks,
Upkar S

[Kubig]

It was not question - just state. And as I said, the shared folder is no longer required.

[cavagnaro]

And how they sync?  You have link to docs explaining that Kubig? Or what changed?

[Kubig]

[quote]UCS can now manage Full Text Search files locally on Primary and Backup applications. Index files no longer need to be shared on the network when the Primary and Backup are not on the same host. For more information, see Collocated and Distributed Deployment section of eService Administrator's Guide. (ESR-7256)[/quote]

[upk_singhm]

Yes how do they sync? If that's possible then I need to check what version is my customer on.

Sent from my Z30 using Tapatalk

[cavagnaro]

Ohhhh good answer