Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to locate index 'default' on table

Status
Not open for further replies.

ltc9

Programmer
Mar 9, 2007
1
CA
I created a table w9smsp with index k-w9smsp.

But when I run my progress program, I got this error
Unable to locate index 'default' on table 'w9smsp' for procedure 'w9sm001.p'. (7967)

Can anyone tell me what does this error mean?

Thanks.
 
ltd9,

from the progess editor help:
Unable to locate index '<indexname>' on table '<tablename>' for procedure '<procedure>'. (7967)
When the named procedure was compiled, it referenced (either implicitly or explicitly) the named index for the named table. When any procedure is run, Progress verifies that all the referenced tables and indexes are present in the database schema. This verification failed because the named index was not present. You need to ensure that all the tables and indexes your procedure uses from your development database are present in your production database.

regards,
longhair
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top