Discussions tagged PowerServer
Select Error: ERROR [07006] [Sybase][ODBC Driver][SQL Anywhere]Cannot convert string to a integer
- Resolved
- Issue
- Last updated 4 weeks ago
- David Xiong @Appeon replied 3 weeks ago
Hi Team,
We just used PB2022 R3 to deploy one of our products on PowerServer. We are seeing odd problems with datatype conversion on one of the application's screens. I am only receiving the error in the Powerserver deployed app, even though it d...
High volume text or excel file import in powerserver
- How-to
- Last updated 1 month ago
- Miguel Leeuwe replied 4 weeks ago
Hi Team,
What is the best method to import high volume text or excel file. For example having column 20 and no of line 50000
We have tried using datawindow import and reading 100 line each loop till we get datawindow import error, but this wo...
will PowerServerLabel Merge statements run SQLs parallelly(Async) on DB?
- Misc
- Last updated 2 months ago
- John Fauss replied 1 month ago
we are trying to improve the performance of our application, we have a couples of Embedded SQLs and Datawindow retrieves called one after another.
so to improve the performance, we moved all the SQL DB calls in a PowerServerLabel Merge statement whi...
Azure App Service Powerserver "Failed to download the file" 404 error
- Resolved
- Issue
- Last updated 2 months ago
- Esau Redwan replied 2 months ago
Hello, I am following the steps listed here for implementing Azure App Services: https://docs.appeon.com/ps2022r3/steps_summary.html
I am on the part where I am installing the Static Web App here: https://docs.appeon.com/ps2022r3/deploying_the_cloud...
Unable to add a folder in the PowerServer application object
- Resolved
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 1 month ago
I'm on the latest and greatest version of PowerBuilder 2022 R3 Build 3356.
I'm attempting to demo the pbtutor application running in the PowerServer environment. I created a new PowerServer object in the pbtutor.pbl.
I'm literally trying to assign ...
SSL Pinning for powerserver application
- Resolved
- How-to
- Last updated 3 months ago
- Logan Liu @Appeon replied 2 months ago
Hi team,
Powerserver deployed application undergone for VA/PT process and observed that SSL pinning to be enabled in application, how we can do this? any guide help us
Below is the observation
Vulnerability: Application is vulnerable to MITM Attac...
PB IDE cannot connect to the remote computer.
- How-to
- Last updated 3 months ago
- Logan Liu @Appeon replied 3 months ago
Hello,
PB 2022R3. I'm setting up a new PowerServer profile to deploy to an external server. It is running IIS, I created a website there, and installed Web Deploy and ASP.Net Core Hosting Bundle as described in PS help. The server is pingable from m...
Ubuntu 22.0 powerserver Service Issue
- Resolved
- Issue
- Last updated 4 months ago
- Narayana Bhat P replied 4 months ago
WHen we set powerserver module as service and trying start service then we get core dump error but if execute using dotnet then it is staring without issueBelow is the sample config and core dump error from logsample config:
Service config file as b...
Dynamically change datawindow syntax for nested report
- Issue
- Last updated 5 months ago
- mike S replied 2 months 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 5 months ago
- Chris Pollach @Appeon replied 5 months 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 5 months ago
- Armeen Mazda @Appeon replied 5 months 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 5 months ago
- Angie Liu@Appeon replied 3 months 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 5 months ago
- David Xiong @Appeon replied 5 months 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 6 months ago
- mike S replied 6 months 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 6 months ago
- mike S replied 6 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 6 months ago
- Jay Hastings replied 6 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 7 months ago
- Carl Bolduc replied 7 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 7 months ago
- Antony Xavier replied 7 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...
- Page :
- 1