AnsweredAssumed Answered

Error: WIS 00008: The query cannot run, because it contains incompatible...

Question asked by navzjoshi00 Champion on Aug 3, 2011
Latest reply on Aug 24, 2011 by Chris_Hackett
Project universe has this condition for project viewer rights

The below condition doesn’t work -
EXISTS (SELECT 1
FROM CMN_SEC_ASSGND_OBJ_PERM_R_V
WHERE CMN_SEC_ASSGND_OBJ_PERM_R_V.OBJECT_TYPE = 'RECORD'
AND @Select(Global rights\Object Code)= 'PRJ_PROJECT'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.PERMISSION_CODE IN ('prProjectViewer')
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.COMPONENT_CODE= 'PRJ'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.USER_ID= @Prompt('User ID', 'N',, mono, free) )


On the other hand , Instance rights of project viewing works -

EXISTS (
SELECT 1
FROM cmn_sec_assgnd_obj_perm_v
WHERE object_instance_id = @Select(Projects\Project DB Id)
AND object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code IN ('prProjectViewer')
AND component_code = 'PRJ'
AND user_id = @Prompt('User ID', 'N',, mono, free) )


Both these condtions work at the universe level .

When I drag the first condition at the report level – I get a error message as

The query cannot run, because it contains incompatible objects. See your Business Objects administrator. (Error: WIS 00008)

A quick response would be much appreciated ... :)

NJ

Outcomes