Home » Developer & Programmer » Forms » forced rollback in forms 6i but working fine in forms 5
forced rollback in forms 6i but working fine in forms 5 [message #77885] Fri, 07 December 2001 05:26 Go to next message
chirag shah
Messages: 4
Registered: October 2001
Junior Member
hi

I am facing one problem with developer 6i
In our organisation We are using forms 5 and 6i both.
While we are able to do transaction using forms 5 we are not able to do so in 6i
here is the list of errors we get:-

FRM-40508 : Unable to insert record
FRM-40655 :SQL Error;Forced Rollback;Clear Form and re-enter transaction
ORA-03113: end-of-file on communication channel

INSERT INTO STR_GRN_D1) VALUES ) RETURNING ROWID,GRN_DIV_CODE,GRN_NUM,GRN_ITEM_CODE,GRN_CHLN_QTY,GRN_IQC_FLAG,GRN_ACPT_QTY,GRN_REJ_QTY,GRN_PKC_AMNT,GRN_CST,GRN_LST,GRN_OTHER_AMNT,GRN_TOT_AMNT,GRN_LST_AMNT,GRN_CST_AMNT,GRN_AMNT,GRN_RATE,GRN_INDT_NUM,GRN_INDT_DT,EXC_AMNT,PACK_AMNT,GRN_DISC_AMNT,DISC_AMNT,GRN_EXC_AMNT,SURC_AMNT,GRN_INSU_PER,GRN_SURC_PER,GRN_INSU_AMNT,EXC_TYPE,GRN_INSU_FLAG,GRN_INV_NUM,GRN_CHLN_NUM,CESS_AMT,GRN_CESS,GRN_MRN_NO,GRN_MRN_DT INTO :1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36

FRM-40655 :SQL Error;Forced Rollback;Clear Form and re-enter transaction

please advice me regarding this problem

Thanks in advance

Regards

Chirag shah

----------------------------------------------------------------------
Re: forced rollback in forms 6i but working fine in forms 5 [message #77924 is a reply to message #77885] Mon, 17 December 2001 01:58 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
Cause: An unexpected end-of-file was processed on the communication
channel. The problem could not be handled by the Net8, two task, software.
This message could occur if the shadow two-task process associated with a
Net8 connect has terminated abnormally, or if there is a physical failure of the
interprocess communication vehicle, that is, the network or server machine
went down. In addition, this message could occur when ALTER SYSTEM KILL
SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the
IMMEDIATE qualifier because, in those cases, the client’s connection to the
database is terminated without waiting for the client to issue a request.
Action: If this message occurs during a connection attempt, check the setup
files for the appropriate Net8 driver and confirm Net8 software is correctly
installed on the server. If the message occurs after a connection is well
established, and the error is not due to a physical failure, check if a trace file
was generated on the server at failure time. Existence of a trace file may suggest
an Oracle internal error that requires the assistance of customer support.

----------------------------------------------------------------------
Previous Topic: Dynamic columns in Reports
Next Topic: Calling Java Class in Forms 6i
Goto Forum:
  


Current Time: Thu Mar 28 14:49:15 CDT 2024