Hello Guys,

I am getting the following error on Sybase Adaptive Server 15
Error 1581
"Create index was aborted because pages in the data only locked table
are not linked"

By the way... - the table is an ALL PAGES SCHEME!

I firstly create a table
-------------------------------
create table temp_liz
    (
     log_id   int
    )

Then I select into this table from other tables in a join clause. (in
the real script)
but this also causes the error...
----------------------------------------------

select log_id
  into temp_liz
 from temp_LL  - just dummy names of course:)

Then I create a clustered index on the leading column which includes
the "with sorted_data" option and others, like "with consumers = 4"
--------------------------------------------------------------
create clustered index idx_liz
     on temp_liz (log_id)
with sorted_data, consumers = 4

Even though this is NOT a "DOL" (data only locked) table, I still get
the issue
NB: sp_help reports ALL PAGES locked scheme. (Lock scheme Allpages)

Our Sybase server version is:
Enterprise 15.0.2 EBF 15093 ESD#2PSun_svr4OS 5.8ase1502251664-bit
FBOThu Dec 20 040537 2007

On another Sybase installation, I only get this error:
--------------------------------------------------------------------------

Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/
ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006

Create index with sorted_data was aborted because of row out of
order.
Primary key of first out of order row is '1018'
Msg: 1530, Level: 16, State: 2

I am aware of the issue surrounding the with SORTED_DATA on a DOL
table, but like I said this is an ALL PAGES Locked scheme and the data
was not bcp'ed into the table.

Any ideas, will help a lot!
Liz