Question Re: SAP Sysbase sybsid user deleted in Technology Q&A

SAP Sysbase sybsid user deleted

former_member197078 — Wed, 29 Jun 2016 06:21:31 GMT

Hi Experts,

I need urgent help on the following problem we are facing on Sybase user

one of the user syb<SID> user was deleted from the operating system now we are not able to do the db configuration on it

mainly DB log clearing when we type ISQL command in the powersell we are getting following error

how to reconfigure the sybda1 user so that i can perform the DB transcation

or is there any way to clear the log without login to the sybsid user

Urgent help needed

Regards

SROY

Re: SAP Sysbase sybsid user deleted

Former Member — Wed, 29 Jun 2016 06:35:35 GMT

Dear Sunil,

Try executing isql from the path where is resides.

ie :

C:\sybase\<SID>\OCS-15_0\bin\isql

Does it work?

Also please cross check if the sybsid user have given/reverted with all the necessary privileges as before/

Regards,

Ajith Prabhakaran

Re: SAP Sysbase sybsid user deleted

former_member197078 — Wed, 29 Jun 2016 06:48:09 GMT

Hi Ajith,

Thank you very much . But when i run it from the folder it gives me error as below

how to fix it

Regards

SROY

Re: SAP Sysbase sybsid user deleted

Former Member — Wed, 29 Jun 2016 08:48:04 GMT

Well, I think, it is not only about removing the sybid user, somehow few of the files are also deleted. Can you tell me if you see in SYBASE%\%SYBASE_OCS%\dll directory?

Check if these library files are exisiting? Else ask the Windows Adminstor to restore each and everything, rather than partial scenes.

Regards,

Ajith Prabhakaran

Re: SAP Sysbase sybsid user deleted

former_member197078 — Wed, 29 Jun 2016 09:15:40 GMT

Hi Ajith,

Thank you very much for your help

I just reentered the env variables in the system and it worked

thank you

Regards

SROY

Re: SAP Sysbase sybsid user deleted

Johan_sapbasis — Wed, 29 Jun 2016 09:31:32 GMT

Hi Sunil,

The environment variables will resolve your current error.

But take into account that your backup team needs to restore the system otherwise you will run into problems in the future with the user having been deleted. Remember during installation the user is created in the registry with unique key entries e.t.c. so you cannot just recreate the user as such.

Kind Regards,

Re: SAP Sysbase sybsid user deleted

former_member197078 — Wed, 29 Jun 2016 10:25:02 GMT

Hi Nicolaas,

thank you ,

yes we inform the client to take Imge BKs

All the registry key has to be created for the new user

thank you

Regards

SROY