Blog Pages

SAP ASE (Sybase) - Cannot create device 'DEVICENAME': no available virtual device numbers (vdevnos)

What I did?
Create a device.

Error message:
Cannot create device 'DEVICENAME': no available virtual device numbers (vdevnos)

Solution:
exec sp_configure 'number of devices', 20 
-- replace 20 with a number that is bigger than what it set now.

Cause:
There is a limit of maximum number of devices - you probably get to it.

Check the number of devices:
exec sp_configure 'number of devices'

See the devices in the server:
select * from master..sysdevices

No comments:

Post a Comment