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:
Click the Windows Start button, right-click Computer, and click Device Manager in the dialog that appears.
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.
Click the Policies tab and turn off the Enable write caching on this disk option. 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. 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:
Click the Windows Start button, and type "cmd." "cmd.exe" will appear in the list; right-click it and choose Run as Administrator.
In the command window that appears, type the following:
C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol -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:
C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol -machine -addgroup All_Code -url *ServerPath*\wwDotNetBridge.dll
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.
If GoldMine is running when I try to run Stonefield Query, I get an error when I run a report. If Stonefield Query is running and I try to run GoldMine, I get a BDE error and it won't let me in.
If your operating system is Windows NT, Windows 2000, or Windows XP, you need to configure the Borland Database Engine (BDE) so it does a better job of sharing resources. To do that, choose Settings from your Windows Start button, then choose Control Panel. Double-click the BDE Administrator icon. Select the Configuration page in the BDE Administrator, click the plus sign in front of System to expand it, and then choose Init under System. Select the SHAREDMEMLOCATION setting, enter a value of 7000, and press Enter. Under the Object menu, choose Apply to save this setting. You can then exit the BDE Administrator. You may have to restart your system to have these settings take effect. Other values you can try are 7F00, 6BDE, and 5BDE; you may have to experiment with different settings to see which one is correct for your system (the allowable range is 1000 to 7F00). Also, you should set SHAREDMEMSIZE to at least 4096.
I'm getting an error when I run a report in Stonefield Query while GoldMine is also open. When I look at the details of the error message, it says "The table CONTACT1 (or some other table) is already opened exclusively by another user". What do I do about this?
This is caused by having GoldMine open its files exclusively, so other applications (such as Stonefield Query) can't access them while GoldMine is open. To change this, log into GoldMine as a user with master rights, and from the Edit menu, choose Preferences, and from the Login page, turn off the Open Files Exclusively setting.
I'm getting an error when I run a report in Stonefield Query. When I look at the details of the error message, it says "The Microsoft Jet database engine cannot open the file 'some GoldMine file name'". What do I do about this?
You most likely need to reinstall the ODBC drivers on your system. You can do this by downloading and installing the Microsoft Data Access Components (MDAC) from the Microsoft Web site (http://msdn.microsoft.com). Search for "MDAC" to find the downloads page for MDAC.
© Stonefield Software Inc., 2018 • Updated: 05/22/18
Comment or report problem with topic