Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"case when not m[1] is present then" outputs ORA-03113

Aketi JyuuzouMar 20 2009 — edited Jan 13 2011
I find that "case when not m[1] is present then" outputs ORA-03113:
Why?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
select * from dual model
 dimension by(0 as d)
 measures(1 as m)
 rules(
 m[any] = case when not m[1] is present then 1 end);
ORA-03113:
Below one is alterNative solution. 
select * from dual model
 dimension by(0 as d)
 measures(1 as m)
 rules(
 m[any] = case when presentv(m[1],1,0) = 0 then 3 end);

D  M
-  -
0  3
This post has been answered by Solomon Yakobson on Mar 20 2009
Jump to Answer

Comments

amey g

Hi,

If the application need to logout user, then it can invoke logoff method on the object of UserSession class. Please check the SDK API doc but you need to invoke this method based on some event.

https://docs.oracle.com/cd/E28280_01/dev.1111/e12491/as_api.htm#AIDEV119

Thanks,

Amey

2 people found this helpful
Sandeep Kumar sk

Yes use the Usersession class as replied above. You will need to invoke logoff method to terminate the user session or log off the user.

public void logoff()

            throws AccessException

Logs off the authenticated user and terminates the session.

Throws:

  AccessException - If error occurs during operation

1 person found this helpful
3014957

Hello,

Thanks for the response. I've seen this and working on this, i guess the question is can i use this UserSession.logoff() API to log all the users out, in a loop for example.

Best Regards.

1 person found this helpful
3014957

to be specific.. the document shows the following. It appears that i can only logoff the current user in session. I may have 100 users logged into access manager at any given time. I don't have their passwords. Can I get all the users that are currently logged in? and use logoff API to log them out? What would be sequence of call there.

Hashtable creds = new Hashtable();

  creds.put("userid", ms_login);

  creds.put("password", ms_passwd);

  UserSession session = new UserSession(rrq, creds);

  if (session.getStatus() == UserSession.LOGGEDIN) {

  if (session.isAuthorized(rrq)) {

  System.out.println("User is logged in and authorized for the"

  +"request at level " + session.getLevel());

  } else {

  System.out.println("User is logged in but NOT authorized");

  }

  //user can be loggedout by calling logoff method on the session object

  } else {

Sandeep Kumar sk
Answer

Refer this LINK where it talks about retrieving session id. You can get session id from OAM database directly ( via sql statement,  select * from oam_session). Actually this will give you all the current sessions in OAM (Yes this table only holds the current/ sessions of users logged in to/via OAM). The sessions information will provide you the unique session_id, userid of the user (and other info as well like time logged in etc). The code in the above LINK provides an example of iterator that goes over all the session ids to provide you the userid. You can use this info in your code and terminate that user session. Hope this helps, please mark as helpful or resolved. Thanks

Marked as Answer by 3014957 · Sep 27 2020
1 person found this helpful
3014957

Hello IdmSk,

I was able to retrieve sessions using oam_session table. However, UserSession object can only be constructed using SessionToken and not session_id. Is there a way to get SessionToken to all users that are logged into oam_session? what table has this information?

Once i get sessiontoken i can construct a UserSession and call logoff method on it.

thanks,

Prasad

3014957

Also when i tried to get session attributes I am getting the following error:

oracle.security.am.asdk.OperationNotPermittedException: OAMAGENT-02005: Operation not permitted on this server.

  at oracle.security.am.asdk.UserSession.getSessionAttributes(UserSession.java:1454)

  at oracle.security.am.asdk.UserSession.getSessionAttributes(UserSession.java:1330)

  at OAMLogoutUsers.main(OAMLogoutUsers.java:50)

3014957

I checked Allow Management Operations and this error is gone, however now i am getting the following for terminateSession(ac, sessionid) call.

oracle.security.am.asdk.AccessException: OAMAGENT-02021: The Access Server has returned a fatal error with no detailed information.

  at oracle.security.am.asdk.UserSession.terminateSession(UserSession.java:1151)

  at OAMLogoutUsers.main(OAMLogoutUsers.java:52)

3014957

I was able to terminate the user session by using sessionID as is. I was parsing it till now.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 10 2011
Added on Mar 20 2009
#11g
8 comments
2,528 views