HTTP Web Server: Corrupt Data Exception

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
FCHINELLATOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FCHINELLATOAuthor 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

0
SysExpertCommented:
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 !


0
FCHINELLATOAuthor 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
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

SysExpertCommented:
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 !
0
marilyngCommented:
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

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

0
Sjef BosmanGroupware ConsultantCommented:
> 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.

0
marilyngCommented:
>>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
0
Sjef BosmanGroupware ConsultantCommented:
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
0
marilyngCommented:
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...
0
Sjef BosmanGroupware ConsultantCommented:
*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.
0
marilyngCommented:
So why don't you put it to a test and put a  replica of names.nsf on your server?
0
Sjef BosmanGroupware ConsultantCommented:
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 ;)
0
marilyngCommented:
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.
0
Sjef BosmanGroupware ConsultantCommented:
Strange that I can find very little info on this subject when you search the Internet.
0
marilyngCommented:
Sysexpert and I both contributed answers that seemed to resolve the problem.  sysExpert more than me.. was first in with the right suggestion.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.