How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesMy query against an OpenEdge database is slower than expected or returns unexpected results. How can I see the ABL query that is being executed on the server?
Applicable Versions: 4.00.0001 and above If a query is slower than expected, or returns unexpected results, it can be helpful to see the ABL query that will be executed on the server. If your query is in a dashboard, follow these steps to view the ABL query string that will be executed on the…
Read article →End Users › GeneralMy sub report always shows every detail row, rather than just the detail rows that match the parent row. How can I fix this?
Applicable Versions: All In order to create a sub report with parent and child information, you must first create a query with multiple subjects, and join those subjects using one or more fields in the parent and child subjects. For instance, in the example below, I have created a query using…
Read article →Administration › Server Administration**** NO VALID AVAILABLE SCHEDULER LICENSE, EXITING is appearing in my scheduler log file.
Applicable Versions: All Versions The " **** NO VALID AVAILABLE SCHEDULER LICENSE, EXITING " error message can appear for several reasons. The Scheduler licence has not been applied. If the Data Location is set to an Enterprise service that has security applied then security must be applied to…
Read article →Administration › InstallationOn Windows 2000 SP4 machines, DataPA Dashboard crashes when you try and open it, DataPA Report crashes when you try and add a graph to a report, and you cannot open a report with a graph on it.
Applicable Versions: All Symptoms When you try and open the DataPA Dashboard, you get the error ""Run Time error '339' - Component 'ChartFx.ClientServer.Core.dll' is not correctly registered"" When you try and add a graph to a report in DataPA Reports, DataPA Reports crashes with the error ""Run…
Read article →Administration › SetupOpenanalytics Download - Latest Version
Product Downloads Download the latest installation package and access release documentation for your DataPA product. Latest Software Release The latest production release is available below. Installation Package Download the latest product installer (.exe) Includes all required application files…
Read article →Developers › DevelopmentPassing AutoLogin=true and the username and password no longer automatically logs a user in to DataPA Enterprise. How do I fix this?
Applicable Versions: 5.50.0078 to 6.00.209 With version 5.50.0078 DataPA Enterprise was changed to only accept the username and password in the message body (post request) of a request by default. This was to ensure the username and password would be encrypted when passed across an SSL…
Read article →End Users › GeneralProgress Explorer does not work after uninstalling DataPA
Applicable Versions: 2.05.085 and below Symptom After uninstalling DataPA, Progress Explorer fails (see screenshot below). Cause The problem is caused when the DataPA MSI Package unregisters a Progress OpenClient component called o4glactivex.dll. In this situation, the MSI Package removes some…
Read article →Administration › Server AdministrationPublish problems . Error occurred when writing info store binary back to MMF. Error Is Target = NotEnoughRoom Message: Not enough space available in the buffer.
Applicable Versions: Version 5.5 and Later The issue here is just that you are running out of space in the file that stores details of all the dashboards. You can increase this setting from the Server Settings screen, on the Resources tab. Change the setting Maximum memory usage to store details…
Read article →Administration › Server AdministrationRefreshing a Query in the Enterprise Dashboard returns an error "Your user directory has reached the size limit set by the administrator. In order to run this item you will need to delete some of your
Applicable Versions: 4.5 and above. When users refresh queries or reports using DataPA Enterprise, the results are stored in a directory specific to that user. The message is informing you that the Maximum size for the user has been reached. If some of the stored results are removed then this…
Read article →Administration › Server AdministrationRelate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large.
The Error "Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large." appears when running a report/query in the Scheduler. This error can arise when a scheduled report is run where an filed in the sort orders, ( i.e, used in a group by…
Read article →Administration › InstallationRepair or remove DataPA OpenAnalytics in Windows 10
Repair in Control Panel To repair DataPA OpenAnalytics, go to Control Panel. On the Start menu, enter Control Panel in the search box and select Control Panel from the results. Select Programs > Programs and Features, and then select the DataPA OpenAnalytics. To fix DataPA OpenAnalytics, select…
Read article →End Users › GeneralReport Designer crashes after running a query
Applicable Versions: All A Microsoft update was released on 13th August that contained a change in the oleaut32.dll to mitigate a specific security exploit. Unfortunately, this mitigation unexpectedly caused any VBA and VB6 apps that passed an empty ParamArray to receive E_INVALIDARG in return…
Read article →Administration › InstallationServer Error in '/' Application it is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being
Full Error is Server Error in '/' Application it is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application IIS on a Windows 2008 and 2012 machine. See What…
Read article →Administration › InstallationServer Error in '/' Application it is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being
See Update Request Failed is displayed in DataPA Enterprise when a query is refreshed on a Windows 7 and 8 machine.
Read article →Administration › Server AdministrationTask XML contains an unexpected node. Upgrading from before 5.50.0212
Following a Windows Task Scheduler component being upgraded a setting that DataPA Scheduler used is no longer supported. This results in a "The task XML contains an unexpected node." error when the Task is Viewed using the windows Task Scheduler. DataPA was using Task 1.0 this creates the XML…
Read article →Administration › InstallationThe DataPA Add-In button does not appear in Excel. How can I add it manually?
Applicable Versions: Prior to Version 6.0 The details on how to manually add the DataPA Add-In to Excel differ slightly depending on whether you are using Excel 2007, or earlier. Follow the details below that relate to your version of Excel to manually add the DataPA Add-In to Excel: Excel 2007…
Read article →Administration › Server AdministrationThe Enterprise web portal does not receive live updates such as published dashboards and alerts.
Applies to v6.0 to V6.00.0135 If you are using DataPA Enterprise over HTTPS/ SSL, it may be necessary to configure the DataPA Enterprise Service to also use this secure connection. Some browsers will not permit communication from a secure (https) connection to an insecure (http) connection. The…
Read article →Administration › Server AdministrationThe Error "Broker System failure: Invalid state for deallocate: Current state = STATE_RECEIVING (7249) " is being returned from a query.
Applicable Versions: All Versions This error occurs when the process running the query has lost it’s connection to the AppServer. When the query completes on the AppServer it goes to return the data but finds that the client has gone. Whilst this is most commonly due to a network problem between…
Read article →End Users › GeneralThe publish button in the Dashboard Designer or Report Designer is not enabled. How do I publish a dashboard or report?
Applicable Versions: 5.00.0000 Onwards In order to publish content so it can be consumed in a browser or mobile app, you must have your client applications configured to connect to a DataPA Enterprise service to retrieve the analytics engine configuration, and have permission to publish to this…
Read article →Administration › Server AdministrationThe underlying connection was closed: An unexpected error occurred on a send
This may be caused by the security protocol settings on your server. You may see this if any TLS protocols are disabled. Please update to the latest version of OpenAnalytics. If this does not solve the problem, enable all TLS protocols, re-install OpenAnalytics, then disable the protocols you do…
Read article →End Users › GeneralUnable to Add the DataPA Excel Addin vsto file
In some cases the DataPA addin is not available. If the VSTo Addin File is run from the O/S the install fails with errors like System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/DataPA/Excel/DataPA OpenAnalytics Excel Addin.dll.config did not…
Read article →Administration › Server AdministrationUnrecognized attribute 'cookieSameSite'
Should you receive the error "Unrecognized attribute 'cookieSameSite'" when running DataPA OpenAnalytics Enterprise, please run Windows updates on your server. Support for SameSite cookies was added to the .Net Framework in December 2019.
Read article →Administration › InstallationUpdate Request Failed is displayed in DataPA Enterprise when a query is refreshed on a Windows 2008 and 2012 machine.
See What features of IIS need to be installed for DataPA Enterprise?
Read article →Administration › InstallationUpdate Request Failed is displayed in DataPA Enterprise when a query is refreshed on a Windows 7 and 8 machine.
Can you make sure the following Windows Features, accessed through "Programs and Feature" are installed, there will be other options checked but these will need to be checked on. .Net Framework 4.5 Advanced Services ( or any other version above 3.5 ) WCF Services the following sub items should…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗