• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 96 subscribers
  • Views 7367 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

[V6.1.3] : Database error 3958 - full tempdb

MAS77
over 7 years ago

Hi, we are encountering an issue in our devlopement environment that blocks us, and prevent us from compiling the databas or  inserting or importing new data. In brief, we cannot do anything with One Identity manager tools.

the size of tempdb which seems full is 16 Gb and is used only by One identity Manager. Here is the error I'm getting :

Database error 3958: detected in (SRV=XXXX, DB=YYYY) Procedure VI_IBaseTreeHasESet, Line 1

      à VI.DB.SqlExecutor.SqlExecuteNonQuery(IQueryProvider provider, IDataParameter[] parms)

      à VI.DB.SqlExecutor._SqlExecuteNonQuery(DbStatement stmt)

Database error 3958: Transaction aborted when accessing versioned row in table 'dbo.BaseTreeHasESet' in database 'YYYY'. Requested versioned row was not found. Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.

An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.

Thank you in advance for your help.

  • 0 over 7 years ago

    I would definitely call Support on that one.

  • 0 over 7 years ago

    Hello MAS77,

    we have recently the same problem on our test system,
    the difference is that our Q1IM, is running on a SQL BUS, along with many other DBs (also Q1IM6.1.4, Q1IM6.1.3,..), so far we have not been able to locate the problem ...
    so if you find a solution, i would be very interested on it
    Thank you

    best regards,
    Tarigh

  • 0 over 7 years ago in reply to Tarigh Nejat

    Hi Tarigh,

    Unfortunatelly I did not manage to find a solution, and this is why i post this topic by the way ;) 

    Moreover, our contract support has expired last month and it's does not make sense to extend it so that we can open a ticket as we will migrate to V8 in few months.

    Please do not hesitate to share with us if you ever find a workaround