topic Re: update CASEMGMT password in Administration and Deployment

update CASEMGMT password

SASuser19 — Tue, 14 Jun 2016 15:56:36 GMT

Dear All,

I need to change the password for CASEMGMT user, I do the following steps:

1 – I changed the password for MS SQL server

2- I changed the ODBC for the user CASEMGMT with the new password

3- I used the SAS deployment wizard to change the password and it finished successfully.

But when I try to log in to the ECM the error appears “HTTP status 500 - could not open JDBC connection for transaction” as the below

Could you please give me your advice.

Re: update CASEMGMT password

dpage — Tue, 14 Jun 2016 16:40:47 GMT

Was there a restart of the the webappserver in that process after running the SDM?

If there was,I'd check the WebpAppServer/SASServer8_1/logs/server.log and see if it has any more details about what is failing. You can also try putting the new unencrypted password directly in conf/catalina.properties (should be a pw.sas.jdbc.casemgmt or ecm or something like that) so you're sure the correct password is being used - if that solves the problem I would open a tech support track to try and understand exactly why the SDM update isn't working like it should.

You might also try checking the SQL Server logs to confirm it's an invalid user/password error and something else (is the new password auto expired or something...)

Re: update CASEMGMT password

SASuser19 — Tue, 14 Jun 2016 17:18:01 GMT

Thank you a lot @dpage after I but the new password in conf/catalina.properties file the ECM work fine. but it is not logic to put the unencrypted password it appears to any one if open this file. so please if there any way to encrypt it.

Re: update CASEMGMT password

dpage — Tue, 14 Jun 2016 17:21:26 GMT

I wasn't suggesting leaving it that way, just confirming the problem was a stale password entry. I'd open a track and provide the casemgmtmid_updatePassword*.log, hopefully a resolution can be found that way.