Skip to Content
author's profile photo Former Member
Former Member

SySAM: License feature name: ASE_RDDB error

I am getting a strange error which I do not understand. I created a temporary database, created a group and that temporary DB to the group and then bind a login to the group. I am receiving the following error in the log and also during the application launch and I don't understand why

When the application starts and the login executes a procedure the following error is received

Exception: dbo.usp_App_GetUser: You cannot run 'SELECT INTO' affecting database 'LocalTempDB01' because the ASE_RDDB license is either not available or has expired

The ASE error log shows

SySAM: License feature name: ASE_RDDB

SySAM: FLEXnet Licensing error:-73,125

ASE Version

Adaptive Server Enterprise/15.7.0/EBF 20733 SMP ESD#03 /P/x86_64/Enterprise Linux/ase157esd3/3183/64-bit/FBO/Sat Dec 8 18:28:29 2012

I am not looking for any in memory feature but merely enabling multiple tempdbs

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 24, 2014 at 11:08 AM

    For some reason ASE thinks your temporary database was created with a RDDB/IMDB attribute.

    Can you post the 'create database' command you used to create your temporary database?

    Could you post the output of 'sp_helpdb'? I'm interested in the *complete* output for tempdb and all user-created temporary databases.

    Add a comment
    10|10000 characters needed characters exceeded

    • Yep, that be the culprit.

      By default temporary databases are automatically configured with durability = no_recovery so there's no need to explicitly state it in the 'create temporary database' command

      Unfortunately, while the 'durability=no_recovery' is redundant for temporary databases and should probably be ignored, including the clause seems to trigger the need for the ASE_RDDB licensing requirement. [Probably a good candidate for a CR.]

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.