| error to run MySQL Aggregate Functions in birt2.1.1 [message #245495] |
Fri, 29 June 2007 01:59 |
Eclipse User |
|
|
|
Originally posted by: jem.gmail.com
Hi,
(sorry for my poor english)
I use eclipse-SDK-3.2.1-win32.zip,
emf-sdo-xsd-SDK-2.2.1.zip,
GEF-ALL-3.2.1.zip,
birt-report-designer-all-in-one-2_1_1.zip
I create s rptdesign and this is my query, this run well from command
prompt.
But when i run this query from birt then a BIRT exception occurred,
which i paste later.also see that the table 'engg_exam_total' is present .
Can u tell me where is the problem??
plz reply me.
this is my query
//////////////////////////////////////////////////////////// ////
select
sum(.engg_exam_total.grand_total)*100/sum(.subject_curriculu m.full_marks)
from examination_type,
examination_instance,
examination_instance_item,
academic_session,
examination_roll_no,
student_personal_details,
person_details,
faculty_academicunit_composition,
academic_unit,
student_enrollment,
course_structure,
course_offering,
subject_curriculum,
subject,
subject_grade,
engg_exam_total
where
examination_type.examination_type_id=.examination_instance.e xamination_type_id
and
engg_exam_total.exam_instance_id=.examination_instance.exami nation_instance_id
and
academic_session.academic_session_id=.examination_instance.c urriculum_session
and
examination_roll_no.exam_instance_id=.examination_instance.e xamination_instance_id
and .student_personal_details.student_id=.examination_roll_no.st udent_id
and .student_personal_details.person_id=.person_details.person_i d
and
faculty_academicunit_composition.faculty_id=.examination_typ e.faculty_id
and
faculty_academicunit_composition.academic_unit_id=.academic_ unit.academic_unit_id
and .student_enrollment.student_id=.student_personal_details.stu dent_id
and
course_structure.academic_unit_id=.faculty_academicunit_comp osition.academic_unit_id
and
course_offering.course_structure_item_id=.course_structure.c ourse_structure_item_id
and
subject_curriculum.subject_curriculum_id=.course_offering.su bject_curriculum_id
and .subject.subject_id=.subject_curriculum.subject_id
and
examination_instance_item.examination_instance_id=.examinati on_instance.examination_instance_id
and
examination_instance_item.course_offering_item_id=.course_of fering.course_offering_item_id
and
subject_grade.exam_instance_id=.examination_instance.examina tion_instance_id
and
subject_grade.course_offering_item_id=.examination_instance_ item.course_offering_item_id
and .examination_instance.curriculum_session='3'
and .examination_instance.examination_type_id='15'
and .faculty_academicunit_composition.faculty_id='1'
and .academic_unit.academic_unit_id='17'
and .course_structure.course_id='42'
and .subject_grade.student_id='275'
group by .examination_instance.curriculum_session,
examination_instance.examination_type_id,
faculty_academicunit_composition.faculty_id,
academic_unit.academic_unit_id,
course_structure.course_id,
subject_grade.student_id
//////////////////////////////////////////////////////////// ////
and this is the error
///////////////////////error//////////////////////////////// //////
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.1.1.v20060922-1058
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: General error: Unknown table 'engg_exam_total' in field list
|
|
|
Powered by
FUDForum. Page generated in 0.04422 seconds
Home