I am moving the repository from Sybase to an Oracle database.
I followed steps already found in the forum, new repository tables have been created, even imported a solution successfully.
However the ‘users’ are not imported during solution-import. I do get a question “Do you wish to import the user info contained in the import?”
→ but no users are imported (hence solution cannot be used)
Possibly the problem is not in the import but already in the export of the solution.
→ When opening the created .servoy-file with winzip, the “user_info.xml” file is empty.
(So for me it looks like the user-data is not exported at all)
Thanks for reply! No such thing as silly questions…
→ I did check the “export users” box, however no users seem to be exported…
I did notice that I have two database-servers under Servoy-preferences: “repository_server” and “user_data”
→ The “repository_server” contains a number of tables including the servoy_users table.
→ The “user_data” contains no tables at all.
I’m seeing exactly the same thing you’re seeing. Exported a repository with an admin and a single User account set up. Tried importing into another instance of Servoy & solution imports fine except no users are imported. I tried every possible combination of adding vs. overwriting accounts, with the import administrator checkbox checked and unchecked, with pre-created accounts on the target server and with no accounts at all on the target server.
User info is not being exported. An examination of the xml file confirms what you report. The xml elements are declared and then there is no data.
I did the export straight from a development box (i.e, repository on same box) and users were set up using Developer.
Yes I too did the same about a week ago. Recreated a whole solution - fairly complex - and pointed it to an Oracle database (instead of the original iAnywhere ) and then also switched it to having the repository in Oracle too. Imported the solution into the new Oracle set up and found that I couldn’t open it because it didn’t recognize my username/password. Went back to the original solution and re-exported it after unchecking the ‘password required’ box or whatever it’s called. I just figured I had some ludicrous Oracle schema/password/instance combination messed up (I’m obviously not a big Oracle fan) and started recreating the users. But now it sounds like there is some sort of problem with Oracle and Servoy in terms of importing the users. Somebody want to file a report? I’m too tired right now…
Ah! … since Servoy also does not export definitions for tables/columns that are not actually put to use within the forms, methods and calculations, your explanation is consistent with an “only what is needed for the solution will be exported” rule. For those folks who may wish to use security only insofar as to control who can log in, but not to limit accessibility of forms/fields etc., this is an important detail to know.