How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesAfter doing a DataPA update I cannot view my form which uses a DataPA control and receive the error ‘Visual Designer cannot load this class’. How do I fix this?
When an update has been done to DataPA the assemblies which hold the DataPA .NET controls will likely have had their version numbers incremented and this causes Progress Architect to believe that the DataPA controls are no longer available. Architect doesn’t handle the upgrade of these controls…
Read article →Administration › Server AdministrationAfter Upgrade to Version 5 all scheduled Tasks became Unsheduled. Attempts to set a time doesn't schedule them.
Applicable Versions: Version 5 to 5.50 In some instance on Windows 8 and Windows Server 2012 the upgrade to Version 5 does not install a registry entry. To resolve a Registry Entry Key must be added. Import from File Save the following three lines to a file with an extension of ".reg" then…
Read article →Administration › InstallationAfter Upgrading to Version 6.0 and opening Excel I get the Error Sorry, we couldn't find c:\Program Files x(86)\DataPA\Excel\DataPA.xla. Is it possible it was moved, renamed or Deleted?
See How do I remove my DataPA Add-In in Microsoft Excel?
Read article →Administration › InstallationAlert images and Export's do not get generated from the DataPA Enterprise service. An error referencing ""System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)"" may be displayed in the En
Applicable Versions: 5.50 Onwards The generation of images for alerts and exports from the Enterprise Service requires an IIS feature to be installed. The feature "IIS6 Metabase and IIS configuration compaibility" needs to be enabled. To enable use the "Turn Windows features on or off" windows…
Read article →End Users › GeneralAll my charts are not displaying, just showing blank space. The issue started in late December 2015.
Applicable Versions: All A Windows Update from 29th December 2015 will cause issues stopping Charts being displayed in the Dashboard Designer Client. The update ( KB3132372) will be listed as a varient of, or similar to :- Security Update for Internet Explorer Flash Player for Windows 10 (…
Read article →End Users › GeneralA particular dashboard I have published is slow to open in the web. How can I improve this?
Applicable Versions: 5.50.0103 and above The time a dashboard takes to load in the web, or mobile apps is affected by the amount of data the server must load to render that dashboard. Obviously reducing the number of objects on a dashboard, or reducing the amount of data the query returns will…
Read article →End Users › GeneralAre Report Drill-downs available on Mobile Devices?
Applicable Versions: 5.50.0200 Onwards Report Drill-downs do not work with mobile devices.There are no plans to implement this in the future. Drill downs are interactive and as such are best withing Dashboards rather then reports.
Read article →End Users › GeneralBoolean fields and boolean calculated fields display as 0 or -1 in the report designer. How can we change that to True or False?
Applicable Versions: 2.01.0152 onwards If your query returns a field with a boolean (logical) data type, it will be displayed using the default Microsoft format, that is 0 for false and -1 for true in a report. There are two ways you can overcome this behaviour to display either true or false…
Read article →End Users › GeneralBusiness logic query fails with error message “Communication layer message. Error marshalling or Unmarshalling (8408) (7175)" whilst running via the Progress AppServer Internet Adaptor (Aia)
Applicable Versions: All The AIA configuration in the unbroker.properties file contains a setting called soReadTimeout. This setting defaults to 240, and is described as; Specifies the amount of time, in seconds, the Aia adapter will wait for a response from an appserver before sending a…
Read article →Administration › Server AdministrationCan DataPA connect to a 64bit server running Progress OpenEdge 64bit?
Applicable Versions: All DataPA support server-side connections to all Progress OpenEdge 10 64bit AppServer configurations. You will however need a procedure library compiled using a 64 bit version of Progress. For the latest release of DataPA, you can download the procedure library here. For…
Read article →Administration › Server AdministrationCan DataPA Enterprise be configured to use Microsoft Active Directory for user authentication?
Applicable Versions: 4.5 to 5.5. Please see the article for v6.0 This article describes how DataPA Enterprise can be configured to use MS Active Directory (“AD”) for user authentication, and assigning users to groups. 1. Set-up Authentication AppServer The authentication will be performed by a…
Read article →End Users › GeneralCan I add a subtotal to a report with Groups?
Applicable Versions: All Adding subtotals and totals to a report is a common task that is made easy with the DataPA Reports Summary Field object. The video below gives a demonstration of adding a sub-total to a report.
Read article →Administration › InstallationCan I change the images and text shown by the DataPA client applications?
Applicable Versions: 5.50.0001 Onwards You can configure what images are used for the splash, about and login screens with DataPA OpenAnalytics, and text that appears in the client applications with a small text file. The file should be located in the directory [InstallDir]\Common and called…
Read article →End Users › GeneralCan I combine freeform and business logic subjects in a single query?
Applicable Versions: 2.01.0152 Onwards This article uses business logic functions. For more information on creating business logic functions, see "Can I create a query that runs a Progress function on the server to retrieve data?". Using Multi-Subject Queries, you can combine any number of…
Read article →End Users › GeneralCan I combine more than one subject in a single query?
Applicable Versions: All With Multi-Subject Queries, DataPA allows users to combine more than one subject in a single query. The video below demonstrates how to create a report using two subjects.
Read article →Administration › Server AdministrationCan I connect and retrieve data from an SQL data source?
Applicable Versions: 2.01.0152 Onwards If you require frequent access to an SQL data source, you can use the Progress DataServers to connect the SQL data source to the Progress AppServer (the data servers are licensed with DataPA business licenses. Please speak to your sales representative for…
Read article →Administration › SetupCan I create a calculated field based on some Progress ABL Business logic?
Applicable Versions: 2.1.0152 Onwards DataPA Freeform Subjects can include calculated fields derived from any valid Progress ABL statement. By using the Progress DYNAMIC-FUNCTION statment, you can include calls to a ABL business logic function on the server to populate your calculated field. The…
Read article →Administration › Server AdministrationCan I create a query that runs a Progress function on the server to retrieve data?
Applicable Versions: 2.01.0152 Onwards DataPA Supports Business Logic subjects that allow reports and queries to be built using any Progress 4GL code that returns a temp-table. The video below shows an example of how to create a business logic subject, and a report based upon it. The code…
Read article →End Users › GeneralCan I create a report based on an existing query, rather than having to create a new query for my new report?
Applicable Versions: All DataPA is designed to allow you to share queries easily between the different applications on your desktop. If you have a query, and would like to create a new report using that query as a starting point, you can simply create a report based on that query. The video…
Read article →End Users › GeneralCan I create summary queries in DataPA?
Yes, DataPA in V4 now supports summary queries. These enable you to use your subjects to create summarised ""cubes"" of data which are processed on the AppServer and only the summarised results being passed back to the client application. The summary queries also have the ability to identify…
Read article →End Users › GeneralCan I limit number of records that I retreive when I run a query or report in DataPA?
Applicable Versions: 3.02.0032 onwards From version 3.02.0032 onward you can enter the number of rows you want a query or report to retrieve. To do this run the report or query as normal and in the run query wizard just prior to the query running you can now select ""Return All Rows"" which will…
Read article →Administration › InstallationCan I run DataPA Enterprise on a different port to the default port 80?
Applicable versions: 4.05.0082 to 5.5. Please see the new method for v6.0 You have always been able to run the DataPA Enterprise web portal on a different port from the default port 80 by configuring it in IIS and from version 4.05.0082 of DataPA you can also choose to run the DataPA Enterprise…
Read article →Administration › InstallationCan I run multiple instances of DataPA OpenAnalytics Enterprise on a single Windows Server?
From version 6.00.0139 of DataPA it is now possible to run multiple instances of DataPA OpenAnalytics Enterprise on a single Windows Server. Setting this up is documented in this document. There have been helper executables and BAT files added to help automate many parts of this process. The…
Read article →Developers › DevelopmentCan I save and store reports in my Progress Database?
Applicable Versions: 3.05.0014 onwards Reports can be stored in a Progress table like any other binary object using the RAW data type. The example code below uses a temp-table to store and load the report. This temp table could be passed to a server if required, and stored in a database table.…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗