Discussions tagged PowerServer
Dynamically change datawindow syntax for nested report
- Issue
- Last updated 1 month ago
- Kristin Sisk replied 1 month ago
Is it possible to dynamically change the datawindow syntax for a nested report in the group header datawindow?
I have a header and footer on a nested report. I want to be able to assign the datawindow syntax to the nested report at runtime. I am ...
Hi
we ran into some serious issue on Friday evening, all our apps suddenly stopped working due to below error.and we are using JWT authentication with our own JWT Servers and verified we are getting a valid access token also.
erroring out at app...
Unauthorization error on trying to login app hosted on PowerServer
- Issue
- Last updated 1 month ago
- Chris Pollach @Appeon replied 1 month ago
Hi we ran into some serious issue on Friday evening, all our apps suddenly stopped working due to below error.we are using JWT authentication with our own JWT Servers and verified we are getting a valid access token also....
Change app name after deployed.
- How-to
- Last updated 1 month ago
- Armeen Mazda @Appeon replied 1 month ago
I want to know if I can change the name of the app after been deployed? We have different environments for testing, but is unacceptable under our standard to create a new power server project for each DB and redeploy. I need to use the same deploymen...
Failed to parse the statement sp_set_session_context
- How-to
- Last updated 1 month ago
- Alex Peters replied 1 month ago
Hello!I have the problem that I have to call the MS SQL Server stored procedure sp_set_session_context to set a context variable. Unfortunately this does not work with the PowerServer.
The PowerServer always gives me the message
'PowerServer.Api.Se...
Powerserver build overwriting ini files after each build
- Issue
- Last updated 1 month ago
- David Xiong @Appeon replied 1 month ago
Hi,
Appeon 2022 R2 building application to be deployed to the Powerserver .
When I set the ini not to overwrite (see picture attached) it still over writes client ini files.
Ideally I dont want to overwrite all the client ini files when I d...
IIS Settings Not Persisting when a build and deploy is performed in PowerServer
- Issue
- Last updated 2 months ago
- mike S replied 1 month ago
We are running into an issue with certain elements of IIS not persisting within a site (powerserver project).
In order for our project to run, we have determined that Anonymous Authentication must bet set to enabled. This is located under PowerServe...
Any gotchas when using the Long_connection dbparm option?
- Advice
- Last updated 2 months ago
- mike S replied 2 months ago
So due to the use of a multitude of cursors and temporary tables that are part of the Oracle database environment that we are working into the PowerServer environment, we stumbled across the ability to use the long_connection option as part of the db...
Powerserver 2022 using Stored Procedures - Fetch Errors
- Resolved
- How-to
- Last updated 2 months ago
- Jay Hastings replied 2 months ago
I have multiple datawaindows that call Oracle stored procedures. Each one returns only ONE result set.
Within the stored procedure they may use temp tables and/or cursors to loop through the temp tables. Some are defined cursors (CURSOR c1_TempCur...
I have multiple datawindows that call Oracle stored procedures. Each procedure returns only ONE result set. I'm finding in datawindow they do NOT like datatypes of NUMBER or LONG. I've been changing them to Decimal(0) yet I can't really say that's...
Oracle error only on Azure server
- Resolved
- Issue
- Last updated 3 months ago
- Carl Bolduc replied 3 months ago
We migrated an application to PowerServer and deployed it inside IIS on an Azure server. Most of the functionalities are working as expected except for one DataWindow. When running the application, we get this error after loading the DataWindow: 1861...
Session creation failed in powerserver
- Issue
- Last updated 3 months ago
- Antony Xavier replied 3 months ago
Hi Gurus,
While try to invoke Powerserver cloud url , am getting the following error :-
---------------------------PowerBuilder application execution error (R0221)---------------------------Application terminated.
Error: Session creation failed.Ca...
Windows prompt when launching the cloud app after adding OCX to the build
- Resolved
- Advice
- Last updated 3 months ago
- David Xiong @Appeon replied 3 months ago
We added OCX and DLL files to our cloud application. They must be registered before the first launch of the application. The process works but we now have this prompt every time we launch the application:
It looks like the cloud app is registering t...
How can I get an argument when my program run on PowerServer 2020?
- Resolved
- How-to
- Last updated 3 months ago
- Kyungil Choi replied 3 months ago
Hello, there.
I wonder if I can get an arguments when I first run my program on PowerServer 2020.
For example, if I make a client program which runs on my desktop, I run it with "myprogram.exe test_arg" and then I get test_arg as a argument and I c...
DataWindow syntax has incorrect release number - PowerServer
- Resolved
- Issue
- Last updated 3 months ago
- Ronnie Po replied 3 months ago
Got an interesting issue I'm running into within the PowerServer environment. PB 2022 R2.The application in question does the following.PB way of handling things. A PBL is created locally on the end-users' machine at runtime.This allows reports to be...
Creating database connection in PoweServer session is slow
- Resolved
- Issue
- Last updated 4 months ago
- Hannu Pikkarainen replied 3 months ago
Hi,
We have created a small PB application and distributing it with PowerServer 2022R2, licenses for 150 users.
When user starts the application and Login screen is opened the database connection MS SQL 2019 is not working yet. It can take 1second ...
PowerServer 2022 Support for multiple DBMS
- How-to
- Last updated 4 months ago
- Logan Liu @Appeon replied 3 months ago
Our software has been developed to support both MS SQL Server & ORACLE depending on the client using the software. With PowerServer 2020 we had both SQL Server and ORACLE set up in our configuration (Database Type section) so the output would sup...
How to recreate or renew a bearer token in WhatsApp Business
- Resolved
- How-to
- Last updated 4 months ago
- Francisco Martinez @Appeon replied 4 months ago
Hi,
I have created an application with PB & PowerServer 2022R2 build 2819. It uses WhatsApp Business to send user an one-time user PIN to authenticate user.
WhatsApp Business needs a fresh Bearer token (less than 23 h old).
How can I update th...
After Upgrade to PowerBuilder Build 2828 PowerServer stopped working
- Resolved
- Issue
- Last updated 4 months ago
- Logan Liu @Appeon replied 4 months ago
Good Morning,
Last week I have done a presentation for a client regarding a powerbuiler application to powerserver 2022. It was working fine, but once I have upgraded to the PB build 2828 I'm getting the error below. I have follo...
PowerServer client error Login failed for user ''
- Resolved
- Issue
- Last updated 4 months ago
- Hannu Pikkarainen replied 4 months ago
Hi,
I am deploying a application through PowerServer.
I have 2 identical environmentsn (?), Win 2019 server & MS SQL Express 2019
On test environment everything works without problem, but when I deploued application to Prod-env and try to inst...
- Page :
- 1