paulm1677332
Participant
paulm1677332
Participant
Activity
‎Oct 27, 2024
05:45 PM
It looked like my message kept failing but it didnt highlight anything and then I got a message saying my message quota had been reached for the day so maybe it went @BKBK ?
... View more
‎Oct 27, 2024
05:12 PM
Unlikley browser cache as i've repeated same steps on 2018 version without an issue on same browser. I'd rather not post code here but I can send you a PM with some.
... View more
‎Oct 27, 2024
08:38 AM
Just for more context. This is running via latest 2023 image from docker in AWS. I've been playing around with other pages too and seeing more query related issues. I have various counts against items on the homepage (counts returned via db query) I made changes there which should see one of those values increase each time which it did. So originally the count was 0 but I added 2 items and each time the counter displayed went up to 2 as expected. Then I added a third and value stayed at 2. Refreshed a number of times and then it went to 0! Then refreshed again and went back to 2. Eventually after going into another page and back again a couple of times it went to 3. No consistency to whats coming back from the query.
... View more
‎Oct 27, 2024
08:16 AM
Hi @BKBK The form actually submits to itself with logic at the top to determine if it's been submitted. Below this then in the code is the 'get' which would query the db for values needed in the form. I forgot to mention that I was able to go out of the form to another page then back to it and still same old values displaying but values in the db were correct. Only when I logged out and back in again and loaded the form did it have the updated values.
... View more
‎Oct 27, 2024
04:11 AM
Hi, We are testing upgrading from CF2018 to 2023 and have noticed some odd behaviour when saving forms over and over. We have a form which updates a table in the database and when updating the values a number of times in a short space of time the values on the screen aren't matching whats in the database. The values save fine to database but when they reload the form it should have the saved values which are called via a query at the top of the page. I assume this is some caching but I havent specified any caching in the query and haven't changed anything in the Coldfusion Administrator in caching section. Its all just default values there. I've tested it on CF2018 and I can save and save and everything reloads as expected. I can understand how this may happen if I used 'cachedWithin' in the query object as the query is the same each time but it should return something different each time as we are saving the form and updating the values for that table. Anyone noticed anything similair before? Thanks
... View more
‎Jun 23, 2024
03:40 PM
Thanks Charlie, Interesting to know its per application. Thats great to know. I think i can definately up that value and look at a few queries to start using it now.
... View more
‎Jun 23, 2024
03:35 PM
Thanks BKBK, What value had you set the for Maximum number of cached queries to be, out of curiousity?
... View more
‎Jun 10, 2024
06:37 AM
Hi Dave, We have a number of queries to return various counts on the homepage so for anyone using the system and constantly returning to the homepage these queries would constantly be reran. The problem is for many of the users these queries would vary depending on certain criteria so there would be lots of similiar queries cached I would say. If the cache was able to handle it I think there should be value adding cachedwithin to a few queries. Thanks
... View more
‎Jun 10, 2024
05:08 AM
Hi, I've never used cachedwithin parameter before in queries as the queries are generally dynamic but i'm potentially thinking it might be of benefit to us. The question I have is with a lot of users and active sessions, would adding this cachedwithin parameter to a few queries overload the cache or have negative affects to performance. I don't know enough about how the cache works or what kind of space it has to operate. Is there a benefit of using that parameter if the queries are dynamic. All I can see in the documentation is that for dynamic queries it will create a new one for each but it doesn't warn against using it if that is the case. Thanks
... View more
‎Mar 12, 2024
09:42 AM
Hi, We have functionality where we store a mapped pdf in AWS, then when we want to create a pdf with our own values, we read in the binary and use cfpdfform with action populate, then use cfpdfformparam to populate our values. This works fine but when we want to create a lot at the same time, we create them, add them to a directory then do a cfpdf action="merge" on that directory to get what we need. Dependant on the amount i'm getting timeouts if its anything around the 100 mark. Just wondering is there an alternative way of doing it. We're using CF2018. Is there anything in more recent releases which make life easier with pdf generation? Thanks
... View more
‎Sep 15, 2023
07:55 AM
Thanks Charlie. You've given me great answers on this before and I always appreciate your responses. The performance issues were actually down to issues with SQL Server and a restart of the instance actually sorted things so it wasn't really CF being the issue in this case. I suppose it was just when looking around I came across that article and was wondering if anyone could confirm or deny that disabling it would be beneficial. We do have Fusion Reactor and I use that to keep an eye on all things DB side. I could probably use it for more but thats another story.
... View more
‎Sep 15, 2023
06:51 AM
Hi, I was looking at some performance issues on a test server and I came across the following: Tip: Our research has shown that in some versions of ColdFusion, leaving Report Execution Times enabled while Enable Request Debugging Output was disabled would still cause ColdFusion to perform excessive background processing on every request, leading to significant overhead. It is highly recommended to disable Report Execution Times regardless of the Enable Request Debugging Output setting in your production environment. I noticed we had Report Execution Times enabled. We are using CF2018. Can anyone confirm if there is additional overhead having this enabled and should I disable it or does it not matter? Thanks
... View more
‎Mar 31, 2023
02:41 PM
Hello there, Sorry for the delay in replying. Long story short we didnt get to retry modifying the Cloudflare settings (not my area). We ended up creating a Windows Scheduled job which contained a call to the url using CURL. This got us what we wanted but im sure we could have got it working via Cloudflare with what you outlined above Charlie. Thanks again for the help.
... View more
‎Mar 03, 2023
02:00 PM
Quick update. We made the change above Option 2, but it stopped all traffic to our sites so we had to revert. We may have configured it wrong but we will test it more next week and will add a follow up here. Thanks
... View more
‎Mar 02, 2023
03:01 PM
Hi Charlie, Thanks for that comprehensive explanation. The Cloudflare route was the only plausible issue as I couldnt find anything similiar for anyone else out there. I was thinking that it may be in the way cfschedule calls the url under the hood but wouldnt have had any idea how to dig any deeper there. I will make the requested change tomorrow and add a follow up just to confirm. The url is on our own servers so we shouldnt have an issue making the required changes. Thanks again
... View more
‎Mar 02, 2023
09:16 AM
I have a lot of component calls etc. so cant post that here but like i said earlier when I commented all that out and just had the below I also got same error code 1010 <cfoutput>
Complete #Now()#
</cfoutput> I see that error code 1010 has some relevance in Cloudflare and we do use Cloudflare so im wondering if it has something to do with that. Cloudflare reference
... View more
‎Mar 02, 2023
08:28 AM
Hi Priyank, Its just for this task. We only have 2 but the other one is working fine. I edited the page just to show the date, nothing else and still the error code 1010 so it isnt anything within a component or function. Thanks
... View more
‎Mar 02, 2023
07:46 AM
Hello, Have an issue running a scheduled task on CF2018. Hitting the url in a browser window it runs fine, but via the schedule task when I output to a file all im getting in the file is error code: 1010 Not seeing anything wrong in execption.log or scheduler.log. Anyone any ideas? Thanks
... View more
‎Oct 25, 2022
02:24 PM
Hello, Just wondering if anyone is using logz.io to monitor their CF logs and if so how easy is it to setup? Thanks
... View more
‎Jan 25, 2022
02:56 AM
Hello, Has anyone experience of setting up ActiveMQ on a CF server to consume and later post messages back to Confluent Cloud? I haven't used event gateways before and the whole Confluent side is also new. I have the gateway running locally and consuming basic messages sent locally, its the linkup with Confluent is the unknown. There are various connectors/sinks available within Confluent for ActiveMQ but i'm not sure of their use and do I need anything like that. I ws thinking it would just be a matter of firing up the gateway giving it some sort of url and topics to listen to and once we get a message we want, my cfc handles the rest. Thanks
... View more
‎Oct 05, 2021
07:00 PM
CF2018 Update 12. Reverted the code, added this new patch that was sent and everything worked again.
... View more
‎Oct 04, 2021
03:29 PM
Contacted Coldfusion support and they've sent me a patch. Will deploy and post here as to how it goes.
... View more
‎Oct 04, 2021
01:06 PM
Hi, We updated our CF servers over the weekend and since the update we've had errors coming in from an area with a Query of Queries is used. Basically there is an order by in the QoQ and this is the field not being returned. It should be returned and it was until we did the updates and for now I had to manually add the field back into the select statement. It should be returned via a select query.* from original but not working now. The only one missing though is the one used in the order by clause. Anyone had similiar issues? Thanks
... View more
‎Sep 13, 2021
02:06 AM
Thanks BKBK. So bottom line is we don't have a way of supporting Urdu locale (ur_IN) currently.
... View more
‎Sep 10, 2021
03:08 AM
Hello, Just wondering whats the best way to handle an unsupported locale. We cater for a number of locales which are all supported but we now have need for Urdu but this isn't in the list of supported locales on our server. Has anyone ran into similair issues and how did they solve it? We're passing the locale to lsDateFormat and similar functions around the system, how can we get these working without errors? Thanks
... View more
‎Aug 10, 2021
08:46 AM
Hi, Just wondering if anyone has any experience of upgrading the Microsoft SQL Server driver from the Adobe one to the Microsoft one and if there was any improvement in performance. We did it but ran into issues with identity fields not being returned from insert queries but if there was a noticeable improvement in performance from them its something we would revisit. Thanks, Paul
... View more
‎Jun 21, 2021
03:09 PM
Thanks Charlie. But sure, if you really meant to say that you would go on and call many more methods in that CFC (or all that one over and over) in a given request, then yes there's for sure an advantage to saving the instantiation in a variable and calling the methods using that. I'll certainly take the above on board as I would have mulitple areas where I would call the same function within a loop so method 1 would seem best utilised in this scenario. I wouldnt have considered that previously and would have just called the function whatever way was closest to hand at that time. I had also had a little google to find the answer but hadn't come across that article you included. Would have saved myself a post. Paul
... View more
‎Jun 21, 2021
03:01 AM
Hello, Just a query on 2 differing ways of calling a function from a component in Coldfusion. I've always called functions in one of 2 ways. Method 1: <cfset myComponent = createObject("component", "pathToMyComponent.componentGet")>
<cfset myVariable= myComponent.getKey (
data = someDSN,
key = myKey,
........)>​ Method 2: <cfinvoke component="pathToMyComponent.componentGet" method="getKey " returnvariable="myVariable">
<cfinvokeargument name="data" value="#someDSN#">
<cfinvokeargument name="key" value="#myKey#">
.......
</cfinvoke> My question would be is there any overhead using Method 1 over Method 2. I assume there must be as you are instantiating an entire component, then only using 1 function. Method 2 would be my preferred way of calling a function but we would still have lots of calls made using Method 1. Just wondering what the advantages of one over the other would be and whats best from system memory/performance point of view? Thanks
... View more
‎Mar 18, 2021
09:26 AM
1 Upvote
Hi Pete, Thanks for all that I eventually got it working. I did use decrypt instead of the other function I had created. I had at some point tried to use that but went back to my other function. The one issue I had was with the algorithim. I got an error until I used "AES/CBC/NoPadding". Thank again
... View more
‎Mar 18, 2021
08:23 AM
Hi Pete, I had looked at that library but was thinking it might be too elaborate for what I needed. I did look at some of the functions in there to try and see was I on the right track. I'm certainly no crypto expert and to me I think i'm pretty close to a working solution but I dont know enough to confirm i'm even decrypting the key properly. Thanks
... View more
AdChoices