Ошибка при старте АОСа

[zZ_TOP_Zz]

Здравствуйте, тут такая возникла ошибка (по логам) при попытке запуска АОСа

Object Server 13: Internal Error occurred executing stored procedure when creating session for the AOS.


конфа DAX4 sp2
БД на SQL 2005

Буду рад любым предложениям по поводу ее устранения. Спасибо всем кто не оставит в беде.

[andy.l]

Похоже вы запускаете AOS на чистой (новой) базе, а в ней нет процедур createserversessions и createusersessions.

CREATE procedure [dbo].[createusersessions] @clientType int, @sessionType int, @serverid int, @versionid int, @loginTime int, @userid varchar(5), @lanExt varchar(10), @manExt varchar(10), @dataFile varchar(3), @sid  varchar(124), @recid bigint, @startId int, @maxusers int, @licenseType int, @sessionid int OUTPUT as declare @return_val as int declare @first as int declare @max_val as int begin select @sessionid = -1 if(not exists(select * from SysServerSessions WITH (NOLOCK) where SERVERID = @serverid AND Status = 1)) begin select @sessionid = -2 return end select top 1 @first=SESSIONID from SysClientSessions WITH (UPDLOCK,READPAST) where STATUS = 0 if (select count(*) from SysClientSessions where SESSIONID IN (@first)) > 0 begin if (@licenseType = 0) begin update SysClientSessions set STATUS = 1, VERSION = @versionid, SERVERID = @serverid, USERID = @userid, LOGIN_DATE = GETUTCDATE(), LOGIN_TIME = @loginTime, SID = @sid, USERLANGUAGE = @lanExt, HELPLANGUAGE = @manExt, COMPANY = @dataFile, CLIENTTYPE = @clientType, SESSIONTYPE = @sessionType where SESSIONID IN (@first) end else if (@licenseType = 1) begin update SysClientSessions set STATUS = 1, VERSION = @versionid, SERVERID = @serverid, USERID = @userid, LOGIN_DATE = GETUTCDATE(), LOGIN_TIME = @loginTime, SID = @sid, USERLANGUAGE = @lanExt, HELPLANGUAGE = @manExt, COMPANY = @dataFile, CLIENTTYPE = @clientType, SESSIONTYPE = @sessionType where SESSIONID IN (@first) and ((select count(SESSIONID) from SysClientSessions where CLIENTTYPE = @clientType and ((STATUS = 1) or (STATUS = 2))) < @maxusers) end else if (@licenseType = 2) begin update SysClientSessions set STATUS = 1, VERSION = @versionid, SERVERID = @serverid, USERID = @userid, LOGIN_DATE = GETUTCDATE(), LOGIN_TIME = @loginTime, SID = @sid, USERLANGUAGE = @lanExt, HELPLANGUAGE = @manExt, COMPANY = @dataFile, CLIENTTYPE = @clientType, SESSIONTYPE = @sessionType where SESSIONID IN (@first) and ( (select count(SESSIONID) from SysClientSessions where CLIENTTYPE = @clientType and (USERID = @userid) and ((STATUS = 1) or (STATUS = 2))) > 0 or (select count(distinct USERID) from SysClientSessions where CLIENTTYPE = @clientType and ((STATUS = 1) or (STATUS = 2))) < @maxusers ) end if @@ROWCOUNT = 0 select @sessionid = 0 else select @sessionid = @first end else begin if (@licenseType = 1) begin if (select count(SESSIONID) from SysClientSessions where CLIENTTYPE = @clientType and ((STATUS = 1) or (STATUS = 2))) >= @maxusers select @sessionid = 0 end else if (@licenseType = 2) begin if ( ((select count(distinct USERID) from SysClientSessions where CLIENTTYPE = @clientType and ((STATUS = 1) or (STATUS = 2))) >= @maxusers) and ((select count(SESSIONID) from SysClientSessions where CLIENTTYPE = @clientType and (USERID = @userid) and ((STATUS = 1) or (STATUS = 2))) = 0) ) select @sessionid = 0 end if (@sessionid = -1) or (@licenseType = 0) begin if (select count(SESSIONID) from SysClientSessions WITH (UPDLOCK)) = 0 select @max_val = @startId else select @max_val= max(SESSIONID)+1 from SysClientSessions WITH (UPDLOCK) insert into SysClientSessions(SESSIONID, SERVERID, VERSION, LOGIN_DATE, LOGIN_TIME, USERID, SID, USERLANGUAGE, HELPLANGUAGE, COMPANY, CLIENTTYPE, SESSIONTYPE, RECID, STATUS) values(@max_val, @serverid, @versionid, GETUTCDATE(), @loginTime, @userid, @sid, @lanExt, @manExt, @dataFile, @clientType, @sessionType, @recid, 1) select @sessionid = @max_val 
CREATE procedure [dbo].[createserversessions] @aosId varchar(50), @version int, @instanceName nvarchar(50), @loginTime int, @recid bigint, @maxservers int, @status int, @loadbalance int, @workload int, @serverid int OUTPUT as declare @first as varchar(50) declare @max_val as int begin select top 1 @first=SERVERID from SysServerSessions WITH (UPDLOCK, READPAST) where AOSID = '' if (select count(SERVERID) from SysServerSessions where SERVERID IN (@first)) > 0 begin update SysServerSessions set AOSID=@aosId, VERSION=@version, INSTANCE_NAME=@instanceName, LOGIN_DATE = GETUTCDATE(), LOGIN_TIME = @loginTime, LASTUPDATETIME = @loginTime, STATUS = @status, LOADBALANCE = @loadbalance, WORKLOAD = @workload where SERVERID IN (@first) and ((select count(SERVERID) from SysServerSessions where AOSID <> '') < @maxservers) if @@ROWCOUNT = 0 select @serverid = 0 else select @serverid = @first end else begin if (select count(SERVERID) from SysServerSessions WITH (UPDLOCK) where AOSID <> '') >= @maxservers select @serverid = 0 else begin if (select count(SERVERID) from SysServerSessions) = 0 select @max_val = 1 else select @max_val = max(SERVERID)+1 from SysServerSessions insert into SysServerSessions(SERVERID, AOSID, INSTANCE_NAME, VERSION,  LOGIN_DATE, LOGIN_TIME, LASTUPDATETIME, STATUS, RECID, LOADBALANCE, WORKLOAD) values(@max_val, @aosId, @instanceName, @version, GETUTCDATE(), @loginTime, @loginTime, @status, @recid, @loadbalance, @workload) select @serverid = @max_val

[aidsua]

Цитата:

Сообщение от zZ_TOP_Zz

Здравствуйте, тут такая возникла ошибка (по логам) при попытке запуска АОСа

Object Server 13: Internal Error occurred executing stored procedure when creating session for the AOS.


конфа DAX4 sp2
БД на SQL 2005

Буду рад любым предложениям по поводу ее устранения. Спасибо всем кто не оставит в беде.

предлагаю проверить доступное свободное место на томе, где лежат файлы данных БД. Есть подозрение, что закончилось свободное пространство/дисковая квота/etc

[zZ_TOP_Zz]

Всем спасибо. Проблема решена. Дело было в SQL сервере. Причем, я так и не понял что это был за фокус...я с утра попробовал еще раз на тех же настройках, и, о чудо, все заработало...шаманство какое то.

[Eldar9x]

То же возникла эта же ошибка. Решил ее, дав в разрешениях БД для пользователя "NT AUTHORITY\NETWORK SERVICE" разрешение Execute.