Search results

  1. J

    BROKER: Could not spawn a server. (1890)

    HI All, Today we received below application connectivity error. Broker : Could not spawn a server. (1890). For 5 mins users are able to connect to application after few mins they facing the same. Can i know reason during which situation we will face this error.Please provide your inputs. I...
  2. J

    Table access

    Thanks Rob for your suggestion will do the same..:)
  3. J

    Table access

    Thanks Rob.. Error we are receiving on below highlighted filed. Before doing it we will test in test server. Please suggest what value we can define and also can we do it when users using this table.
  4. J

    Table access

    HI Rob, thanks for information.. i'm able to generate your query and it helped me alot. After that we have provided access for below table but when we run below select command it showing an error. As per progress knowledge base it stating "to avoid errors from data in a field exceeding its SQL...
  5. J

    Table access

    HI Team, We have Progress Database which is running on 9.1e version. Today we have received incident where user dont have access to vo_mstr table while they are connecting from SQL explorer tool they facing "Access Denied error". We checked using below command they dont have access to table and...
  6. J

    QUICK Help : Shared memory utilization

    We don't have vendor supportand also we checked with vendor they are out of support for 9.1e version. Can I reboot the server to fix this issue
  7. J

    QUICK Help : Shared memory utilization

    Database went down and quckily restated database. I found in 9.1e doc during this issue we need to release shared segment to free up the memory using ipcrm -m id
  8. J

    QUICK Help : Shared memory utilization

    Hi Rob Wht action we need to take. For all database in promon shared memory segment it showing used full.
  9. J

    Wrong port identified

    Thanks Rob, we will change accordingly BEFORE that I have doubt, portno's which I mentioned are oracle database port no's but how it is connecting to that port without we are defining any port range in secondary broker.
  10. J

    Wrong port identified

    HI All, During monitoring we have identified below ports are using by _Sqlsrv process but in Promon > R&D > 1 > 3 > in Curr users filed it is showing zero. But we found sql process running on server. Anything we need to change on parameters. What went wrong here? ps -ef | grep _sqlsrv2 | wc...
  11. J

    Limit User connection

    HI ALL, I would like to know whether we can limit user connections to database. We had defined 1000 connections can be made. Database version is old & ancient 9.1e And also we are using mfg/pro application 8.6d version. Is there any way we can limit a particular user connections on database?
  12. J

    4gl Brokers

    Sorry Rob wrongly attached other database.please find below Activity - Sampled at 11/14/17 11:13 for 9:14:24. Event Total Per Sec Event Total Per Sec Commits 363 0.0 Undos 0 0.0 Record Updates 44...
  13. J

    4gl Brokers

    HI, I would like to know how may 4Gl servers are connected to database. Please find attached screen shot for number of users and server process list. To avoid 748 error we are planning to monitor 4gl connection count from promon or using vst. Please let me know how to find this count. Version...
  14. J

    Backup Is Very Slow.

    Thanks .... For us OS version AIX 5.3 support has been ended with IBM. On 1st day 83GB it taken 5:30 hours On yesterday for 83GB is taken 2 hours Today for 83GB it is taken only 1:30 hours. As cecil said may be we have issue with storage drives may be.
  15. J

    Backup Is Very Slow.

    Thanks Rob... Is this new? Were backups of this size previously fast and now slow, or have they always been slow? No Production box it is taking only 15 mins to take backup but in test server it is taking so much time. What do you know about the type and configuration of the storage hardware...
  16. J

    Backup Is Very Slow.

    Hi, I created test databases as per application team request.Before releasing these databases i have taken offline backup .But for larger databases backup is running for very long. Can i know reason why backup is running for long. for Ex: Database size is 65GB. To take offline backup it is...
  17. J

    No Sql Server Are Available.

    HI team, Today we faced below issue during that time database and application are up and running fine. Data stage team are connecting to our database they found this error on their jobs log. Error: J_aps_rey_ps_mstr..TR: |J_aps_rey_ps_mstr..PS_MSTR: DSD.BCIConnect connecting to REY, call to...
  18. J

    Server Or Has No More Resources

    How to set -Mpb startup parameter? if i want to setup new connection for 500 users.Can i set the parameters as below. -n 500 -Mn 100 -Ma 5 -Mi 1.
  19. J

    Server Or Has No More Resources

    Thanks Tom for info. I have checked all this conditions we are good Error 748 can be caused when: the -n setting is not high enough, the kernel parameters for semaphores might not be set correctly, === We not checked this kernel parameters. the services file might not be set up properly, or...
  20. J

    Server Or Has No More Resources

    Hi All, We had issue with our Mfg/pro application "server has no more resources" .Database is up and running fine but application we are not able to connect. Some times user able to connect to application for 5 mins after that we are receiving same issue. In promon it shows user 108 users...
Back
Top