oracle error

[Jacky ESAYAG <je...@ennov.com>]

hi everyone,
i was trying executing the default_roles_permissions.sql in my oracle
database and received the following error message...


ERREUR à la ligne 1 :
ORA-01400: cannot insert NULL into ("SYSTEM"."TURBINE_ROLE"."ROLE_ID")

this is ligne 1:  insert into TURBINE_ROLE (ROLE_NAME) values
('authenticated_user');

Both users seem to be ok!

Thanks
Jacky


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

Re: oracle error

[Raphaël Luta <ra...@networks.groupvu.com>]

Jacky ESAYAG wrote:

> hi everyone,
> i was trying executing the default_roles_permissions.sql in my oracle
> database and received the following error message...
> 
> 
> ERREUR à la ligne 1 :
> ORA-01400: cannot insert NULL into ("SYSTEM"."TURBINE_ROLE"."ROLE_ID")
> 
> this is ligne 1:  insert into TURBINE_ROLE (ROLE_NAME) values
> ('authenticated_user');
> 


It's possibly due because the sql files are out of date compared to the
latest turbine used. Use TDK 2.1/torque to generate a correct schema
for your database and then import the Jetspeed user information so that
you can run the default webapp correctly.

If anybody has a nice way to automate this task, I'm a taker; I don't
think Jetspeed should distribute sql files anymore...


--
Raphael Luta - raphael.luta@networks.groupvu.com
Vivendi Universal Networks - Paris


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org