Kbase 20306: WARNING: No Possible RECID-Index Found for Table xyz
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/2/2008 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
MS SQL 7
SYMPTOM(s):
WARNING: No possible RECID-Index found for table xyz
37000 [Microsoft][ODBC SQL Server Driver][SQL Server] Line 1: Incorrect syntax near ).
CAUSE:
The WARNING message is caused when Progress is unable to find a valid index in the source table that can be used to implement the progress recid function. The message occurs when you perform a schema pull, and it is found in the ds_upt.e file that is automatically created in your current working directory. If you have multiple tables with a 'no RECID-Index reference', it is possible to get error 37000 ODBC error when you query both tables within the same procedure block.
FIX:
Create a unique, not null, index on the offending table and perform the schema pull again.