Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple projects linked to one project issue Too many result rows returned for SQL

Highlighted
Sjouke
Acclaimed Contributor

Multiple projects linked to one project issue Too many result rows returned for SQL

The following message is appearing when opening an existing Project Issue:
---------------------------
Microsoft Internet Explorer
---------------------------
Too many result rows returned for SQL

in Rule 3 - {1}:

select pf.prj_business_unit_code, pf.prj_business_unit_meaning
from
knta_references kr, kcrt_fg_pfm_project pf
where
kr.parameter1 = 31738 AND
kr.source_id = pf.prj_project_id (KNTA-10532)

Exception Correlation: GUID=EE7976E4-F4A4-2E9B-C02C-42B3A2357762
Generated Time=2011/03/16-09:23:35.852 CET
Server Node Name: 801
---------------------------
OK
------

When going through the GUI, this project issue is only linked to one project. While in the table KNTA references there are 3 rows with the same parameter1 number, while it appears not to be the case for other logged project issues.

anyone an idea on how to solve this issue?
1 REPLY
M Santosh Kumar
Super Collector

Re: Multiple projects linked to one project issue Too many result rows returned for SQL

Hi,

Put 'Distinct' in the select clause to resolve this problem.

Thanks,
Kumar
//Add this to "OnDomLoad" event