Symptom
- Stored procedures that create and drop #temp tables within the procedure
- Occasionally return Error 3702
- With subsequent executions failing with Error 2714
- While MDA table monOpenObjectActivity is queried:
Msg 3702, Level 16, State 1:
Server 'ASE', Procedure 'myproc' :
Cannot drop or replace the table '#my_temp_table' because it is currently in use.
Msg 2714, Level 16, State 3:
Server 'ASE', Procedure 'myproc' :
There is already an object named '#my_temp_table' in the database.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- Dataserver
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
message, temporary, "#temp", dropped, 790672, CR790672, CR#790672 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.