Table of Contents
- What's New
-
- PowerServer 2022 R2
- 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
- Concepts
- Installation
- Quick Start
-
- Guide 1: Deploying to local environment (built-in Kestrel)
- Guide 2: Deploying to local IIS
- Guide 3: Deploying to remote IIS
- Guide 4: Deploying multiple apps to one site
- Guide 5: Deploying the client app separately
- How-to Guides
-
- Overview
- Configure a server for deployment
- Configure and deploy the PowerServer project
- Customize Cloud App Launcher
- Work with the PowerServer C# solution
- Run and manage PowerServer
- Run and manage the deployed app
-
- Package the installable cloud app
- Install the installable cloud app
- Change the Web API URL
- Run the installable cloud application
- Change the deployed app using commands
- Customize the app entry page
- Manage app versions/updates
- Roll back to an earlier version of app
- Support cookie validation
- Undeploy the client app
- Uninstall the client app
- Tutorials
-
- Tutorial 1: Deploying your PowerServer project to remote servers
- Tutorial 2: Connecting to the Database
-
- Overview
- Accessing the Database Configuration dialog
- About the database driver
- Connecting with the DB2 database
- Connecting with the Informix database
- Connecting with the MySQL database
- Connecting with the Oracle database
- Connecting with the PostgreSQL database
- Connecting with the SQL Anywhere database
- Connecting with the SQL Server database
- Connecting with the Adaptive Server Enterprise database
- Troubleshooting
- Tutorial 3: Hosting Web APIs in Kestrel
- Tutorial 4: Hosting Web APIs in IIS (in-process hosting)
- Tutorial 5: Hosting Web APIs in Docker Containers
- Tutorial 6: Deploying installable cloud apps to Kubernetes
- Tutorial 7: Publishing PowerServer Projects to Azure App Service
- Tutorial 8: Publishing PowerServer Projects to Azure Container Instances
- Tutorial 9: Hosting the client app in a file server
- Tutorial 10: Load-balancing PowerServer Web APIs
- Tutorial 11: Authenticating your apps
- Tutorial 12: Building your PowerServer project with commands
- Tutorial 13: Packaging & Distributing Installable Cloud Apps (for ISVs)
-
- Verifying system requirements
- (Optional) Configuring database connections
- (Optional) Customizing app launcher and app entry page
- Packaging the installable cloud app
- Installing the installable cloud app
- Configuring the app on server
- Configuring the Web APIs on server
- (Optional) Hosting the client app separately
- Running the installable cloud app
- 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
- Tutorial 16: Setting up an FTP server
- Working with Database Connections
-
- Overview
- DB connection differences (C/S app vs. installable cloud app)
- Supported database types & versions
- Supported DBParm properties
- Enabling long connections
- Configuring database caches
- Setting up static database connection for the app runtime
- Setting up dynamic database connection for the app runtime
- Managing database connections using APIs
- 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
-
- PBLs contain DataWindows with the same name
- Object name using C# reserved words
- DataWindow name containing special characters
- Editing SQL
- Column order in data source and Column Specification
- One compute expression containing multiple computed columns
- Cursor syntax
- Syntax after UNION
- Custom DataWindows from InfoMaker
- PowerServer 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
- "The string 'xxx' was not recognized as a valid DateTime" when converting DataWindow to data model
- "Invalid object name 'xxx'" 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
- Database
-
- Different results returned from an ASE stored procedure
- SelectBlob data truncated
- Garbage letters display when retrieving multibyte data
- Slow app performance with SQL Anywhere
- 64-bit database cannot be connected from IIS
- SQLHandle not found
- "Invalid object name 'xxx'" when executing ESQL
- Inconsistent information with set_context and sys_context
- Others
- License errors
- PowerServer solution errors
- Runtime error numbers
- 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