I am getting this error/exception java.lang.reflect.InvocationTargetException on cfspreadsheet

[joseph.yan]

Hi,

I am getting the error/exception java.lang.reflect.InvocationTargetException when I tried to do cfspreadsheet action="write".

I am using Coldfusion 2021 version 2021.0.06.330132.

JVM Oracle version 11.0.18.

Operating System is Red Hat Enterprise Linux release 8.5.

Please help.

Thank You

[Dave Watts]

I have no idea what would cause that, because I haven't used the CFSPREADSHEET tag in years. If I had to guess, I'd say it's a permissions issue. But you might be able to find out yourself by opening a shell, sudoing as the CF user, and trying to write a file in the same place as the spreadsheet will go. Also, are you running SELinux? That's fairly common in Red Hat.

Dave Watts, Eidolon LLC

[joseph.yan]

SELinux is disabled and wrote to temp folder and there is no any permission issue to write into it. Thanks.

[Dave Watts]

I got nothin.

Dave Watts, Eidolon LLC

[joseph.yan · Accepted solution]

I found the solutions from this https://github.com/Leftbower/cfspreadsheet-lucee-5/issues/27

Steps:

* sudo su

* yum install fontconfig

* yum install https://download-ib01.fedoraproject.org/pub/epel/7/x86_64/Packages/c/cabextract-1.9-7.el7.x86_64.rpm

* yum install https://downloads.sourceforge.net/project/mscorefonts2/rpms/msttcore-fonts-installer-2.6-1.noarch.rp...

* fc-cache -fv

* ./coldfusion restart