on 05-15-2015 5:11 AM
Hi Experts,
Please help,
I had a situation like I have lost all the passwords SA, SAPSA, SAPSSO so I was forced to regenerate to SA password to get into database. I have followed a procedure 1872806. Got the password for SA with that I have changed the SAPSA and SAPSSO passwords.
+++SYBADM shows the connection was successfully established. But we are failing to trigger auto backups.
Also the scheduled calender jobs are failing after the password resets. More over SA is locked.
At OS level I am getting a message worker jsj__RunSQLJob:jsd_MakeConnection() failed for user sapsa to server SID”
Please help on this situation.
Regards,
Amarnath
Amar,
Did you unlock the sa login before executing the syb_update_db script?
Check SAP Note 1602547 , section "How to unlock or lock the sa login" .
When you change your password for SA you need to ensure the password for all users with sso_role is consistent.
For this follow note 1706410, if you did use procedure in 1872806 make sure you do not add -psa
but rather -psapsso
1706410 - SYB: Security - Changing passwords for database users
1872806 - How to set a new password for SA account in Sybase ASE server
Also for the Backup Scheduiling use the below note: 1841993 - SYB: How to schedule backups in DBA Cockpit
Regards
Kiran K Adharapuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kiran,
Thanks for the suggestion . I tried the mentioned notes and scheduled the backup accordingly but it failed with the below error,
FATAL ERROR: Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION method EXEC_ACTION line 88 / RC=Job error
Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION method EXEC_ACTION line 88
Kernel Error ID:
WP ID: 21
WP PID: 5048
Application Server: XXXXXXXXX
SYSID: XXX
SY-SUBRC: 1059
SY-TABIX: 0
Message: Job error
Messages from Scheduler Back-End:
Writing job parameters failed
[ASE Error SQL208:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]saptools..JOB_PARAMETERS not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Please help with this situation.
Regards,
Amarnath
Amar,
Check if you have the permission to access the table which is throwing you the error:
Run this query:
select name,owner=user_name(uid)
from sysobjects
where name = "<table_name>"
go
Also try with the below options:
1. Also check if your ATM is up and running? If possible un-install and re-install ATM and Repair ATM
2. Restart the JS_Agent(JOB Scheduler)
Execute the below commands from isql:
use sybmgmtdb
go
exec sp_sjobcontrol @name=NULL,@option="stop_js"
go
exec sp_sjobcontrol @name=NULL,@option="start_js"
go
Refer this SAP Note:
1835880 - SYB: How to diagnose issues with Sybase ASE Job Scheduler, ATM, or Scheduled Jobs
If nothing goes fine share me the corresponding screen-shots and database error log which can be found from the below path:
$SYBASE/ASE-15_0/install/<SID>.log
Regards
Kiran K Adharapuram
Hi Amar,
Attach the 3 error logs for analysis, we will get some hints from it, I am sure.
1. Database Server error log($SYBASE/ASE-15_0/install/SID.log)
2. Database BackupServer error log($SYBASE/ASE-15_0/install/SID_BS.log)
3. JS_Agent log
If possible delete all the scheduled jobs and restart the JS_Agent and try again
Regards
Kiran K Adharapuram
Hello Armanath,
I wonder how did you change sapsa and sapsso passwords?
I suggest you to read carefully SAP Note 1706410 - SYB: Security - Changing passwords for database users : item 5 (changing passwords in Secure Storage), item 6 (Renew external logins) and item 7 and ensure you have correctly followed these instructions.
SYB_JSTASK external login uses the sapsa login, so if you changed the sapsa password without following the instructions detailed in the SAP Note above, I'd expect the Job Scheduler to no be able to establish a connection to the ASE.
Do **not** delete the jobs, they are Data Collector jobs, and what we have so far is an attempt to connect to the ASE that failed, not an issue with jobs scripts.
HTH
Cris
Cris,
Thank you very much chris for the reply . I agree, I was expecting that there may be issue with the job scripts so asked for delete and re-create, also my intention was to re-create just the user created jobs not the DataCollector Jobs.
Now after the glance of the log it is sure that the issue is connecting to ASE attempt failed.I am about to give this note after looking the log file.
@Amar: Kindly follow the SAP Note 1706410 - SYB: Security - Changing passwords for database users
and let us know the connectivity to ASE got succeed
Regards
Kiran K Adharapuram
Hi maria,
We do not have any of the passwords to further proceed with database activities except sybadm. There was no other option other than re-setting passwords.
1) I have stopped Sybase.
2) Edited file "run_sid" and added flag -psa -T4044.
3) Ran sybase.bat file from cmd promt.
4) After adjusting the CMD buffer size again executed RUN_SID.bat file which I have edited previously.
5) A new password for sa was generated.
6) With the help of sa chaged sapsa and sapsso passwords.
7) isql -Usa -Pxxxxx -SSID -c -w9999.
😎 sp_password "oldpassword",new password,sasso.
9) sp_password "oldpassword",new password,sapsa.
10) After doing this again locked sa.
Please advice now.
Thanks,
Amarnath
Hello Armanath,
Please follow the instructions detailed in item 5 (changing passwords in Secure Storage), item 6 (Renew external logins) and item 7 from SAP Note 1706410 - SYB: Security - Changing passwords for database users .
Regards,
Cris
Hi Kiran/Maria,
Thanks a lot for the advice, previously I have followed all the steps mentioned in Note- 1706410.
Could you please guide me in below step i.e., creating a temporary password file. Is that nothing but password written on any text document? or just the password.
Please advice.
Thanks,
Amarnath.
Hi Maria/Kiran,
Thanks a lot it worked as a charm. Now I am able to schedule backup from DBACOCKPIT manually by SQL Script and I am not able to schedule using DUMP DATABASE and schedule as a recuring action. Do you have any idea with this?
If I am correct I see my solution manager is the owner for rest of the systems. Should I schedule it in solution manager by DBACOCKPIT and schedule an action?
But to say you people are very helpful thanks again.
Thanks,
Amarnath
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.