Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

Reply
New Contributor
Posts: 2

Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

2012-12-03T05:09:08,129 INFO  [00000003] Smiley FrustratedYSTEM@abc - SAH061001I SAS Table Server (2171), State, starting

2012-12-03T05:09:08,145 INFO  [00000039] Smiley FrustratedYSTEM@abc - New out call client using cached connection (1) for user sastrust@saspw.

2012-12-03T05:09:08,177 ERROR [00000007] Smiley FrustratedYSTEM@abc - 20121203:05.09.08.18: 00000039:ERROR: Metadata identity "OMSOBJSmiley Tongueerson/A***.A***2" is not configured as a table server system user.

2012-12-03T05:09:08,177 ERROR [00000007] Smiley FrustratedYSTEM@abc - 20121203:05.09.08.18: 00000039:ERROR: 0; ; ; V_CTOR, CREATE SERVICE CONTEXT: Unexpected failure encountered: Function failed.

2012-12-03T05:09:08,191 ERROR [00000007] Smiley FrustratedYSTEM@abc - 20121203:05.09.08.19: 00000039:ERROR: CLASSFACTORY cannot be instantiated.

PROC Star
Posts: 425

Re: Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

I would hazard a guess that perhaps someone has removed the SAS Trusted User as a member of the Table Server Administrators group.  In my SAS 9.2 installation the Table Server Administrators group has 2 members: SAS Truster User (a user) and SAS Administrators (a group).

New Contributor
Posts: 2

Re: Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

Posted in reply to PaulHomes

Hi Paul,

Thanks for reply, you are correct, however we already added the Trusted User (SMC) and restart all the servces, still getting the same issue.

Any suggestion.

Regards,

Jaydeep

PROC Star
Posts: 425

Re: Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

If it's still an issue then I'd suggest contacting SAS Technical Support for further assistance. The removal of the SAS Trusted User from the Table Server Administrators group suggests the possibility of other issues with the default security setup being modified.  You might also consider getting the assistance of a local consultant (SAS Professional Services or a partner) to review your environment.

N/A
Posts: 1

Re: Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

Posted in reply to PaulHomes

Thanks Paul, Adding trusted user to Table Server Administrators worked..

Ask a Question
Discussion stats
  • 4 replies
  • 325 views
  • 1 like
  • 3 in conversation