
The following stored proc blows up:
[dbo].[ZNODE_GetDashboardItemsByPortal]
It declares the variable "@YTDRevenue" as a small money. Small money has an upper limited of "+214,748.3647". As soon as your YTD revenues exceed this amount the stored proc throws an error and you cannot login as admin. This variable should be declared as a money data type.
ZNODE_GetDashboardItemsByPortal
Thankyou for pointing this out! We will submit a ticket for a developer to look into this issue.
Znode Administrator
email: support@znode.com
url: www.znode.com