What steps will reproduce the problem? 1. select a table in the object browser 2. right click and select table ddl 3. repeat, it sometimes takes a few times until the error occurs

What is the expected output? What do you see instead? Expect output is the table ddl

Actual output is ------------------------ Execute ------------------------ Attempt to insert duplicate key row in object '#tmp00000130017331117' with unique index '_tmp_6986082971' Command has been aborted. ----------------- Done ( 1 errors ) ------------------

What version of the product are you using? On what operating system? Product version is 2007-11-19 Sybase dbms is 15.2.0 and 12.5.0 on Solaris 10 and 8 respectively

Please provide any additional information below.

I need additional information on this issue:

please do the following steps - start new session of the aseisql connect to the database where problematic object is located - open "object browser" and go into stubs page - rightclick on "select stubs/menu/table ddl" and select "paste" - specify a table name when prompted - execute the script - attach here the script and the error log (rightclick on the log and select "Copy All" while pressing Ctrl)

Comment deleted

Comment deleted

Comment deleted

Comment deleted

Comment deleted

Comment deleted

Comment deleted

I need errors only after first execution Please provide full log ( Ctrl + Copy all ) And please attach them as a files, so format will remain. (i will delete your previous posts)

Hi

Attached are the requested files.

Regards Glen

could you please generate DDL of this table using sybase central or something else

and publish it here.

the only thing that i can say now, ddl code have to be reviewed..

Okay something really weird. I could not actually remember what table I was looking at the generate the query_sql.txt file. It was something 'block' and a 'b'.

I thought I would look at the query_sql.txt to get the table name so I could get the ddl from Sybase Central. The query_sql.txt refers to the table 'b_block' except we do not have a table in our database with the name 'b_block'.

We only have tables named 'block_b' and another table named 'a_block_b'.

I cannot be sure but I am pretty confident the table I used before was 'block_b' and the ddl generated from Sybase Central is

USE traindb GO CREATE TABLE dbo.block_b ( report_id "linkno" NOT NULL, firs_premise_no "linkno" NOT NULL, circuit_no "tiny_line" NULL, location_of_detector "firs_code" NULL, level_of_detector "firs_code" NULL, type_of_detector "firs_code" NULL, type_of_alarm_call "firs_code" NULL, alarm_no "alarm" NULL, premises_name "short_line" NOT NULL, entry_server "srvname" NULL, row_no "rowno" NOT NULL, "timestamp" timestamp NULL ) LOCK allpages WITH max_rows_per_page=0, exp_row_size=0, reservepagegap=0, identity_gap=0 ON 'default'

GO EXEC sp_bindefault 'dbo.server_def','block_b.entry_server' GO EXEC sp_bindefault 'dbo.rowno_def','block_b.row_no' GO GRANT references ON dbo.block_b TO appadm GO GRANT select ON dbo.block_b TO appadm GO GRANT insert ON dbo.block_b TO appadm GO GRANT delete ON dbo.block_b TO appadm GO GRANT update ON dbo.block_b TO appadm GO GRANT references ON dbo.block_b TO appuser GO GRANT select ON dbo.block_b TO appuser GO GRANT insert ON dbo.block_b TO appuser GO GRANT delete ON dbo.block_b TO appuser GO GRANT update ON dbo.block_b TO appuser GO GRANT select ON dbo.block_b TO appview GO GRANT references ON dbo.block_b TO frsuser GO GRANT select ON dbo.block_b TO frsuser GO GRANT insert ON dbo.block_b TO frsuser GO GRANT delete ON dbo.block_b TO frsuser GO GRANT update ON dbo.block_b TO frsuser GO GRANT references ON dbo.block_b TO level1 GO GRANT select ON dbo.block_b TO level1 GO GRANT insert ON dbo.block_b TO level1 GO GRANT delete ON dbo.block_b TO level1 GO GRANT update ON dbo.block_b TO level1 GO GRANT references ON dbo.block_b TO sysadmin GO GRANT select ON dbo.block_b TO sysadmin GO GRANT insert ON dbo.block_b TO sysadmin GO GRANT delete ON dbo.block_b TO sysadmin GO GRANT update ON dbo.block_b TO sysadmin GO

Regards Glen

fixed in revision 66 new installer published