Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SESSIONS_PER_USER limit

  1. #1
    Join Date
    Aug 2007
    Posts
    9

    Default SESSIONS_PER_USER limit

    Hi all,

    I've got a little problem and hope of help here.
    I have several db joins and table inputs on the same database but different tables. When I try to start my transformation I get the Error message

    ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

    Before I go to the IT department, I wanted to know if there is a possibility to access the database just before it is needed to avoid this error.

    Thanks a lot for your help
    Regards
    Judith

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Talk to your DBA's... you're currently using more sessions than you're allowed to.

    You can minimize your use of sessions by switching on use "unique connections": in a transformation, press control-T and then go to the "miscellaneous" tab.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.