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.
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).
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
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.
Thanks Paul, Adding trusted user to Table Server Administrators worked..
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.