ERROR: EXEC userdata..item_resolve_by_name N'SELECT RTRIM(formula) FROM user_formula WHERE formula_uid = @uid', N'user_formula', N'formula_uid', N'sname', @userUid = ?, @name = ?, @groupUid = ?, @resolveGroupUid = ?;Connection is busy with results for another hstmt;0000025F6AFA0360
https://www.portfolio123.com/app/screen/summary/226978?st=1&mt=1
It worked for the past 365 days, but not today. Whats going on? 
Looks like it has to do with my screen report: https://www.portfolio123.com/report_edit.jsp?reportid=16467
Other screens work, but not when i switch to this report
I can destroy any screen by switching to that report, because of the error, i than can’t switch off that report anymore.
Looks like it is one of my formulas. But which one?
$AvgGrowth doesnt work
Avg(LTGrthMean,FHist("LTGrthMean", 5),FHist("LTGrthMean", 10),FHist("LTGrthMean", 50),FHist("LTGrthMean", 100),FHist("LTGrthMean", 200),FHist("LTGrthMean", 300))
These also don’t work anymore:
| | | | $AvgPE2 | Unclassified | Avg(FHist("ProjPECurFY", 52),FHist("ProjPECurFY", 104),FHist("ProjPECurFY", 150),FHist("ProjPECurFY"... | 07/06/19 | 07/06/19 |
|:---:|----|:---|:---|:---|:---|:---:|:---
| | | | $AvgPE3 | Unclassified | Avg(FHist("ProjPECurFY", 25),FHist("ProjPECurFY", 75),FHist("ProjPECurFY", 125),FHist("ProjPECurFY",... | 07/06/19 | 07/06/19 |
| | | | $AvgPE4 | Unclassified | Avg(FHist("ProjPECurFY", 10),FHist("ProjPECurFY", 60),FHist("ProjPECurFY", 110),FHist("ProjPECurFY",... | 07/06/19 | 07/06/19 |
| | | | $AvgPEAll | Unclassified | Avg($AvgPE2,$AvgPE3,$AvgPE4) | | |
Something with FHist in custom formulas?
LoopAvg("FHist(`ProjPECurFY`, CTR * 5)", 30) has the same problem.
In a fundamental chart these variables work, its just in a screen report where they bug.
Confirmed. We're looking into the error.
Having the same issue this morning so perhaps it’s a system wide issue.
Same issue here. My screens that use a P123 default ranking system work, but screens with a custom ranking system don’t work.
Should have a patch soon. Any report with more than one custom column has an error.
Is there a way to change a screen report to a default before I run the screen? I just need the stock tickers from my screens for trading today.
I’ve only ever changed which report a screen produces after I run the screen.
I don't see a way to change the screening rules until you reach the screen results page, and since the screen is currently failing, you can't get there.
One thing you can try is renaming the screen report.
Go to your Screen Reports, select the report that's generating the error, choose Save As, and give it a new name. That may bypass the problem and allow you to continue working until we have a permanent fix in place.
I figured out I could just create a new screen with the same universe, ranking, and rules and it will work since it just gets to the default report. Unfortunately I figured that out after the open and missed a trade in DAKT which would have been quite profitable quickly.
The Screener report issue has been resolved. If you continue to experience any problems, please let us know in the comments.
Thank you for your patience.
Thanks, works for me now.