[progress Communities] [progress Openedge Abl] Forum Post: Stale Schema Failure During...

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
Anyone know what this means in an appserver log: [17/06/03@19:20:39.422-0400] P-005396 T-005812 1 AS -- (Procedure: 'UpdateHeader app/Maintenance/AppServer/Maintenance.p' Line:401) RAW-TRANSFER statement failed due to stale schema for table 'my_rec_hdr'. (11425) I getting this message consistently for about an hour from a state-reset appserver. The appserver agent in question was connected to a database over a client-server connection. Interestingly, google has no hits on the error message yet. So I suspect I must be doing something very unusual (ie perhaps I'm using some obscure part of the progress/openedge product). The problem mysteriously started happening after I made an online schema change - I added a column to a table. I even bounced the entire broker and all its agents a few times and the problem would not go away. It was very reproducible. Then I switched to a shared-memory connection (instead of client/server) and ran the same code and everything worked. I went back to review the client/server repro again, in order to try to gather more details and possibly submit a bug.... but the problem mysteriously vanished once again from my client/server scenario. It would almost seem like a bug in a client/server database connection that is "flushed out" by accessing the same schema via an unrelated shared-memory client. I am somewhat new to using client/server connections with ABL. But I was made to believe that this is a well-supported way of using Progress. My understanding is that, while the performance is worse than shared-memory clients, we should not be seeing with a different set of bugs in the platform. Please let me know if anyone has encountered this. I'm not sure if I should stop using client/server or if I should stop making online schema changes. OE wasn't happy about one or the other of these, and I'm not sure which. I'm using OE 11.6.3 on Windows.

Continue reading...
 
Status
Not open for further replies.
Back
Top