AnsweredAssumed Answered

NSQL Error

Question asked by swathithodupunoori62131063 on Nov 20, 2013
Latest reply on Nov 20, 2013 by another_martink

select
@select:dim:user_def:implied:Project:f.UniqueId:proj_id@,
@select:dim_prop:user_def:implied:Project:f.rel_name:release_name@,
@select:dim_prop:user_def:implied:Project:f.prStart:proj_start_date@,
@select:dim_prop:user_def:implied:Project:f.prFinish:proj_finish_date@,
@select:dim_prop:user_def:implied:Project:f.milestoneStart:release_start_date@,
@select:dim_prop:user_def:implied:Project:f.milestoneEnd:release_end_date@

FROM (SELECT concat(inv.id ,t.id,rel.id)  UniqueID, rel.wf_ent_milestone1 rel_name,
p.prStart prStart,p.prFinish prFinish,rel.wf_milestone1_start milestoneStart,
rel.wf_milestone1_date milestoneEnd
FROM inv_investments inv
INNER JOIN odf_ca_inv odf on odf.id = inv.id
INNER JOIN PRTASK P on p.prprojectid = inv.id
INNER JOIN ODF_CA_TASK T ON T.ID = p.prid
INNER JOIN odf_ca_wf_release_obj rel on rel.id = odf.wf_release_idea_proj and rel.wf_rel_type_onoffpro = 'On'
WHERE P.PRSHORTNAME = 'wf_tog_est') f
 and
@FILTER@

 

 

I am facing getting below error when i am trying to execute above NSQL query in clarity 

 

Error:NPT-0103: Error when trying to execute the query. Native message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00909: invalid number of arguments SQL Text: select f.UniqueId proj_id, f.rel_name release_name, f.prStart proj_start_date, f.prFinish proj_finish_date, f.milestoneStart release_start_date, f.milestoneEnd release_end_date FROM (SELECT concat(inv.id ,t.id,rel.id) UniqueID, rel.wf_ent_milestone1 rel_name, p.prStart prStart,p.prFinish prFinish,rel.wf_milestone1_start milestoneStart, rel.wf_milestone1_date milestoneEnd FROM inv_investments inv INNER JOIN odf_ca_inv odf on odf.id = inv.id INNER JOIN PRTASK P on p.prprojectid = inv.id INNER JOIN ODF_CA_TASK T ON T.ID = p.prid INNER JOIN odf_ca_wf_release_obj rel on rel.id = odf.wf_release_idea_proj and rel.wf_rel_type_onoffpro = 'On' WHERE P.PRSHORTNAME = 'wf_tog_est') f and 1=? and 1=1 .

 

Could anyone please help me with this ?

Outcomes