Report Error 500 Error Message: No initiatives found.

[Erik Mallory]

Hello,

I recently upgraded our base OS to RHEL 8 with PHP 7.4

Our librarians are experiencing this error when attempting to build a report 

for Time Series, Raw, Calendar Heat Map, Days of the week seems to just spin and Sessions works as expected.

Any advice would be greatly appreciated

MariaDB 10.4 InnoDB engine

Installed PHP

php-common-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-pdo-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-json-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-cli-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-mbstring-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-gd-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-mysqlnd-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-xml-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-xmlrpc-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

php-fpm-7.4.6-4.module+el8.3.0+7002+2eb69d76.x86_64

SE Linux is on but set to when permissive there is no change in behavior

Thanks,

Erik Mallory

Server Analyst 

Wichita State University

[Holland, Andrew S]

If you hit F12 in your browser while trying to run a report, what do the error messages tell you?

 

Are you able to view your server logs for php errors?

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/cdd2bf6f-d065-4e09-80d7-c3eaaaea28c4n%40googlegroups.com.

 

[Erik Mallory]

Failed to load resource: the server responded with a status of 500 (Internal Server Error)

VM242:1 GET https://suma.wichita.edu/suma/analysis/reports/lib/php/dataResults.php?clas…tGrps=&requireActs=&sdate=2021-05-09&startHour=0000&stime=&wholeSession=no 500 (Internal Server Error)

VM242:1 GET https://suma.wichita.edu/suma/analysis/reports/lib/php/dataResults.php?clas…tGrps=&requireActs=&sdate=2021-05-09&startHour=0000&stime=&wholeSession=no 500 (Internal Server Error)





​I have full access to the apache logs and php-fpm there are no apache 500 errors that I can see it's as if the application is misbehaving but not reporting it.

[Holland, Andrew S]

Hmmm. 500 errors could be heaps of things. Firewall rules, file ownership, server timeouts…

 

I don’t know that you necessarily need to look for 500 errors though in your apache log files. It could be a php error that’s causing dataResults.php to shut down and return a file not found. Something like that seems more likely given that you said sessions was working.

 

Are you tracking errors with Suma settings as well? It’s been a while since I set this up, but I believe there are log file settings in your configs. Do they tell you anything?

To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/efa58b8f-011b-4171-82e2-c922c6aa41aan%40googlegroups.com.

 

[erik.m...@gmail.com]

I appreciate you getting back to me. I got pulled onto other things and
I am now poking at this issue again.
I upgraded suma to the latest version. I enabled debug in both suma and
php. The error persists and does not log anything.

Error Code: 500

Error Message: No initiatives found. Please create an initiative in the
Suma admin tools.

I think this may be related to the configuration of initiatives. Suma
seems to think no initiatives are found.

> https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/efa58b8f-011b-4171-82e2-c922c6aa41aan%40googlegroups.com
> .

>
> --
> You received this message because you are subscribed to the Google
> Groups "Suma: mobile library assessment toolkit" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to
> suma-mobile-library-asses...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/CH2PR04MB7000BBC7B1C26FD7E9519EDD8FD59%40CH2PR04MB7000.namprd04.prod.outlook.com
> .

[erik.m...@gmail.com]

Update:
It was this

https://github.com/suma-project/Suma/issues/143

On Thu, 2021-09-09 at 18:47 +0000, Holland, Andrew S wrote:

> https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/efa58b8f-011b-4171-82e2-c922c6aa41aan%40googlegroups.com
> .

>
> --
> You received this message because you are subscribed to the Google
> Groups "Suma: mobile library assessment toolkit" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to
> suma-mobile-library-asses...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/CH2PR04MB7000BBC7B1C26FD7E9519EDD8FD59%40CH2PR04MB7000.namprd04.prod.outlook.com
> .

[Lynda Howell]

What file did you need to edit?  

https://github.com/suma-project/Suma/issues/143 doesn't give a filename, and grep isn't finding me any files with references to $activity on lines numbered in that range.  

I've been fighting this error with all reports on a clean install (RHEL 7.9, PHP 7.4), and my sys admins say they're stumped and aren't seeing any additional logs that could be related.  

Thanks!

Lynda.

[Mark Swenson]

The file modified was:

 

<Suma Install Directory>/service/transformers/LcaTransformer.php

 

That said, I just upgraded to the newer version of Suma a little over a week ago and am not using the modified version of this file in that version and everything seems to be ok.

 

Mark Swenson

IT Manager

Winnetka-Northfield Public Library District

To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/85a70c68-fa23-4d67-b624-5e64cb7af961n%40googlegroups.com.

[Keith Hargraves]

I've been fighting this issue across multiple clean RHEL installs.  It seems to work until I write to the database and then is suddenly says no initiatives found.  We are all stumped as well.

[Jason Casden]

Hi Keith,

I was recently working on a similar issue. Here is what fixed it in that case: go and check `service/web/config/config.yaml` and see if SUMA_DEBUG is set to false. There are some deprecation notices being printed out during debugging that caused some of the reports to fail. I'm not sure if this will help you, but it may be worth a try.

Thanks,

Jason

To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/2ba5d1e3-31c3-4588-9535-49b338bb6374n%40googlegroups.com.

[erik.m...@gmail.com]

Looks like I never closed the loop on this.
In my case the problem was solved by adusting the code:

LcaTransformer.php line 110
if ($activity == $row['act']) is what is there currently. I can't
remember what the line was before.
if memory serves, it was a code syntax issue when we upgrade php to 7.4
I hope this helps.
--
Erik Mallory
--
"A happy man's paradise is his own good nature."
Edward Abbey

[Jason Casden]

Great catch, Erik! We had seen some notices about this but hadn't figured out the problem. I just submitted a PR based on your discovery in case you'd like to test it.

https://github.com/suma-project/Suma/pull/156

Thanks,

Jason

To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/cab907830fdfb70b25dc5e25b2e9fd3b39453d1d.camel%40gmail.com.