How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesHow do I update the records in a lookup?
See How do I refresh the parameter query? If I add a new record to a lookup on the system, I need to refresh in dashboard drop down parameter?
Read article →Administration › InstallationHow do I upgrade DataPA OpenAnalytics to the latest version
Applicable Versions: 4.5 onwards DataPA OpenAnalytics can be installed as a Client on a user's PC and on a Server ( to run DataPA Enterprise). The following notes explain the steps required to upgrade DataPA OpenAnalytics to the latest version. The latest version and accompanying Release Notes…
Read article →End Users › GeneralHow do I use columns in a condition / criteria that are not part of an index in a DataPA Query?
When creating or amending a subject on the Column/Field Attributes Page, there is a checkbox that allow a field to be used in a query condition. The details of the screen are below, the second last paragraph is the value your customer will want to change in the Subject. The Subject Wizard -…
Read article →End Users › GeneralHow do set a field in the DataPA Reports designer to word wrap?
Applicable Versions: All In DataPA Reports in design mode select the field that you want to set to word wrap. Next from the menu select the View > Designer Toolbars > Show Property Toolbar This will show the Property Toolbar as below: Now in the Property Toolbar set the WordWrap and Multiline…
Read article →Administration › Server AdministrationHow do you set up an OpenEdge MS SQL Dataserver for use with DataPA ?
This KB entry details how to install and setup an MS SQL and prepare it for use with DataPA via a OpenEdge AppServer. Before you begin you must make sure that you have the appropriate OBDC drivers installed on the machine that the OpenEdge DataServer’s will be running on. This KB entry deals…
Read article →Administration › Server AdministrationHow is DataPA setup to work with an AppServer Internet Adapter (AIA)?
Download and Install ServletExec from http://www.newatlanta.com/ The full Setup and Installation Guides are available from http://www.newatlanta.com/support/servletexec/docs/index.jsp Instructions for New Atlanta ServletExec AS 6.0 The ServletExec Installation Requires Java JDK or JRE 1.4x or…
Read article →Administration › Server AdministrationHow much memory do I need for a server running DataPA OpenAnalytics Enterprise when publishing large dashboards that use a lot of data?
Because some Subjects, dashboards and queries can access a large number of records, even when summarising the data, there are a number of things you can do to significantly improve the performance of these. 1. Upgrade to DataPA OpenAnalytics V5.5 or above. The 5.5 version of DataPA OpenAnalytics…
Read article →End Users › GeneralHow to find your data file(s) to send to a support representative.
Applicable Versions: All When you raise a support issue, the support representative will often ask you to send through a dashboard, report or query, and the supporting data file(s). The data file(s) contain all the information you create in the setup screens. The location of the data file(s) is…
Read article →End Users › GeneralHow to view Windows application errors using Window Event Viewer
Sometimes DataPA Support will ask users to check the Event Viewer and see if any application errors logged. The purpose of this guide is to go over the basics of the Windows Event Viewer, which is a tool natively included in Windows that logs application and services events. This can be helpful…
Read article →Developers › DevelopmentHTTPS is required for embedded dashboards
To embed dashboards in another web page, HTTPS must be enabled for the Web Site relating to DataPA Enterprise in IIS. HTTPS is strongly recommended for all installations of DataPA Enterprise to protect your security credentials, and data. Futhermore, in 2020, changes began to emerge in browsers…
Read article →End Users › GeneralI am receiving a RunTimeError ‘54’ Bad file Mode error in the Scheduler.
Applicable Versions: All Versions The ""Bad file mode"" error has been known to occur occasionally when a) two reports are being generated at the same time, b) if there is a file lock arising from a failure in the creation of an excel file following an internal excel error. In scenario b) with…
Read article →Developers › DevelopmentI am receiving Out-of memory error messages and other errors with large dashboards opened in the dashboard designer control embedded in my application. Is there anything I can do to improve this?
Applicable Versions: All In version 5.50.0072, we released a change to improve the handling of source data (the raw data returned by the query) in the dashboarddesigner control. Most objects on a dashboard will build their own partial summary data, and as such unless they are going to be edited…
Read article →End Users › GeneralI am trying to create a DataPA report, based on a query I have created. When I try to create the query on my PC or on a colleagues PC, I get the error ""-2147467259 Method '~' of object '~' failed"".
Applicable Versions: All Versions The error points to one of the third party components used by DataPA is not properly registered. Previous occurrances of these kind of errors have been resolved by running a repair of the DataPA Installation.
Read article →End Users › GeneralI cannot open certain dashboards in the dashboard designer.
Applicable Versions: 4.05.0062 and above If a dashboard was last saved with an early version of 4.05 (4.05.0027 or earlier), it may fail to open in version 4.05.0062 or later. This is due to a change in the way the files are structured and the dependent .NET Frameworks to simplify the…
Read article →Administration › Server AdministrationI get an Error connecting to DataPA Enterprise "Unable to retrieve server security object. Please ensure the DataPA Enterprise Service is running. Error occurred while touching Dashboard. Error was
Applicable Versions: Version 6 and Later Please check that the user for the DataPA application pool in IIS (usually "NetworkService") has read and write access to the directory C:\ProgramData\DataPA. To determine the user that DataPA Application Pool is running as, open IIS Manager (type IIS in…
Read article →End Users › ClientI get an error when using Chrome to access a Drill Down in a report in DataPaEnterprise.The initial error is This web page is not available
Applicable Versions: 5.50.0000 Onwards The Detail of the error is :- The server at padrilldown.aspx can't be found because the DNS look-up failed. DNS is the network service that translates a website's name to its Internet address. This error is most often caused by having no connection to the…
Read article →End Users › GeneralI have a dashboard with auto refresh but I’d like to switch off the chart animation, is that possible?
Applicable Versions: 5.00 Onwards On the Dashboard Object Definition screen the last tab is Labelled ""Advanced"". To stop animation of a chart add the text animation ='0' to the Box labelled ""Additional Chart Attributes"".
Read article →End Users › GeneralI have a number of Dashboards published and setup to auto refresh. For some reason some refresh while others do not. I have attempted to unpublish, verify the schedule refresh setting and re-publish,
Applicable Versions: 4.05 onwards If you are seeing one or more lines containing ERROR: Number of Dashboard Objects loaded in memory= 10, maximum number permitted is 10, so cannot load any more. in your DataPAEnterpriseService logfile then it looks like you are running into the limit set as the…
Read article →Administration › InstallationI have a report that runs fine. However, when I go to schedule it in the DataPA Scheduler it will not move into the scheduled tasks.
See After Upgrade to Version 5 all scheduled Tasks became Unsheduled. Attempts to set a time doesn't schedule them.
Read article →Administration › Server AdministrationI have installed a new licence code for additional Enterprise agents and am still receiving an Agents are in use message.
Applicable Versions: 5.0 and above. The agent count should be reset with the installation of a new licence, in some scenarios a restart of IIS is required. In this situation the following steps should be carried out. 1. Stop the DataPA Service 2. Stop IIS 3. Restart IIS 4. Restart the DataPA…
Read article →Administration › Server AdministrationI have moved the DataPA Web application to a different directory since installation, and now images in alerts and exports are all blank. How do I fix this?
Applicable Versions: 5.50.0000 and above There is a configuration setting set by the installer that tells the service where the source files for the DataPA Enterprise Web application reside. This setting is required for the engine to generate images of items on the dashboard (for alerts and…
Read article →Administration › Server AdministrationI have upgraded to v6.0, but can no longer connect to the Enterprise Service
See How do I run DataPA Enterprise Service on an alternative port to the default port 80?
Read article →End Users › GeneralI'm adding a calculated column in a Dashboard but it is not returning any results.
Applicable Versions: All Most likely cause is a possible division by zero in the calculated column. If this happens in a single row, it prevents the entire calculation. You can use the IIF expression to handle this, i.e IIF( [MyColumn1] <> 0 , [MyColumn2] / [MyColumn1] , 0 ).
Read article →Administration › Server AdministrationI'm having trouble connecting to my appserver, I get the following error message: 'NameServer Communications Failure: A blocking operation was interrupted by a call to WSACancelBlockingCall ..."
Applicable Versions: All Full Error is I'm having trouble connecting to my appserver, I get the following error message: 'NameServer Communications Failure - System.Net.Sockets.SocketException: A blocking operation was interrupted by a call to WSACancelBlockingCall at…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗