Error when accessing form “BI generation options
I got a error when i click on following linkAdministration > Setup > Business analysis > OLAP > BI generation options
Cannot execute the required database operation. The SQL database has issued an error and in Application event viewer on AOS server you can find following entry The database reported (session 3 (Admin)):
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'usergroup3'..
The SQL statement was:
DELETE FROM [DBO].BIUDMROLES WHERE USERGROUPID IN usergroup1,usergroup2,usergroup3)"
Possible Reason:
The problem is caused by minor bug in Classes\ SrsStatementQuery method deleteInvalidBIUdmRoles() Right now the while looks like:
while select udmRoles
{
select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
if (!userGroupInfo)
{
if (strlen(list) > 0)
{
list += #comma;
}
list += udmRoles.UserGroupId;
}
}
Suggested Solution:
{
select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
if (!userGroupInfo)
{
if (strlen(list) > 0)
{
list += #comma;
}
list +="'"+ udmRoles.UserGroupId+"'";
}
}
-Harry
No comments:
Post a Comment
Thanks