Error In Stored Proc "[dbo].[ZNODE_GetDashboardItemsByPortal]" - Cannot login as admin

agerent's picture

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.

admin's picture

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