Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (6)

Resolved PWDialog - password change does not happen after expiry

  1. Issue
0
Votes
Undo
  1. Shayin Bhaskaran
    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)
ase_password_change_dialog.PNG ase_password_change_dialog.PNG
ase_error_message.PNG ase_error_message.PNG
  1. ASE
  2. Database
  3. Migration
  4. PowerBuilder (Appeon)
DataWindow edit issue, PB padding string fields ca...
Pb 2019( R3 build 2703).exe never make exit when r...
Responses (6)
Shayin Bhaskaran
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
David Peace (Powersoft)
  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
Shayin Bhaskaran
  1. Shayin Bhaskaran
  2. Monday, 20 December 2021 06:48 AM UTC
I have raised a support ticket as bug 7691
  1. Helpful
Chris Pollach @Appeon
  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
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
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
Chris Pollach @Appeon
  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
Shayin Bhaskaran
  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
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
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)
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.