V3B1 Can't Create Users in Oracle? Stuck in the Gate

Classic Servoy
1

OK,

I went back to my V2 solution and turned off “login required” and tried again.

I exported with users

Back in V3, I imported. I can get into my solution due to turning off the login requirement. No users were created, even though Servoy asked me if it was OK, and I said “Yes”.

Now when I try to create a new user in my imported app. I get this error:

ORA-01400: cannot insert NULL into (“SERVOY_APP”.“SERVOY_USERS”.“USER_ID”)

I also attempted to create a new Solution in V3 and had the same problem.

Can anyone assist?

Thanks,
Lee

Some additional Info.

I am running against an Oracle10g Database for all the data and repository.

I deleted the Repository and attempted a New Solution setup and have the same problem, so I am surmising this is not an issue with the imported solution.

I believe the problem with my Imported Users not coming in is the same problem. Basically the code to insert users is failing. The table is there and OK in Oracle, so I’m not sure what to do?

2

did you fill in the SCHEMA name in your connection settings? If you don’t oracle will give all kinds of funny errors.

3

jaleman:
did you fill in the SCHEMA name in your connection settings? If you don’t oracle will give all kinds of funny errors.

Jan:

Not sure what you mean?

I’m using the connection string that Servoy provides with the Automatic connection setttings. I copied the same connection strings into my V3 version. They work fine in 2.x versions.

The error is occuring in the repository db and user.

Can you give me an example?

Thanks,
Lee

4

SCHEMA is a way of splitting a large DB with lots of tables into more manageable chunks, both from a logical point of view and a storage point of view.

Jan. Does this mean that PostgreSQL schemas will work :slight_smile: ?

5

swingman:
SCHEMA is a way of splitting a large DB with lots of tables into more manageable chunks, both from a logical point of view and a storage point of view.

Jan. Does this mean that PostgreSQL schemas will work :-) ?

Christian:

I understand what a schema is. I don’t understand how it’s pertinent to the database connection string. The user name in Oracle IS the schema name, and that is specified in the setup for the repository_server.

Oracle is reporting the error and it indicates that Sevoy is not transferring a user name, which is mandatory for the table. The schema is being found correctly, as the error indicates the specific field that is causing the insert to fail.

Regards,
Lee

6

Sorry Lee, should have read your post more carefully.

7

swingman:
Sorry Lee, should have read your post more carefully.

Christian:

No problem. :wink:

Just hopin Jan can find me an answer soon. I’m somewhat dead in the water at the moment.

Regards,
Lee

8

in the connection dialog there is a SCHEMA setting, just put in the SCHEMA name in it if you use oracle.

9

jaleman:
in the connection dialog there is a SCHEMA setting, just put in the SCHEMA name in it if you use oracle.

OK, Jan I tried that, but it makes no difference, I get the same error:

ORA-01400: cannot insert NULL into (“SERVOY_APP”.“SERVOY_USERS”.“USER_ID”)

Which, you can see is shwiing the correct Schema. The problem is with the USER_ID. Oracle is not seeing a value being inserted here.

HELP!

Thanks,
Lee

FWIW, I was able to add a new Group with no problem. Just can’t add users.