Announcement

Collapse
No announcement yet.

Scriptcase V7 hangs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Scriptcase V7 hangs

    I have Scriptcase V7 but here lately has been starting to hang up and does not respond or takes too long to respond, example: Editing an existing form and wanting to navigate from the main page to the Application/Settings to check on the database connection. When I click on Settings nothing happens, when I click on some other menu item Scriptcase does not do anything.

    I have not upgraded from V7 to V7.1 I don't know how and I don't know if is a good idea or not.

    Can someone tell me what I need to do to upgrade from V7 to V7.1??????

  • #2
    To upgrade you don't have to do a thing except going to the menu and run update. SC does hang now and then and that useually has to do with the apache webserver stack. Within services you can restart this apache service and in my case issue is solved then. I'm shortly over to SC7.1 and it hasn't happened yet, so can't tell if this is specific to 7.1 and if this is the same issue. But it's worth a try.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      I still have the problem after stopping/starting apache server so that is not the problem.
      I was able to change the connection on a grid from the bad connection to one that works.
      I thought I could just access the "linked form" and change the connection there but ScriptCase plain freezes up and does not come out of the freezer!!! I have to shut ScriptCase.
      I think the problem is that when "I open the form for editing" ... ScriptCase is trying to "MAKE A CONNECTION" to the database at that time and should not be trying to make a connection when opening a form for editing it has been 3-DAYS and still, can't open the SQL to change the connection..

      Comment


      • #4
        Hello,

        It can be something related to your SC installation getting corrupted. To solve that you could do a manual update.

        Or it could be something related to your web server. Checking a few directives such as memory_limit, max_execution_time may help you to solve the issue.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Restart Service 5 Times a Day

          Originally posted by bartho View Post
          Hello,

          It can be something related to your SC installation getting corrupted. To solve that you could do a manual update.

          Or it could be something related to your web server. Checking a few directives such as memory_limit, max_execution_time may help you to solve the issue.

          regards,
          Bernhard Bernsmann
          Hello I'd already done this: Manual Update, memory_limit, max_execution.
          But Believe Me I'm Reestarting the service about 5 - 7 Times a Day. How can I avoid reestarting the ApacheService71 everytime

          Windows Server 2003 R2
          Ms Sql Server
          This is my diagnosis:

          Diagnosis
          Environment
          OK PHP: 5.4.20
          OK Hostname: sxxx-abcder54e
          OK Zend: 3.3
          OK OS: WINDOWS NT sxxx-abcder54e 5.2 BUILD 3790 (WINDOWS SERVER 2003 R2 ENTERPRISE EDITION SERVICE PACK 2) I586
          OK WEB Server: Apache/2.4.3 (Win32) mod_fcgid/2.3.7
          ScriptCase Devel:
          ScriptCase Build:
          ScriptCase Prod: 7.1.019
          Databases
          OK COM
          Problem DB2
          OK InterBase
          Problem Ifx
          Problem Informix
          OK MsSQL Server
          OK MsSQL Server SRV
          OK MySQL
          OK ODBC
          Problem Oracle 8
          Problem Oracle
          OK PostGreSQL
          Problem SQLite
          Problem SyBase
          OK PDO MySQL
          OK PDO PostGreSQL
          OK PDO SQLite
          OK PDO MsSQL Server
          Problem PDO Oracle
          OK PDO Firebird
          Problem PDO Informix
          Extensions
          OK ZLIB
          OK GD
          Environment 2
          OK php.ini PATH: C:\PROGRA~1\NetMake\v71\components\php\php.ini
          OK zend_optimizer.license_path: SEM ARQUIVO
          OK ScriptCase write permission
          OK Session write permission
          OK Internet Access - Socks
          Problem ZendId execute Permission
          OK ZendId MD5:
          OK Popup: OK
          OK GD - 2.1
          OK C:\Program Files\NetMake\v71\wwwroot\xxxxxxx\_lib
          Thank's in advance!
          Best Regards!
          Last edited by ddefrain; 04-10-2014, 09:16 PM.

          Comment


          • #6
            Try running the apache service as a user with more rights. It may be that the user under which it runs doesnt have enought rights (e.g. using internet).
            Go to services, choose ApacheScriptcase71, choose the Log On tab and change from Local System account to This account and enter an account name with more rights...

            Comment


            • #7
              Thank's for the reply rr I will try this one. And let you know if this one helps.
              Best Regards!

              Comment


              • #8
                ...I'd already start the service as Administrator and the problem persists, I have to reestart the service about 5 times a Day.
                It's annoying.
                When a third-fourth user connects to the server "online" after about 30 minutes the server hangs, and then I need to reestart the service.
                What else can I do? , please help me!
                Best Regards!

                Comment


                • #9
                  Grab the sysinternals tools and open procexp (as administrator) on your server. Then look at the processes, you will easily recognize your scriptcase server there. It will have started several php-cgi sub processes. Then do your work and see what happens with those php-cgi processes. Are there a lot more coming that are not disappearing after a while? Is the memory increasing drastically?

                  We are running on server 2008 R2 here with a service under another username for us it goes fine, so I suspect that it still is some rights issue. You could try to fiddle with the php.ini in from scriptcase (keep your original). I have increased a few values for timeouts here and there.

                  Comment


                  • #10
                    Thank's for the reply.
                    When I'd installed Scriptcase I'd changed the port to 3387, and then open it for internet access. It might be the problem? (Changing the port I mean).
                    I will check the procexp tool, I'd already check the task bar windows window and yes there are a few php-cgi sub processes that does not disappear after a while(when I stop the service, I kill them manually, then I start the service), first I will check the procexp(if memory increases, that I think this would not be the problem 'cause the server have 9GB of memory), and then fiddle with the ini file.
                    Best Regards!

                    Comment


                    • #11
                      Changing the port shouldnt really be an issue, that is just a setting in your apache config. The only issue that exists if that that port could be used by something else on occacion (use TCPVIEW.EXE from sysinternals to check).
                      The server has only 9M of memory? That is way too low. I guess it starts swapping like crazy then as well since it will try to use more memory and hence swap memory in and out. That indeed makes it go very very slow after some time (we had that with version 6, so the memory on the virtual machine was increased).
                      You should check out (use procexp or the standard taskman) how your memory useage is with more detail. For our version 6 we had more then 8 dll's hanging around and becoming slower and slower. Since increasing memory helped, I hope it helps for you too..

                      Comment


                      • #12
                        Originally posted by rr View Post
                        Changing the port shouldnt really be an issue, that is just a setting in your apache config. The only issue that exists if that that port could be used by something else on occacion (use TCPVIEW.EXE from sysinternals to check).
                        The server has only 9M of memory? That is way too low. I guess it starts swapping like crazy then as well since it will try to use more memory and hence swap memory in and out. That indeed makes it go very very slow after some time (we had that with version 6, so the memory on the virtual machine was increased).
                        You should check out (use procexp or the standard taskman) how your memory useage is with more detail. For our version 6 we had more then 8 dll's hanging around and becoming slower and slower. Since increasing memory helped, I hope it helps for you too..
                        Sorry rr I do not post 9M check again it says 9GB.
                        I will try the TCPVIEW, thank's for the tip.

                        Comment


                        • #13
                          Hello rr
                          After reading a little bit I finally modify the following values at http.conf
                          Scriptcase Installation
                          KeepAliveTimeout 50
                          MaxKeepAliveRequests 500

                          I'd modified/replaced with:
                          KeepAliveTimeout 2
                          MaxKeepAliveRequests 1000

                          Why I'm I doing this?
                          'Cause I had a Refresh Interval Grid every 20 Seconds. So I incremented (the refresh interval) to 60 Seconds

                          ..and this little one KeepAliveTimeout 2 would kill the connection every 2 seconds. (for another attempt and so on).
                          The Scriptcase KeepAlive http.conf has 50 seconds to kill the connection and the server hangs That's what I think

                          Source:
                          http://systemadmin.es/2008/11/conexi...live-de-apache

                          I would do some tests and post again if this solves my problem, and to others who have the same problem as mine
                          If this is not correct, would you please put me in the right direction?

                          Best Regards!

                          Comment


                          • #14
                            Hello all!
                            I'm still having problems with the server hangs
                            I'm reestarting the service about 10 times a day, please where or who can check my problem?.
                            Thank's
                            Best Regards!

                            Comment


                            • #15
                              Ok this is odd, we had server hangs in development with an old version too. That seemed to occur because the dll's were too long in memory (as in the php dll was taking up about 1G of memory space for each instance).
                              Check out with processexplorer (from the sysinternals suite) on your server how it looks like on your situation.
                              Please check out how much memory your loaded dll's are using and how many dll's are loaded. It is is lots (several G ) then check out whether the dll's are released. Because they should be.
                              At least then you may get an idea what is happening. Not that this is the solution yet tho. You would then need to find out why the memory isnt released again.
                              In our deployment it all runs fine as it is...

                              Comment

                              Working...
                              X