Skip to main content
P
plarts
Inspiring
May 14, 2014
Question

Processing on CF 9.0.0

  • May 14, 2014
  • 1 reply
  • 871 views

I wrote a process in Coldfusion treating more than 2000 Excel lines
- conversion to Access DB (using cfspeadsheet)
- deleting bad lines (cfloop)
- deleting again bad lines against an other DB (cfloop)
- then extracting suspect lines to transfer them a a new table (cfloop)
- then building a new table with the remaining good lines. (cfloop)

I built this on a local machine : Windows 7 (32bits) with CF9.0.2
It does work perfectly in 16 minutes.

I said to my client, I does work.

Then I upload this to my server : Windows 2008 server and CF 9.0.0 (64bits)
And then a lot of problems :
- cfspeadsheet does not work the same :
  it does nor recognize "excludehearrrow" ,
  it add double quotes in some fields.
  I modify my programs to get a solution to these.
- the CFflush does not work the same, it does not display data after the 1st loop.
- The process time is much more monger on the server (for a limited rows, 800)
- When running with all rows, it never ends on the server (no error message)
  Then a page (page cannot be displayed), access DB remain with a lock.
  I have to stop/start the CF server to unloak.

Very desapointed. I will have to say to the client, IMPOSSIBLE.
Or set up a PC at your home.
Why working perfectly on the local environnement ?

Any suggestion, help will be welcome.

Pierre.

    This topic has been closed for replies.

    1 reply

    P
    plartsAuthor
    Inspiring
    May 14, 2014

    As I cannot edit my message, I make a first reply :

    While processing, other sites have difficulties to access the datasource.

    Error messages received : (even if it is bots,same for humans)

     

    Date : 14-mai-2014  14:24:18
     Erreur sur page :     /vente/vente_show.cfm
     Query string :     rub=6
         Diagnostic :
     Error Executing Database Query. Timed out trying to establish connection
    The error occurred on line 205.
         IP adresse : 66.249.75.195
     Visiteur non loggué.
     Provenance (http_referer) :
    Navigateur : Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)


    Any idea, how to prevent this ? Is this a server parameters question ?

    Thanks for any help.


    Pierre.


     

    Anit_Kumar
    Anit_Kumar
    Inspiring
    May 14, 2014

    Hi Pierre,

    It seems from the description, that the change from 32-bit to 64-bit has caused some unexpected behavior. Check the access and permissions on the file system and DB. Try to verify the datasources and see if that helps.

    Also, did you look at the ColdFusion logs. There should be entries for all the exceptions.

    Regards,

    Anit Kumar

    P
    plartsAuthor
    Inspiring
    May 14, 2014

    Thanks for help.

    If I loop on limited rows (exemple : 1200)

    It works (But other sites have exceeded time to access the datasource)

    If I loop on all rows (more than 2000) it never ends. i have later "page cannot be displayed"

    and finished with a lock on all mdb files (used by the process).

    The datasources are OK.

    access and permissions are OK because all is working with small amount of rows.

    Thanks for any help.

    could it be a CF9 problem ?

    or 32/64 bits problem ?

    or Server/iis7 problem ?

    Does work fine on local.

    Pierre.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices