Skip to Content
0

Why is every UDF queried 9 times when a document is opened?

May 11 at 09:57 PM

31

avatar image

We recently expanded to a 2nd building and over the secure point-to-point VPN between buildings it takes SAP 30-40 seconds to open a document. To try to figure out what was happening I ran a trace via the Profiler then opened a blank sales order. There were around 800 of the messages below, one for each of the 88 UDFs on RDR1. Not only that but it queried all 88 in sequence nine times! I checked and the same things happens in SAP on the local network but it's not noticeable until you have a little lag. Why the heck is SAP doing this and how can I stop it?

exec sp_executesql N'SELECT T0.[RelUDO] FROM [dbo].[CUFD] T0 WHERE T0.[TableID] = (@P1) AND T0.[AliasID] = (@P2) ',N'@P1 nvarchar(21),@P2 nvarchar(19)',N'RDR1',N'NumSeats'

Using SAP B1 8.82 PL19

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers