mwoods1971
Explorer
mwoods1971
Explorer
Activity
‎Apr 03, 2024
01:26 PM
1 Upvote
Update: I was able to figure it out and hopefully this will help someone. For Apache POI 4.01 ColdFusion 2021 this is how you set underlines for a cell. The commented and italicized code is the old way of doing this and the uncommented code above is the new way we need to call it with CF. <cfset cellStyleCurrencyBottomTopBorderTan = wb.createCellStyle()/> <cfset cellStyleCurrencyBottomTopBorderTan.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("($##,####0.00_);[Red]($##,####0.00)"))/> <cfset cellStyleCurrencyBottomTopBorderTan.setBorderBottom(createObject("java", "org.apache.poi.ss.usermodel.BorderStyle").THICK)> <!--- <cfset cellStyleCurrencyBottomTopBorderTan.setBorderBottom(cellStyleCurrencyBottomTopBorderTan.BORDER_DOUBLE)/> ** ---> <cfset cellStyleCurrencyBottomTopBorderTan.setBorderTop(createObject("java", "org.apache.poi.ss.usermodel.BorderStyle").THIN)> <!--- <cfset cellStyleCurrencyBottomTopBorderTan.setBorderTop(cellStyleCurrencyBottomTopBorderTan.BORDER_THIN)/> ** --->
... View more
‎Apr 03, 2024
08:39 AM
Ok sorry again for coming back so late (1 year, yeah I know) To catch up: I was able to get the till of the cell done: <cfset cellStyleBGYellow = wb.createCellStyle()/> <cfset cellStyleBGYellow.setFillForegroundColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$LIGHT_YELLOW").getIndex())/> <cfset FillPatternType = createObject("java","org.apache.poi.ss.usermodel.FillPatternType")/> <cfset cellStyleBGYellow.setFillPattern(FillPatternType.SOLID_FOREGROUND)/> <!--- <cfset cellStyleBGYellow.setFillPattern(cellStyleBGYellow.SOLID_FOREGROUND)/> ** ---> The commented line is the way it was, and the lin above is the working change. This fills the cell with yellow. There are a lot of these in the output from yello to greeen etc. I have all of these working. What is not working is appling an undeline to a cell. Here is the original line of code. <cfset cellStyleCurrencyBottomBorderDoubleGreen.setBorderBottom(cellStyleCurrencyBottomBorderDoubleGreen.BORDER_DOUBLE)/> This would apply a border at the bottom of the cell. There is an error when doing this as things have changed in this version of apache POI. I did raise a question on stack overflow on how to do this which was answered however I'm not sure how to implement it as what I tried didn't work. The answer: The border type is now in an own Enum instead of being a member of CellStyle. See https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom-org.apache.poi.ss.usermodel.BorderStyle- https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/BorderStyle.html Here is what I tried: <cfset cellStyleCurrencyBottomBorder.setBorderBottom(BorderStyle.THIN) /> which didn't work This is the last step to "fix"this since moving to 2021 and I know I have to be close. If anyone has an suggestions, its def apprciated. Thanks
... View more
‎Apr 03, 2024
08:29 AM
@James Moberg Thanks for the suggestion on the the gihub. I will defantly be looking at this in the fututre however the client doesn't want to pay to refactor the code to a newer (better) platform. They kinda want this fixed to have it "working the way it used to" I was able to figure out the backround fill issue but still hung up on adding an underline to the cell @Dave Watts Sorry this is late but here is the dump object of org.apache.poi.hssf.usermodel.HSSFCellStyle Class Name org.apache.poi.hssf.usermodel.HSSFCellStyle Methods Method Return Type cloneStyleFrom(org.apache.poi.hssf.usermodel.HSSFCellStyle) void cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle) void equals(java.lang.Object) boolean getAlignment() short getAlignmentEnum() org.apache.poi.ss.usermodel.HorizontalAlignment getBorderBottom() short getBorderBottomEnum() org.apache.poi.ss.usermodel.BorderStyle getBorderLeft() short getBorderLeftEnum() org.apache.poi.ss.usermodel.BorderStyle getBorderRight() short getBorderRightEnum() org.apache.poi.ss.usermodel.BorderStyle getBorderTop() short getBorderTopEnum() org.apache.poi.ss.usermodel.BorderStyle getBottomBorderColor() short getDataFormat() short getDataFormatString() java.lang.String getDataFormatString(org.apache.poi.hssf.model.InternalWorkbook) java.lang.String getDataFormatString(org.apache.poi.ss.usermodel.Workbook) java.lang.String getFillBackgroundColor() short getFillBackgroundColorColor() org.apache.poi.hssf.util.HSSFColor getFillForegroundColor() short getFillForegroundColorColor() org.apache.poi.hssf.util.HSSFColor getFillPattern() short getFillPatternEnum() org.apache.poi.ss.usermodel.FillPatternType getFont(org.apache.poi.ss.usermodel.Workbook) org.apache.poi.hssf.usermodel.HSSFFont getFontIndex() short getHidden() boolean getIndention() short getIndex() short getLeftBorderColor() short getLocked() boolean getParentStyle() org.apache.poi.hssf.usermodel.HSSFCellStyle getQuotePrefixed() boolean getReadingOrder() short getRightBorderColor() short getRotation() short getShrinkToFit() boolean getTopBorderColor() short getUserStyleName() java.lang.String getVerticalAlignment() short getVerticalAlignmentEnum() org.apache.poi.ss.usermodel.VerticalAlignment getWrapText() boolean hashCode() int setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment) void setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle) void setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle) void setBorderRight(org.apache.poi.ss.usermodel.BorderStyle) void setBorderTop(org.apache.poi.ss.usermodel.BorderStyle) void setBottomBorderColor(short) void setDataFormat(short) void setFillBackgroundColor(short) void setFillForegroundColor(short) void setFillPattern(org.apache.poi.ss.usermodel.FillPatternType) void setFont(org.apache.poi.ss.usermodel.Font) void setFont(org.apache.poi.hssf.usermodel.HSSFFont) void setHidden(boolean) void setIndention(short) void setLeftBorderColor(short) void setLocked(boolean) void setQuotePrefixed(boolean) void setReadingOrder(short) void setRightBorderColor(short) void setRotation(short) void setShrinkToFit(boolean) void setTopBorderColor(short) void setUserStyleName(java.lang.String) void setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment) void setWrapText(boolean) void verifyBelongsToWorkbook(org.apache.poi.hssf.usermodel.HSSFWorkbook) void
... View more
‎Aug 23, 2023
06:43 AM
Hi Charlie, To answer the questions: I did try a new browser I downloaded the results were the same. I also did restat CF after I made those changes. I have confirmed that the client is storing to a cookie. Here are the dumps. First in the app.cfc Next, this this is the dump with the <cfif> I mentioned above
... View more
‎Aug 22, 2023
08:17 PM
So, first Charlie thanks for chiming in. We have worked together before on some things so I appreciate the tips. I certainly didn't know about all of the comparison methods that one could use when looking at the settings. There was one setting that was different in the memory variables section. I did update that and the problem still does exist. So, lets move on to what was requested. Here is a dump of the cgi.http_cookie on the first line of app.cfc CFID=1202; CFTOKEN=be514c8fb1801904-410D1051-9BC7-6089-8F6F6A87C7BB77CD; JSESSIONID=C3428C80CE2C392E2F6CDC1395A8BD75.cfusion; CFCLIENT_PARKERBUSINESSPLANNING_2021=rolename%3DAdministrator%23dealer%5Fid%3D149%23role%5Fid%3D1%23user%5Fid%3D1%23fullname%3DDavid%20Parker%23; CFGLOBALS=urltoken%3DCFID%23%3D1202%26CFTOKEN%23%3Dbe514c8fb1801904%2D410D1051%2D9BC7%2D6089%2D8F6F6A87C7BB77CD%26jsessionid%23%3DC3428C80CE2C392E2F6CDC1395A8BD75%2Ecfusion%23lastvisit%3D%7Bts%20%272023%2D08%2D22%2021%3A58%3A08%27%7D%23hitcount%3D9%23timecreated%3D%7Bts%20%272023%2D08%2D22%2020%3A55%3A48%27%7D%23cftoken%3Dbe514c8fb1801904%2D410D1051%2D9BC7%2D6089%2D8F6F6A87C7BB77CD%23cfid%3D1202%23 and here is a dump of the cookie variable from the same place. App.cfc Dumpe of Cookie and cgi.http_cookie This is a dump from within a file that is trying to find the client variable to make a determination on if it should show something or not. Like last time, here is the txt of cgi.http_cookie: CFID=1202; CFTOKEN=be514c8fb1801904-410D1051-9BC7-6089-8F6F6A87C7BB77CD; JSESSIONID=C3428C80CE2C392E2F6CDC1395A8BD75.cfusion; CFCLIENT_PARKERBUSINESSPLANNING_2021=rolename%3DAdministrator%23dealer%5Fid%3D149%23role%5Fid%3D1%23user%5Fid%3D1%23fullname%3DDavid%20Parker%23; CFGLOBALS=urltoken%3DCFID%23%3D1202%26CFTOKEN%23%3Dbe514c8fb1801904%2D410D1051%2D9BC7%2D6089%2D8F6F6A87C7BB77CD%26jsessionid%23%3DC3428C80CE2C392E2F6CDC1395A8BD75%2Ecfusion%23lastvisit%3D%7Bts%20%272023%2D08%2D22%2021%3A58%3A08%27%7D%23hitcount%3D9%23timecreated%3D%7Bts%20%272023%2D08%2D22%2020%3A55%3A48%27%7D%23cftoken%3Dbe514c8fb1801904%2D410D1051%2D9BC7%2D6089%2D8F6F6A87C7BB77CD%23cfid%3D1202%23 And now the picture of http_cookie and the dump of cookie So dumping that cookie VAR out I can see the value that I am looking for. ITs role_id which its being compared. <cfif getDealersByTwentyGroup.recordCount gt 1 AND isdefined("client.role_id") AND client.role_id EQ 1> When this IF fails, nothing is sent to the screen since there is an AND there it doesn't see client.role_id but we do see its in the cookie scope. The question I have is why? Looking forward to what you can see from this.
... View more
‎Aug 22, 2023
07:50 AM
I am assisting in moving a site that was on CF11 to CF2021. There has been a lot to fix but I have had trouble on on instace in where there are client variables that are lost from one page to another. When a user logs in, client variables are set. However, when users click to go to a part of that websiet that uses Model Glue for this and only this folder, the client variables and session variables are cleared. Now, on CF 11, this worked no problem. The variables exist without issue. However, on CF2021, those variables are cleared. Now, yes, there is an Application.cfc within this folder and I suspect its the reason why this is cleared (there is no app.cfc in the folders before this again, old appliction not my code) The problem is, that there is code within this model glue folder that tries to refrence that now cleared (on CF2021) variable. I'm lookng for a good solution, is there a way to move that client information into this folder which is needed for some functionality?
... View more
‎Aug 21, 2023
10:34 AM
Thanks I am just checking this after a few weeks and I'll defiantly look at this.
... View more
‎Jun 13, 2023
06:04 AM
I am trying to move a site that was on CF11 to CF2021 and there is an issue with moving the POI portion which creates excel files to CF2021. The first thing I did look for is to find the version of POI on CF11 (which is 3.12) and the version of POI on CF2021 (Which is 3.17). The code that is giving me trouble revolves around coloring the foreground of cells. First the workbook is created: <cfset wb = createObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").init()/> <cfset fontRedUnderlineBold = wb.createFont()> <cfset fontRedUnderlineBold.setColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$RED").getIndex())> <cfset fontRedUnderlineBold.setUnderline(1)> <cfset fontRedUnderlineBold.setBold(true)> <cfset cellStyleCurrency = wb.createCellStyle()/> <cfset cellStyleCurrency.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("($##,####0.00_);[Red]($##,####0.00)"))/> <cfset cellStyleNumeric = wb.createCellStyle()/> <cfset cellStyleNumeric.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("##,####0.00"))/> <cfset cellStyleBGYellow = wb.createCellStyle()/> <cfset cellStyleBGYellow.setFillForegroundColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$LIGHT_YELLOW").getIndex())/> <cfset cellStyleBGYellow.setFillPattern(cellStyleBGYellow.SOLID_FOREGROUND)/> The code above works just fine until we get to the last line which used to set the foreground. When this is run this error appears: Element SOLID_FOREGROUND is undefined in CELLSTYLEBGYELLOW. So, this used to work in 3.12 but now doesn't in 3.17. I have been trying to search on what has changed but so far have come up empy. Has anyone else experienced this?
... View more
‎May 14, 2022
12:42 PM
So, that's probably becasue this instance was moved over from another machine. We upgraded from one OS to another. However, I'm more thank willing to try anything. I'll read the link. Thanks
... View more
‎May 13, 2022
08:32 PM
@Charlie Arehart @Dave Watts I was able to find the log for the update and there are two no-fatal errors. The log is attached but here are the two fails: Execute ANT Script: Script: unix_basic_commands.xml Status: ERROR Additional Notes: ERROR - unix_basic_commands.xml:222: Execute failed: java.io.IOException: Cannot run program "/tmp/184194.tmp/temp-init.sh" (in directory "/tmp/184194.tmp"): error=13, Permission denied ANT Script Error: Status: ERROR Additional Notes: ERROR - unix_basic_commands.xmlExecute failed: java.io.IOException: Cannot run program "/tmp/184194.tmp/temp-init.sh" (in directory "/tmp/458590.tmp"): error=13, Permission denied
... View more
‎May 13, 2022
04:55 PM
Hey Dave, Thanks, I just sent that off to cfsup@adobe.com with the detials listed here. Thanks for the suggestion!
... View more
‎May 13, 2022
04:29 PM
Server: Linux Codfusion 2018 Update 14 installed from the command line. The update said it completed succesfuly and when tryign to get to the admin page, I get an error that says: The Monitoring Service is not available. Please note: CF is service pages, but I just can't get to the admin. A dump of the server variable confirms that update 14 is installed. Logs: May 13, 2022 18:25:20 PM Information [main] - Starting logging... May 13, 2022 18:25:20 PM Information [main] - Starting license... May 13, 2022 18:25:20 PM Information [main] - Enterprise Edition enabled May 13, 2022 18:25:20 PM Information [main] - Starting crypto... May 13, 2022 18:25:20 PM Information [main] - Installed JSafe JCE provider: Version 6.21 Crypto-J 6.2.1, EMC Corporation. JsafeJCE Security Provider (implements RSA, DSA, ECDSA, Diffie-Hellman, ECDH, AES, DES, Triple DES, DESX, RC2, RC4, RC5, PBE, MD2, MD5, RIPEMD160, SHA1, SHA224, SHA256, SHA384, SHA512, HMAC-MD5, HMAC-RIPEMD160, HMAC-SHA1, HMAC-SHA224, HMAC-SHA256, HMAC-SHA384, HMAC-SHA512, HMACDRBG, HASHDRBG, CTRDRBG, FIPS186PRNG, SHA1PRNG, MD5PRNG; RFC 3394, RFC 5649 AES Key Wrap; X.509 CertificateFactory; PKCS12, PKCS15 KeyStore; X.509V1, PKIX, PKIX-SuiteB, PKIX-SuiteBTLS CertPathValidators; X.509V1, PKIX, PKIX-SuiteB, PKIX-SuiteBTLS CertPathBuilders; LDAP, Collection CertStores) May 13, 2022 18:25:20 PM Information [main] - Starting security... May 13, 2022 18:25:20 PM Information [main] - Starting scheduler... May 13, 2022 18:25:20 PM Information [main] - Starting WatchService... May 13, 2022 18:25:20 PM Information [main] - Starting debugging... May 13, 2022 18:25:20 PM Information [main] - Starting sql... May 13, 2022 18:25:21 PM Information [main] - Starting runtime... May 13, 2022 18:25:22 PM Information [main] - CORBA Configuration not enabled May 13, 2022 18:25:22 PM Information [main] - Starting mail... May 13, 2022 18:25:22 PM Information [main] - Starting cron... May 13, 2022 18:25:23 PM Information [main] - Created scheduler DefaultQuartzScheduler with thread pool size as 10 May 13, 2022 18:25:23 PM Information [main] - Starting registry... May 13, 2022 18:25:23 PM Information [main] - Starting client... May 13, 2022 18:25:23 PM Information [main] - Starting xmlrpc... May 13, 2022 18:25:23 PM Information [main] - Starting jaxrs... May 13, 2022 18:25:23 PM Information [main] - Starting graphing... May 13, 2022 18:25:23 PM Information [main] - Starting solr... May 13, 2022 18:25:23 PM Information [main] - Starting archive... May 13, 2022 18:25:23 PM Information [main] - Starting document... May 13, 2022 18:25:26 PM Information [main] - Starting eventgateway... May 13, 2022 18:25:26 PM Information [main] - Event Gateway Disabled. May 13, 2022 18:25:26 PM Information [main] - Starting FlexAssembler... May 13, 2022 18:25:26 PM Information [main] - Starting .NET... May 13, 2022 18:25:26 PM Information [main] - Starting Monitoring... May 13, 2022 18:25:27 PM Error [main] - Unable to initialise Monitoring service: java.lang.NoSuchMethodError: org.apache.log4j.helpers.OptionConverter.convertLevel(Ljava/lang/String;Lorg/apache/logging/log4j/Level;)Lorg/apache/logging/log4j/Level; May 13, 2022 18:25:27 PM Information [main] - Starting PDFG... May 13, 2022 18:25:27 PM Information [main] - Starting WebSocket... May 13, 2022 18:25:28 PM Information [main] - WebSocket server listens on port: 8581 May 13, 2022 18:25:28 PM Information [main] - ColdFusion started May 13, 2022 18:25:28 PM Information [main] - ColdFusion: application services are now available 05/13 18:25:28 INFO Macromedia Flex Build: 87315.134646 May 13, 2022 18:25:31 PM Error [Thread-15] - Registration error for service manager : .http://127.0.0.1:8991/PDFgServlet/.Reason: NOT FOUND May 13, 2022 18:26:28 PM Error [http-nio-8500-exec-1] - The Monitoring service is not available.This exception is usually caused by service startup failure. Check your server configuration. The specific sequence of files included or processed is: /data/coldfusion2018/cfusion/wwwroot/CFIDE/administrator/index.cfm, line: 114 May 13, 2022 18:27:55 PM Error [http-nio-8500-exec-4] - The Monitoring service is not available.This exception is usually caused by service startup failure. Check your server configuration. The specific sequence of files included or processed is: /data/coldfusion2018/cfusion/wwwroot/CFIDE/administrator/index.cfm, line: 114 May 13, 2022 18:36:23 PM Error [http-nio-8500-exec-6] - The Monitoring service is not available.This exception is usually caused by service startup failure. Check your server configuration. The specific sequence of files included or processed is: /data/coldfusion2018/cfusion/wwwroot/CFIDE/administrator/index.cfm, line: 114 May 13, 2022 18:55:22 PM Error [http-nio-8500-exec-8] - The Monitoring service is not available.This exception is usually caused by service startup failure. Check your server configuration. The specific sequence of files included or processed is: /data/coldfusion2018/cfusion/wwwroot/CFIDE/administrator/index.cfm, line: 114 May 13, 2022 19:03:56 PM Error [Thread-19] - The Monitoring service is not available. May 13, 2022 19:03:56 PM Information [Thread-19] - ColdFusion stopped I have tried restarting the service multiple times but still getting the same result.
... View more
‎Dec 10, 2018
06:49 AM
2 Upvotes
I found this on stack and hopefully it will help someone in the future: So to review, I have a RHEL6 server that I need to install CF10 on. To complicate the matter I am required to run this silently and to use Ansible for the installation. The install wasn't working so I started over in just getting it to install on the machine then to script it later. I found out that this machine had been locked down already and I could not install anything from the /tmp directory. This post showed an example script on how to change the tmp directory How do I tell ColdFusion 9.0.1 to use a directory besides /tmp? - Stack Overflow It says its for CF9 but I also got it to work with CF10. Here is the script from the post: cd /opt/coldfusion9/bin IATEMPDIR=/home/coldfusion export IATEMPDIR LAX_DEBUG=1 export LAX_DEBUG ./ColdFusion_update_901_WWEJ_linux64.bin Enjoy
... View more
‎Dec 06, 2018
10:44 AM
So after doing some more research, I have found that this machine does not like to have anything install from the /tmp directory. The first thing the installer does is extract the directory contents to /tmp.install.[random number] folder. This is where I get that error that I have a permission denied. So, I jumped down in the directories to make sure I (the user on Linux) had permissions and nothing was set weird. I did see that I could not as so much get the java -version to work. I then moved the entire directory to my home directory and did the same thing and java responded with a version number. So, if I could just set the installer to use a specific directory of my choosing, I think I would be a step closer. Thanks
... View more
‎Dec 04, 2018
07:36 AM
WolfShade​ Thanks for you answer. I suggested that but on this machine I don't think we ca obtain root access.
... View more
‎Dec 03, 2018
12:33 PM
I'm having a ton of trouble getting a new install up and running on RHEL6. Its ColdFusion 10 and when I try to install the package I get an error that says: ColdFusion_10_WWEJ_linux64.bin line 3309 /tmp/install.dir.21145/Linux/resource/jre/java: Permission Denied This dies right after the installer starts working. I have tired: sudo ./Install - Same results I have also changed permissions on the installer directory (can you restart a failed install from the directory?) SELinux is *NOT* enabled so I have skipped past this part. Anyone have any suggestions in getting this installed?
... View more
‎Apr 16, 2018
07:57 AM
Hi, I'm installing CF10 on CentOS 6. The install works just fine but when I start the CF server and try to browse the ADMIN page I get this error: HTTP Status 500 - java.lang.NullPointerException. I have tried: compiling a custom Apache connector, installing the mandatory CF10 updates, installing to the latest version of CF10. However, everything I have done, I still get the same error. In the ColdFusion out log there is this: Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Client Storage service: coldfusion.server.ServiceFactory$ServiceNotAvai$ Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting xmlrpc... Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting jaxrs... Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting graphing... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Graphing service: java.lang.ExceptionInInitializerError Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting solr... Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting archive... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Archive/Deploy service: java.lang.NoClassDefFoundError: Could not initi$ Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting document... Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting eventgateway... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Event service: coldfusion.server.ServiceException Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting FlexAssembler... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise FlexAssembler service: coldfusion.server.ServiceFactory$ServiceNotAvail$ Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting .NET... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise .NET service: coldfusion.server.ServiceFactory$ServiceNotAvailableExcep$ Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting Monitoring... Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Monitoring service: java.lang.NoClassDefFoundError: Could not initializ$ Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting WebSocket... Apr 16, 2018 10:50:36 AM Error [Thread-12] - The Runtime service is not available. Apr 16, 2018 10:50:36 AM Information [pool-2-thread-1] - WebSocket server listens on port: 8575 Apr 16, 2018 10:50:36 AM Warning [Thread-10] - Graphing service is unavailable Apr 16, 2018 10:50:36 AM Information [pool-2-thread-1] - ColdFusion started Apr 16, 2018 10:50:36 AM Information [pool-2-thread-1] - ColdFusion: application services are now available 04/16 10:50:36 INFO Macromedia Flex Build: 87315.134646 Full Stack of the Error in the Browser: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:662) root cause java.lang.NullPointerException coldfusion.CfmServlet.init(CfmServlet.java:82) coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:121) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:662) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.23
... View more
‎Jun 28, 2016
11:06 AM
Hi, I have been recently asked to look into updating the web connectors on our server at work. First, some stats: Server RHEL 5 ColdFusion 10 (64bit) Apache (not sure of the ver number) When I first did this install, I had to compile a custom connector to get it to work. However, there has always been one issue. In the rare times where I have had to stop CF from the command lines, I can't get CF to come back up and reconnect to the webserver. However, after a reboot everything works fine. I started researching the problem and I came across http://www.carehart.org/blog/client/index.cfm/2013/9/13/why_you_must_update_cf10_webserver_connector - Charlie's article about updating the connector. My first question is: Can someone from Adobe give me a little bit of information as to what happens when you create a connector? If I complied a connector when I first installed CF and compiled a connector *after* I have updated CF to the latest version are those connectors different? I'm asking as doing this could get a bit tricky and since the server is running fine now, I don't want to poke the bear unless absolutely necessary. Thanks!
... View more
‎May 25, 2016
05:58 AM
@WolfShade Thanks for the reply. One follow up. Are you talking about using SpreadsheetFormatCell or SpreadsheetFormatColumn? I have had some success with format column before but I still end up with data that the client still has issues with? Thanks for the reply.
... View more
‎May 24, 2016
08:55 AM
Hi, I have a request from a client to generate an excel spreadsheet from a query. I have the query kicking out the fields and I can generate the excel file without a hitch. The problem comes when the client takes that excel file and then tries to manipulate it. The majority of the trouble comes from fields that should be marked as currency or dates. I am, with some struggle able to generate a "real" date field. Before this Excel was not sorting the dates properly. I was able to call an excel formula by using this: <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##Replacement_ETD##Chr(34)#)",therow,9)> Date value forces Excel to acknowledge this as a real date field. However, this fails when this file is manipulated thru excel. The next problem is the currency field. I can't get excel to acknowledge this as a currency. It always comes up custom. When this is set, the SUM function won't work in excel. You can add the fields individually like A1+B1+C1 = TOTAL. This won't be helpful when there are 200 rows. I was able to get a suggestion from another CF programmer who had a similar situation. He generated the excel file first with the proper headings and set the columns to their proper fields such as date and currency etc. The next step would be to fill in the fields row by row and they should be properly formatted. Code: <cfset filename = expandPath("./reports/arrivals.xlsx")> <cfspreadsheet action="read" src = "#filename#" name = "s" > <cfset therow = 0> <cfoutput query="myExcel" startrow="1"> <cfset therow = myExcel.currentrow + 1> <cfset SpreadsheetSetCellValue(s, Incumbent, therow, 1)> <cfset SpreadsheetSetCellValue(s, Section, therow, 2)> <cfset SpreadsheetSetCellValue(s, Position_Number, therow, 3)> <cfset SpreadsheetSetCellValue(s, Position_Title, therow, 4)> <cfset SpreadsheetSetCellValue(s, Incumbent_Emplyment_Type, therow, 5)> <cfset SpreadsheetSetCellValue(s, Incumbent_ETD, therow, 6)> <cfset SpreadsheetSetCellValue(s, Tour_Comments, therow, 7)> <cfset SpreadsheetSetCellValue(s, Replacement, therow, 8)> <cfset SpreadsheetSetCellValue(s, Replacement_ETA, therow, 9)> </cfoutput> <cfheader name="content-disposition" value="attachment; filename=Departures_(#DateFormat(now(),'mmddyy')#).xls"> <cfcontent type="application/msexcel" variable="#spreadsheetReadBinary(s)#" reset="true"> The data in the cells has already been properly formatted. When this file is generated and streamed to the user the columns are not formatted as expected. Does anyone else know if this method will work or have a better suggestion on getting CF to generate a proper date and currency field for excel to acknowledge? Adobe ColdFusion v10 running on RHEL 5 Thanks
... View more
‎Mar 28, 2016
08:48 AM
Thanks for answering, Are you on Stackoverflow? I'd love to give you some street cred on there too!
... View more
‎Mar 28, 2016
08:25 AM
1 Upvote
I may have a different solution: <cfset therow = 0> <cfoutput query="myExcel" startrow="1"> <cfset therow = myExcel.currentrow + 1> <cfif len(eCCSubDate) GT 0> <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##eCCSubDate##Chr(34)#)",therow,13)> </cfif> <cfif len(eCCApproved) GT 0> <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##eCCApproved##Chr(34)#)",therow,14)> </cfif> <cfif len(DateDepartCntry) GT 0> <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##DateDepartCntry##Chr(34)#)",therow,16)> </cfif> <cfif len(DateArrive) GT 0> <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##DateArrive##Chr(34)#)",therow,17)> </cfif> <cfif len(DateDepart) GT 0> <cfset SpreadsheetSetCellFormula(s,"DATEVALUE(#Chr(34)##DateDepart##Chr(34)#)",therow,18)> </cfif> </cfoutput> I'm using the Excel DateValue function that makes it accept the cell value as a date. It does appear to work and sort properly now.
... View more
‎Mar 28, 2016
07:49 AM
Thanks I'll be sure to try it. I have added this: <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 13) /> <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 14) /> <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 16) /> <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 17) /> <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 18) /> <cfset spreadsheetFormatColumn(s, {alignment="right"}, 16) /> <cfset therow = 0> <cfoutput query="myExcel" startrow="1"> <cfset therow = myExcel.currentrow + 1> <cfset SpreadsheetSetCellValue(s, DateArrive, therow, 17)> </cfoutput> So my idea was to loop back over the original query and rewrite using the date value and inserting it back into the cell. I found something along the way that someone else had done that had a similar problem: Forcing values to be inserted into spreadsheets as text | cfSimplicity So, I'm guessing if we do it the manual way, I would have to do a SpreadsheetSetCellValue to enter in my column headers, then loop over the query to insert the data cell by cell. But, if I do that will it automatically create a new row in the spreadsheet every time?
... View more
‎Mar 28, 2016
07:21 AM
WolfShade, Thanks for answering. I would love to test this out but I guess I am confused at to where the dataformat will stick. There is no place in SpreadsheetSetCellValue to set dataformat. Or will it respect it in the spreadsheetFormatColumn that is being set? Also, it does sound like a pain to do this but I could generate the whole spreadsheet then go back and reset the values for that one column through the entire spreadsheet before exporting it. Do you have an quick example to show me what you mean? I just need to get started. Thanks
... View more
‎Mar 26, 2016
05:16 PM
Server: CF10 Platform: Windows and Linux (Win in DEV windows in PROD) So I'm generating this awesome excel file for a client but having trouble getting date fields to behave properly. Everything else seems to work just fine but when I send the data to excel to be generated, excel treats it as just text and when this filed gets sorted it handles it as such. More info: The column I'm trying to configure is called Arrival Date it is arriving formatted as mm/dd/yyyy (I have tried to format is as m/d/yy but when it arrives in the sheet that doesn't work as well) I'm also including an image of the sorted row. It does think its a valid but just doesn't sort it in chronological order. Code: <cfset filename = expandPath("./TDYData_(#DateFormat(now(),'mmddyy')#).xls")> <!--- Make a spreadsheet object ---> <cfset s = spreadsheetNew("TDYData")> <!--- Add header row ---> <cfset spreadsheetAddRow(s, "TDY Phase,Full Name,Employment Category,Gender,Originating Agency,Agency Comments,Originating Office,Office Comments,Originating Country,TDY Request Received,Mission Office Supported,Type of TDY Support,eCC Submission,eCC Approval,eCC Point of Contact,Date of Departure from Originating Country,Arrival Date,Departure Date,Accomodation Type,Accomodation Comments,Assigned Desk,Local Mobile Number,TDY Comments")> <!--- format header ---> <cfset spreadsheetFormatRow(s, { bold=true, fgcolor="lemon_chiffon", fontsize=10 }, 1)> <!--- Add query ---> <cfset spreadsheetAddRows(s, myExcel)> <cfset SpreadSheetAddFreezePane(s,0,1)> <cfset spreadsheetFormatColumn(s, {dataformat="m/d/yy"}, 17) /> <cfset spreadsheetFormatColumn(s, {alignment="right"}, 16) /> <cfheader name="content-disposition" value="attachment; filename=TDY_Data_(#DateFormat(now(),'mmddyy')#).xls"> <cfcontent type="application/msexcel" variable="#spreadsheetReadBinary(s)#" reset="true"> Any ideas? Thanks
... View more
‎Dec 04, 2014
07:51 AM
Hi, I recently updated CF10 to Update v14 and I have noticed something interesting. Env: RHEL 5.10 64 Bit CF10 64 Apache 2.2,3 Every time I restart ColdFusion I see that its trying to run the connector wizard. It says that it does this on the first time. Every time I restart CF it tries to do this connection and it eventually fails but it takes a long time to do this. Eventually CF shows up and eventually I can connect to any CF page. In the wsconfig.log it says: 12/04 09:46:15 info Tomcat Connector 12/04 09:46:15 debug command line: -ws Apache -dir /etc/httpd/conf -bin /usr/sbin/httpd -script /etc/rc.d/init.d/httpd -cfide /opt/coldfusion10/cfusion/wwwroot/CFIDE -v 12/04 09:46:15 error This web server is already configured for ColdFusion. com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstallerException: This web server is already configured for ColdFusion. at com.adobe.coldfusion.connector.connectorinstaller.ApacheInstaller.installConnector(ApacheInstaller.java:207) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.installConnector(ConnectorInstaller.java:353) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java:297) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java:759) 12/04 09:57:16 info Tomcat Connector 12/04 09:57:16 debug command line: -ws Apache -dir /etc/httpd/conf -bin /usr/sbin/httpd -script /etc/rc.d/init.d/httpd -cfide /opt/coldfusion10/cfusion/wwwroot/CFIDE -v 12/04 09:57:16 error This web server is already configured for ColdFusion. com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstallerException: This web server is already configured for ColdFusion. at com.adobe.coldfusion.connector.connectorinstaller.ApacheInstaller.installConnector(ApacheInstaller.java:207) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.installConnector(ConnectorInstaller.java:353) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.doIt(ConnectorInstaller.java:297) at com.adobe.coldfusion.connector.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java:759) I did look back in the logs and this was going on before but it didn't take as long to get the server up. On the average, it would take maybe 2 - 3 minutes before but now it takes double the time. Any suggestions?
... View more
‎Jun 23, 2014
08:32 AM
Update: Ok for now I think I have this worked out. So hopefully to help out anyone else in my shoes I'm going to recap what I did to get this working: Coldfusion 10 Red Hat Enterprise Linux 5.10 Apache x64 v 2.2.3 After the install I noticed the following error when trying to start Apache: Starting httpd: http: Syntax error on line 992 of /etc/httpd/conf/httpd.conf: Syntax error on line 2 of /etc/httpd/conf/mod_jk.conf Cannot load /opt/coldfusion10/cfudion/wsconfig/1/mod_jk.so into server: /opt/coldfusion10/config/wsconfig/1/mod_jk.so unidentified symbol: a_get_server_description After lots of searching, I found this link: https://helpx.adobe.com/coldfusion/kb/rhel-connector-configuration.html In here it mentions that Adobe has some pre-complied mod_jk.so files for specific version of RHEL. My version was not listed but it didn't stop me from trying to copy over the mod_jk.so file into the config directory located here (/opt/coldfusion/config/wsconfig/1/) According to the link, if none of these worked, I would have to compile a connector of my own. To compile the connector from source, do the following: Unzip connector-source.zip. Open the native folder. Give permission to folder chmod -R 777 native/ Run the following configure command: ./configure --with-apxs={apxs executable path} {find the location of apxs using find / -name apxs} For example, if the apache is installed under /home/apache2, then above command is as follows: ./configure --with-apxs=/home/apache2/bin/apxs Once configured, the command runs fine. Run the make from same folder. The make command compiles all the source. Open the apache-2.0 folder and locate mod_jk.so. If you don't find mod_jk.so, open the apache-2.0 folder. Replace the generate mod_jk.so with previous configured connector. You can find the same in the location {cf-home}/config/wsconfig/{magic-numner}/mod_jk.so. Restart ColdFusion and Apache. The first problem I ran into was, apxs was not installed on the system. I was able to get installed (as root) sudo yum install httpd-devel That gave me the apxs command. I tried again, another failure. This error said: error: C++ preprocessor "/lib/cpp" fails sanity check That meant that there was no c++ compiler on my system. So, back to yum to install gcc-c++. sudo yum install gcc-c++ Once that was installed I was able to find the path of apxs and follow the directions listed above. Once it had compiled, I looked into the apache-2.0 directory and copy over the freshly complied mod_jk.so to the configuration directory. A quick restart of Apache and coldfusion confirmed that everything was working.
... View more
‎Jun 20, 2014
12:46 PM
Ok so I'm having a hard time getting CF10 64bit installed on Red Hat Enterprise Linux 5.10 Apache version: 2.2.3 I have installed CF10 but when I try to restart Apache I get this error: Starting httpd: http: Syntax error on line 992 of /etc/httpd/conf/httpd.conf: Syntax error on line 2 of /etc/httpd/conf/mod_jk.conf Cannot load /opt/coldfusion10/cfudion/wsconfig/1/mod_jk.so into server: /opt/coldfusion10/config/wsconfig/1/mod_jk.so unidentified symbol: a_get_server_description Everything else seemed to work just fine but I can't get Apache to restart due to this error. Does anyone have any suggestions to try? TIA
... View more
‎Oct 24, 2011
10:49 AM
I would start googling for itext. This is what CF uses to create the PDF http://www.geek-tutorials.com/java/itext/itext_image.php Good luck!
... View more
‎Oct 05, 2010
12:22 PM
I have a need to use flash to capture an image and have that image uploaded to the server. I have seen some examples of code that uses flash to capture an image but it saves the file locally. We need that file to be sent to the server. We are using CF9.0 and I figure that once we are able to capture the image we could hand it off to ColdFusion to send to the server. Has anyone done anything like that or know if it's possible? Any help is apprecaited. Thanks, Mallory
... View more
AdChoices