Hello,
We are on EP SP16.
We Created an iView using "Portal Activity Report iView" template and found that it shows data only till specific date. We have a user named "Robert.O'Niel" and while creating aggregate data system give Oracle error.
Here's the INSERT Statement.
The SQL statement "INSERT INTO WCR_USERSTAT(TIMESTAMPHOUR,AGGREGATIONLEVEL,HASHEDUSERID,USERTYPE,LOGONID) VALUES (1150736400000,'h','Robert.O'Neil','n','ROBERT.O'Neil')" contains the syntax error[s]: SQL syntax error: not a table reference
SQL syntax error: the token "," was not expected here
The problem is System is not able to generate aggrgate data in Table WCR_USERSTAT anymore and gives this error continously.
Can somebody help is clearing this data from Portal.Also is there any patch available which can resolve this issue in future.
Regards
Navdeep Dharmak