Table of Contents
- What's New
-
- PowerServer 2022
-
- New Features
-
- Cloud App Launcher refactoring
- PowerServer project painter refactoring
- PowerServer performance enhancements
- PowerServerLabel and PowerServerResult
- Unsupported feature detection enhancements
- PowerServer project debugging
- PowerServer toolbar changes
- HTTP/2 support
- TLS 1.3 support
- Ignoring PowerServer certificate errors
- Enhanced PowerScript features
- .NET 6.0 support
- Authentication template for AzureAD
- Web API default port changes
- PowerServer log level changes
- Licensing server backup
- Upgrade Guide
- Bug Fixes & Known Issues
- PowerServer 2021
- Installation
- Quick Start
-
- Guide 1: Deploying to local environment
- Guide 2: Deploying to IIS (.NET server)
- Guide 3: Deploying second app to remote IIS
- How-to Guides
-
- Overview
- Configure the Web server for deployment
- Install the Cloud App Launcher on the Web server
- Configure and deploy the PowerServer project
- Understand and work with the PowerServer C# solution
- Run and manage PowerServer
- Run and manage the deployed app
- Tutorials
-
- Tutorial 1: Deploying your PowerServer project to remote servers
- Tutorial 2: Connecting to the Database
- Tutorial 3: Setting up a Web server
- Tutorial 4: Hosting Web APIs in Docker Containers
- Tutorial 5: Hosting Web APIs in IIS (in-process hosting)
- Tutorial 6: Hosting Web APIs in Kestrel (using reverse proxy server)
- Tutorial 7: Load-balancing PowerServer Web APIs
- Tutorial 8: Deploying installable cloud apps to Kubernetes
- Tutorial 9: Publishing PowerServer Projects to Azure App Service
- Tutorial 10: Publishing PowerServer Projects to Azure Container Instances
- Tutorial 11: Authenticating your apps
- Tutorial 12: Building your PowerServer project with commands
- Tutorial 13: Packaging & Distributing Installable Cloud Apps (for ISVs)
- Tutorial 14: Load testing installable cloud apps
-
- Load testing installable cloud apps with LoadRunner
-
- Dynamic Values in the Recorded Script
- Enclosing parameters in angle brackets “<>”
- Running the application in test mode before recording the script
- Changing the compression method to Gzip
- Recording
- Correlating the Session ID
- Correlating the Transaction ID
- Parameterizing static values in SQLs
- Replaying
- Load testing installable cloud apps with JMeter
- Tutorial 15: Applying a production license to an existing PowerServer project
- Working with Database Connections
- Unsupported Features & Workarounds Guide
-
- How to detect unsupported features
- Unsupported features & workarounds
- Discrepancies & workarounds
-
- Discrepancies that cannot be detected
-
- DB connection
- Alias name
- rowsupdated value
- DisableBind parameter
- TableBlob retrieval
- Dynamic DataWindow
- TransactionName
- Data type in Dynamic SQL Format 4
- Decimal data type in static SQL or DataWindow
- Timing of transaction rollback
- Oracle AutoCommit and Lock
- Stored procedure parameter
- Transaction commit
- Use Describe in Dynamic SQL Format 4
- Bit data field
- SelectBlob/UpdateBlob supports UTF8 only
- SQLNRows property (with Cursor)
- SQLCode property (with SP)
- Column name from view
- Incompatible coding styles
- Troubleshooting Guide
-
- Configuring and deploying PowerServer projects
-
- Permission errors when configuring the Web server profile
- Syntax error during the build process
- DB driver error during the build process
- Error in the Unsupported (DWs) window
- Failed to generate the PowerServer Web APIs project
- Error uploading application files to FTP
- Changed PBL list
- Error when converting DataWindow to data model
- Failed to load database driver for PowerServer project
- Failed to load database driver when building/deploying PowerServer project
- Running installable cloud apps
-
- Cloud app launcher and application executable
- Models and controls
- Server
-
- Session creation failed
- Cannot connect to the server when creating the session
- Session does not exist
- Session not created
- App requires login again
- File name containing character + cannot be downloaded
- "HTTP Error 404.2 - Not Found" error when running the app
- Failed to access the *.json file
- Failed to connect to the license server: No such host is known
- Session fails to respond
- Communication protocol inconsistent between server and client
- Database
- License errors
- PowerServer solution errors
- Performance Guide
-
- Introduction
- Performance suggestions on project compilation and deployment
- Performance suggestions on loading installable cloud apps for the first time
- Performance suggestions on running installable cloud apps
-
- Debugging the performance
- Working against the impact of Internet and slow networks on runtime performance
- Hosting Web APIs and database on the same LAN
- Web API publishing method
- Optimizing database server performance
- Tuning excessive server calls
-
- Overview
- Technique #1: grouping multiple server calls with PowerServerLabel
- Technique #2: partitioning transactions via stored procedures
- Technique #3: partitioning non-visual logic via server-side REST APIs
- Technique #4: eliminating recursive embedded SQLs
- Technique #5: eliminating DW computed fields calling user functions that have ESQL
- Minimizing large data transmissions
- Debugging Guide
