cannot update a UDF (WTR1)

[vasileiosfasolis]

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

[Former Member]

Hi,

How many UDF do you have for Item Master?

Thanks,

Gordon

[vasileiosfasolis]

Hi Gordon

there are pleny UDFs in my Item master Data....

more than 40....

i can create new udfs but while trying to change them it displays the message and i do not know what to do...

[Former Member]

Your db is inconsistent now. DBCC and reindex must be done.

[Former Member]

Hi,

What error are you receiving and if do you have add-on temporary disabled it also?

Thank you.

Regards,

Clint

[vasileiosfasolis]

Hi Clint

there is not any change in settings neither in addons

everything was working fine

but know it does not work. unfortunatelly i do not know what to check.

the error is WTR1...thats it :S

[former_member186095]

Hi,

I am afraid that this issue happened because of corrupted document numbering auoupdate.

Another possibility is the WTR1 entry has been corrupted.

I suggest to escalate this issue to SAP Global SUpport.

Rgds,

JM

[vasileiosfasolis]

Hi Jimmy

could you please inform me what can i check?

unfortunatelly my sap version is 2005...you can understand that it is impossible to get any help from Sap Global Support and i am not able to update any UDF any more....

[former_member186095]

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;

[vasileiosfasolis]

regarding this query i got this result

@OCHH_LOG    U_RELACCT    13    10    10

what should i do now?

[former_member186095]

Hi Vasil,

You must extend the UDF length in the udf management from 10 to 13.

After that, check if the issue "WTR1 still appear.

Rgds,

Jimm

[vasileiosfasolis]

i tried it and unfortunatelly the same error

[former_member186095]

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

[vasileiosfasolis]

Hi Jim

unfortunatelly i tried restoring document numbering but the problem still exists.

i tried to create a new udf which cas created succesfully but still i cannot alter it therefore.

[kothandaraman_nagarajan]

Hi,

Please post screen shot of error message with UDF field.

Thanks & Regards,

Nagarajan

[vasileiosfasolis]

Hi Naga

it is impossible to make a print screen immediately.

it is gonna take more than an hour some times in order to complete the whole change..

the message displayed is only ''WTR1''

no more descriptions

[former_member186095]

Hi,

You may check this link:

http://scn.sap.com/message/10690647

Rgds,

[vasileiosfasolis]

i will try it tonight

what i have done till now is just restart the server

[vasileiosfasolis]