Student Roster 404 Error

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

So that last query you sent doesn’t return any records so I assume it must be a data entry issue. I’ll work on entering more data and see if that fixes the problem.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

Hmm, below is the query for student roster. Run the following code through the SQL Interface and tell me if it returns a result. I am assuming the courseSecID is “1” based on your previous post:

SELECT a.stuID, 
       a.courseSecCode, 
       a.termCode, 
       a.courseCredits, 
       CASE a.status 
         WHEN 'A' THEN 'Add' 
         WHEN 'N' THEN 'New' 
         ELSE 'Drop' 
       end AS 'Status', 
       b.acadProgCode, 
       b.acadLevelCode, 
       c.courseSection, 
       c.facID, 
       c.roomCode, 
       c.secShortTitle, 
       c.startDate, 
       c.endDate, 
       c.startTime, 
       c.endTime, 
       c.dotw, 
       c.instructorMethod 
FROM   stu_course_sec a 
       LEFT JOIN stu_acad_level b 
              ON a.stuID = b.stuID
       LEFT JOIN course_sec c 
              ON a.courseSecID = c.courseSecID
WHERE  c.courseSecID = '1' 
       AND c.termCode = a.termCode 
       AND a.status IN( 'A', 'N', 'D' ) 
       AND b.addDate = (SELECT Max(addDate) 
                        FROM   stu_program 
                        WHERE  stuID = a.stuID) 
GROUP  BY a.stuID, 
          a.courseSecCode, 
          a.termCode

 

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

I was using safari, but after using Chrome I received the same error. Is there anything in the code I could look at or start investigating to get more information on the issue?

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

Are you using Safari by chance? What happens when you use a different browser?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

I ran those queries and there is a row with the student’s information in both tables.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

If you go to SRPO screen (Screens > Person Management > Student > SPRO) and do a lookup for the student in question, is the record active or inactive? Using the SQL Interface (Screens > SQL > SQL Interface), run the following queries one at a time to make sure it returns data:

SELECT * FROM stu_course_sec;
SELECT * FROM stu_acad_cred;

 

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

That’s the weird thing. There are no logs for that error but there are for other errors. I tail the Log file when I try to generate the script and it doesn’t spit anything out, unlike other errors that I have found.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

What is in the error logs (/app/tmp/logs/*.txt)?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

Yes. There’s only one class and I’ve added that student to the class.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

Are there students in the course section you are trying to print out a roster for?

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Marc TanisMemberTopics: 1Replies: 5Total Posts: 6]

I was able to successfully register  a student and was trying to then print off a roster for that class. However, I hit a snag as when I fill out the Fields for running the student roster report and click submit I get taken to a 404 page (/sect/sros/1/default/). Do you have any suggestions on things to try?

You need to login in order to like this post: click here