search

opendcim / openDCIM

An open source (GPL v3) Data Center Inventory Management (DCIM) application.
http://opendcim.org
305 stars 204 forks source link

"Data Center Asset Report [Excel]" is not working #1483

Closed cpbonamico closed 9 months ago

cpbonamico commented 9 months ago

I have installed 23.04 fresh and loaded mysql.sql into the mariadb instance and all is working fine except the above report. I have installed all of the modules as defined in your install instructions including php-xml, and running on Rocky 8.9, php 8.0.3 mariadb 10.3.39 and getting this error from php-fpm

[04-Dec-2023 15:37:28 America/Denver] PHP Deprecated: usort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /opt/openDCIM/openDCIM-23.04/report_asset_Excel.php on line 1276 [04-Dec-2023 15:37:45 America/Denver] PHP Fatal error: Allowed memory size of 880803840 bytes exhausted (tried to allocate 4096 bytes) in /opt/openDCIM/openDCIM-23.04/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/StringHelper.php on line 495

Any help is greatly appreciated.

Chris B.

samilliken commented 9 months ago

The Fatal error is your clear message. Your memory limit set for PHP is too low.

Scott

From: cpbonamico @.> Sent: Monday, December 4, 2023 6:20 PM To: opendcim/openDCIM @.> Cc: Subscribed @.***> Subject: [opendcim/openDCIM] "Data Center Asset Report [Excel]" is not working (Issue #1483)

I have installed 23.04 fresh and loaded mysql.sql into the mariadb instance and all is working fine except the above report. I have installed all of the modules as defined in your install instructions including php-xml, and running on Rocky 8.9, php 8.0.3 mariadb 10.3.39 and getting this error from php-fpm

[04-Dec-2023 15:37:28 America/Denver] PHP Deprecated: usort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /opt/openDCIM/openDCIM-23.04/report_asset_Excel.php on line 1276 [04-Dec-2023 15:37:45 America/Denver] PHP Fatal error: Allowed memory size of 880803840 bytes exhausted (tried to allocate 4096 bytes) in /opt/openDCIM/openDCIM-23.04/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/StringHelper.php on line 495

Any help is greatly appreciated.

Chris B.

— Reply to this email directly, view it on GitHub https://github.com/opendcim/openDCIM/issues/1483 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AAMTY66K5NS5BHPEABUQSBLYHZLBHAVCNFSM6AAAAABAGYQFXSVHI2DSMVQWIX3LMV43ASLTON2WKOZSGAZDIOJXGAYTKMI . You are receiving this because you are subscribed to this thread. https://github.com/notifications/beacon/AAMTY63HIS63NQQOSOCXVTTYHZLBHA5CNFSM6AAAAABAGYQFXSWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHHRMUXU4.gif Message ID: @. @.> >

wilpig commented 9 months ago

I have just finished installing a clean build on rocky 8 following https://github.com/opendcim/openDCIM/wiki/RHEL#rhel-8-installation-instructions and can confirm that it works perfectly. I was also able to create your error when I tried to pull an asset report before creating a datacenter and cabinet in it.

cpbonamico commented 5 months ago

solved this by doing what Scott and the www-error.log was telling. Increase the php memory.... I tried increasing the PHP memory limit by editing the php.ini file. This did absolutely nothing to help my issue. Monitoring using TOP show no addition increase in memory usage. I then increased the amount of memory allocated in the report_asset_Excel.php file at line 151 to 4096M and it works great and is reflected in TOP.