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

Resolved Database account is locked

  1. Issue
0
Votes
Undo
  1. Jon Tzeng
    Jon Tzeng
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 7 April 2020 19:35 PM UTC

We have a PowerBuilder Web application deployed to PowerServer. Data Source setting in AEM is using Dynamic Database Connection: and Pooling is checked. Maximum Connection Pool Size =1, Minimum Connection Pool Size =1. We have a issue that user database account would be locked without a reason. It looks like system is taking the ID/Password from a wrong session.

Attached are the AppeonServer.log for account locked. It happened on [20-04-06 10:49:15]

Can anyone tell me why this happened and how to prevent it?

Thank you,

Jon

 

Issue connecting to IBM DB2 database
getting 02005 error during deploying to remote web...
Accepted Answer
Jon Tzeng
Jon Tzeng Accepted Answer Pending Moderation
  1. Wednesday, 29 April 2020 03:19 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Zhao Kai,
We have long connection setting and dynamic database connection by using SQLCA.LogId = %your id% and SQLCA.LogPass=%your pass%. .We are able to reproduce the issue.
1. Application first use g_security transaction to connect database.
2. User logon to application with user database ID/password.
3. After successfully database connection, user is asked to change his password due to 45 days using the same password. and user change the password successfully.
4. User idle for 10 minutes and perform a database insert. At this time, ORA-01017: invalid username/password; logon denied.
5. AEM database resource, if we unchecked the dynamic database connection: we can see the User Name: has the user id and password that User get ORA-01017.
Thanks,
Jon

Attached is service and error log.

Thanks,

Jon

Comment
There are no comments made yet.
Responses (2)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 April 2020 00:34 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Jon,

With Dynamic Database Connection, please use the PB script like below to specify the user/password to connect to the database.
SQLCA.LogId = %your id%
SQLCA.LogPass=%your pass%

Just for your reference, when the Dynamic Database Connection feature is turned on the LogID and LogPass of the Transaction object will be used to connect to the database; when it is turned off then the user name and password specified in the data source will be used to connect to the database.

If there is still the issue, please refer to below article to provide the PowerServer log and PowerServer error log to us too, thanks.
http://support.appeon.com/index.php?/Knowledgebase/Article/View/50/0/what-you-can-provide-to-us-for-further-debugging-when-you-run-into-the-appeon-server-related-issues


Regards,
ZhaoKai

Comment
Load more comments
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Friday, 17 April 2020 00:53 AM UTC
For long connection solution, the DB session won’t be released for the client, but it is used by other transactions in you case. So, I suggest you try create two data sources.
  1. Helpful
Jon Tzeng
  1. Jon Tzeng
  2. Wednesday, 29 April 2020 03:12 AM UTC
Hi Zhao Kai,

We have long connection setting and dynamic database connection by using SQLCA.LogId = %your id% and SQLCA.LogPass=%your pass%. .We are able to reproduce the issue.

1. Application first use g_security transaction to connect database.

2. User logon to application with user database ID/password.

3. After successfully database connection, user is asked to change his password due to 45 days using the same password. and user change the password successfully.

4. User idle for 10 minutes and perform a database insert. At this time, ORA-01017: invalid username/password; logon denied.

5. AEM database resource, if we unchecked the dynamic database connection: we can see the User Name: has the user id and password that User get ORA-01017.

Thanks,

Jon



Attached is service and error log.



Thanks,



Jon
  1. Helpful
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Wednesday, 29 April 2020 03:28 AM UTC
HI Jon,



Please try disconnect and connect database again with correct password once user change the password successfully.



Regards,

ZhaoKai
  1. Helpful
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.