SAP Sysbase sybsid user deleted

[former_member197078]

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

[former_member197078]

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

[former_member197078]

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

[Johan_sapbasis]

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,

[former_member197078]

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

[Former Member]

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

[Former Member]

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