12-03-2012 08:47 AM
2012-12-03T05:09:08,129 INFO  YSTEM@abc - SAH061001I SAS Table Server (2171), State, starting
2012-12-03T05:09:08,145 INFO  YSTEM@abc - New out call client using cached connection (1) for user sastrust@saspw.
2012-12-03T05:09:08,177 ERROR  YSTEM@abc - 20121203:05.09.08.18: 00000039:ERROR: Metadata identity "OMSOBJerson/A***.A***2" is not configured as a table server system user.
2012-12-03T05:09:08,177 ERROR  YSTEM@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  YSTEM@abc - 20121203:05.09.08.19: 00000039:ERROR: CLASSFACTORY cannot be instantiated.
12-04-2012 03:38 AM
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).
12-04-2012 06:12 AM
Thanks for reply, you are correct, however we already added the Trusted User (SMC) and restart all the servces, still getting the same issue.
12-04-2012 04:01 PM
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.
06-29-2013 05:16 PM
Thanks Paul, Adding trusted user to Table Server Administrators worked..