How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesIn DataPA every time I open Excel 2003 or Access 2003 the Windows Installer windows appears.
Applicable Versions: Version 3 and above. (Use .NET 2.0 Progress Open Client) This is due to a bug in Office 2003. This Microsoft KB entry explains the problem and provides a fix. Update for Office 2003 (KB907417)
Read article →End Users › GeneralIntermittent Update Request Failed error appearing in Embedded Dashboards
Applicable Versions: 5.50 and above Expanding the error may give a some additional information relating to the reason the Update Failed. This error appear can appear intermittently for a couple of reasons:- If the browser has been left unattended then the user may have been logged out of the…
Read article →Administration › InstallationI received Error 1721 when installing DataPA on Vista PC, after the error DataPA uninstalls the product.
Applicable Versions: 3.02.0026 and below The installation of DataPA includes an installation of Adobe Flash. On a PC running Vista the Flash installation needs to be run with Administrator privileges. With version 3.02.0031 and above, the Flash Installation inherits the raised privileges of the…
Read article →End Users › GeneralI see "Invalid Token. Access Denied" when viewing a dashboard on and iOS device such as an iPad or iPhone
The latest version of the DataPA app for Apple iOS devices (iPad, iPhone, iPod) has a minimum requirement of iOS 10.2 or later. Devices running older versions of iOS are unable to run the latest version of the app, and older versions of the app do not work with the latest version of DataPA…
Read article →Administration › Server AdministrationI see the error "At least one security token in the message could not be validated"
Applicable versions: 6.0 DataPA now uses authorisation tokens to secure communications to its services. This message indicates a problem with the token authorisation. Normally it is sufficient to find DataPA services at 'localhost', however some server configurations (such as use of domain…
Read article →Administration › Server AdministrationI see the error "No auth token could be retrieved"
See I see the error "At least one security token in the message could not be validated"
Read article →Administration › SetupIs it possible in DataPA to create a query that will return records from one table which have no matches in a second table?
Yes, in order to achieve this a special type of link between the database tables needs to be created. This functionality is available from version 3.05.0036 onwards. If we take an example using the sports2000 demo database and say that we want to create a query to find customers who have no…
Read article →Administration › InstallationIs it possible to change what features are installed with DataPA OpenAnalytics using the command line?
See What is the minimum I need to install on a client that will run an application with the DataPA Reports and/or DataPA Dashboard embedded?
Read article →Developers › DevelopmentIs it possible to control the display of dashboard tabs when embedding a dashboard into my application using DataPA Enterprise?
Applicable Versions: 4.05.0084 and above "How 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?" describes how to obtain the URL to embed a dashboard rendered by DataPA Enterprise into your application. You may also want…
Read article →End Users › TutorialsIs it possible to create dashboards with user specific content?
Applicable Versions: 5.05.0036 and above When a user logs in to DataPA OpenAnalytics, they are assigned a username and user group as defined in the server settings screen. To add a filter the data for a specific user, your data must include a column that contains either the user name to which…
Read article →End Users › GeneralIs it possible to embed a YouTube video into a dashboard?
Applicable Versions: 5.50.0153 and above DataPA OpenAnalytics allows you to embed any web content into a control panel on a dashboard. As such, if you want to embed a YouTube video into a dashboard, follow these steps; Add a new control panel object to your dashboard. From the Panel tab of the…
Read article →Administration › Server AdministrationIs it possible to filter the Database Schema that are available to specific users?
Applicable Versions: 3.05.0031 Onwards Users can only create subjects available. As such, user data access can be controlled by limiting the subjects. This means it is common to want different subjects available for different users. DataPA reads the schema from the connected databases, and…
Read article →Administration › Server AdministrationIs it possible to filter the subjects that are available to specific users, or the fields in subjects that are available to specific users?
Applicable Versions: 3.00.0078 Onwards Users can only create or run queries for which they have subjects available. As such, user data access can be controlled by limiting the subjects. This means it is common to want different subjects available for different users. The data location determines…
Read article →Administration › Server AdministrationIs it possible to maintain user context information when running DataPA with a Stateless AppServer?
When running DataPA with an AppServer in a stateless mode we face the same challenges as a business application using a stateless AppServer does. Each request received by the AppServer has no context and this means that the AppServer knows nothing about the user running the query. A common…
Read article →Developers › DevelopmentIs it possible to prevent the run query wizard from prompting for required parameters when running a query from an application?
Applicable Versions: All Required values occur when conditions are created against the subject or query, that have been designated as Required Values in either the subject or query wizard. In normal operation, DataPA prompts the user for values to satisfy these required values in the query…
Read article →Developers › DevelopmentIs it possible to refresh a report or query in DataPA Enterprise before opening it in the web when viewed from a 3rd party application?
Applicable Versions: 4.05.0084 and above "How 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?" describes how to obtain a URL to open a report published to DataPA Enterprise directly in the browser or an iframe. By…
Read article →Developers › DevelopmentIs it possible to refresh data in a dashboard, passing a parameter from my Application
Applicable Versions: 4.05.0000 and above When a query is refreshed in the dashboard, the DashboardDesigner control checks if there is a valid control panel object for each required field in the query. For each required field that does not have a valid control panel object, the DashboardDesigner…
Read article →Developers › DevelopmentIs it possible to refresh the data in a dashboard silently from a Progress batch process?
Applicable Versions: 5.50.0073 Onwards You may wish to control the refreshing of data in a dashboard from a Progress batch process, to say update the data overnight. In order to achieve this, you cannot use the dashboard control as it is a visual control which cannot be rendered in a batch…
Read article →Developers › DevelopmentIs it possible to specify which connection or connections a query is refreshed against when I open a dashboard using a URL from my application?
Applicable Versions: 4.05.0084 and above "How can I pass a parameter to a dashboard using the URL?" describes how to refresh data in a dashboard, passing a parameter from your Application. You may also wish to control which connection or connections each query is refreshed agaist. You can do…
Read article →Administration › Server AdministrationIs it possible to use a single AppServer with more than one version of DataPA?
Applicable Versions: All With each successive version of DataPA, the functionality is extended. This means there are changes to not only the client, but also the to the business logic procedures that support the client. As a result, you should always use the version of the DataPA procedure…
Read article →End Users › GeneralIs there a debug option to allow me to debug queries?
Applicable Versions: 2.01.0152 to the latest 5.50 Sometimes a query will return unexpected results or not run at all. There is a debug option that allows you to run a query with debug mode on. This will cause DataPA to create messages in the AppServer log file detailing every step of processing…
Read article →End Users › GeneralIs there an example Database Performance Dashboard I can use against my application?
Applicable Versions: 5.50.0046 and above From version 5.05.0024 and above, you can use a simple Environmental Variable switch to allow access to OpenEdge virtual system tables (VST's) to build dashboards that offer insights into the physical storage, performance, memory usage and user activity…
Read article →End Users › ClientIs there any limit to the size of a DataPA query?
Applicable Versions: All For Progress AppServer systems the limit to the number of fields is based on the limit to the number of fields that can be accommodated in a temp-table object. The limit depends on how large the field information (initial value, validate information, help messages, etc.)…
Read article →Administration › Server AdministrationIs there any way for me to see who is tying up the "agents" when connected to the Enterprise website?
Applicable Versions: 5.00.Onwards The DataPA Server Settings screen - Logging Tab has a checkbox to "Enable agent Usage Logging". Setting the Enable agent usage logging option, writes a line to the "C:\ProgramData\DataPA\DataPAEnterpriseAgent.log" log file anytime a request is processed by an…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗