I want count from user table , so now i am executing query like
queryidnodateresult idList = CRMService.queryidnodate("", "users", true);
aisid[] myaisid = idList.records;
MessageBox.Show("Number of IDs returned by query:"+myaisid.Length.ToString());
but it return exception as {"The string '' is not a valid AllXsd value. "}
While SQl log does not show any error
here is sql log
Aug 19 2015 18:13:53.802 11556 4932 3 execsql,time,sql 0 UPDATE Activity SET Acty_Duration = DATEDIFF(MI, Acty_Login, COALESCE(Acty_Logout,'20150819 18:13:53')) WHERE Acty_LogoutMethod IS NULL
Aug 19 2015 18:14:02.696 11556 1388 3 fselectsql,time,sql 0 Select User_UserID, user_updateddate, user_CreatedDate, user_deleted from users where user_deleted IS NULL ORDER BY user_updateddate
Aug 19 2015 18:14:09.542 11556 1388 3 fselectsql,time,sql 0 Select Parm_Name, Parm_Value From Custom_Sysparams WITH (NOLOCK) where Parm_Name = N'MetadataVersion' OR Parm_Name = N'SysLockedTime' OR Parm_Name = N'SysLockedByUsrID' ORDER BY Parm_Name