Have a method to create a new user in Smart Client. It has been working for three years. Suddenly I can’t create a new user.
When I go into the the security section, I also cannot add a new user.
Tried to add a new user in the Servoy Application Server. Can enter the user name and password, click on ‘Create User’ and it gives me the message that a new user has been created. However, there is no new user. I’m stumped.
This is a real problem. Any help would be greatly appreciated. K
Hi Kurt, did you upgrade recently, what Servoy are you using, what os etc…
Hi Marcel,
My development computer is using 3.5.9 and the production server is 3.5.7.
About a month ago we moved from MSQL to Sybase and I’m pretty sure we have set up some new users since that time. (but not positive)
Development computer is OSX 10.4.11. Not sure what is at the data center.
no errors in the log?
For example maybe the sequences are out of sync and it tries to insert a duplicate pk now.
Greg at Adblocks, where c3net is hosted, fixed it. He writes,
“I think I have resolved the issue that you were having with creating new users. It ended up being a bad index in the repository for the users table. I deleted and recreated it and it appears to work fine now.”
Everything works now. Thanks for the help. K
Just had this same problem that I had never seen before & thanks to the forum and this post, fixed!
Slightly scary that something like this happens.
What else might or might not be working in Repository if other indexes go wrong?
Do I need to rebuild all the indexes on all tables on ‘servoy_repository’ database?
Rafi