When I select a certain report, I get a "Report contains tables and/or fields you do not have permission to access" error and I can't print the report.

As the error message indicates, you cannot access that report because it contains at least one table or field the administrator has determined you cannot access.

I have Stonefield Query installed on a server and published it as an application on a Terminal Server. However, when anyone runs Stonefield Query, they get an "MSVCR71.DLL cannot be found" error.

Since Stonefield Query is actually running on the Terminal Server (even though it's installed on the other server), you need to do at least a workstation install on the Terminal Server, because certain runtime files (such as MSVCR71.DLL) are required.

When I run a report, I get a "File c:\temp\somefile.tmp does not exist" error in the CreateReportFile method.

This error is most likely caused by having the System flag on your temporary files folder. To turn this off, click the Windows Start button, choose Run, enter ATTRIB C:\TEMP -S (in place of C:\TEMP, specify the path for your temporary files folder), and click OK.

Another possibility is that you have disk write caching turned on for your hard drive. To turn that off:

  • In Windows Vista and later versions, click the Windows Start button, right-click Computer, and click Device Manager in the dialog that appears. For earlier versions of Windows, right-click My Computer, click Properties, click the Hardware tab, and click Device Manager.

  • Click the plus sign next to Disk Drives to expand it.

  • Right-click the drive on which you want to disable disk write caching, and then click Properties.

  • For Windows Vista or later versions, click the Policies tab and turn off the Enable write caching on this disk option. For earlier versions, click the Disk Properties tab and turn off the Write cache enabled setting. Click OK, then close the Device Manager.

When I start Stonefield Query, I get a "bad path" or "invalid path or file name" error before anything appears.

This is caused by an invalid directory listed in your PATH environment variable. How you fix this depends on your operating system:

  • If the operating system is Windows 95 or Windows 98, the Path statement is found in the Autoexec.bat file.

  • For Windows NT, go to the System icon in the Control Panel. Select the Environment tab then check the contents of the Path variable. Windows NT also reads an Autoexec.bat file if one is present. Look for a SET PATH statement in the Autoexec.bat file if the Environment tab Path variable does not contain any visible problems.

  • In Windows 2000 and Windows XP, right-click the My Computer icon on your desktop and choose Properties. Select the Advanced page and click the Environment Variables button. Check the contents of the Path variable.

  • In Windows Vista and later versions, click the Windows Start button, right-click Computer, and choose Properties. Click Advanced system settings in the dialog that appears. Click the Environment Variables button and check the contents of the Path variable.

I'm getting a "Date/DateTime evaluated to an invalid value" error when I run a report.

This error occurs if you have dates in your database prior to 01/01/1601. Stonefield Query doesn't support dates earlier than that.

I'm getting an "Unable to create temporary work files" error when I run a report.

Stonefield Query temporarily puts some files in your Windows temporary folder. This error occurs if that folder is read-only, marked as hidden, or the volume it's on is almost full. You have to fix this problem before you can run any reports.

When I run a report, I'm getting an "invalid path or file name" error.

If you use the Advanced Report Designer to add an image to a report and you specify Expression or variable name for the Image source type setting, the field you use for the image must contain a valid image file name for every record in the report or you'll get an "invalid path or file name" error. In that case, set a filter on the report for that field not being empty.

I'm trying to schedule a report, but when I click Finish, I get an error message stating that the schedule couldn't be saved.

A scheduled report has to run under a specific Windows account, so be sure to enter the login name and password of the account to run the report under in the last step of the Schedule Wizard. Normally, this is your usual Windows user name and password. If you are on a network, you may need to specify the domain using "DOMAIN\USERNAME."

The scheduled task cannot be saved if you don't have a password for your Windows account.

I'm running Stonefield Query from my network server and when I try to email from Stonefield Query, I get a security policy warning.

The component Stonefield Query uses to send emails uses the Microsoft .Net framework. If you have an earlier version of .Net than 4.0 installed, by default, .Net won't allow operations such as emailing when the application exists on a server rather than on the local workstation. You can change the security policy setting by doing the following:

  • In Windows Vista or later version, click the Windows Start button, and type "cmd." "cmd.exe" will appear in the list; right-click it and choose Run as Administrator.

  • In Windows XP or earlier, click the Windows Start button, select Run, type "cmd," and press Enter.

  • In the command window that appears, type the following:

          -machine -addgroup 1 -url file://*ServerName*/*
          FullTrust -name *ServerName*_Zone -pp off

    In place of ServerName, specify the name of your server.

  • Alternatively, you can use:

          -machine -addgroup All_Code -url

    In place of ServerPath, specify the location where Stonefield Query is installed on your server.

I get an "insufficient GDI resources" error when I run a certain report.

This error occurs when you run a report that has more than about 4,800 pages. The issue is that Windows has a limited number of resources available for producing graphics, which is what report pages are output as. You have a few choices:

  • Use a filter to limit the report to less than 4,800 pages (the exact limit depends on your system and what other applications are running).

  • Output the report to PDF rather than printing or previewing it.

  • Bump up the number of resources Windows provides using the Registry Editor. Edit the value of the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows\GDIProcessHandleQuota key from the default of 10,000 to something higher, to a maximum of 65,536.

    This is for advanced users only who are comfortable changing the Windows Registry.

Stonefield Query crashes when exiting.

This happens on some Windows 7 and later systems. To fix this problem, turn off the Use special Windows features setting in the Options dialog.

I am getting a "There are too many fields in this report. Please reduce the number of fields and try again" error when I run a certain report.

This happens when the SQL statement used to process the data for a report exceeds 8,000 bytes. One way to fix the problem is to remove some fields from the report, but if you really need all of the fields in the report, you can turning off the Process null values specially setting on the Data page of the Options dialog. This reduces the size of the SQL statement by eliminating null processing. That means you might not get the results you expect if any of your fields contain null values, but at least the report runs. Since this setting affects all reports, you may wish to change it just for this one report by adding the following to the BeforeData script for the report (click Advanced in step 2 of the report wizard to access that script):

loDataEngine.lHandleNull = .F.