1. Rajkumar K S
  2. PowerBuilder
  3. Wednesday, 28 June 2023 16:41 PM UTC

Hi All,

 

Recently we have migrated our PB Apps to Powerclient. We are getting one issue related to "Failed to update the app"

below are the cases to reproduce the issue.

 

1. All the PB and app related files uploaded successfully.

2. Sybase 16 - DB and related files (db dlls and other supported files) writing in specified folder. ( Not in the Powerclient app downloaded folder)

            DB supported files path : C:\Users\Rajkumar\AppData\Roaming\PBApps\Applications\DBFiles

            DB Path : C:\Users\Rajkumar\AppData\Roaming\PBApps\Applications\DB

3. ODBC is created and pointed to DB copied folder.

4. First time applauncher downloaded and installed necessary files in the below path and application is successfully launched.

         "C:\Users\Rajkumar\AppData\Roaming\PBApps\Applications\10.0.100.6_salesdemo_local".

5. For our DB will not be closed after closing our powerclient application for that we have given AutoStop = "No"

                      

6. If we are do any update in any of the pb objects and do the incremental build. when we try to downloaded the apps again it's getting the error

           "Failed to update the app" because of Sybase DB connection  is still active. 

 

Please let us know is there any solution to solve this issue..

 

Regards

Rajkumar K.S

 

Rajkumar K S Accepted Answer Pending Moderation
  1. Thursday, 29 June 2023 02:54 AM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,

Thank you!

Please find the below details

  • PB version & build that you are using

                 

  • Web Server type & version that you are using that is hosting the PC App(s) 

                 

 

  • Screen captures of your PC Project settings that you are using

                 Attached : Project Settings.pdf

  • Screen captures of your CAL utility settings that you are using

 

Please let me know if any other details required.

Regards

Rajkumar K S

Attachments (1)
Comment
  1. Chris Pollach @Appeon
  2. Friday, 30 June 2023 15:09 PM UTC
HI Rajkumar;

For Case #2

If you are running SA locally by App, then you need to set AutoStop to YES.

If you are running multiple PC Apps on the same user's machine against the *same* DB instance, then I would set-up one SA DBMS to start as a O/S "Service". Then that SA DBMS instance will always be running and then will be available to *all* your PC Apps to connect to that SA instance. Then the DSN's should be set to ...

1) Connect to a Running DB on this Computer

2) Should give a "Server Name"

3) Should state a DB instance name

HTH

Regards ... Chris

HTH

Regards ... Chris
  1. Helpful
  1. Rajkumar K S
  2. Wednesday, 5 July 2023 07:48 AM UTC
Hi Chris,



Adding few more details for better understanding.



the DLL files that are available in the application even after we have used the advance option not to download every time files that are marked in "External Files" tab.. Currently we are facing challenges while downloading the updates...



If any of the files which are in used by the SAP SQL Anywhere 16 application folders say dbsvr16.dll, dbghelp.dll, dbrsakp16.dll & dbserv16.dll it will not download the updates through Powerclient if these files are in used, even after we have selected the option under ->Startup->Advanced->Download Options—Download the app files as neccessary



PowerClient Application Path -> D:\Ecogreen\Applications\rilecogreen.csquare.in_rilecogreen@qa

RunTime Path -> D:\Ecogreen\Applications\Runtime\22.0.0.1900

All the files related to SAP SQL Anywhere 16 are placed under the Powerclient Application Folder.



Regards

Rajkumar K S
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 5 July 2023 14:30 PM UTC
HI Rajkumar;



Yes, that is why you need to set AutoStop to YES so that the SA files can be first A) downloaded to the PC App user and then B) the App needs to move these SA file to the appropriate SA Folder *before* issuing another DB "CONNECT;" command.

You can also automate this via the PRELOAD event as defined in the PC Project where you could (for example) fire off a BAT file that does the SA maintenance / update before the App begins. This then would alleviate the SA updating from your PC App altogether.

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 28 June 2023 17:27 PM UTC
  2. PowerBuilder
  3. # 2

Hi Rajkumar ;

   Can you tell us ...

  • PB version & build that you are using
  • Web Server type & version that you are using that is hosting the PC App(s)
  • Screen captures of your PC Project settings that you are using
  • Screen captures of your CAL utility settings that you are using

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.