T+专属云15.0升级18.0后账套登录报错：The request is invalid.

【问题现象】

专属云15.0升级18.0后账套登录报错：The request is invalid.

【解决方案】

升级账套后登录报错：The request is invalid的问题，可以先尝试以下方案解决。

--备份好数据，在账套库执行以下修复脚本后重启T+服务：

declare @temp table(userid int)

insert into @temp

select id from eap_user

where issystem=0 and ActorType=0

and id not in (select userid from EAP_UserGroupRelation)

declare cur cursor for

select userid from @temp

open cur

declare @uid int

fetch next from cur into @uid

while @@FETCH_STATUS=0

begin

insert into EAP_UserGroupRelation(groupid,UserId) values (5,@uid)

--select * from eap_user where id=@uid

fetch next from cur into @uid

end

close cur

deallocate cur