Forum topic

Folks,

Currently if we try to save any Custom Queries that we have created, it generates an error message. This was the one for Student > Enrollment -

--

*** Error on action - AC_BU_SaveEnrQuery ***
java.lang.ClassCastException: java.lang.String cannot be cast to com.quinsoft.zeidon.Blob EI = nazsis.zqSQuery.StoredQuery Keys: ID=4; SQL => INSERT INTO STOREDQUERY ( ID, TYPE, NAME, OBJECTNAME, FUNCTIONALAREA, PRIVATEFLAG, REPORTBLOBEXISTSFLAG, REPORTTITLE, YEARLYMODIFICATIONFLAGDATE, CREATEDDATETIME, MODIFIEDDATETIME, FK_ID_ADMINISTRATIVEDIVISION, FK_ID_STOREDQUERY, FK_ID_STOREDQUERYCATEGORY, FK_ID_Z_USER, REPORTBLOB, ATTRIBUTEBLOB, QUERYBLOB, DESCRIPTION ) VALUES (4, null, 'Test', null, null, 'Y', null, null, null, '2019-09-06 09:43:22.578', '2019-09-06 09:43:22.578', 1, null, 2, 7129, null, ? , ? , 'Test' ); Value 1 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@28632e53 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 2 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@2392c97a [com.quinsoft.zeidon.dbhandler.BoundAttributeData] EntityDef : nazsis.zqSQuery.StoredQuery Col index: 1 Value z01001Zeidon mAdhocAttrib mAdhocAttrib 2019/09/06 09:43:22 mOIFLAGS 0 eQueryAttributes 1,0 aID 100 aAttributeType string aAttributeOrder 1 aDescription Course Number aEntity Course aAttributename Number aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 101 aAttributeType string aAttributeOrder 2 aDescription Course Title aEntity Course aAttributename Title aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 102 aAttributeType string aAttributeOrder 3 aDescription Course Status aEntity Course aAttributename Status aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 103 aAttributeType string aAttributeOrder 4 aDescription Course Department aEntity Course aAttributename dDepartmentName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 104 aAttributeType string aAttributeOrder 5 aDescription Course College aEntity Course aAttributename dCollegeName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 105 aAttributeType string aAttributeOrder 100 aDescription Class Term aEntity Class aAttributename dClassTerm aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 106 aAttributeType string aAttributeOrder 101 aDescription Class Section aEntity Class aAttributename Section aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 107 aAttributeType string aAttributeOrder 102 aDescription Class Credit Hours aEntity Class aAttributename CreditHours aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 108 aAttributeType date aAttributeOrder 103 aDescription Class Start Date aEntity Class aAttributename ClassStartDate aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 109 aAttributeType date aAttributeOrder 104 aDescription Class End Date aEntity Class aAttributename ClassEndDate aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 111 aAttributeType string aAttributeOrder 106 aDescription Class Status aEntity Class aAttributename Status aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 112 aAttributeType string aAttributeOrder 107 aDescription Class Delivery Method aEntity Class aAttributename ClassDeliveryMethod aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 113 aAttributeType string aAttributeOrder 108 aDescription Class Enrollment Limit aEntity Class aAttributename EnrollmentLimit aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 114 aAttributeType date aAttributeOrder 109 aDescription Class Cancelled Date aEntity Class aAttributename CancelledDate aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 115 aAttributeType string aAttributeOrder 110 aDescription Class Grades Verified aEntity Class aAttributename GradesVerifiedFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 116 aAttributeType string aAttributeOrder 111 aDescription Class Total Enrolled aEntity Class aAttributename dTotalEnrolled aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 117 aAttributeType string aAttributeOrder 112 aDescription Class Total Waitlisted aEntity Class aAttributename dTotalWaitlisted aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 118 aAttributeType string aAttributeOrder 113 aDescription Class Meeting Schedule aEntity Class aAttributename dMeetingSchedule aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 110 aAttributeType string aAttributeOrder 150 aDescription Class Campus Location aEntity CampusLocation aAttributename Name aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 119 aAttributeType string aAttributeOrder 200 aDescription Lead Instructor Name aEntity LeadInstructor aAttributename dFullName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 121 aAttributeType string aAttributeOrder 202 aDescription Lead Instructor Status aEntity LeadInstructor aAttributename Status aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 120 aAttributeType string aAttributeOrder 250 aDescription Lead Instructor Campus Location aEntity LeadInstructorCampusLocation aAttributename Name aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 122 aAttributeType string aAttributeOrder 300 aDescription Student Given Name aEntity EnrolledStudentPerson aAttributename FirstName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 123 aAttributeType string aAttributeOrder 301 aDescription Student Middle Name aEntity EnrolledStudentPerson aAttributename MiddleName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 124 aAttributeType string aAttributeOrder 302 aDescription Student Family Name aEntity EnrolledStudentPerson aAttributename LastName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 125 aAttributeType string aAttributeOrder 303 aDescription Student Preferred Email aEntity EnrolledStudentPerson aAttributename PreferredEmail aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 126 aAttributeType string aAttributeOrder 304 aDescription Student School Email aEntity EnrolledStudentPerson aAttributename SchoolEmail aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 127 aAttributeType string aAttributeOrder 305 aDescription Student Portal User Name aEntity EnrolledStudentPerson aAttributename UserName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 128 aAttributeType string aAttributeOrder 306 aDescription Student Campus ID aEntity EnrolledStudentPerson aAttributename CampusID aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 129 aAttributeType string aAttributeOrder 307 aDescription Student Home Phone aEntity EnrolledStudentPerson aAttributename HomePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 130 aAttributeType string aAttributeOrder 308 aDescription Student Mobile Phone aEntity EnrolledStudentPerson aAttributename MobilePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 396 aAttributeType string aAttributeOrder 309 aDescription Gender aEntity EnrolledStudentPerson aAttributename Gender aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 397 aAttributeType string aAttributeOrder 310 aDescription MaritalStatus aEntity EnrolledStudentPerson aAttributename MaritalStatus aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 401 aAttributeType string aAttributeOrder 311 aDescription Photo Release aEntity EnrolledStudentPerson aAttributename PhotoRelease aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 428 aAttributeType string aAttributeOrder 313 aDescription Personal Email aEntity EnrolledStudentPerson aAttributename eMailAddress aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 131 aAttributeType string aAttributeOrder 400 aDescription Student Status aEntity EnrolledStudent aAttributename Status aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 132 aAttributeType string aAttributeOrder 401 aDescription Student Current Level aEntity EnrolledStudent aAttributename CurrentLevel aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 133 aAttributeType string aAttributeOrder 402 aDescription Student Life Hold aEntity EnrolledStudent aAttributename StudentLifeHoldFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 134 aAttributeType string aAttributeOrder 403 aDescription Student Life Cleared Date aEntity EnrolledStudent aAttributename StudentLifeClearedDate aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 135 aAttributeType string aAttributeOrder 404 aDescription Student Financial Hold aEntity EnrolledStudent aAttributename FinancialHoldFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 136 aAttributeType string aAttributeOrder 405 aDescription Student Residency Status aEntity EnrolledStudent aAttributename ResidencyStatus aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 137 aAttributeType string aAttributeOrder 500 aDescription Student Enrollment Status aEntity Enrollment aAttributename Status aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 138 aAttributeType string aAttributeOrder 501 aDescription Taking Class Type aEntity Enrollment aAttributename TakingClassType aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 139 aAttributeType date aAttributeOrder 502 aDescription Dropped Date aEntity Enrollment aAttributename DroppedDate aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 140 aAttributeType string aAttributeOrder 503 aDescription Credit Hours Taken aEntity Enrollment aAttributename CreditHours aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 141 aAttributeType string aAttributeOrder 504 aDescription Grading Scale aEntity Enrollment aAttributename dGradeScale aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 142 aAttributeType string aAttributeOrder 505 aDescription Final Grade aEntity Enrollment aAttributename FinalGrade aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 143 aAttributeType string aAttributeOrder 506 aDescription Final Grade Percent aEntity Enrollment aAttributename FinalGradePct aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 144 aAttributeType string aAttributeOrder 507 aDescription Final Grade Point aEntity Enrollment aAttributename FinalGradePoint aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 145 aAttributeType string aAttributeOrder 508 aDescription Midterm Grade aEntity Enrollment aAttributename MidtermGrade aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 146 aAttributeType string aAttributeOrder 509 aDescription Midterm Grade Percent aEntity Enrollment aAttributename MidtermGradePct aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 147 aAttributeType string aAttributeOrder 510 aDescription Midterm Grade Point aEntity Enrollment aAttributename MidtermGradePoint aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 148 aAttributeType string aAttributeOrder 511 aDescription Faculty Entered Final Grade aEntity Enrollment aAttributename FacultyEnteredFinalGrade aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 149 aAttributeType string aAttributeOrder 512 aDescription Faculty Entered Final Grade Percent aEntity Enrollment aAttributename FacultyEnteredFinalGradePct aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 150 aAttributeType string aAttributeOrder 513 aDescription Faculty Entered Final Grade Point aEntity Enrollment aAttributename FacultyEnteredFinalGradePoint aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 151 aAttributeType string aAttributeOrder 514 aDescription Faculty Grade Entry Note aEntity Enrollment aAttributename FacultyGradeEntryNote aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 152 aAttributeType string aAttributeOrder 515 aDescription Faculty Entered Midterm Grade aEntity Enrollment aAttributename FacultyEnteredMidtermGrade aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 153 aAttributeType string aAttributeOrder 516 aDescription Faculty Entered Midterm Grade Percent aEntity Enrollment aAttributename FacultyEnteredMidtermGradePct aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 154 aAttributeType string aAttributeOrder 517 aDescription Faculty Entered Midterm Grade Point aEntity Enrollment aAttributename FacultyEnteredMidtermGradePoint aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 155 aAttributeType string aAttributeOrder 518 aDescription Faculty Entered Midterm Grade Note aEntity Enrollment aAttributename FacultyMidtermGradeNote aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 156 aAttributeType string aAttributeOrder 519 aDescription Supplementary Grade aEntity Enrollment aAttributename SupplementaryGrade aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 157 aAttributeType string aAttributeOrder 520 aDescription Supplementary Grade Percent aEntity Enrollment aAttributename SupplementaryGradePct aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 158 aAttributeType string aAttributeOrder 521 aDescription Supplementary Grade Point aEntity Enrollment aAttributename SupplementaryGradePoint aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 159 aAttributeType string aAttributeOrder 522 aDescription Grad/Undergrade Override Flag aEntity Enrollment aAttributename GradUndergradOverrideFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 160 aAttributeType string aAttributeOrder 523 aDescription Prerequisites not met aEntity Enrollment aAttributename PrereqsNotMet aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 161 aAttributeType string aAttributeOrder 524 aDescription No Show aEntity Enrollment aAttributename NoShowFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 162 aAttributeType string aAttributeOrder 525 aDescription No Show Number Absences aEntity Enrollment aAttributename NoShowNumberAbsences aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 163 aAttributeType string aAttributeOrder 526 aDescription No Show Comment aEntity Enrollment aAttributename NoShowComment aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 164 aAttributeType string aAttributeOrder 527 aDescription Reserved Seat aEntity Enrollment aAttributename ReservedSeatFlag aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 165 aAttributeType string aAttributeOrder 528 aDescription Original Status aEntity Enrollment aAttributename wOriginalStatus aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 166 aAttributeType string aAttributeOrder 529 aDescription Enrollment Note aEntity Enrollment aAttributename EnrollmentNote aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 395 aAttributeType string aAttributeOrder 601 aDescription IPEDS Ethnicity aEntity Demographics aAttributename IPEDS_Ethnicity aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 402 aAttributeType string aAttributeOrder 701 aDescription Name aEntity DirectoryRestrictions aAttributename DisplayName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 403 aAttributeType string aAttributeOrder 702 aDescription Home Phone aEntity DirectoryRestrictions aAttributename DisplayHomePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 404 aAttributeType string aAttributeOrder 703 aDescription Mobile Phone aEntity DirectoryRestrictions aAttributename DisplayMobilePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 405 aAttributeType string aAttributeOrder 704 aDescription Email aEntity DirectoryRestrictions aAttributename DisplayHomeEmailAddress aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 406 aAttributeType string aAttributeOrder 705 aDescription Address aEntity DirectoryRestrictions aAttributename DisplayHomeAddress aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 407 aAttributeType string aAttributeOrder 706 aDescription Profile Picture aEntity DirectoryRestrictions aAttributename DisplayPicture aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 408 aAttributeType string aAttributeOrder 707 aDescription Roster Name aEntity DirectoryRestrictions aAttributename ClassName aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 409 aAttributeType string aAttributeOrder 708 aDescription Roster Home Phone aEntity DirectoryRestrictions aAttributename ClassHomePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 410 aAttributeType string aAttributeOrder 709 aDescription Roster Mobile Phone aEntity DirectoryRestrictions aAttributename ClassMobilePhone aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 411 aAttributeType string aAttributeOrder 710 aDescription Roster Email aEntity DirectoryRestrictions aAttributename ClassHomeEmailAddress aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 412 aAttributeType string aAttributeOrder 711 aDescription Roster Address aEntity DirectoryRestrictions aAttributename ClassHomeAddress aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery eQueryAttributes 1,0 aID 413 aAttributeType string aAttributeOrder 712 aDescription Roster Profile Picture aEntity DirectoryRestrictions aAttributename ClassPicture aSelected,2 Y aFK_ID_STOREDQUERYCATEGORY 2 eStoredQueryCategory 2,0 aID 2 aName EnrollmentQuery ZEND Class: java.lang.String
com.quinsoft.zeidon.dbhandler.StandardJdbcTranslator.bindAttributeValue(StandardJdbcTranslator.java:295)
com.quinsoft.zeidon.dbhandler.JdbcHandler.prepareAndBind(JdbcHandler.java:775)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeStatement(JdbcHandler.java:825)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.executeStatement(AbstractSqlHandler.java:1674)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.insertEntity(AbstractSqlHandler.java:228)
com.quinsoft.zeidon.standardoe.CommitToDbUsingGenkeyHandler.commitCreates(CommitToDbUsingGenkeyHandler.java:293)
com.quinsoft.zeidon.standardoe.AbstractCommitToDb.commitView(AbstractCommitToDb.java:81)
com.quinsoft.zeidon.standardoe.CommitToDbUsingGenkeyHandler.commit(CommitToDbUsingGenkeyHandler.java:115)
com.quinsoft.zeidon.standardoe.CommitMultipleOIs.commit(CommitMultipleOIs.java:512)
com.quinsoft.zeidon.standardoe.TaskImpl.commitMultipleOis(TaskImpl.java:318)
com.quinsoft.zeidon.standardoe.TaskImpl.commitMultipleOis(TaskImpl.java:299)
com.quinsoft.zeidon.standardoe.ViewImpl.commit(ViewImpl.java:387)
com.quinsoft.zeidon.vml.zVIEW.commit(zVIEW.java:116)
com.quinsoft.zeidon.vml.VmlOperation.CommitObjectInstance(VmlOperation.java:5244)
org.nazarene.nazsis.nAdhocQu_Dialog.OP_SaveEnrQuery(nAdhocQu_Dialog.java:3328)
org.apache.jsp.nAdhocQuSaveEQuery_jsp._jspService(nAdhocQuSaveEQuery_jsp.java:387)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)

--

This was the error for Prospect Query:

--

*** Error on action - AC_GOTOACADMin ***
com.quinsoft.zeidon.ZeidonException: Entity may not be udpated. AttributeDef = nazsis.fGenPro.Person.LastName
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.validateUpdateAttribute(AttributeInstanceImpl.java:256)
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.validateUpdateAttribute(AttributeInstanceImpl.java:218)
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.setValue(AttributeInstanceImpl.java:311)
org.apache.jsp.nAdhocQuProsQuery_jsp.DoInputMapping(nAdhocQuProsQuery_jsp.java:95)
org.apache.jsp.nAdhocQuProsQuery_jsp._jspService(nAdhocQuProsQuery_jsp.java:1677)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)

--

Thanks!

Rob