Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Moving Bizview Databases and Assembly Errors

Bizview is leveraging the functionality to extend SQL Server with .NET assemblies for advanced operations that Bizview wants to execute within the context of SQL Server. For example, in Bizview you can write a query where client_id = '10#20#30' and the Bizview assembly (clr_sqlmart) will break that up into: in (10', 20', 30') etc.

When databases are moved from one SQL instance to another, the Bizview assemblies must be made sure they are working. Otherwise you might experience the following problems;

If you experience that selection panes are not populated with data, like below:


And/Or, you get error messages like this:

Execution of user code in .NET Framework is disabled. Enable "clr enabled" configuration option.

Possible solution:

EXEC sp_configure 'clr enabled' , '1'

GO

reconfigure;
GO

Also, if you move an SQL Server database from one instance to another and you are using "SQL Logins" for authentication from the Bizview app-server to the databases, you must take care of 'orphan users'. In the example below there are two SQL-logins: bvadmin and bvreader.

Possible solution:

EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false

GO

EXEC sp_change_users_login 'Auto_Fix', 'bvadmin'

GO

EXEC sp_change_users_login 'Auto_Fix', 'bvreader'

GO
Published:

Moving Bizview Databases and Assembly Errors

Bizview is leveraging the functionality to extend SQL Server with .NET assemblies for advanced operations that Bizview wants to execute within the context of SQL Server. For example, in Bizview you can write a query where client_id = '10#20#30' and the Bizview assembly (clr_sqlmart) will break that up into: in (10', 20', 30') etc.

When databases are moved from one SQL instance to another, the Bizview assemblies must be made sure they are working. Otherwise you might experience the following problems;

If you experience that selection panes are not populated with data, like below:


And/Or, you get error messages like this:

Execution of user code in .NET Framework is disabled. Enable "clr enabled" configuration option.

Possible solution:

EXEC sp_configure 'clr enabled' , '1'

GO

reconfigure;
GO

Also, if you move an SQL Server database from one instance to another and you are using "SQL Logins" for authentication from the Bizview app-server to the databases, you must take care of 'orphan users'. In the example below there are two SQL-logins: bvadmin and bvreader.

Possible solution:

EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false

GO

EXEC sp_change_users_login 'Auto_Fix', 'bvadmin'

GO

EXEC sp_change_users_login 'Auto_Fix', 'bvreader'

GO
For an optimal Community experience, Please view on Desktop
Powered by Zendesk