You get error when opening form Administration > 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)"
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;
}
}
{
select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
if (!userGroupInfo)
{
if (strlen(list) > 0)
{
list += #comma;
}
list += udmRoles.UserGroupId;
}
}
Should be changed into:
while select udmRoles
{
select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
if (!userGroupInfo)
{
if (strlen(list) > 0)
{
list += #comma;
}
list +="’"+ udmRoles.UserGroupId+"’";
}
}
{
select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
if (!userGroupInfo)
{
if (strlen(list) > 0)
{
list += #comma;
}
list +="’"+ udmRoles.UserGroupId+"’";
}
}
Note:
The code is provided as is with no warranties, and confers no rights, and is not supported by of Microsoft Support
| author: | Czesława Langowska |
| editor: | Czesława Langowska |
| date: | 07/Feb/2011 |