on 07-24-2014 7:34 AM
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
10 years later, in case anybody was waiting for it, here's the answer:
Set the values of status3 and status4 in master..sysdatabases for "user-created enhanced performance temp db" to that of the normal tempdb. Then restart the server. After restart errorlog will no longer show missing ASE_RDDB license and the tempdbs will have normal configuration.
Use with caution, dropping and recreating tempdbs is the safer way
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.