Database Issues 5.8.5.0 Windows

[Danny Wheeler]

We are trying to create a document interface to integrate Siemens EDM with Precyse CAC.  We have had document interfaces in the past but not with this volume.  We are running into a issue where if a message fails it halts the interface and backlogs all of these messages in the recovery database.  When we try to clear the recovery database it freezes the database manager and locks the database for all processes basically bringing down the entire site.  Even if I stop the HCIDBDUMP process in the task manager it keeps the database locked.  I have tried the hcisitectl -K and -S to try and free these locks but it seems to only be working the monitor daemon.  The only thing that fixes this is to do a site cleanup.  

My questions:

Are there file size limits in Cloverleaf for these types of interfaces?  I am using MLP_PDL and it seems to happen mostly on files 7mb or larger.

Is there a way to free the DB locks without doing a site cleanup in Windows?

If I create a site just for this interface will it use a different database or will it continue to lock the database used by our other production threads?

Topic

[Russ Ross]

One of the big advatages to mutiple sites is that each site gets its own database, thus reducing DB contention.

We have run into the case were a bad interface had to be placed in its own site to keep it from adversely impacting the other good interfaces in a site.

Then this buys us some time to eventual improve the bad interface without hurting the good interfaces so much in the mean time.

So far I’ve been able to negotiate not sending actual documents and instead send pointers to the documents thru the interface so I never sent anything near 7MB across.

I have a gut feeling from inital conversation related to impelemnting EPIC that I might see the day I have to pass actual base64 encoded documents thru Cloverleaf.

Perhaps others can comment on the largest message size they have sent across an interface shared with multiple routes and xlates.

Russ Ross
RussRoss318@gmail.com

[Danny Wheeler]

Thanks Russ.  I created this secondary site and it is helping with the issues so far.  This will allow us to continue to try and bring this live without causing so many pains in the current PRD site.

[Author]

Replies