I have created a new customized session which calls a custom library. It works for me, but when a user test the session out they get the following error when they try to open the session:

Fatal Error : Error 1229 (bdb_errno 1229) on SELECT
Can not continue in tiosd9199m000 in DLL: otiobgd10000003 (<0>[sql.fetch])

I searched the forums for the error number without much luck. The user has access to both the tiobg module and the tiosd9199m000 session.

Any suggestions?

Are there any errors in the various error logs? Are there any special tables that the user might not have permissions to? Just taking a couple of stabs in the dark - I seem to recall this error, but not what the solution was. And is this really just opening the session or trying to run the session?

From your profile, I am assuming ORACLE. Here is what the command oerr ora 229 [1229 minus 1000] gives:

oerr ora 229

00229, 00000, "operation disallowed: already hold snapshot controlfile enqueue"
// *Cause: The attempted operation cannot be executed at this time because
// this process currently holds the snapshot controlfile enqueue.
// *Action: Retry the operation after calling cfileUseCurrent to release the
// snapshot controlfile enqueue.


I am not really sure what the solution would be. Most probably not the session, because it does work for you at least. So, possibly some tools table that is referred when the session starts up. Look at log.oracle8 or log.ora.sql

Need to update my profile (we're using MS SQL Server now as of Oct of last year). With the Migration to SQL Server we went from having one database user accessing to Baan to a one-to-one Baan/Database user and when we created the test environment we needed to set up a different permission group for users. These new users were not set up with that permission group so they got the error (I am certainly not a DBA).

Thanks for your responses.