I've removed TEMP02.DBF ... same problem
Set aggregation for those 2 fields In RPD
Sorry I can't uderstand your suggestion...
Are you talking about Oracle BI rpd ?
The problem is that Oracle gives a bab output on a "normal" group by query !
Interesting, just in case make sure all those 3 fields values are same.
What ever it is if you are using BI then that should take care of it.
The 3 fileds values are the same !
It was the first thing I've checked ... I excuted an external query to count record having a count >1
select a.field1, a.field2, a.field3, count(*)
select field1, field2, field3, sum( field6 ), sum( field7 )
group by field1, field2, field
group by a.field1, a.field2, a.field3
No records found !
Then I tried to filter using a set of field1, field2, field3 values causing the PK error.
With this smaller dataset the error doesn't occur. Because of this I've supposed the problem could be related to temporary spaces or someting similar.