I am looking to see if anyone else has created customs columns in the Portfolio screen. I have recently add some new fields at the request of our gift officers. I add fields like "Last Gift Date" "Gift Amount this FY", etc. Each column works fine on it's own, but I am, finding when I add multiples of these columns. Other users and myself get the following error message.
I suspect either my SQL queries in TR CUSTOM PORTFOLIO ELEMENTS are inefficient or there is a limit to the number of columns.
Has anyone seen this issue?
This is typically caused by only a few things. The most significant is a deadlock. It would help to see the query you are using. It may need to be less complex or optimized (maybe you need a (NO LOCK) statement in it to keep things from locking up.
Sorry about the duplicate posts. It got blocked as SPAM and I tried different formats to hopefully get the reply to post. So of course once it was determined it was not spam so now there are 3 versions of the same post