How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesWhen DataPA tries to connect to the AppServer I receive the following error even though I know the AppServer is running. ""Unable to read data from progress appserver""
Applicable Versions: All This error occurs when the AppServer has been stopped and re-started whilst DataPA is open and connected to the AppServer. To fix the problem you need to re-start DataPA. If you are running DataPA from a host application, for example Excel, you may need to close the host…
Read article →End Users › GeneralWhen I add a gauge to a report that has multiple locations, it creates a gauge for each location (very nice. However I cannot organize the gauges side by side, only one on top of the other. How do I
Applicable Versions: All It is possible to organise gauges side by side by setting the section of the report to have multiple Columns. A short video is available here that shows the steps. 1. Open the Group Options Dialog. Select the 'Section Options' Tab. Select the Section you want to have the…
Read article →Administration › InstallationWhen I add the DataPA add-in within Access, an error is displayed.
Applicable Versions:Various Symptoms When you try and install the DataPA Add-in, you get the error indicating that a wizard has not been installed or cannot be found. The error message may vary depending on which version of the Add-In is being selected. AccessPA.mde DataPA97.mde DataPA2000…
Read article →End Users › GeneralWhen I export a query to excel to a sheet number that is not the currently displayed I receive a Subscript out of range error.
Applicable Versions: All In some circumstances when exporting data from the DataPA Excel Add-in to an Excel worksheet that is not the currently selected sheet a Subscript out of range error can occur. The error can be caused if the Excel EuroTool Addin (Eurotool.xla or Eurotool.xlam) is active…
Read article →Administration › Client AdministrationWhen I install DataPA, I get the error message:Error 27500. This setup requires Internet Information Server 4.0 or higher for configuring IIS Virtual Roots. Please make sure that you have IIS 4.0 or
Applicable Versions: 2.02.0023 and above The SQL Server components distributed with the DataPA installation require a Microsoft IIS WebServer. SQL Server components are only required on a single server that will provide DataPA clients with access to non-Progress databases. If you select a…
Read article →Administration › InstallationWhen installing DataPA, DataPA Enterprise is not visible as one of the features? How do I install DataPA Enterprise?
Applicable Versions: 3.00 and Later Symptoms When you run the DataPA Installation, the installer does not show DataPA Enterprise as an available feature. Solution The issue is that DataPA Enterprise requires Microsoft Internet Information Services (IIS) 5 or above to be correctly configured on…
Read article →End Users › GeneralWhen installing DataPA on a machine with IIS7, DataPA Enterprise is not visible as one of the features. How do I install DataPA Enterprise on a machine with IIS7
Applicable Versions: 3.00 and Later Symptoms When you run the DataPA Installation on a machine with IIS7 installed, the installer does not show DataPA Enterprise as an available feature. Solution The issue is that DataPA Enterprise requires IIS7 to have IIS6 Metabase and IIS6 configuration…
Read article →Administration › InstallationWhen installing DataPA OpenAnalytics, I get an error message ""Operation failed with 0x8007000B"" An attempt was made to load a program with an incorrect format.
Applicable Versions: All The error occurs when you have an appropriate IIS webserver installed, but support for ASP.NET has not been configured. See this Microsoft Knowledge base for details on how to add support for ASP.NET to your operating system.
Read article →End Users › GeneralWhen I open a help file downloaded from the DataPA Website, every page displays the error ""Navigation to the webpage was canceled"".
Applicable Versions: All See http://support.microsoft.com/kb/902225
Read article →Administration › InstallationWhen I open DataPA Enterprise in a web browser, I get the error "No valid DataPA OpenAnalytics Enterprise license has been applied to this server". How do I fix this?
Applicable Versions: 4.05.000 Onwards To apply a license to a DataPA Enterprise server, you need to open one of the client applications (Enterprise Dashboard or DataPA Reports) and set the data location to the Enterprise Server. To do this, follow these steps; Open the Client Settings screen…
Read article →End Users › GeneralWhen I publish a dashboard, what determines whether it overwrites an existing dashboard or creates a new copy on the server?
Applicable Versions: 4.50 and above Dashboards are given a unique ID when they are created, and it is this unique ID that is used to identify the dashboard and determine whether it already exists on the server when you publish it. The unique ID will always remain the same in a dashboard, unless…
Read article →End Users › ClientWhen I run a query in Excel, I get the error "Run-time error '1004': Method 'Visible' of object '_Worksheet' failed".
Applicable Versions: 2.03.0137 and Earlier With some installations of Excel, an attempt to show or hide a worksheet from an AddIn failed with this error. Version 2.03.0137 and earlier did not cope with this error. To resolve this error, download the attached zip file that contains DataPA.xla. On…
Read article →End Users › GeneralWhen I run the DataPA AddIn from Excel 97 I get the error "Error in Hidden Workbook"
Applicable Versions: 3.01.0190 and Later A change was made to version 3.01.0190 to increase performance and reduce memory usage with the DataPA Excel Add In. Some of this code is incompatible with Excel 97. To resolve this error, download the attached zip file that contains DataPA.xla. On the…
Read article →End Users › GeneralWhen I try and connect to my AppServer, I get the error message "Could not connect to server".
Applicable Versions: All Detail of Error Messages is: Could not connect to the AppServer: General Error: com.progress.open4gl.NameServerCommunicationsException: Connect Failure: NameServer Communications Failure - java.net.SocketException: Connection reset by peer (8230). (7203)" DataPA could…
Read article →Administration › Server AdministrationWhen I try and connect to my AppServer, I get the error message "Could not connect to server". If I look at the details, it reads "Connect failure: Server refused connection (7251)"
Applicable Versions: All If your AppServer is defined with a connection procedure to process a username and password (see below), DataPA must prompt-for and pass a valid username and password to the AppServer. If it does not, the above error will occur. To configure DataPA to prompt for a…
Read article →Administration › Server AdministrationWhen I try and connect to my AppServer, I get the error message "Could not connect to server". If I look at the details, it reads "Connect failure: Server refused connection (7251)"
Applicable Versions: All If your system is defined to connect directly to your AppServer (rather than through a NameServer), and your AppServer is not running, or the Service field of your system setup does not indicate the AppServer Broker Port (see below), you will receive this error. Ensure…
Read article →Administration › Server AdministrationWhen I try and connect to my state-free AppServer, I get the error message "Could not connect to server". If I look at the details, it reads "Connect failure: Server refused connection (7251)"
Applicable Versions: All To date, DataPA does not support State-Free AppServers. For all supported AppServer operating modes, see "What AppServer operating modes does DataPA support?".
Read article →End Users › GeneralWhen I try and export a report that contains Unicode characters to a PDF document, I get an error like ""-214746259 - ActiveReports PDF export error"".
Applicable Versions: All In order to export reports that contain Unicode fonts toi PDF documents, you must select Acrobat version 4.x and ensure you do not attempt to embed any fonts.The screenshot below shows the export dialog window. Follow these steps: Check the Advanced Options check box.…
Read article →End Users › ClientWhen I try and run a query in DataPA, I get the error Automation errorClassFactory cannot supply requested class
Applicable Versions: All DataPA requires an environmental variable, CLASSPATH, to be set on the client machine. DataPA sets this as a system wide environmental variable so DataPA will work for any user logged on to the machine. This environmental variable is often used by other applications, and…
Read article →Administration › SetupWhen I try and use the Create New Report option I get the following error 3021 - Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ADOD
Applicable Versions: All This error can arise if the setup file ( DataPASetup.dat ) has been saved with a later version to that running in the DataPA Client Application. Subjects can be moved from a later Version of DataPA using the Analytics Import/Export functions, available in the Analytics…
Read article →Administration › InstallationWhen I upgraded version 4.5 (or older) to version 5.5, I lost the Analytics Engine configurations (systems, subjects etc). Can I get them back?
Applicable Versions: 5.50.0000 - 5.50.0027 The installer for version 5.5 installed a new configuration file that overrode any configurations set up in Versions 4.5 and older. This problem was fixed in the installer with version 5.50.0028, however for customers that installed previous versions of…
Read article →End Users › GeneralWhen running a query, DataPA returns an error in the format 'Error No'.
Applicable Versions: All There are a number of errors that can be returned when running a query. As a starting point for troubleshooting, look in the AppServer Log File for any error that are displayed. There may be more information displayed in the Log File. Error No 40 must be a quoted…
Read article →End Users › GeneralWhen running a query to generate an excel data sheet I get the following error. "The name that you type does not exceed 31 characters...."
Applicable Versions: All The Full Error is: ERROR+++++++++++++++++ You typed an invalid name for a sheet or chart. Make sure that: • The name that you type does not exceed 31 characters. • The name does not contain any of the following characters: : \ / ? * [ or ] • You did not leave the name…
Read article →Administration › Server AdministrationWhen running DataPA on 64 bit machine I get errors when using DataPA Enterprise. How do I fix this?
The errors coming from this problem could be one or more of the following: Retrieving the COM class factory for component with CLSID {9115D8CB-D713-48D1-83D2-53CD1AE4FDBF} failed due to the following error: 80040154. Open query failed for Query Error occurred while running report: No Agents are…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗