1. Shayin Bhaskaran
  2. PowerBuilder
  3. Wednesday, 15 December 2021 14:23 PM UTC

Hello,

I am using Powerbuilder 2019R3 with Adaptive Server Enterprise/15.0.3 versiob as backend.  I have recently migrated the source code from Powerbuilder 12.5 to Powerbuidler 2019R3. After migration, for the login user after the password has expired the dialog to change the password is displayed (since in the code PWDialog is set to 1 for DBParm parameter) but when the user enters the new password in both the fields (Enter password and Re-enter password fields - screen shot attached) and presses enter the password change does not happen.  Instead following error message is thrown: "Error: Unable to set the Password." (screen shot attached). 

But this functionality worked in the before migration version of the application (in Powerbuilder 12.5) - password change happens without issue.  Can anyone suggest why the password does not work in the newly migrated version of powerbuilder 2019R3 after the password has expired.

 

Thank you.

Regards,

Shayin Bhaskaran

Attachments (2)
Shayin Bhaskaran Accepted Answer Pending Moderation
  1. Thursday, 16 December 2021 06:45 AM UTC
  2. PowerBuilder
  3. # 1

Hi David,

The database transaction object returns SQLDBCode = 4022 (failure) during connect to the database but still the database dialog prompt gives the option to change password but fails during passowrd change.  This option works pre-migrated Powerbuilder 12.5 version but not in the newly migrated version of Powerbuilder 2019R3.

Regards,

Shayin

Comment
  1. David Peace (Powersoft)
  2. Friday, 17 December 2021 15:22 PM UTC
If it works outside of PB, then I would raise a support ticket.
  1. Helpful
  1. Shayin Bhaskaran
  2. Monday, 20 December 2021 06:48 AM UTC
I have raised a support ticket as bug 7691
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 20 December 2021 17:20 PM UTC
Thanks Shayin .. Appeon has been able to recreate this issue.
  1. Helpful 1
There are no comments made yet.
Shayin Bhaskaran Accepted Answer Pending Moderation
  1. Thursday, 16 December 2021 05:32 AM UTC
  2. PowerBuilder
  3. # 2

Hi John,

Yes user does have privelege to run the SP_PASSWORD procedure.  The user is able to change the password while the password is not yet expired. In this case the SP_PASSWORD gets executed and password is changed.

But the scenario I mentioned is when the password is expired and user gets prompt dialog from ASE (not from powerbuilder) to change password after expiry and which case the password change fails.  From isql command prompt of ASE I can change the password after expiry.

 

Thanks & Regards

Shayin

Comment
There are no comments made yet.
Shayin Bhaskaran Accepted Answer Pending Moderation
  1. Thursday, 16 December 2021 05:26 AM UTC
  2. PowerBuilder
  3. # 3

Hi Chris,

 

Yes since during migration ASE database was not changed hence there were no changes done to the dbparm parameter.

Following is the current settings in the code (ltr_object is transaction object):

ltr_object.DBMS='ASE'

ltr_object.dbParm = "Release='15',PWDialog=1,StaticBind=0,AppName='Provis',PWEncrypt='Yes',TrimSpaces=1"

Following dll is in my runtime environment for db connectivity:

pbsyc.dll

pbase.dll

 

Regards,

Shayin

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 16 December 2021 15:09 PM UTC
HI Shayin;

Assuming that your systems are using the ASE 15.x DB Client and this problem is still happening ... then I would suggest opening a support ticket for this issue.

Regards ... Chris
  1. Helpful 1
  1. Shayin Bhaskaran
  2. Monday, 20 December 2021 06:49 AM UTC
bug 7691 raised as support ticket.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 18:20 PM UTC
  2. PowerBuilder
  3. # 4

Hi Shayin ;

   Is your App using the proper driver and settings for ASE 15.x?

  • SQLCA.DBMS = "ASE"
  • SQLCA.DBParm = "Release='15'"

Regards ... Chris

 

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 15:23 PM UTC
  2. PowerBuilder
  3. # 5

Greetings, Shayin -

According to the documentation:

https://docs.appeon.com/pb2019r3/connection_reference/ch01s01.html#PWDialog

The password change is accomplished via the sp_password stored procedure. Does the user have access rights to execute this system stored procedure?

Best regards, John

Comment
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 15:16 PM UTC
  2. PowerBuilder
  3. # 6

Hi

What is the underlying DB calls comming back with, what  is the database error being returned?

Can you run under debug and see what is happening and the database retrn codes/text?

David

 

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.