Skip to Content
0
Former Member
Jul 21, 2006 at 09:37 PM

Portal Activity Report Iview Doesnot work due to Special Char in UserID

35 Views

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