Symptom
Schedule database job failed with following error:
[ASE Error SQL4002][SAP][ASE ODBC Driver][Adaptive Server Enterprise] Login failed.
Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION method REFRESH_ACTIONS line 64/ RC=1074
DBACOCKPIT - DB connection test failed and warned same error '[ASE Error SQL4002][SAP][ASE ODBC Driver][Adaptive Server Enterprise] Login failed.'
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 Business Suite
Solution
- Run T-code DBACOCKPIT;
- On left panel -> Choose 'Database Connections';
- Chose 'Remote Database Connection' - 'SAP ASE' and click 'Change User Credentials';
- Input the correct password of DB user.
More details refer snote 2692998