PeopleTools 8.54.36 app:8.9 in Tree Viewer when clicked on Search button on the search page:
File: \pt85436b-retail\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 686 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22008) 241
Failed SQL stmt: SELECT COUNT ( DISTINCT TREE_NAME + SETID + SETCNTRLVALUE + EFFDT + (CONVERT(CHAR(10),EFFDT,121)) + DESCR + TREE_CATEGORY + TREE_STRCT_ID + VALID_TREE + NODE_FIELDNAME + DTL_FIELDNAME ) AS COUNT_KEYS FROM PSTREEDEFVWR_VW
What causes this error? We are using SQL Server 2016.