on 10-03-2013 9:23 AM
hello to all!
i try to update a UDF in Item Master Data and the message WTR1 is displayed
there is not any FMS assigned on it
i have made a restart the server but still nothing
do you have any idea about this issue?
i can add the UDF
Hi,
How many UDF do you have for Item Master?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What error are you receiving and if do you have add-on temporary disabled it also?
Thank you.
Regards,
Clint
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vasil,
1.Check if there is a new udf that have the same name with the udf that you want to update.
2. Run this query to find out any queries that its value size has been more than defined size:
declare @TableID nvarchar(20);
declare @AliasId nvarchar(18);
declare @EditSize smallint;
declare @SizeID smallint;
declare @RealSize int;
declare @statement nvarchar(max);
declare @params nvarchar(max);
declare alfa_udfs cursor for
select TableID, AliasID, EditSize, SizeID from cufd where TypeID = 'A';
open alfa_udfs;
FETCH NEXT FROM alfa_udfs
INTO @TableID, @AliasId, @EditSize, @SizeID;
WHILE @@FETCH_STATUS = 0
BEGIN
IF EXISTS (SELECT * FROM sys.tables WHERE name = @TableId)
BEGIN
set @RealSize = 0
set @params = '@RealSizeOut int output';
set @statement = 'select @RealSizeOut = max(len(U_' + @AliasID + ')) from [' + @TableId + '] where U_' + @AliasID +' is not null';
EXECUTE sp_executesql @statement, @params, @RealSizeOut = @RealSize OUTPUT;
if @RealSize is not null
BEGIN
if @EditSize < @RealSize
BEGIN
select @TableID As TableName, 'U_' + @AliasId As UDFName, @RealSize As RealSize, @EditSize As DefinedSize, @SizeID as DefinedSize2
END
else if @SizeID < @RealSize
BEGIN
select @TableID As TableName, 'U_' + @AliasId As UDFName, @RealSize As RealSize, @EditSize As DefinedSize, @SizeID as DefinedSize2
END
END
END
FETCH NEXT FROM alfa_udfs
INTO @TableID, @AliasId, @EditSize, @SizeID;
END
CLOSE alfa_udfs;
DEALLOCATE alfa_udfs;
Hi Vasil,
You can try to restore document numbering function. It is available in the utilities or help file.
If it doesn't solve, try to test by creating new udf in item master data and then update again, check if this issue still reoccur.
If the issue still reoccur, you must restore the latest database backup or you can try to escalate to sap support and inform them that you will upgrade soon after this issue solved.
Rgds,
Jimm
Hi,
Please post screen shot of error message with UDF field.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.