Search results

  1. D

    OER D/L

    Hello All, Can we do dump and load on OER server and later-on apply the same on live server, below activities are for the same: Dump and load database on OER server (including type conversion). Stop Live DB after dump/load completed and apply all live ai (al-roll forward) files on OER server...
  2. D

    How Many APW’s

    Dear All, How many APW’s we should have with a database? Our database size is around 800GB and currently we have 12 APW’s running. As per below Promon activities, writes by APW seems fine but rest values should be lower (I think). Writes by APW 99 % Buffs Flushed...
  3. D

    Error 1124/4229

    Hello All, We have been getting error 1124 and 4229 in the database logs and sometimes client got this error when running the application (QAD menu option). After facing of this issue, database won’t shut down and everything works fine. Backup of this database is also fine (we restored this...
  4. D

    Error 1124/4229

    Hello All, We have been getting error 1124 and 4229 in the database logs and sometimes client got this error when running the application (QAD menu option). After facing of this issue, database won’t shut down and everything works fine. Backup of this database is also fine (we restored this...
  5. D

    Appserver Hangs

    Hello All, Users were facing error 3244 very frequently (3-4 times in two weeks) when opening .NET UI and were not even able to see menu structure after clicking this error message. Below are the error messages that we found in Appserver Logs: P-094746 T-2959914784 1 AS -- Failed to create...
  6. D

    -n Exceeded

    Hello All, We have one cron job running in every 15-20 seconds and this cron is setup/associated via qad menu..each time this cron runs it calls a .p program...but here whenever this cron runs, it increases number of user sessions and exceeded -n. I think, every time cron runs will open the...
  7. D

    Question Bi Hwm/logical Size

    Hello All, I want to know the exact size of BI file (not physical). For ex: If BI file size is 7 GB and we disconnect the user with long running transaction from long time then the BI file size still remains 7 GB but actual/logical size of BI should get decreased to some value. I have gone...
  8. D

    Error (3712) System Error: Mtlatch 3, Holding 0x40

    Dear All, There are some programs which are constantly locking each other and for solving this problem someone has written a program (currently I don’t have that program) that polls the _Lock table to see in advance if there will be a locking problem ahead of time. This program runs fine for...
  9. D

    Question How To Run Qad .net Client On Oer Server

    Hello All, We have one live server and one OER server and this OER server has been created by syncing required QAD and progress files from live to OER. Once live server goes down, we shut down OER server and run it as replication source. After doing so, CHUI (putty client) works fine on OER...
  10. D

    How To Run Qad .net Client On Oer Server

    Hello All, We have one live server and one OER server and this OER server has been created by syncing required QAD and progress files from live to OER. Once live server goes down, we shut down OER server and run it as replication source. After doing so, CHUI (putty client) works fine on OER...
  11. D

    Semadd Semaphore Error When Starting Database (replication Target)

    Hello All, I am getting below semaphore error when staring database. I have gone through couple of articles for this but unable to resolve this issue. 09:28:59 BROKER The startup of this database requires 94Mb of shared memory. Maximum segment size is 1024Mb. 09:28:59 BROKER 0...
  12. D

    Type1 To Type 2 Storage

    Dear All, Kindly help me regarding below concerns of mine: 1. Under “Type-2”, database and index should have same area or should be different for data and index (as in type-1). 2. What all tables schema area should contain, only VST tables? 3. How do I convert type1àtype 2...
  13. D

    Unable To Access Data From Multiple Tables - 2016ee

    Hello All, ODBC User with QAD2010SE version is able to access data from multiple tables at once but with QAD 2016EE version, whenever user tries to access data from multiple tables, connection lost with message “Broker rejects connection”. Please suggest. Regards,
  14. D

    Fathom Not Working.

    Hello All, Admin server is working fine on UNIX server but I am unable to start Fathom. I am getting below message when trying to start fathom with fathom –start Fathom -start Fathom can not be started. (9681) Fathom status: Initializing (9670) Linux Version: Linux 2.6.18-398.el5 x86_64...
  15. D

    Getting Error 293 When Deleting Records Of Code_mstr

    Hello All, I am trying to delete records of code_mstr table (QAD) but getting below error message. FOR EACH code_mstr EXCLUSIVE-LOCK: DELETE code_mstr. END. Error: ** "coderd.t" was not found. (293) I wanted to do that for loading new .d file of code_mstr table. Kindly help asap. Regards.
  16. D

    Seeking Solution After Bi Alert

    Hello Everyone, I have few below mentioned quires regarding BI files. I have shared these after going through couple of articles/discussions. · Is it possible to add bi extent online if last bi extent is variable or fixed length without -bithold –bistall startup parameter? Or can we...
  17. D

    Type-1 -> Type-2 Conversion/creation

    Hello All, I am a bit confused with type-1 to type-2 conversion/creation. Please check below for the same: 1. If we take full back-up of type-1 database and restore it over type-2 structure file (new created structure file from type-1 structure file, number of database blocks is 8) then...
  18. D

    Question Odbc Rights

    Hello All, I want to create one user in _user table for odbc access and want to grant permissions similar to one existing user. Example:- One user "cust" has read/write permission on multiple tables, now I want to create one new user and want to give similar rights like cust user. Is there...
  19. D

    Question Live & Oer Connection Issue

    Hello All, We have one Live production server and one OpenEdge replication server. If connection fail between Live (Source) and OER (Target) server because of ERROR: - “(12688) The Replication Server has been terminated or the Source database has been shutdown. The Agents will enter...
  20. D

    Progress Db -- Odbc -- Sql Client

    Hello all, hope you all are doing well!!! This post is regarding Progress database access through SQL client. As per my knowledge, when we want to give access of a Progress database table to SQL user then we create one user (in _user) with sysprogress userid and grant access. I have been...
Top