Knowledgebase
Stonefield Query Home > Stonefield Help Desk > Knowledgebase

Search help:


"ACT! OldDB Provider for Reporting 2.0 : Failed to parse SQL" error with Activities table

Solution

Applies to:

  • 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.

3. Type:

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;

and click the Execute button in the toolbar.

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.

 
Was this article helpful? yes / no
Related articles How do I recreate ACT!'s database views using the ActDiag tool?
Handling Tables with the Same Names in Different Databases
Error reading file on network drive or C000006 error
A message reading "Cannot CoCreateInstance(CLSID_IOleDBSecurityImp)" appears when I attempt to log in to my database in Stonefield Query for ACT!.
Improving the Performance of Calculated Fields and Formulas
Article details
Article ID: 42
Category: Error Messages
Rating (Votes): Article not rated yet (0)

 
« Go back