Search results

  1. Mike

    Long running transaction by a user and his activity code

    Hi all, I have a question about long running transactions of database by using R&D and active transaction. We always having transaction number like below:- 45 Rxcm -4 SELF/ABL 06/03/25 08:27 06/03/25 13:20 1746518328 Active But it is not giving complete info like what...
  2. Mike

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

    1:- We have progress version 11.2 and OS version :-Hp-UX Yesterday there was an issue with database or server . User not able to connect database ERP CHUI mode and showing black screen. We login to the server and went to the db path where we see .lk file exist .We tried to do Promon and db and...
  3. Mike

    Error Connections exceeding.

    Hi, We have a situation where sql connection exceeding. User complaining about connection exceeding. With error in db log file:- :00:04.200-0600] P-3750 T-140117189777216 I BROKER 1: (8839) No SQL servers are available. Try again later. [2024/11/06@13:54:28.711-0600] P-3750...
  4. Mike

    Question Need to update open edge version 11.7.9 to 11.7.20

    Hi Tom and Team, We need to update the open edge version 11.7.9 to 11.7.20service installation pack because of security issue and fixes. Os = Linux Can you please tell me steps in detail? Does in impact on existing version? Will it overwrite in existing version? How can we test this? Please...
  5. Mike

    Error Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available

    Hi Tom and team, Progress version:- 11.7 OS :- Linux Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available 2024/08/26@14:27:25.990-0500] P-3750 T-140117189777216 I BROKER 1: (8839) No SQL servers are available. Try again later...
  6. Mike

    Error Unable to start app server.

    Hi Team, We are getting error while starting App server: Progress version:- 10.1B OS =Linux Error below:- plug-in of type: com.progress.ubroker.tools.UBCommandPlugin (Aug 14, 2024 02:40:32:153) dev_fg_AS is not responding to ping (8307). Thanks and Regards Mike
  7. Mike

    Question Way to delete records of table from database? (DBA related query using and utility)

    Hi Tom Team, We had a situation where we had an urgent need purge (delete records of 1 year old ) from a database table. Progress version 11 and linux platform.We called the programmer to write the code and delete the records of 1 year of table. We took backup of table .df and .d of table and...
  8. Mike

    Conversion.

    Hi, OS version:- HPUX Progress version :- 9.1d with 32bit and 64 bit We have two database with different version one is 9.1d 32bit and another is 9.1d 64bit .I have some doubts:- Q1:- what are difference between 32bit and 64bit ? Is it coz of performance aspects? Q2:- Can we convert 32 bit...
  9. Mike

    We need to use test server and test databases as a prod.

    Hi , Tom/team, Progress version:- 9.1d 32 bit and 64 bit Os version:- HPUX application version:- Eb2 sp4 qad mfg/pro We have one test server for two databases. I mean its a different test server where we have two test databases same as production and they are refreshing every week from prod...
  10. Mike

    Progress installation Java version

    We are going to install progress 9.1d in server OS version:- Linux 2.6.9-55.ELsmp #1 SMP x86_64 x86_64 x86_64 GNU/Linux Progress version need to install :- Progress 9.1d which java version we required for Please guide me which Java version is suitable for above Linux version? How we install...
  11. Mike

    Question 32 bit and 64 bit progress 9.1d version doubt

    We have server where we installed progress 9.1d version 32bit and 64 bit on same server: - 1:- 32 bit :-/progress9/dlc/bin and 2:- 64bit :- /progress9_64/dlc/bin So my question is which is better version 64 bit or 32 bit and what is the difference between. And in aspects of shared memory...
  12. Mike

    Appserver agent are busy and stuck.

    We got monitoring system this morning that the Qxtend inbound port was not responding to queries. We were also receiving transaction failures from boomi that were related. Upon investigation, I discovered that all of the available appserver for topro_as were busy. This was confirmed by running a...
  13. Mike

    Sysprogress user

    Hi, Just want to know what is the use of Sysprogress database user in progress ?Is this unix user? Or mfgpro user ? Suppose if I have Sysprogress data baad user so what is the use and how to login ? Can you please explain me use of this? Thanks and regards Mike
  14. Mike

    -n value maximum number of user

    Hi Team, Progress version :-9.1d Os version:-Hp/aux What will the maximum number of user -n limit to connect database? Is there is any limit ? How many maximum users we can define in db startup -n? Thanks and regards Mike
  15. Mike

    Pro2sql User guide need help

    Hi Team, I am newbie for pro2sql .Can anybody help me to get pro2sql all documents that how it works :- 1:- How we add tables via pro2sql and threads 2:- How to configure? Please I need full guide of pro2sql. I cant see any useful documents for pro2sql.Please guide. Thanks and Ragards Mike
  16. Mike

    Database migration to different server (lift and shift)

    Hi Team, We have progress database 9.1d in one server Os version:- HP-UX. We are planning to shift this all database to Linux red-hat Os version server. So can you please give your suggestions if it is possible or not if yes so what will be the steps. 1:- Can we move all OS HP-UX copies and...
  17. Mike

    Question Need AI reorder or not? Please clarify.

    Unix envisronment :-HP-UX Open edge version:-Open edge 11.2 Db size :- 40 GB DB blocksize :- 8192 AIMGT = enable and archiver enabled ai interval= 36000 Daily offline backup after that Db starts with archiver directory. we have 4 ai(after image extents) .I want to add more 4 extent with same...
  18. Mike

    Question Urgent Need to find RCA.

    Server :- HP-UX Openedge version: - 11.2 We had a situation where all AI files become full and AI demon was in hung state. We tried make empty full ais but does not work, Db had down. So we re-boot the server. and got date time mismatch. Db got corrupt after re-boot or before no idea.Seeking...
  19. Mike

    Question Convert progress 9.1d05 database to sql database.

    Progress version:- 9.1d05 Unix version:- HP AIX My question can we convert 9.1d05 database to sql database? do anybody analysis on how to Progress DB converted to SQL DB? If it's not possible: - do we have any doc that tells progress 9.1d05d will not be supported? If yes, please tell me the...
  20. Mike

    Question Convert progress 9.1d05 database to sql database.

    Progress version:- 9.1d05 Unix version:- HP AIX My question can we convert 9.1d05 database to sql database? do anybody analysis on how to Progress DB converted to SQL DB? If it's not possible: - do we have any doc that tells progress 9.1d05d will not be supported? If yes, please tell me the...
Back
Top