I'm having trouble creating a view in cache with query like:


SELECT column1, column2, column 3
    FROM  table
        (column1, columnn 2) IN (SELECT c1, c2 FROM table2 GROUP BY c1)
    ORDER BY column1


I think the problem is in where clause, because it cannot take two columns .


the exact error: [SQLCODE: <-1>:<Invalid SQL statement>] [%msg: < ) expected, , found^ (column1,>]


Any idea on how to solve this?


Thank you.

0 3 75,895



I set up cache in container, which is working fine. But when accessing managment portal the default user was alway Unknown user and no username or password were required. So i disabled the Unknow user in the Security section, but now i keep getting an error access denid. 

0 9 2,258