Search results

  1. B

    How to find out if record is locked

    I know that i should not use that system table and i know that there are performance issues. My question was how to find out by SQL if the record is locked by another transaction. I need to know, when the update fails by the Apache side in order to display that to the user. On our error lock...
  2. B

    How to find out if record is locked

    Hello community, by a PHP Application i want to update a dataset inside a Progress-Table, that is working generally. But it is possible to work on the same dataset inside our EPR-System that locks the dataset. Now when i want to update the dataset this i get this error. SQL error...
  3. B

    On Clause Outer Join Predicate

    "ON clause outer join predicate" contains invalid column reference. (12480)" Really? Progress doesn't really mean that. SELECT A.Firma, A.PP_Auftrag_Obj, A.Auftrag, A.AuftragsStatus, ( CASE WHEN A.BelegNummer != 0 THEN A.BelegNummer ELSE...
  4. B

    Broker Rejects Connection

    Now i found the -Mn and -n parameters. ProAplha has a tool where we can edit these parameters. How we solve the problem that the broker will not detect dead server? Errormessage "BROKER entdeckte toten Server" ( "broker detects death of server" ) Where this error comes from? With SQL-Statement...
  5. B

    Broker Rejects Connection

    Can you tell me how to find the table _Connect or how to find out how many records are in there. Where is the value -n is defined? Our OpenEdge Version: 11.3.02.000 1333
  6. B

    Broker Rejects Connection

    Hello Community, we have written an application where we are connecting to a progress database via ODBC and SQL. On the other side there is running an proAlpha application. Our application is written in PHP and is running an a Debian Linux Server. When we are executing a SQL statement...
  7. B

    Failure getting record lock on a record from table

    Our apache webservice is running on a linux debian server. So i can not change anything on any registry. I just have the odbc.ini
  8. B

    Failure getting record lock on a record from table

    Hello Community, we have an intranet website written by PHP. There we are using the odbc interface. Next to this website the customer is working with ProAlpha. During the select statements these error messages are occurring: [Mon Jul 20 11:48:13 2015] [error] [client 192.168.50.207] PHP...
  9. B

    Error Message Ung

    I got the following error message: SQL error: [unixODBC][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Ung, SQL state S1000 in SQLExecDirect Can anyone tell me, what this message means?
  10. B

    Error Error "SQL state 60"

    Hello Community, I have a php application which opens a database connection. The code looks like this and is working fine. $strDSN = "progress_test01"; $strUsername = "user"; $strPassword = "xyz"; $_SESSION [ 'odbc_connect_01' ] = odbc_connect( $strDSN, $strUsername, $strPassword )...
Top