SUPPORT / SAMPLES & SAS NOTES
Problem Note 69088: A Factorization Machine object in SAS® Visual Analytics 8.5 might return "DataQueryException: Error executing query dependencies for dd94..."
 |  |  |  |  |
In SAS Visual Analytics 8.5, the Factorization Machine object might return the following error:
WARN 165968 --- [ SASExecutor8] c.s.reportdata.service.utils.DataUtils : bowman-consultant(ea74f814-12b8-4718-b6b2-a265ae5aa34e) [142640d305260a2d] Error retrieving data results for DataDefinition dd94 in Report query:7889ccd5-bb26-4b1d-b489-073560885618_7889ccd5-bb26-4b1d-b489-073560885618_c7 - dataLevel=custom - DataQueryException: Error executing query dependencies for dd94 - dependency dd19 - java.lang.Exception: Query canceled:7889ccd5-bb26-4b1d-b489-073560885618_c7 - (Status: failure, ResultCacheLifetime: noLifetime, Errors: [ Error:Level(Severe)Type(queryCancelledByUser)Parameters()java.lang.Exception: Query canceled:7889ccd5-bb26-4b1d-b489-073560885618_c7])
This issue occurs because one of the underlying supplemental tables pulls in too much data when large amounts of data are run through the object.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Cloud Foundry | 8.5 | Viya | ||
| Linux for x64 | 8.5 | Viya | ||||
| Microsoft® Windows® for x64 | 8.5 | Viya | ||||