Getting this Error Number 20 Occurred: Invalid index

system · December 20, 2005, 5:28pm

I am getting this error in the Publisher.

“(20) Error Number 20 Occurred: Invalid index”.

Its bugging me from past 5 days.

Pls help on this!!

Thanks

Genny (BOB member since 2005-11-08)

system · December 20, 2005, 8:00pm

Hi,

this looks like a problem of the database origin. You should contact your DBA and show him the SQL that BO runs against the database. He should be able to recognize what table and what index cause this problem.

Marek

Marek Chladny (BOB member since 2003-11-27)

system · March 4, 2010, 3:26pm

Hello,
The problem was that a user redefined the report and changed one of the TAB’s names.
I redefined the “e-mail content”, deactivated the publication, and activated the publication again.
Hope this helps

Pau (BOB member since 2006-06-03)

system · May 12, 2010, 7:44am

Hello,

Over time on BO6.5.x I’ve had this error raising on my production environment.

There are mainly 2 causes:

The TAB name has been changed/eliminated
The TAB name has punctuation marks (llike accents)

Pau Fores

Pau (BOB member since 2006-06-03)