Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

GDS Exception in Fyracle

ub-dmb
2006-06-07
2013-05-02
  • ub-dmb
    ub-dmb
    2006-06-07

    Hi,
    I have set up Compiere 253a with Fyracle 0.8.10 database and I get this error when try to delete a record from Compiere:

    "Could not delete record: GDS Exception 335544361: attempted update during read-only transaction.

    any idea? thanks

     
    • PAscal
      PAscal
      2006-06-07

      Could you tell us wich action / screen generates this behavior ?

      I invite you to open a thread in fyracle forum at
      http://www.fyracle.org/thread.php?group=fyracle
      for a quicker resolution

      Regards
      PAscal

       
    • ub-dmb
      ub-dmb
      2006-06-09

      If I try to delete a record from any Compiere table (M_Product_Category for example) it works fine.
      If I try to delete a record of the TESTING table from the Fyracle pl/sql console it works fine too.

      The DDL I used to create the TESTING table is:

      CREATE TABLE TESTING(
          TESTING_ID NUMBER(10) NOT NULL,
          NAME VARCHAR2(30) NOT NULL,
          AD_CLIENT_ID NUMBER(10) NOT NULL,
          AD_ORG_ID NUMBER(10) NOT NULL,
          CREATED DATE NOT NULL,
          CREATEDBY NUMBER(10) NOT NULL,
          UPDATED DATE NOT NULL,
          UPDATEDBY NUMBER(10) NOT NULL,
          ISACTIVE CHAR(1) NOT NULL
      );
      ALTER TABLE TESTING ADD CONSTRAINT TESTING_PK PRIMARY KEY (TESTING_ID);
      CREATE UNIQUE INDEX TESTING_NK ON TESTING (NAME);

      ... and this is the log of the error when I try to delete a record of this table from Compiere:

      15:50:31.890 APanel.actionPerformed: Delete - 16 [11]
      15:50:31.890   AWindow.setBusy: AWindow_1000000 - true [11]
      15:50:31.906 ADialog.ask: DeleteRecord? - null [11]
      15:50:33.531     MTab.dataDelete: #0 - row=0 [11]
      15:50:33.531 MTable.dataDelete: Row=0 [11]
      15:50:33.531           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.546           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.546           DB.getConnectionRO: #0 - org.firebirdsql.jdbc.FBConnection@968fda [11]
      15:50:33.546         M_Table.load: ID=1000000 [11]
      15:50:33.546         M_Table.load: AD_Table_ID=1000000 [11]
      15:50:33.546           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.562           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.562           DB.getConnectionRO: #1 - org.firebirdsql.jdbc.FBConnection@11756a4 [11]
      15:50:33.562         M_Table.load: (rs) [11]
      15:50:33.593         M_Table.getPOclass: Not found: compiere.model.MTESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: org.compiere.model.MTESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: org.compiere.wf.MTESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: org.compiere.print.MTESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: org.compiere.impexp.MTESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: compiere.model.X_TESTING [11]
      15:50:33.609         M_Table.getPOclass: Not found: org.compiere.model.X_TESTING [11]
      ===========> M_Table.getPO: (rs) - Class not found for TESTING [11]
      15:50:33.625           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.625           Secure.decrypt: d504ada4fe01fe9b => N [11]
      15:50:33.625           DB.getConnectionRO: #0 - org.firebirdsql.jdbc.FBConnection@968fda [11]
      ===========> MTable.dataDelete: DELETE TESTING WHERE TESTING_ID=1000000 [11]
      org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544361. attempted update during read-only transaction; State=HY000; ErrorCode=335544361
          at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:503)
          at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:144)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:585)
          at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
          at org.firebirdsql.pool.$Proxy3.executeUpdate(Unknown Source)
          at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
          at org.compiere.model.MTable.dataDelete(MTable.java:2233)
          at org.compiere.model.MTab.dataDelete(MTab.java:797)
          at org.compiere.apps.APanel.cmd_delete(APanel.java:1251)
          at org.compiere.apps.APanel.actionPerformed(APanel.java:1144)
          at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:211)
          at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
          at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
          at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
          at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
          at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
          at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
          at java.awt.Component.processMouseEvent(Component.java:5488)

      ===========> MTable.saveError: DeleteError - GDS Exception. 335544361. attempted update during read-only transaction [11]
      15:50:33.687     MTab.dataStatusChanged: #0 - DataStatusEvent - DeleteError GDS Exception. 335544361. attempted update during read-only transaction :  0/2 [11]
      15:50:33.687     MTab.fireDataStatusChanged: DataStatusEvent - DeleteError GDS Exception. 335544361. attempted update during read-only transaction :  1/2 [11]
      15:50:33.687   GridController.dataStatusChanged: (MTab #0 Testing (1000000)) Col=0: DataStatusEvent - DeleteError GDS Exception. 335544361. attempted update during read-only transaction :  1/2 [11]
      15:50:33.687   GridController.dynamicDisplay: MTab #0 Testing (1000000) - Rows=2 [11]
      15:50:33.687         MField.isEditable: AD_Client_ID NO - TabRO=false, FieldRO=true [11]
      15:50:33.687         MField.isEditable: AD_Org_ID NO - FieldUpdateable=false [11]
      15:50:33.687   GridController.dynamicDisplay: MTab #0 Testing (1000000) - fini - complete [11]
      15:50:33.703 APanel.dataStatusChanged:  1/2 [11]
      15:50:33.703     APanel.setStatusLine: Could not delete record: GDS Exception. 335544361. attempted update during read-only transaction [11]
      15:50:33.703 ADialog.error: DeleteError - GDS Exception. 335544361. attempted update during read-only transaction [11]

      *** 2006-06-08 15:51:25.093 Compiere Log (CLogFile) ***

      Thanks

       
      • PAscal
        PAscal
        2006-06-12

        Could you specify from which screen you try to delete, and which setup has been used for it

        Regards
        PAscal