Hi I have created a directory service pointing an sql db.It has a table named users with fields UserId,GoupName and Password.Now I have defined all the User attributes to UserId and GroupAttributes to GroupName.
Now in the Query Lookup User By ID (required) I have gvien the query select * from USERs where USERID=‘{uid}’.
For this I am getting an error "
[POP.012.0006.wm_xt_dbdirsvc] An error occured executing the SQL query: “select * from USERMEMBERSHIP where USERID=‘{uid}’”. Please type a valid query and try again."
Can any body please help…!!
#webMethods#webMethods-BPMS#MWS-CAF-Task-Engine