Dear All

I am looking for some help if possible as it would appear that our issue has both our support partner, and Sage stumped. We have the standard system view vListOpportunity in the DB, however, for some reason on a fairly regular basis, this seems to change to vListOpportunity.count(*). This creates an issue where the opportunity area of the application fails as users cannot access it.

The result is that we are regularly having to perform IIS reset and metadata refresh to try and restore functionality. I attach a snip of the system log file below:

Dec 12 2013 12:12:19.807 17224 4432 3 CoeWareBase,Time 47
Dec 12 2013 12:12:19.822 17224 5016 4 EndUserAction,User,Action,Time 1624 410 343
Dec 12 2013 12:12:19.822 17224 4432 3 CoeWareBase,Time 0
Dec 12 2013 12:12:19.838 17224 4432 1 SQL Error : Incorrect syntax near '*' (select vListOpportunity.count(*) as fcount from vListOpportunity WITH (NOLOCK) LEFT OUTER JOIN Currency oppo_forecast_Currency ON oppo_forecast_Currency.Curr_CurrencyID = oppo_forecast_CID WHERE

The issue is that the select statement should not have the .count(*) at the end and it is somehow being pulled in and causing chaos. Is there anyone with similar/same issue and any input on what the root cause might be would be more than welcomed.

Thanks a lot

Angie