Urgent issue
Dear All, Suddenly my Production site is down. I am getting the below message. Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2 Can anyone please help me on this issue. Thanks for your time help. Regards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Urgent issue
Now it's showing as Coldfusion service as started. But still I am not able to view CF administrator or site. I am confused. Sathya On 22 Oct 2014 10:44, Phillip Vector vec...@mostdeadlygame.com wrote: If you are running it on a non-windows machine, I would google search that code. If it's windows, I would review the system event log. On Tue, Oct 21, 2014 at 11:29 PM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, Suddenly my Production site is down. I am getting the below message. Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2 Can anyone please help me on this issue. Thanks for your time help. Regards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Urgent issue
Dear Phillip, It is a windows server machine. Now I checked the CF log and it shows CF is started. But I am not even able to see CF admin page also. Regards, Sathya On Wed, Oct 22, 2014 at 10:53 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Now it's showing as Coldfusion service as started. But still I am not able to view CF administrator or site. I am confused. Sathya On 22 Oct 2014 10:44, Phillip Vector vec...@mostdeadlygame.com wrote: If you are running it on a non-windows machine, I would google search that code. If it's windows, I would review the system event log. On Tue, Oct 21, 2014 at 11:29 PM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, Suddenly my Production site is down. I am getting the below message. Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2 Can anyone please help me on this issue. Thanks for your time help. Regards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Urgent issue
Dear All, Thanks for your suggestions. There was some problem with IIS. It was showing IIS service started but W3wp.exe was not showing in running process under task manager. Not sure exactly what the problem is. But the simple restarting the Windows server 2003 solved the problem. Regards, Sathya On Wed, Oct 22, 2014 at 12:43 PM, Russ Michaels r...@michaels.me.uk wrote: Have you checked the connectors have been setup properly? Have you tried internal web server Have you check runtime logs Etc On Wed, Oct 22, 2014 at 7:59 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear Phillip, It is a windows server machine. Now I checked the CF log and it shows CF is started. But I am not even able to see CF admin page also. Regards, Sathya On Wed, Oct 22, 2014 at 10:53 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com javascript:; wrote: Now it's showing as Coldfusion service as started. But still I am not able to view CF administrator or site. I am confused. Sathya On 22 Oct 2014 10:44, Phillip Vector vec...@mostdeadlygame.com javascript:; wrote: If you are running it on a non-windows machine, I would google search that code. If it's windows, I would review the system event log. On Tue, Oct 21, 2014 at 11:29 PM, Sathyanarayanan Ramanathan sathya0...@gmail.com javascript:; wrote: Dear All, Suddenly my Production site is down. I am getting the below message. Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2 Can anyone please help me on this issue. Thanks for your time help. Regards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS web site none does not exist issue
Dear All, I am getting this message IIS web site none does not exist ,When I try to add using Add Web Server configuration tool. In the drop down I am not able to see the website. https://forums.adobe.com/thread/693906 Thanks for your time help. Regards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue Solved - Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear Friends, Finally the is solved. Thanks Bobby Paul. While adding datasource in CF administrator , in server field I was wrongly trying as localhost, now I changed to MICRO\SQLEXPRESS as server and db name in database field along with check box checked for Enable High ASCII characters and Unicode for data sources configured for non-Latin characters. This solved the issue. Now am able to successfully connect CF9 with SQL server 2008 and Arabic text is displaying as well. Your valuable time help is really appreciated. Thanks, Sathya.R On Thu, Aug 7, 2014 at 10:34 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear Friends, Few days before I was trying to insert Arabic text into my ColdFusion application with oracle database. And finally it worked for me as I mentioned in previous mail chain below. *Steps taken:* *Oracle side:* I created the new database with NLS_CHARACTERSET as AL32UTF8 and imported my old exported database having different characterset. *CF side:* I added the below two lines at the top of the cfm template. meta http-equiv=Content-Type content=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 *Current Issue:* But now am facing similar issue with respect to insert Arabic text into my ColdFusion application with SQL Server 2008 database. *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in some table columns. But when I try to fetch display using CF even after adding charset in meta tag cfprocessingdirective as UTF-8 all Arabic text appeared as . But if I use charset as Windows-1256 static text in the cfm page such as column headers are coming as Arabic. But the fetched data from sql db still appear as ??? Please help. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF apps sudden performance issue - it's very slow
· Dear Friends, We noticed our ColdFusion application(CF9 server Oracle db) works differently every time. o For example, when we refresh a page the second time it comes faster. o When we connect to COLDFUSION APPLICATION server remotely and logged in with same user credentials it was working fine faster. But from user machine itâs very slow. o Also we found it works faster once we connect to COLDFUSION APPLICATION server remotely from the end user machine. But still we are browsing the site from user machine and not remote desktop server. Which means I think there might be some difficulty for the network to find the COLDFUSION APPLICATION server every first time when a page request happens. o Sometimes the COLDFUSION APPLICATION works fine when the PC restarted. o Sometimes the COLDFUSION APPLICATION works fine when we delete the browser history. · The application was stable for the past three years and no changes has been made. Suddenly for the past 3 weeks we are getting application slowness mails from users. We checked with our network team but nothing has been changed by them recently. · Please suggest me some tips that you might have used to increase the performance of CF application. Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue solved - To insert Arabic text into my ColdFusion application with Oracle database.
Dear Friends, Finally it worked for me. *Steps taken:* *Oracle side:* I created the new database with NLS_CHARACTERSET as AL32UTF8 and imported my old exported database having different characterset. *CF side:* I added the below two lines at the top of the cfm template. meta http-equiv=Content-Type content=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 But while saving the file using Dreamweaver I faced encoding problem. I followed the below steps to solve it. 1.Open the cfm template in dreamweaver and copy the above two lines into the top of the cfm template. 2.Goto Modify menu - page properties -Title/Encoding - Unicode(UTF-8) - Click Apply save the cfm template. Thanks all for your valuable time help. Really appreciated. *Sathya.R* On Sun, Jul 13, 2014 at 5:54 PM, Bobby bo...@acoderslife.com wrote: Your screenshots will not come through on the the list, you will have to put them online somewhere and send the links instead. As for the âEnable High asciiâ settings, my apologies, it doesnât appear to be available for oracle datasources. On 7/13/14, 9:47 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I have created a test oracle database with AR8MSWIN1256 as characterset. Also I created a test table with NVARCHAR2 (1000) as the datatype. Please see the screenshots below. [image: Inline image 1] *Test table:* [image: Inline image 2] *Simple insert statement using Toad for Oracle:* *[image: Inline image 3] * I am not able to find Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² as suggested by Bobby. I am using CF9. Regards, Sathya On Sun, Jul 13, 2014 at 3:52 PM, Bobby bo...@acoderslife.com wrote: In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
To insert Arabic text into my ColdFusion application with Oracle database.
Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
Dear All, I have created a test oracle database with AR8MSWIN1256 as characterset. Also I created a test table with NVARCHAR2 (1000) as the datatype. Please see the screenshots below. [image: Inline image 1] *Test table:* [image: Inline image 2] *Simple insert statement using Toad for Oracle:* *[image: Inline image 3] * I am not able to find Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² as suggested by Bobby. I am using CF9. Regards, Sathya On Sun, Jul 13, 2014 at 3:52 PM, Bobby bo...@acoderslife.com wrote: In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Restrict the user from editing the excel sheet exported using cfcontent tag.
Dear Friends, Is there anyway we can restrict the user from editing the excel sheet exported using cfcontent tag. Your time help is really appreciated. ThanksRegards, Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need help to configure SMS with CF application
Dear Friends, I have been provided with below details. I don't know how to configure SMS with CF application. Your valuable time help is really appreciated. SMS short code details: Action: Provide ShortCode: (4 digit no) Sender ID: Admin Throughput: 5 Classification: Normal SMS Connectivity details: IP address: Action: Provide Thanks, Sathya (sathya0...@gmail.com) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm