We are using SQL/Anywhere 16. We started having trouble with Sybase Central crashing when we clicked "users" or "roles". When I looked at the error message that was being generated, it was reporting an error 'user "BugsBunny" already exists in user map. I did a DROP USER BugsBunny, and it executed OK. Now Sybase Central can load the "Users" and "Roles" lists.

I tried to re-create the user "BugsBunny" in Sybase Central, and it fails with a "User already exists" error. I did "select * from sysusers", and BugsBunny is not there.

I'm stumped on where to look next.

asked 12 Jan, 16:57

Bud%20Durland%20MRP's gravatar image

Bud Durland MRP
46127
accept rate: 0%

edited 12 Jan, 16:57

I am curious, what if you unload the DB to CSV files. Would you find "BugsBunny" there?

(13 Jan, 15:35) Vlad
Replies hidden

Is it possible you have created two or more databases, and from time to time you click on the wrong entry in Sybase Central?

Or, is it possible you are using Sybase Central for some operations, and ISQL for other operations, and they are connected to different databases?

(14 Jan, 08:39) Breck Carter
Replies hidden

That's actually my plan for today. It's a 50+ GB database, so first I'm going to do a "no data" unload and look at the resulting SQL.

(2 days ago) Bud Durland MRP

We do have a copy of this database that we use for testing and training. Because this started as an error in Sybase Central that started happening after a flurry of patches and updates, that was one of the first things we tested -- does it occur in the test database, and it does not.

(2 days ago) Bud Durland MRP

No Joy. loading the the .sql file created by a "no data" unload into an editor shows not traces of BugsBunny. I can unload the data files & see if he appears there, but I suspect that will be pointless, since the data is user tables, not system tables.

(20 hours ago) Bud Durland MRP

What if you create the user via SQL?

(20 hours ago) Vlad
showing 2 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×105
×18

question asked: 12 Jan, 16:57

question was seen: 68 times

last updated: 20 hours ago