Loading ...
Sorry, an error occurred while loading the content.
 

Page Incosistent with the Database error.

Expand Messages
  • vignesh_258
    Hi.. All of a sudden I am getting this error when I am trying to cancel an order. I know this error comes when some one else tries to update the information,
    Message 1 of 1 , Jan 8, 2010
      Hi..
      All of a sudden I am getting this error when I am trying to cancel an order. I know this error comes when some one else tries to update the information, but that doesn't seem to be the case here. When I checked out the SQL trace a Rollback has happened right after thie query.

      SELECT CAPTURE_ID, H1UK_POST_SELL_ACT, PERSON_ID, BUSINESS_UNIT, TO_CHAR(CAPTURE_DATE,'YYYY-MM-DD'), CAPTURE_TYPE_CD, CONFIDENCE_PCT, CONFIRM_PO_RECVD, CURRENCY_CD, CUR_RT_TYPE, CUSTOMER_PO, DESCR50, PAYMENT_METHOD, PRICE_RULE_CD, PYMNT_TERMS_CD, TO_CHAR(QUOTE_DUE_DATE,'YYYY-MM-DD'), TO_CHAR(QUOTE_EXPIRE_DT,'YYYY-MM-DD'), RA_PROMOTION_CODE, REVISION_NUMBER, RO_PRIORITY, RO_PROCESS_TYPE, SHIP_PARTIAL_FLAG, SOURCE_CD, STATUS_CODE, TOTAL_PRICE, UID20F, UID20F_BILL, UID20F_BILLC, UID20F_CCOT, UID20F_CCRC, UID20F_SOLD, UID20F_SOLDC, RBTNEWACCT, RBTACCTID, RBTACCTTYPE, RBTPARENTACCTID, RBTSPONSOREDACCTID, RBTRECPAYMETHOD, TO_CHAR(ROW_ADDED_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"'), ROW_ADDED_OPRID, TO_CHAR(ROW_LASTMANT_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"'), ROW_LASTMANT_OPRID, SYNCID, TO_CHAR(SYNCDTTM,'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PS_RO_HEADER WHERE CAPTURE_ID=:1 FOR UPDATE OF STATUS_CODE, ROW_LASTMANT_DTTM, ROW_LASTMANT_OPRID

      I tried running this query in PL/SQL it works but.

      The trace file looks something like this.

      PSAPPSRV.2439 (4744) 1-954 16.30.22 0.002199 Cur#2.2439.PSOFTP02 RC=0 Dur=0.001412 COM Stmt=SELECT CAPTURE_ID, H1UK_POST_SELL_ACT, PERSON_ID, BUSINESS_UNIT, TO_CHAR(CAPTURE_DATE,'YYYY-MM-DD'), CAPTURE_TYPE_CD, CONFIDENCE_PCT, CONFIRM_PO_RECVD, CURRENCY_CD, CUR_RT_TYPE, CUSTOMER_PO, DESCR50, PAYMENT_METHOD, PRICE_RULE_CD, PYMNT_TERMS_CD, TO_CHAR(QUOTE_DUE_DATE,'YYYY-MM-DD'), TO_CHAR(QUOTE_EXPIRE_DT,'YYYY-MM-DD'), RA_PROMOTION_CODE, REVISION_NUMBER, RO_PRIORITY, RO_PROCESS_TYPE, SHIP_PARTIAL_FLAG, SOURCE_CD, STATUS_CODE, TOTAL_PRICE, UID20F, UID20F_BILL, UID20F_BILLC, UID20F_CCOT, UID20F_CCRC, UID20F_SOLD, UID20F_SOLDC, RBTNEWACCT, RBTACCTID, RBTACCTTYPE, RBTPARENTACCTID, RBTSPONSOREDACCTID, RBTRECPAYMETHOD, TO_CHAR(ROW_ADDED_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"'), ROW_ADDED_OPRID, TO_CHAR(ROW_LASTMANT_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"'), ROW_LASTMANT_OPRID, SYNCID, TO_CHAR(SYNCDTTM,'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PS_RO_HEADER WHERE CAPTURE_ID=:1 FOR UPDATE OF STATUS_CODE, ROW_LASTMANT_DTTM, ROW_LASTMANT_OPRID
      PSAPPSRV.2439 (4744) 1-955 16.30.22 0.000061 Cur#2.2439.PSOFTP02 RC=0 Dur=0.000001 Bind-1 type=2 length=20 value=04903d18fc4d11d79330
      PSAPPSRV.2439 (4744) 1-956 16.30.22 0.003369 Cur#2.2439.PSOFTP02 RC=0 Dur=0.003339 EXE
      PSAPPSRV.2439 (4744) 1-957 16.30.22 0.000070 Cur#2.2439.PSOFTP02 RC=0 Dur=0.000035 Fetch
      PSAPPSRV.2439 (4744) 1-958 16.30.22 0.009035 Cur#2.2439.PSOFTP02 RC=0 Dur=0.008865 Rollback
      PSAPPSRV.2439 (4744) 1-959 16.30.22 0.000027 Cur#2.2439.PSOFTP02 RC=0 Dur=0.000001 Commit


      What could possibly be wrong? Anyone has any ideas?
    Your message has been successfully submitted and would be delivered to recipients shortly.