Forum topic

I’m using the Student List report to obtain a list of email address for all active students. I had tried to create a contact list through the Academics search option, but was thrown an error message (see below in bold).

When I tick the appropriate boxes in the Student List report on the options, and hit ‘Create Contact List’ I’m thrown another error message (below in italics).

Is this something that has occurred previously, or is this a bug in the system?

*** Error on action - PerformFindStudent ***
com.quinsoft.zeidon.InvalidAttributeValueException: Invalid value for attribute LodDef = nazsis.fStudent2 Table = PERSON EntityDef = nazsis.fStudent2.Person SQL => SELECT ID, LASTNAME, FIRSTNAME, MIDDLENAME, SUFFIX, PREFIX, CAMPUSID, PREFEREDFIRSTNAME, MAIDENNAME, SALUTATION, GENDER, MARITALSTATUS, HOMEPHONE, WORKPHONE, FAX, MOBILEPHONE, EXTENSION, EMAILADDRESS, TITLE, DATEOFBIRTH, OCCUPATION, CHURCHDENOMINATION, OCCUPATIONCODE, RETIREDPASTORFLAG, CONTACTPREFERENCE, PREFERREDEMAIL, GOVERNMENTID, FK_ID_ADDRESS, FK_ID_CHURCH, FK_ID_DONOR, FK_ID_EXTRACURRICULARACTIVITY, FK_ID_FINAIDPROFILE, FK_ID_PERSON, FK_ID_TRUSTEE, z_NOTE FROM PERSON WHERE PERSON.ID = ? ; DB: jdbc:mysql://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false Column = PERSON.GENDER AttributeDef = nazsis.fStudent2.Person.Gender Value = T Invalid table domain value. XOD: nazsisbin/fStudent2.XOD

*** Error on action - CREATE_ContactList ***
com.quinsoft.zeidon.InvalidAttributeValueException: Invalid value for attribute LodDef = nazsis.qStuEnr2 Table = STUDENT EntityDef = nazsis.qStuEnr2.Student SQL => SELECT STUDENT.ID, STUDENT.CREATIONDATE, STUDENT.WITHDRAWALREASON, STUDENT.DATEOFDEPARTURE, STUDENT.DIRECTORYDATABLOCK, STUDENT.EMAILADDRESS, STUDENT.STATUS, STUDENT.CURRENTLEVEL, STUDENT.RESIDENCYSTATUS, STUDENT.FINALGPA, STUDENT.ENTRYYEARMONTH, STUDENT.TOTALEARNEDCREDITS, STUDENT.FK_ID_COHORT, STUDENT.FK_ID_ADMINISTRATIVEDIVISION, STUDENT.FK_ID_HEALTHTRACK, STUDENT.FK_ID_CAMPUSLOCATION, STUDENT.FK_ID_COLLEGE, STUDENT.FK_ID_COLLEGEYEAR, STUDENT.FKEYID_COLLEGEYEAR, STUDENT.FK2_ID_PERSON, STUDENT.FK_ID_PERSON, STUDENT.FK_ID_STUDENTHEALTH, PERSON.ID, PERSON.MOBILEPHONE, PERSON.PHOTO, PERSON.CAMPUSID, PERSON.DATEOFBIRTH, PERSON.WORKPHONE, PERSON.EMAILADDRESS, PERSON.WORKEMAILADDRESS, PERSON.PREFERREDEMAIL, PERSON.HOMEPHONE, PERSON.GENDER, PERSON.LASTNAME, PERSON.FIRSTNAME, PERSON.MIDDLENAME, PERSON.PREFEREDFIRSTNAME, PERSON.SUFFIX, PERSON.SALUTATION, PERSON.PHOTORELEASE, PERSON.CHURCHDENOMINATION, PERSON.FK_ID_ADDRESS, PERSON.FK_ID_CHURCH, PERSON.FK_ID_DONOR, PERSON.FK_ID_EXTRACURRICULARACTIVITY, PERSON.FK_ID_FINAIDPROFILE, PERSON.FK_ID_PERSON, PERSON.FK_ID_TRUSTEE, ADDRESS.ID, ADDRESS.LINE1, ADDRESS.LINE2, ADDRESS.LINE3, ADDRESS.CITY, ADDRESS.STATEPROVINCE, ADDRESS.COUNTRY, ADDRESS.COUNTY, ADDRESS.POSTALCODE, ADDRESS.PHONE1, ADDRESS.LATITUDE, ADDRESS.LONGITUDE, ADDRESS.FK_ID_CHURCH, ADDRESS.FK_HOSTID_HOST, ADDRESS.FK_ID_ORGANIZATION, ADDRESS.FK_ID_PERSON, ADDRESS.FK_ID_SCHOOL, ADDRESS.FK_ID_STUDENTHEALTH, ADDRESS.SHIPHOSTID_HOST, ADDRESS.FK_ID_CAMPUSLOCATION, DEMOGRAPHICS.ID, DEMOGRAPHICS.IPEDS_ETHNICITY, DEMOGRAPHICS.CITIZENSHIPCODE, DEMOGRAPHICS.PRIMARYLANGUAGE, DEMOGRAPHICS.ALIENREGNUMBER, DEMOGRAPHICS.ETHNICITY, DEMOGRAPHICS.NATIONOFCITIZENSHIP, DEMOGRAPHICS.FK_ID_PERSON, CHURCH.ID, CHURCH.NAME, CHURCH.SPECIALTYPE, CHURCH.PHONE, CHURCH.DISTRICTCODE, CHURCH.DENOMINATION, CHURCH.FK_ID_ADDRESS, CHURCH.FK_ID_PERSON, ADMINISTRATIVEDIVISION.ID, ADMINISTRATIVEDIVISION.NAME, ADMINISTRATIVEDIVISION.FK_ID_DOCUMENT, CAMPUSLOCATION.ID, CAMPUSLOCATION.NAME, CAMPUSLOCATION.FK_ID_ADDRESS, CAMPUSLOCATION.DESCRIPTION FROM STUDENT LEFT JOIN PERSON ON STUDENT.FK_ID_PERSON = PERSON.ID LEFT JOIN ADDRESS ON PERSON.FK_ID_ADDRESS = ADDRESS.ID LEFT JOIN DEMOGRAPHICS ON DEMOGRAPHICS.FK_ID_PERSON = PERSON.ID LEFT JOIN CHURCH ON PERSON.FK_ID_CHURCH = CHURCH.ID LEFT JOIN ADMINISTRATIVEDIVISION ON STUDENT.FK_ID_ADMINISTRATIVEDIVISION = ADMINISTRATIVEDIVISION.ID LEFT JOIN CAMPUSLOCATION ON STUDENT.FK_ID_CAMPUSLOCATION = CAMPUSLOCATION.ID LEFT JOIN MM_STUDENT_TKSCLST_CAMPUSLOCATIO ON MM_STUDENT_TKSCLST_CAMPUSLOCATIO.FK_ID_STUDENT = STUDENT.ID LEFT JOIN CAMPUSLOCATION CAMPUSLOCATION1 ON CAMPUSLOCATION1.ID = MM_STUDENT_TKSCLST_CAMPUSLOCATIO.FK_ID_CAMPUSLOCATION WHERE CAMPUSLOCATION1.ID = ? AND ( STUDENT.STATUS = ? ) AND ( STUDENT.CURRENTLEVEL = ? ) AND STUDENT.FK_ID_ADMINISTRATIVEDIVISION = ? ; DB: jdbc:mysql://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false Column = PERSON.GENDER AttributeDef = nazsis.qStuEnr2.Person.Gender Value = T Invalid table domain value. XOD: nazsisbin/qStuEnr2.XOD