-
Migrating the Pyramid Database from PostgreSQL 9.6 to PostgreSQL 18 (Linux)
CRITICAL: Required Before Upgrading to Pyramid 2025.11 or Later IMPORTANT: This migration from PostgreSQL 9.6 to PostgreSQL 18 MUST be completed BEFORE upgrading Pyramid to version 2025.…
-
Migrating the Pyramid Database from PostgreSQL 9.6 to PostgreSQL 18 (Windows)
CRITICAL: Required Before Upgrading to Pyramid 2025.11 or Later IMPORTANT: This migration from PostgreSQL 9.6 to PostgreSQL 18 MUST be completed BEFORE upgrading Pyramid to version 2025.…
-
Run Pyramid under a web path instead of the root
Background Running Pyramid from a path is sometimes required (e.g., https://mysite.com/pyramid) instead of the root (e.g. https://mysite.com). In embedding scenarios,…
-
Terminate SSL on AWS Amazon Load Balancers (ALB)
Background AWS ALB (and possibly other load balancers/reverse proxies) terminate SSL at the load balancer level and communicate with backend servers (Pyramid) over HTTP.…
-
Handling 504 and 502 Errors in Pyramid
If you're encountering 504 or 502 error messages, the issue is likely related to the reverse proxy or load balancer sitting in front of Pyramid. These errors often occur due to timeouts that are set…
-
How to configure Nginx to act as a reverse proxy to support SSL
The following article explains how to install Nginx to act as a proxy allowing access to Pyramid using HTTPS. The configuration setup described will also support WebSocket needed to allow Pyramid…
-
Discontinued support for EOL operating systems and databases 2024
Various operating systems and technologies are out of support or nearing end of life (EOL). In tandem, Pyramid will start to drop official support for them.…
-
How to speed up Queries running against an AWS Aurora RDS MySQL database instance?
AWS RDS Aurora MySQL 5.7.12 Query Performance In a recent customer scenario we encountered some unexpected performance issues when connecting to a AWS RDS Aurora MySQL 5.7.12 as data source.…
-
What to check went schedules/prints are not running
Issue: Pyramid stops running tasks such as models/prints or provisioning users. Steps to mitigate the problem: The first thing to check is the Pyramid summaries panel.…
-
Pyramid installation tips
This article provides useful recommendations and checks to perform before installing or upgrading Pyramid. Following these recommendations can help prevent common installation issues and ensure that…
-
What is a "Subquery mode" ?
Note: "Sub Query" mode is only applicable to Microsoft Analysis Services data sources. Microsoft SSAS has a limitation that the "where" clause of the MDX statement can't accept more than one element…
-
No proxy account was set for user
To configure your browser for Windows Integrated Authentication (automatic login using your Windows credentials), follow the instructions below. These instructions apply to Microsoft Edge,…
-
When trying to use an R script from the Market Place an error occurs
When trying to use a script from the Market Place that uses one of R packages e.g the “Sentiment analysis” (uses stringr package) the following error occurs: "scripting error:Error:…
-
Issues re-installing Pyramid on Linux
If a Pyramid installation fails, you may encounter an error when attempting to reinstall Pyramid, even after running the uninstaller. One possible error is:…
-
Logs Locations
Pyramid supports both individual and enterprise deployments and can run across multiple servers and services. Various logs are generated to help administrators monitor system activity,…
-
Routine Content Backup Recommendations
The following are items we Recommend backing up periodically. (Preferably Daily but it's up to you) The database repository. If you don't know where it is, browse to HTTP:…
Badges
Latest Posts
