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
Hello,
If you ever see those types of messages then its an error in the system. If it was an anticipated possible error you would receive a standard popup that indicates what is wrong with your request. The desired outcome it that you never see those messages. Thank you for sharing them so that we can work on a solution.
If I am not able to duplicate the error I may reach out for you to help me duplicate it.
Thank you for taking your time to help us resolve these!
Dana
*GNECsis Support Specialist*
At the end of the errors is: AttributeDef = nazsis.fStudent2.Person.Gender Value = T Invalid table domain value.
I added to the gender Picklist the internal value of T. I then searched for students with the T gender. There were 2 people in the system with this gender. I changed their gender to a valid value and then removed gender T from the picklist. Picklist's are meant to be permanent values in the system. Once a value is added and used it should never be removed unless it is absolutely certain that there are no records in the system using that value.
Its also possible that the value was part of your import data and these types of error will show up as you work on the data. So please continue to let us know if you receive any more errors like these.
Campus ID's: 370002042, 370002039
Dana
*GNECsis Support Specialist*
Hi Dana - Apologies for the delay in responding - Thank you for having a look at that, and for fixing the error. I hope it wasn't an inconvenience.
Paul :)
Paul Barrett
LKC Registry Office