Kbase P126352: MS SQL Server DataServer schema pull produces WARNING: No possible RECID-Index found for table <tabl
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
Windows
OpenEdge 10.x
SYMPTOM(s):
MS SQL Server DataServer schema pull produces WARNING: No possible RECID-Index found for table <tablename> (Owner: <owner>)
Schema pull of a MS SQL Server database produces errors
ds_upd.e contains one or more errors:
WARNING: No possible RECID-Index found for table <tablename> (Owner: <owner>)
CAUSE:
The tables mentioned within the error message(s) have an MS SQL Server column that is of an Identity data type.
The Progress MS SQL Server DataServer does not support the MS SQL Server Identity data type.
FIX:
Review the OpenEdge Data Management: DataServer for Microsoft SQL Server section titled "Modifying tables to create PROGRESS_RECID in support of the ROWID function". This chapter discusses the situation where Identity data types are being used, and how to select an index to support the ROWID function.