Stonefield Query for ACT!
A error message of "ACT! OldDB Provider for Reporting 2.0 : Failed to parse SQL" when any report containing fields from the Activities table is run may be caused by a bug in the ACT! installer. The problem is that one of the ACT! stored procedures doesn't get created properly under some circumstances when the database is updated to a new version of ACT!. There are two solutions:
1. Create a new, blank database and import the existing data into it. Since the issue is only related to the version update process for databases, new databases don't have the problem. This may or may not be an easy option, depending on the amount of customization that's been done to your database.2. Manually create the missing stored procedure in your database using these steps:a. Place the Act.Database.ManagedReportProvider.dll file in the (shared) database files Assemblies subfolder (\DATABASENAME-database files\Assemblies\)
b. Start SQL Server Management Studio and connect to the server.
c. Expand the Databases node, expand the node for the ACT! database, expand the Programmability node, expand the Stored Procedures node, select the dbo.PRC_CREATE_CLR_GET_ACTIVITIES_OBJECTS stored procedure, right-click, and choose Execute Stored Procedure.
Another possibility is that the .NET CLR isn't enabled. To enable it:
1. Start SQL Server Management Studio and connect to the server.
2. Expand the Databases node, expand the node for the ACT! database, and click the New Query button in the toolbar.
EXEC sp_configure 'clr enabled';
and click the Execute button in the toolbar.
4. If Config_Value is 0, type:
EXEC sp_configure 'clr enabled', 1; RECONFIGURE;
5. Launch the ActDiag program, ensure that on the first screen under Server Options that "CLR Enabled" appears, and rebuild the views. See http://stonefieldquery.com/OnlineHelp/ACT/_4ra0zgbih.htm for details.
« Go back