How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesCan I specify the data location for DataPA to use as a command line switch?
Applicable Versions: 3.02.0035 onwards From version 3.02.0035 onwards you can use a command line switch to set the data location that DataPA should use for that session. This is done by using the /d and /x switches. You must enclose the data location you want to use in double quotes. So for…
Read article →Administration › Server AdministrationCan I store my setup data in a standard XML format rather than DataPA's proprietry dat format?
Applicable Versions: 3.00.0078 to 3.05.0075 NB: This functionality was retired with version 4.00. To allow you to manipulate the setup data, for instance filtering subjects and fields on a per user basis, it is possible to configure DataPA so the setup data is stored in readable XML files rather…
Read article →Administration › SetupCan I store the DataPA configuration in a database?
Yes, you can store the DataPA configuration in a database. This allows you to completely control, based on the user, which connections, subjects, subject fields, links and lookups they have access to. In order to achieve this you need to follow the steps below. If you are starting with the…
Read article →End Users › GeneralCan I use an inner join with a multi level query in DataPA?
Applicable Versions: 3.02.0032 onwards From version 3.02.0032 onwards an inner join can be used in a multi level query in DataPA. To use an inner join instead of an outer join (which is the default behaviour) you must highlight the child subject in the tree and check the inner join box located…
Read article →End Users › GeneralCan I use a query created when I create a report in other applications like Excel?
Applicable Versions: All DataPA is designed to allow you to share queries easily between the different applications on your desktop. If you have a report, and would like to use the query behind that report in Excel, you can easily share that query. The video below demonstrates how to share a…
Read article →Developers › DevelopmentCan I use DataPA with a direct database connection?
Applicable Versions: 3.02 Onwards From version 3.02 DataPA can now use a direct database connection rather than having to access the data through the Progress AppServer. This is only possible where the DataPA has been embedded into a Progress GUI client which already has established database…
Read article →Developers › DevelopmentCannot add the DataPA Reports control to a Visual Studio 2005/2008 Forms project.
Applicable Versions: 2.05.0257 and previous Symptoms When you try to add a DataPA Reports object to a windows form you get the error message ""Failed to import the ActiveX Control. Please ensure it is properly registered"". When you try build an existing windows forms project with a DataPA…
Read article →Administration › Server AdministrationCannot pass the login screen on Chrome when using DataPA embedded.
Applicable Versions: 5.50 Onwards This issue is that when using the chrome browser the dashboard is not accessible in an iframe (logging into the dashboard redirects to the dashboard login page), the same action work in Internet Explorer. The likely cause is a Cross-Origin error. Chrome…
Read article →Administration › Server AdministrationCannot Schedule Any Tasks. Run-time Error '-2146232576 (80131700)'
Applicable Version: Version 5.5.0212 onwards When selecting Ok on the Schedule Task screen of Scheduler Maintenance a Run-time Error '-2146232576 (80131700)' is displayed and the Scheduler Maintenance program Closes The .NET Framework 3.5 ( includes .NET 2.0 and 3.0) Feature needs to be installed.
Read article →Administration › Server AdministrationCan reports on DataPA Enterprise be rendered out of process?
By default DataPA Enterprise will render report using the DataPA Enterprise Report Service. This is a 32-bit Windows service. This creates COM objects for the purpose of rendering the reports and under heavy use this can sometimes cause issues with the DataPA Enterprise Report Service itself.…
Read article →End Users › GeneralCan the DataPA Excel Add in work with a 64bit version of Office?
Applicable Versions: Prior to Version 6 Prior to Version 6. DataPA does not support pure 64bit operation required for 64bit Microsoft Office. Applicable Versions: Version 6 onwards A new 64 bit DataPA Excel Add-in was introduced in Version 6.0.
Read article →Administration › Server AdministrationCan the look and feel of DataPA Enterprise by customised ?
Applicable Versions: 3.00.0073 Onwards DataPA provides two Cascading Style Sheets (.css) that allows the modification of the look and feel of DataPA Enterprise to suit individual requirements. These files are located withing the Stylesheet folder of the DataPA Enterprise Installation.…
Read article →End Users › Client"Class not registered" error when opening Server Settings
If you see an error with the detail "Class not registered" when attempting to open the Server Settings in DataPA Enterprise Dashboard, it may mean that Internet Explorer has been disabled on your machine. To remedy, open "Turn Windows Features On or Off" via the Windows Control Panel, and tick…
Read article →Developers › DevelopmentControlling the export process using the API
Unfortunately it is not possible to configure the settings of this export screen using the com object. That said, you can manually manage the export process rather than using this screen. For instance, if you want to export the report to a PDF file, where the export file name is contained in the…
Read article →End Users › GeneralDashboard problems with large result set - resulting in OutOfMemory exceptions.
Applicable Versions: 4.05 onwards System.IO.OutOfmemory error messages with a dashboard that returns a lot of data a consequence of a 32 bit process performing various simultaneous functions on a large dataset. The dashboard is doing a lot more than Excel with the dataset. In addition to…
Read article →End Users › ClientDataPA and Access 365
In Versions before 6.0. The DataPA option for Access was an 'Add-In' that Appeared under the 'Add-ins 'Menu item. From Version 6.5.0152 onwards the DataPA option for Access is now a DataPa Application that is accessible from the start menu. The item is named 'DataPA Accedd Utility'. The…
Read article →End Users › ClientDataPA and Excel
In Versions before 6.0. The DataPA option for Excel was an 'Add-In' that Appeared under the 'Add-ins 'Menu item. From Version 6.0 onwards the DataPA option for Excel is now a Toolbar item that appears as a Main Excel Item named 'DataPA OpenAnalytics Excel Addin'. The screenshot below shows a…
Read article →Administration › InstallationDataPA Enterprise has stopped working for no reason. I get a 404 error when I start it or just a blank page?
This problem can be caused by a Windows Update which prohibits the use of ASP.NET web service extensions. This effectively means that no ASP.NET based application will be permitted to run on IIS. As an ASP.NET application DataPA Enterprise is affected by this kind of Windows Update. To resolve…
Read article →End Users › ClientDataPA Menus are slow to react on machines running Microsoft Vista
Applicable Versions: 2.05.0260 and below A bug has been identied with DataPA running on Microsoft Vista machines. The problem causes the DataPA menus to react very slowly, with a pause of 10 to 20 seconds to open a drop down menu. The bug effects any Windows Vista machine with using the Windows…
Read article →Administration › InstallationDataPA Reports and DataPA Scheduler return Run time error 429 or -2147221164
Applicable Versions: 6.50.0092 onwards If a machine has had previous versions of DataPA OpenAnalytics installed, the installer can sometimes fail to register a particular component correctly. This will result in the error below when you try and open the report designer or scheduler apps; To fix…
Read article →Administration › InstallationDataPA_Sched.exe has stopped working Error is generated when running a scheduled task.
Applicable Versions: 5.50.0200 Onwards The Error 'DataPA_Sched.exe has stopped working' can occur when there is an incorrectly registered dll. Running the following commands at a Command prompt "As Administrator" should resolve the issue cd "\Program Files (x86)\DataPA\Bin"…
Read article →Administration › InstallationDataPA scheduler unscheduled a job and will not allow it to be scheduled.
Applicable Versions: All Note: This applies to pre Vista operating systems. If you are running on Windows 8 or Server 2012 then see the kb After Upgrade to Version 5 all scheduled Tasks became Unsheduled. Attempts to set a time doesn't schedule them. Possible causes and resolution:- Check that…
Read article →Administration › InstallationDataPA works from a mobile/ Tablet ( Android / Ipad / Iphone) browser but cannot connect using the DataPA Mobile App.
See What features of IIS need to be installed for DataPA Enterprise?
Read article →End Users › GeneralDoes DataPA OpenAnalytics have a vunerability to log4j exploit?
We can confirm that there is nothing in DataPA OpenAnalytics itself that uses log4j. OpenAnalytics is built on .NET technology, and does not use Java. There may however be some vulnerabilities in the Progress architecture stack that DataPA OpenAnalytics connects to. For details more, Progress…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗