본문 바로가기

Archive/ABAP

SAP ERP Netweaver 6.x 버전에서 MS SQL 2012 업그레이드

728x90

C EXEC sap_check_if_sick

A *** ERROR => Can't execute sap_check_if_sick [sapicc.c 1345]

ALTER proc [스키마].[sap_check_varbin_MAX] @result varchar(64) output
as
BEGIN
declare @major int
declare @colcnt int
select @result = 'ok'
select top 1 @colcnt = 1 from
/*sys.columns sc with (nolock,FASTFIRSTROW )*/
sys.columns sc with (nolock )
/*inner join sys.objects so with (nolock,FASTFIRSTROW )*/
inner join sys.objects so with (nolock)
on sc.object_id = so.object_id
where
sc.system_type_id in (35,99,34) and -- text, ntext, image
so.schema_id = schema_id() and
so.type = 'U' and
so.name not like 'sys%' and
so.name not like 'sap%'
option (force order, fast 1)
if @colcnt > 0
select @result =
'Wrong long datatypes. Perform SQL Server after upgrade steps.'
END

 

728x90