Re: Transaction locking table, not sure where or why...
i would start by taking the file upload/processing out of transaction if you have it there. leave only db insert/update in the transaction. Azadi On 14/05/2010 13:20, Paolo Broccardo wrote: Hi Azadi - thanks for the feedback. I really like your idea of not having the uploading in the transaction and have in fact thought about how to do this before. I could remove some processing out of the transaction processing, but the photo uploading will need to be in the transaction. The reason for this is that the ID of each inserted album photo is used as the photo filename. Thus, if uploading 10 photos and photo number 7 fails, the system needs to roll back all photos already added to the database. If it's not in a transaction, I can't do this. Unless there is another way I am not thinking of. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
i would start by taking the file upload/processing out of transaction if you have it there. leave only db insert/update in the transaction. Yes. With transactions, the shorter the better. Also, do you have any indexes on the album table? Hi Leigh Thanks for the input. At this point there are no indexes besides the primary key on the table. Could this be contributing to the problem and if so how? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
Store the data in a temporary structure in memory and then write it to the DB once the uploads are finished. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 14 May 2010 17:23, Paolo Broccardo ad...@cheekyonline.com wrote: i would start by taking the file upload/processing out of transaction if you have it there. leave only db insert/update in the transaction. Azadi On 14/05/2010 13:20, Paolo Broccardo wrote: Hi Azadi - thanks for the feedback. I really like your idea of not having the uploading in the transaction and have in fact thought about how to do this before. I could remove some processing out of the transaction processing, but the photo uploading will need to be in the transaction. The reason for this is that the ID of each inserted album photo is used as the photo filename. Thus, if uploading 10 photos and photo number 7 fails, the system needs to roll back all photos already added to the database. If it's not in a transaction, I can't do this. Unless there is another way I am not thinking of. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Software Recommendations
I definitely prefer BlogCFC. ;) On Thu, May 13, 2010 at 4:07 PM, Will Swain w...@hothorse.com wrote: Are people generally preferring Mango to Ray's BlogCFC nowadays? I've done a few blogs with blogCFC, but haven't tried Mango yet. -Original Message- From: Christopher Stowell [mailto:christopher.stow...@yahoo.com] Sent: 13 May 2010 22:03 To: cf-talk Subject: Re: Software Recommendations ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
You should never include file uploading or photo processing within a transaction. It won't scale. It might work well on your test system, but when 20 people try to upload photos at the same time, and even if 1 has a slow connection, your system will crash and burn. Perhaps another way is to use UUIDs for the filename and key to the table.. OR use a separate table that just holds the last ID used. If you need 10 IDs for the next set of 10 photos, you set up a transaction that asks for the next ID available, and add 10 to it, store it then end the transaction. That should take miliseconds vs possibly tens of seconds your way. On 14/05/2010 13:20, Paolo Broccardo wrote: Hi Azadi - thanks for the feedback. I really like your idea of not having the uploading in the transaction and have in fact thought about how to do this before. I could remove some processing out of the transaction processing, but the photo uploading will need to be in the transaction. The reason for this is that the ID of each inserted album photo is used as the photo filename. Thus, if uploading 10 photos and photo number 7 fails, the system needs to roll back all photos already added to the database. If it's not in a transaction, I can't do this. Unless there is another way I am not thinking of. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
When you say you run the URL separately are you doing this from the server console? If not, the server may not be able to resolve the FQDN. Dave, I'm still not able to get this cfschedule working. When I say run it separately, it means that instead of cfschedule activating the cf code that I have (which then sends email) that I instead bring up the url on my own browser to have it do it's task. That makes it run (and send my urls) just fine. So, no I'm not doing it from the server console, which I don't have access to. Are you saying that it should not be able to work with a URL that's fully qualified like http://sph.umd.edu/blah.cfm? I would think that would be best because it knows the whole path and it is on a centralized server. From what I've been able to gather, people replace the relative url with a full url on cfschedule when they run into a problem. Any more assistance would be great. I'm sure I'm close. I've been at this on and off for weeks now and it's tiring. oh and I've not been able to get the log file to work either. I'm feeling useless. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Logging is your friend. :-) Create a log file for your scheduled task. Does this page sit in an application that requires authentication? If so, make sure to specify the username and password. Qing, I'm not having much luck logging either. jeez. and no, there's no username and password for the directory or file. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
On Friday 14 May 2010 15:34:46 you wrote: Dave, I'm still not able to get this cfschedule working. When I say run it separately, it means that instead of cfschedule activating the cf code that I have (which then sends email) that I instead bring up the url on my own browser to have it do it's task. That makes it run (and send my urls) just fine. So, no I'm not doing it from the server console, which I don't have access to. This is almost always because your browser or computer is doing something different to the server's browser. Could it be DNS (change not getting there yet) or permissions (automatic Windows domain authorisation, for instance, or saved credentials in your browser). Testing directly on the server or locally with something like 'wget' is normally the best path forwards. -- Tom Chiverton Helping to heterogeneously scale web-readiness as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Could it be DNS (change not getting there yet) or permissions (automatic Windows domain authorisation, for instance, or saved credentials in your browser). Testing directly on the server or locally with something like 'wget' is normally the best path forwards. I can't test directly on the server. I don't have access to it. It's a shared host. I may have to learn wget for this, I suppose. I dunno. I've never looked at it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Did you see any problems with the code above? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Loop through an array - with GROUPING? - New Problem - Row Out Of Range
After looking at my code, I can actually SKIP creating the array and go ahead and directly create the query object: AT the top of the page: cfset hasMEDIA = QueryNew(thisHEAD, sec_id, thisSTORY, idLIST, VarChar, Integer, VarChar, VarChar) cfoutput query=:someQ cfset temp = QuerySetCell(hasMEDIA, tHEAD, #tHEAD#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, secid, #secid#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, tSTORY, #tSTORY#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, idLIST, #theseID#, #COUNT#) /cfoutput If I do a simple CFOUPUT of the vars I'm trying to put into cells, I'm getting exactly what I want to see, correct row number and everything. Running the above though, I get an error message: The row number 1 is out of bounds. Suggestions? cfset thisARRAY[#thisCOUNT#][1] = SECTION cfset thisARRAY[#thisCOUNT#][2] = id cfset thisARRAY[#thisCOUNT#][3] = title cfset thisARRAY[#thisCOUNT#][4] = stuff cfset thisARRAY[#thisCOUNT#][5] = other stuff cfset thisARRAY[#thisCOUNT#][5] = more stuff cfset thisARRAY[#thisCOUNT#][5] = even more stuff __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Loop through an array - with GROUPING? - New Problem - Row Out Of Range
Found it. Sheesh. Didn't realize you *HAD* to tell it you were going to add a new row. I thought if you just gave it a row number (#COUNT#) it would go ahead and ADD that row. So, before the chunk or QuerySetCell statements, I needed to add: cfset temp = QueryAddRow(hasMEDIA) cfoutput query=someQ cfset temp = QueryAddRow(hasMEDIA) cfset temp = QuerySetCell(hasMEDIA, tHEAD, #tHEAD#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, secid, #secid#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, tSTORY, #tSTORY#, #COUNT#) cfset temp = QuerySetCell(hasMEDIA, idLIST, #theseID#, #COUNT#) /cfoutput OK, I feel stupid now. But also somewhat confused! What's the point of the row number in QuerySetCell if you have to tell it to add a new row to start with? OK, if you're UPDATING and existing row maybe, but ... ?? Hmmm... __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is there a way to do an arbitrary sort order on a specific cell?
Is there a way to do an arbitrary sort order on a specific cell? For example, let's say I have a cell colour. Possible values: 1. blue 2. cyan 3. green 4. orange 5. red 6. silver I want to sort on this cell, BUT, I want the order to show all red first blue second green third ... blah ... __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Substitute/conversion for Flash Interactive Menus for iPad?
Just FYI - I highly recommend using Google Analytics to track who is visiting your site. It is a free tool and not only tells you where people are visiting your site from, it also lets you know what kinds of browers they are using, whether they are using mobile devices, if their browsers are javascript enabled and what versions of Flash they have installed. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
case statement in the ORDER BY should work. See http://www.devx.com/tips/Tip/17288 On Fri, May 14, 2010 at 9:24 AM, Les Mizzell lesm...@bellsouth.net wrote: Is there a way to do an arbitrary sort order on a specific cell? For example, let's say I have a cell colour. Possible values: 1. blue 2. cyan 3. green 4. orange 5. red 6. silver I want to sort on this cell, BUT, I want the order to show all red first blue second green third ... blah ... __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
Is there a way to do an arbitrary sort order on a specific cell? What do you mean by cell? A query, grid, etcetera ...? In general terms, you could assign a sort number to each color (red=1, blue=2, ecetera). Then sort by that value. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking for To Rent Office Space in Denver for 6 mos
Posting here, because I do a lot of ColdFusion development. Anyone have space or recommend an executive suite in particular? I'll be living in the Platt Park neighborhood. Would really be interested in space with an existing IT shop. Any leads are appreciated. Drop me a line at m dot lesko at verizon dot net. I would be working for my current employer. Looking for July through December. Regards, Matthew Lesko ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
Store the data in a temporary structure in memory and then write it to the DB once the uploads are finished. +1 Store the data in a struct or array and wait until you have all the data to open your transaction. Do this and your problem with disappear. Also, in the places you are reading from the album table I would recommend setting the isolation for that connection only. Also keep in mind that the cftransasction tag's default isolation level is read committed, and it will reset it every time you open the tag. If you want to change the isolation level of the transaction, use the isolation attribute of the cftransaction tag. That being said, I don't think that's what you want to do. You want to change the isolation level of the query READING from the table. Also, run some traces to see if your updates are causing row locks or are escalating to table locks. I think that might be what Leigh was getting at. I don't know that I can recommend setting your global isolation level to read uncommitted. Locks are for a reason and I've seen some weird hard-to-find errors in systems where over-zealous DBA's used read uncommitted for EVERYTHING. :) ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
Also, run some traces to see if your updates are causing row locks or are escalating to table locks. I think that might be what Leigh was getting at. Yep. But I think that is secondary to the main issue everyone has mentioned: too much non-related processing within the transaction. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 ODBC Server crashes when talking to Sybase over SQL Anywhere 11
Hi there, We have recently upgraded our database from Sybase 6 to Sybase 11. We are also hoping to move from ColdFusion MX 6.1 to ColdFusion 9 in the near future. In both environments, the ColdFusion ODBC Server enters a state where it is hung and the ColdFusion Application Server needs to restart. I have been testing in CF9 since it actually gives an error message, where CF6.1 just boots me out to the login page. Connections are setup using the ODBC Socket in CF Administrator. In the ColdFusion 9 ODBC Server debug log we see the following warnings as it is trying to run GetDescribe. It appears that it is unable to retrieve Catalog Name, but I donât know why this would cause the ODBC Server to die. In Sybase 6, the Catalog Name is blank as well, but there are no warnings either. This statement is doing a select * and returning 155 columns. Following is a successful example where only 4 columns are retrieved. I could (and have) gone through and chop my select statements, but since this worked in Sybase 6 I wonder if there is a handshaking problem? I would appreciate any advice on setting up my DSN or ODBC server that may help this issue. Thank you for your help! Holly Ackerman Applications Programmer Survey Research Operations â University of Michigan ** ColdFusion 9 ODBC Server debug log failure ** Tue May 11 13:41:58 2010: SWSOC_CursorVar_DescribeCol entry descIx = 155 Tue May 11 13:41:58 2010:SQLColAttribute SQL_DESC_CATALOG_NAME sqlRc = 1 Tue May 11 13:41:58 2010: SWANDBSRVC_OdbcError entry Tue May 11 13:41:58 2010: SWSOC_OdbcErrorWithState entry Tue May 11 13:41:58 2010:Diagnostics (Warning) added: message:[01004][ODBC Socket][Sybase][ODBC Driver]Data truncated;code:0;component:6;function:10;row:0;column:0 Tue May 11 13:41:58 2010: SWSOC_OdbcErrorWithState exit Tue May 11 13:41:58 2010: SWANDBSRVC_OdbcError exit Tue May 11 13:41:58 2010: SWSOC_CursorVar_DescribeCol exit Tue May 11 13:41:58 2010:SWANDB_GetDescribe exit Tue May 11 13:41:58 2010:The active request for session 8 is interrupted due to an unexpected exception Tue May 11 13:41:59 2010:SWANDB_FreeVariables entry Tue May 11 13:41:59 2010:SWANDB_FreeVariables exit Tue May 11 13:41:59 2010:SWANDB_Close entry Tue May 11 13:41:59 2010:SWANDB_Close exit Tue May 11 13:41:59 2010:SWANDB_Logoff entry Tue May 11 13:41:59 2010:Abnormal logoff detected (caused by crash, kill, ) Tue May 11 13:41:59 2010:Logoff behaviour not set, using database default Tue May 11 13:41:59 2010:SWANDB_Logoff exit ColdFusion 9 ODBC Server dump file: //= Tuesday, May 11, 2010 1:41:58 PM ACCESS_VIOLATION Stack Dump: PC:7C82CAC2-Seg:1;Off:0002BAC2-RtlDeleteCriticalSection+11A PC:7C833A52-Seg:1;Off:00032A52-RtlGetFullPathName_UstrEx+16D PC:7C82B61B-Seg:1;Off:0002A61B-wcscpy+180 PC:0046F5AB-Seg:1;Off:0006E5AB PC:0046F5CD-Seg:1;Off:0006E5CD //= When I look at the ODBC Server debug log for other GetDescribe statements on the same table, the same warnings appear, and the catalog name is blank, but it seems to proceed fine from there. In the example below, I limit the select to 4 columns. ** ColdFusion 9 ODBC Server debug log success ** Tue May 11 13:41:37 2010: SWSOC_CursorVar_DescribeCol entry descIx = 4 Tue May 11 13:41:37 2010:SQLColAttribute SQL_DESC_CATALOG_NAME sqlRc = 1 Tue May 11 13:41:37 2010: SWANDBSRVC_OdbcError entry Tue May 11 13:41:37 2010: SWSOC_OdbcErrorWithState entry Tue May 11 13:41:37 2010:Diagnostics (Warning) added: message:[01004][ODBC Socket][Sybase][ODBC Driver]Data truncated;code:0;component:6;function:10;row:0;column:0 Tue May 11 13:41:37 2010: SWSOC_OdbcErrorWithState exit Tue May 11 13:41:37 2010: SWANDBSRVC_OdbcError exit Tue May 11 13:41:37 2010: SWSOC_CursorVar_DescribeCol exit Tue May 11 13:41:37 2010:SWANDB_GetDescribe exit Tue May 11 13:41:37 2010:SSP OUTPUT === sspVersion:9 error :1 CHAIN num:4 subPacketError:0 OPEN stmtRefnum:3 EXECDIRECT row count:-1 result available :1 transaction :0 output available :no GETDESCRIBE numDescs:4 (logging describe cursorvar:1) auto unique :no case sensitive:no catalog name : money :no label :npreferenceid length:5 name :npreferenceid nullable :no scale :0 schema name :DBA searchable:searchable table name:table name successfully displayed here type :numeric type name :numeric unsigned :no updatable :yes encoding : ~| Order the Adobe Coldfusion Anthology now!
Automate FTP
I have a remote server with some transaction logs I would like to automate the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but it seems no matter how long I set the timeouts in the CF Admin for the task, or in the cfftp tag, it fails for files larger than ~ 30-40M. I can get 100M files via cmd like this either one step at a time in the cmd window or with this in a batch script: open 10.10.1.49 DBUser DBPW get Eligibility_tlog_201005141200.TRN quit I have tried all afternoon to use cfexecute to do this such that I can let CF provide the filename programmatically with no luck. So basically I would like to use some FTP inside my cf scheduled task rather than using cfftp. Or any other ideas would be greatly appreciated. My scheduled task has worked until the transaction logs started getting too big. -- Greg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Automate FTP
Have you tried seeing if it's possible to upload some of these big files manually? It's not uncommon for FTP servers to have a max files size restriction. What's the error that your receiving? Paul Alkema http://paulalkema.com/ -Original Message- From: Greg Luce [mailto:luce...@gmail.com] Sent: Friday, May 14, 2010 4:58 PM To: cf-talk Subject: Automate FTP I have a remote server with some transaction logs I would like to automate the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but it seems no matter how long I set the timeouts in the CF Admin for the task, or in the cfftp tag, it fails for files larger than ~ 30-40M. I can get 100M files via cmd like this either one step at a time in the cmd window or with this in a batch script: open 10.10.1.49 DBUser DBPW get Eligibility_tlog_201005141200.TRN quit I have tried all afternoon to use cfexecute to do this such that I can let CF provide the filename programmatically with no luck. So basically I would like to use some FTP inside my cf scheduled task rather than using cfftp. Or any other ideas would be greatly appreciated. My scheduled task has worked until the transaction logs started getting too big. -- Greg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion memory leaks
Hi, I am new to ColdFusion server monitoring, so I am trying to get some ideas here to get me move in the right direction. We have a situation where our production ColdFusion applications are using more and more memory until they bring the server to a halt. I was informed (I am new here) that our systems administrator actually wrote a batch script to automatically restart the ColdFusion server every Sunday morning to avoid this very problem. Despite this, the memory leaks still make it necessary to manually restart the ColdFusion server from time to time (could be every couple of weeks). CF8 comes with pretty decent server monitoring tools including memory monitoring but I dare not run it in production since it is such a memory monster. Without purchasing other monitoring software like SeeFusion or BlueDragon, what are my options here? I see that there is an option in CFAdmin to periodically recycle JVM memory once it reaches a threshold, but I am a little too concerned to use it--it is not really like fixing the problem. Any idea will be most appreciated! Thanks, Qing Xia ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion memory leaks
Ironically, I'd double-check to make sure that you have the built in CF server monitor turned off. It can bring a production server to its knees, and we had a ton of crashing and burning that we couldn't figure out until we finally discovered that someone had turned the server monitor on by mistake. On Fri, May 14, 2010 at 3:24 PM, Qing Xia txiasum...@gmail.com wrote: Hi, I am new to ColdFusion server monitoring, so I am trying to get some ideas here to get me move in the right direction. We have a situation where our production ColdFusion applications are using more and more memory until they bring the server to a halt. I was informed (I am new here) that our systems administrator actually wrote a batch script to automatically restart the ColdFusion server every Sunday morning to avoid this very problem. Despite this, the memory leaks still make it necessary to manually restart the ColdFusion server from time to time (could be every couple of weeks). CF8 comes with pretty decent server monitoring tools including memory monitoring but I dare not run it in production since it is such a memory monster. Without purchasing other monitoring software like SeeFusion or BlueDragon, what are my options here? I see that there is an option in CFAdmin to periodically recycle JVM memory once it reaches a threshold, but I am a little too concerned to use it--it is not really like fixing the problem. Any idea will be most appreciated! Thanks, Qing Xia ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion memory leaks
The first thing I look at when people say they have a memory leak is the session variables. More than once I've identified the cause of a clients problems in a few minutes by looking at how much data they put into session variables, how long the timeout is, and how often they are hit by bots. Think of it this way. A bot comes to the site. It gets a session. The session exists for X time. The same bot comes to a different page. It gets a NEW session which exists for X time. It might look like a small amount of memory for a session but on really big sites (a million pages), it builds fast and can crash hard. http://www.blogoffusion.com/112805-pseudomemory-leak.cfm -- Michael Dinowitz Lead Author - Adobe Coldfusion Anthology http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion On Fri, May 14, 2010 at 5:24 PM, Qing Xia txiasum...@gmail.com wrote: Hi, I am new to ColdFusion server monitoring, so I am trying to get some ideas here to get me move in the right direction. We have a situation where our production ColdFusion applications are using more and more memory until they bring the server to a halt. I was informed (I am new here) that our systems administrator actually wrote a batch script to automatically restart the ColdFusion server every Sunday morning to avoid this very problem. Despite this, the memory leaks still make it necessary to manually restart the ColdFusion server from time to time (could be every couple of weeks). CF8 comes with pretty decent server monitoring tools including memory monitoring but I dare not run it in production since it is such a memory monster. Without purchasing other monitoring software like SeeFusion or BlueDragon, what are my options here? I see that there is an option in CFAdmin to periodically recycle JVM memory once it reaches a threshold, but I am a little too concerned to use it--it is not really like fixing the problem. Any idea will be most appreciated! Thanks, Qing Xia ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
Charlie Griefer wrote: case statement in the ORDER BY should work. See http://www.devx.com/tips/Tip/17288 Checking my syntax, but doesn't seem to work for a query of queries.. Like: cfloop query=featureMENU cfset temp = QueryAddRow(hasMEDIA) cfset temp = QuerySetCell(hasMEDIA, tHEAD, #req.tHEAD#, #tCOUNT#) cfset temp = QuerySetCell(hasMEDIA, sid, #sid#, #tCOUNT#) /cfloop cfquery dbtype=query name=getAllMedia SELECT tHEAD, sid FROM hasMEDIA ORDER by ( Case thisHEAD WHEN 'Feature Article' THEN 1 WHEN 'Quoatable' THEN 2 WHEN 'On the Money' THEN 3 WHEN 'In the News' THEN 4 WHEN 'Innovation' THEN 5 WHEN 'About Us' THEN 6 WHEN 'Border Bound' THEN 7 WHEN 'Quick Facts' THEN 8 ELSE 100 END ) /cfquery ERROR: Query Of Queries syntax error. Encountered (. Incorrect ORDER BY column reference [(]. Only simple column reference, alias name, and integer column id are allowed. __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion memory leaks
In addition to the other good suggestions so far, check your datasource settings. It is often the case that datasources are allowed to have a huge number (or even infinite) connections to the database, and there are often excessive timeout values with each datasource as well. If CF sits patiently waiting for DB calls that don't ever return, you run out of threads (and memory) pretty quickly. Limit number of connections to something like 5 x CPU cores, and set Timeouts to 15 min and 5 min. If you're running SQL Server, I also recommend 20 seconds on the Login timeout, since that's the default on the DB side already. Last but not least, if you're on SQL Server, please allow it to Maintain Connections ... the RDBMS is better at managing its threads than the JVM :) On 5/14/2010 5:24 PM, Qing Xia wrote: Hi, I am new to ColdFusion server monitoring, so I am trying to get some ideas here to get me move in the right direction. We have a situation where our production ColdFusion applications are using more and more memory until they bring the server to a halt. I was informed (I am new here) that our systems administrator actually wrote a batch script to automatically restart the ColdFusion server every Sunday morning to avoid this very problem. Despite this, the memory leaks still make it necessary to manually restart the ColdFusion server from time to time (could be every couple of weeks). CF8 comes with pretty decent server monitoring tools including memory monitoring but I dare not run it in production since it is such a memory monster. Without purchasing other monitoring software like SeeFusion or BlueDragon, what are my options here? I see that there is an option in CFAdmin to periodically recycle JVM memory once it reaches a threshold, but I am a little too concerned to use it--it is not really like fixing the problem. Any idea will be most appreciated! Thanks, Qing Xia ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
Checking my syntax, but doesn't seem to work for a query of queries.. QoQ's are very limited. They do not support CASE statements, AFAIK. If you are using a database query as the source of this information, add a CASE statement to your base database query to generate a column called SortNumber. Then use that column for ordering. Alternatively, you could add a SortNumber column to your base table. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
If you are using a database query as the source of this information, add a CASE statement to your base database query to generate a column called SortNumber. Then use that column for ordering. Alternatively, you could add a SortNumber column to your base table. I wish it were that easy. The information is coming from a number of different sources - RSS feeds, a database or two - and being consolidated down into a single source In theory, I could add a new database table to the site in question, and populate it every X number of hours on a schedule, but that's not exactly how this is set up to function. It's something I'm looking into though. Thanks! __ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
In theory, I could add a new database table to the site in question, and populate it every X number of hours on a schedule, but that's not exactly how this is set up to function. Well .. either way, you will have to change to something if the CASE values are not static. Be it a table, or a SQL query. However, if your base query is _not_ a database query, then you do not have many options, AFAIK. You are limited by the capabilities of QoQ's. It is either, add a sortNumber column and populate it row-by-row, or use a hack to simulate an OUTER join in QoQ's (tres ugly). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to do an arbitrary sort order on a specific cell?
Well .. either way, you will have to change to something if the CASE values are not static. Be it a table, or a SQL query. ... or your CF code. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Automate FTP
Yes, I am currently doing the large files manually. And like I said I have transferred 100M + files via the command line ftp syntax posted. I'm not really getting any errors when using cfexecute, just nothing is happening or transferring. Greg On Fri, May 14, 2010 at 5:00 PM, Paul Alkema paulalkemadesi...@gmail.comwrote: Have you tried seeing if it's possible to upload some of these big files manually? It's not uncommon for FTP servers to have a max files size restriction. What's the error that your receiving? Paul Alkema http://paulalkema.com/ -Original Message- From: Greg Luce [mailto:luce...@gmail.com] Sent: Friday, May 14, 2010 4:58 PM To: cf-talk Subject: Automate FTP I have a remote server with some transaction logs I would like to automate the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but it seems no matter how long I set the timeouts in the CF Admin for the task, or in the cfftp tag, it fails for files larger than ~ 30-40M. I can get 100M files via cmd like this either one step at a time in the cmd window or with this in a batch script: open 10.10.1.49 DBUser DBPW get Eligibility_tlog_201005141200.TRN quit I have tried all afternoon to use cfexecute to do this such that I can let CF provide the filename programmatically with no luck. So basically I would like to use some FTP inside my cf scheduled task rather than using cfftp. Or any other ideas would be greatly appreciated. My scheduled task has worked until the transaction logs started getting too big. -- Greg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Out of the Office
Thanks for your email. Unfortunately, I am out of the office and will have very limited access to my voicemail and emails until I return to the office on Tuesday, May 18th. If a quicker response is necessary, please contact James Wright at ja...@bridgetechnicalsolutions.com or 401 398-1900 x101 instead. Thanks, Joe Devine ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4321 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
