CopyPaste.Net: September 2020

SAP (sybase) ASE - The maximum number of configured devices has been reached

The case:

Creation of a new device.

Error message:

The maximum number <X> of configured devices has already been reached. Please reconfigure 'number of devices' to a larger value and retry disk initialization.

1> disk init name="DdeviceNameLog", physname="/sybvol01/sap16/data/DdeviceNameLog1.dat", size="100M"

2> go

Msg 5162, Level 16, State 1:

Server 'SRSSERVER', Line 1:

The maximum number 20 of configured devices has already been reached. Please reconfigure 'number of devices' to a larger value and retry disk initialization.

Solution:

sp_configure 'number of devices', 30

SAP (sybase) RS - rs_init - Could not connect to ID Server Unable to execute query create connection

The case:

Error when adding a new connection using rs_init:

Could not connect to ID Server Unable to execute query create connection.

Error message:

WARNING: "Could not connect to ID Server 'ID_RS_NAME'."

Press <return> to continue.

SQL Server message: msg 45, level 12, state 0

WARNING: "Could not connect to ID Server 'ID_RS_NAME'."

Press <return> to continue.

Unable to execute query 'create connection to "ASENAME"."DBNAME" s

et error class rs_sqlserver_error_class set function string class rs_sqlserver_

function_class set username "DBNAME_maint" set password *** with log tr

ansfer on' against server 'RS_NAME'.

Press <return> to continue.

Solution:

The ID Server RS is not available:

The RS service is down - start it.
Network or connections problems.
Any other reason

SQL Server: Alternate to msdb.dbo.agent_datetime

msdb.dbo.agent_datetime converts integer date + integer time values to a datetime value.

Sometimes you won't have permissions to run agent_datetime (For example in the admin user in AWS RDS) - so you'll need an alternative to it.

DECLARE @int_date INT, @int_time INT

SELECT @int_date=20200913, @int_time=155834

SELECT msdb.dbo.agent_datetime(@int_date,@int_time)

SELECT cast(cast(@int_date as char(8))+' '+stuff(stuff(right('000000'+convert(varchar(6),@int_time),6),3,0,':'),6,0,':') as datetime)

select jh.run_date, jh.run_time,

msdb.dbo.agent_datetime(jh.run_date, jh.run_time) as 'agent_datetime',

cast(cast(jh.run_date as char(8))+' '+stuff(stuff(right('000000'+convert(varchar(6),jh.run_time),6),3,0,':'),6,0,':') as datetime) as fog_last_run_time

from msdb.dbo.sysjobhistory jh