How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesDo I need to do anything else after upgrading DataPA on my client?
Applicable Versions: All The procedure libraries referenced by your ApppServer, that DataPA connects to, are version specific. As such you should always update these procedure libraries on the server with the same version installed with the client. To update the procedure libraries, check first…
Read article →End Users › GeneralEmail from the Scheduler is not working
Applicable Versions: All The following link to the online Help manual shows the Mail settings screen Emails not being sent out is not necessarily an issue with DataPA. To track down possible causes the following items would be a good starting point. Check the Scheduler log file, and/or the…
Read article →Administration › InstallationEmails with excel attachments are not being sent from the Scheduler , but do get send when the task is run manually. Errors appearing in the log include SEND EMAIL FAILED. PLEASE CHECK YOUR MAIL SERV
Applicable Versions: 4.00 onwards In normal cases a the temp file is created then deleted at the end of the task being run. The file is listed in the log file and usually is in the folder "C:\ProgramData\DataPA\data". The Mail fails as it is expecting a file that cannot be accessed. The "SaveAs…
Read article →Developers › DevelopmentEmbedded dashboard only shows login screen
Please see HTTPS is required for embedded dashboards
Read article →Administration › Server AdministrationEnable SSL/HTTPS for DataPA Enterprise
To enable SSL on a website in IIS, first select the site under which DataPA is installed (usually Default Web Site), then select Bindings. In that binding, select HTTPS as the Type. You will need to provide an SSL certificate. If you do not have one yet, you can create a temporary self-signed…
Read article →End Users › GeneralError message attempting to access DataPA - Unable to de-serialise server security data.Additional error: Failed to open stream, array passed was empty
Applicable Versions: 4.05 onwards If an Error message is displayed when attempting to access DataPA and this is happening on more than one client there may be an issue with the service. As an initial step to resolution Start and Stop the DataPA Enterprise Service on the server.
Read article →Administration › InstallationFailure to Render Report to a Browser on Server 2012. When running a report, after the Query Run box clears, the report does not display, showing either a blank screen or with a spinning icon where th
Applicable Versions: 5.00 and above This can happen when the HTTP Activation IIS role has not been installed. This has to be set as a role under the "Application Server - Windows Process Activation Service Support" feature. Setting this on at this level will also enable HTTP Activation under the…
Read article →End Users › GeneralHow can I add a dynamic image to a report that is loaded from a filename defined in a field?
Applicable Versions: All It is possible use images on a report dynamically loaded from a URL stored within a database. To achieve this of the report designer, follow these steps: Start DataPA Reports and create a report using a query which contains the field with the URL for the image. Add an…
Read article →Administration › InstallationHow can I add my own branding to the client applications?
See Can I change the images and text shown by the DataPA client applications?
Read article →Administration › Server AdministrationHow can I avoid having to reboot my computer after applying an update to DataPA?
Applicable Versions: All DataPA will prompt you to reboot your PC after applying an upgrade to DataPA if any of the files that need to be overwritten are in use. To make sure you will not have to reboot after applying an update to DataPA, check the following: Make sure there are no copies of…
Read article →Administration › Server AdministrationHow can I call my existing business logic, in a procedure, from DataPA?
Applicable Versions: 2.01.0152 Onwards DataPA allows you to call Progress ABL functions that generate a temp table to provide data for your reports, queries and dashboard, see Can I create a query that runs a Progress function on the server to retrieve data? for details. Your business logic…
Read article →End Users › GeneralHow can I change the visibility of fields on a report based on the value of a Parameter?
Applicable Versions: All Versions Sometimes you might want to show of hide a field on your report based on the value of an parameter. This can be achieved by adding the parameter to the report's Page Header then adding some script to the OnFormat event of the report Detail section This script…
Read article →Administration › Server AdministrationHow can I configure my AppServer so I do not have to restart all of the agents each time I add or change a business logic routine?
Applicable Versions: 2.01.0152 Onwards If you use Progress ABL business logic functions for calculated fields in a freeform subject (see "Can I create a calculated field based on some Progress ABL Business logic?"), or to create business logic subjects (see "Can I create a query that runs a…
Read article →End Users › TutorialsHow can I create a freeform subject that draws information from more than one table in the database?
Applicable Versions: All The following tutorial shows how to use links to allow you to create a freeform subject that draws information from multiple tables in the connected databases.
Read article →Administration › InstallationHow can I determine or change the DataPA Enterprise Web Application timeout?
Applicable Versions: 4.00 Onwards The DataPA Enterprise web application has no settings that relate to the control of the session timeout. The session timeout defaults to the values configured within IIS. The normal setting for this is the "Application Pool" - "Process Model" - "Idle Timeout"…
Read article →End Users › GeneralHow can I easily change my DataLocation so that my setup is stored centrally on an AppServer?
Applicable Versions: 2.01.0152 and above In most corporate environments, you will want to store your setup files centrally on an AppServer so they can be controlled centrally. To do this you will need to change your DataLocation to point to an AppServer (see "How do I store my setup centrally on…
Read article →End Users › GeneralHow can I get page numbers to restart for each group on my report?
In order to achieve this some of the properties of the page number field need to be changed. This KB entry assumes that you have grouping on your report and have a page number situated in the Page Footer section on your report. In the design window of DataPA Reports select from the menu View >…
Read article →Developers › DevelopmentHow can I get the URL for a dashboard, report or query published to DataPA Enterprise so I can use it in my own web application?
Applicable Versions: 4.05.0050 and above You may wish to embed dashboards, reports and queries into your own webspeed or web application. Follow these steps to retrieve the URL for the dashboard, report or query you wish to embed; Open the DataPA Enterprise Dashboard client application. From the…
Read article →Administration › SetupHow can I import links from QAD into DataPA? The import deafult links wizard doesn't return any records.
Because the QAD MFG/PRO database has field names which are unique the import default database links does not return any records. This is the same result as if you ran the DB Relations report in the Progress Data Dictionary. In order to quickly and easily set up links in DataPA for this database…
Read article →End Users › GeneralHow can I improve the performance of dashboards embedded in my application?
See A particular dashboard I have published is slow to open in the web. How can I improve this?
Read article →End Users › GeneralHow can I improve the performance of my dashboard in the mobile apps?
See A particular dashboard I have published is slow to open in the web. How can I improve this?
Read article →End Users › GeneralHow can I improve the performance of my dashboard in the mobile web?
See A particular dashboard I have published is slow to open in the web. How can I improve this?
Read article →Administration › Server AdministrationHow can I log, modify or override the query statement used in all freeform queries?
Applicable Versions: 3.02.0156 and above DataPA OpenAnalytics provides a hook on the server that allows you to intercept and modify the query statement before any freeform query is executed by the AppServer. This allows the administrator to add code to the server to log, modify or override any…
Read article →Administration › Server AdministrationHow can I manage the automatic update functionality internally, so we control updates to our users rather than it coming from the DataPA website?
Applicable Versions: 3.00.0001 Onwards DataPA's automatic update information can be configured to load updates from your own servers rather than DataPA's. Follow the steps below to configure the update. Create your own update.xml file. You can download the latest update.xml from…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗