We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

HTTP Web Server: Corrupt Data Exception

FCHINELLATO
FCHINELLATO asked
on
Medium Priority
1,172 Views
Last Modified: 2013-11-16
Hi ,

We have develloped there is 3 years ago, a database in R5 version (our server is in 6.0.2). We make evolution and update during 2 years, and we used it correctly during this last year.

This web application is a database used 'exclusively via http' and connected with an oracle Database.

All was perfect but .. there is 2 or 3 week an error 'HTTP Web Server: Corrupt Data Exception' or in other case 'HTTP Web Server: Lotus Notes Exception - Entry not found in index' appear then we try to "discuss' with the oracle database.

Seeing this problem we decided to restore an 4 week backup, and all whas corrected.

But every time we restore it, few time after the problem is back !!!

I suspect an index task to corrupt somethink ???

Do your have idea ?

Thanks
Please, sorry about my pure english. It'snt my natural language

Franck Chinellato
Comment
Watch Question

Author

Commented:
I forgotten the most important:

We have 2 databases identical on our directory /lotus/data/corporate.

One is called hse-fr.nsf and the other is hse-us.nsf and ...

The us database work fine, and just the 'french' have a problem yhen, I try to write in the Oracle DB

CERTIFIED EXPERT
Top Expert 2007

Commented:
DId you check theNoets logs for any issues ?
Did you do a compact and / or Updall to try to fix the French DB ?

Is it possible that the data is incompatible with Oracle, perhaps some unknown character set ?

I hope this helps !


Author

Commented:
Thanks.

I believe I'm in the rigth direction.

The two database was with the same replica ID.

I suppose it can generate  a 'melting pot' with the index.

I'm waiting few days before confirm if this is corrrect.

Franck
CERTIFIED EXPERT
Top Expert 2007

Commented:
I would definitely make sure that the replicas have different ID's. It is never a good idea to have two databases with the same replica ID on the same server, since it definitely can cause replication issues.

I hope this helps !

Commented:
After you remove the replica that you don't want on the server, you should delete the index (if one exists).  (you will see a .FT folder on the server with the database name)

Delete a full-text search index when you no longer need it, when you need to the change the index options, or when you discover problems with the index.
  1.      From the Domino Administrator, select the server that stores the database or databases.
  2.      Click the Files tab.
  3.      Using the Tools pane, make sure that you have at least Designer access in the ACL of any database for which you want to delete the index.
  4.      Select all the databases for which you want to delete the index.
  5.      From the Tools pane, choose Tools - Database - Full Text Index.
  6.      Select Delete.
  7.      Click OK.

Then compact & updall as SysExpert suggests

Author

Commented:
Thanks.

There is 2 days, I separated replica ID. There is 2 days that each database is UNIQUE.

And today, all seems to be fine, yet !

I'm waiting 2 or 3 days more, and if all is correct, the topic will be closed.

Thanks for your anwsers.

Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
> I would definitely make sure that the replicas have different ID's.
> It is never a good idea to have two databases with the same
> replica ID on the same server, since it definitely can cause
> replication issues.
NOT TRUE!! In R6, multiple replica databases can exist on the same server. Indexing: no problem. But it would in fact explain why the problems reappeared. Maybe, separating both databases wasn't such a good idea after all, since a single update must now be done in both databases.

It should be enough to compact and to remove/re-create views.

Commented:
>>NOT TRUE!! In R6, multiple replica databases can exist on the same server. << NOT TRUE, Notes does not support this configuration if you mean Database ABC with ReplicaID=123 and Database DDD with ReplicaID = 123 sit on the same server: Server A

http://www-1.ibm.com/support/docview.wss?rs=0&q1=Database+Replicas&q2=multiple&uid=swg21096344&loc=en_US&cs=utf-8&cc=us&lang=en
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
Quote:
    "Unlike Domino v5, Domino v6 will quite happily replicate with multiple databases on the same server with the same replica ID"

From:
    http://www.pmooney.net/dload/bp106.pdf

Commented:
Well, my dear, the title of the piece was: Worst Practices in IBM... and the particular quote referred to roaming users whose personal address books all had the same ID, and where everyone was seeing information in the other's address books, and causing the server processor to run rampant (yah, you think? I replicate to A, so now A has new documents so I replicate to B, now B has new documents so I replicate to A....)

The resolution was to replace all the replica id's on the personal address books so that they were not replicas.  

Again, IBM does not support having replicas with the same replica ID on the same server...
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
*Grunt* You're right...

Though I must say the comment in the IBM-link you gave wasn't very conclusive about versions other (higher) than 6.0 and 6.5.

Commented:
So why don't you put it to a test and put a  replica of names.nsf on your server?
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
That's a good idea, I'll let you know what happens. Should I make a backup beforehand?

I think I'll test with admin.nsf or so ;)

Commented:
Not a good test unless you use a very active database.. I can tell you the result, but I wouldn't want to spoil the surprise.
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
Strange that I can find very little info on this subject when you search the Internet.
Commented:
Sysexpert and I both contributed answers that seemed to resolve the problem.  sysExpert more than me.. was first in with the right suggestion.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.