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

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

Jaydeep — Mon, 03 Dec 2012 13:47:33 GMT

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

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

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

2012-12-03T05:09:08,177 ERROR [00000007] :SYSTEM@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] :SYSTEM@abc - 20121203:05.09.08.19: 00000039:ERROR: CLASSFACTORY cannot be instantiated.

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

PaulHomes — Tue, 04 Dec 2012 08:38:50 GMT

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).

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

Jaydeep — Tue, 04 Dec 2012 11:12:03 GMT

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

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

PaulHomes — Tue, 04 Dec 2012 21:01:14 GMT

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.

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

Rocky2090 — Sat, 29 Jun 2013 21:16:08 GMT

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