AnsweredAssumed Answered

Incorrect Number Format

Question asked by brenochuba- on Aug 23, 2010
Latest reply on Aug 24, 2010 by DevK
I am filtering a OBS Project in a custom portlet. I am getting the error:

INCORRECT NUMBER FORMAT

What can be?

Here is my NSQL query:
SELECT @SELECT:DIM:USER_DEF:IMPLIED:PROJECT:ID:ID_PROJECT@,
       @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:NAME:NAME_PROJECT@
FROM(
SELECT DISTINCT                                          inv2.id ID,
                                                         inv2.name NAME
                                                FROM   cop_program_v v
                                                LEFT OUTER JOIN inv_investments inv ON v.program_id = inv.id AND inv.is_active <> 0
                                                INNER JOIN inv_investments inv2 ON v.project_id = inv2.id
                                                INNER JOIN inv_projects prj ON inv2.id = prj.prid AND prj.is_program <> 1
                                                LEFT OUTER JOIN PRJ_BASELINE_DETAILS det ON prj.prid = det.object_id 
AND det.object_type = 'PROJECT' 
AND det.is_current = 1
                                                LEFT OUTER JOIN cmn_sec_users u ON inv2.manager_id = u.id
                                                LEFT OUTER JOIN prj_obs_associations assoc ON inv2.id = assoc.record_id AND assoc.table_name = 'SRM_PROJECTS'
                                                LEFT OUTER JOIN prj_obs_units_flat flat ON assoc.unit_id = flat.unit_id
                                                WHERE (v.is_program <> 1) 
                                                AND (prj.is_template <> 1) 
                                                AND (inv2.is_active <> 0)
                                                AND ((flat.branch_unit_id IS NULL) OR (flat.branch_unit_id = flat.branch_unit_id)) 
                                                AND @WHERE:PARAM:USER_DEF:INTEGER:flat.branch_unit_id:OBS@
)
WHERE @FILTER@

Outcomes