Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01410: invalid ROWID (Oracle 10g)
ORA-01410: invalid ROWID [message #343464] Wed, 27 August 2008 06:33 Go to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
When i run the following procedure i got error message which says
ORA-01410: invalid ROWID
Any idea ? Thanks in advance...


CREATE OR REPLACE PROCEDURE NORTHI_LOADER_MTRL_BSS_GSR81.PROCEDURE_CELLCCH(XDATA_DATE IN DATE) AS BEGIN
MERGE INTO NORTHI.CELLCCH A USING
(SELECT C1.ALLOC_SDCCH - (C1.CM_SERV_REQ_CALL+C1.CM_SERV_REQ_SMS+C1.CM_SERV_REQ_SUPP+C1.CM_SERV_REQ_EMERG+C1.CM_REESTABLISH+C1.IMSI_DETACH+C1.PAGE_RESPONSE) SZFAILURES,
C1.RF_LOSSES_SD RFLOSSES,C1.ALLOC_SDCCH_FAIL*100 SDCCH_CONG_VF_NUM,C1.CM_SERV_REQ_CALL+C1.CM_SERV_REQ_SMS+C1.CM_SERV_REQ_EMERG+C1.CM_SERV_REQ_SUPP+C1.CM_REESTABLISH+
C1.LOCATION_UPDATE+C1.IMSI_DETACH+C1.PAGE_RESPONSE+C1.CM_LCS_REQUEST+C1.CM_SERV_REQ_VGCS+C1.CM_SERV_REQ_VBS+C1.MS_REQ_VGCS_IMM+C1.MS_ REQ_VGCS_IMM2+
C1.MS_REQ_NOTIF_RESP+C1.LOC_FLW_REQ_NRM+C1.LOC_FLW_REQ_SMS SCCHACCSUCC_VF_NUM,C1.OK_ACC_PROC_SUC_R-C1.CHAN_REQ_MS_BLK SDCCHACCSUCC_VF_DENOM,
C1.ALLOC_SDCCH-C2.CHANRQFAILSDCH_ROL SDRFLOSS_VF_DENOM,C1.RF_LOSSES_SD+C2.RF_LOS_TCH_SIG PSIGFLOSS_VF_NUM,
C1.ALLOC_SDCCH+C2.ALLOC_TCH_SIG-C1.CHAN_REQ_FAIL_ROL PSIGFLOSS_VF_DENOM,800*(C1.SMS_INIT_ON_SDCCH*131+C1.O_INTRA_BS_HO_SUC*242+
C1.O_INTER_BS_HO_SUC*262+C1.LOCATION_UPDATE*355+(C1.PAGE_RESPONSE-C1.SMS_INIT_ON_SDCCH)*351+C1.PAGE_REQ_FROM_MSC*41+C1.MT_LCS_ON_SDCC H*165)/(65535*3600) RSLTXLOAD_VF,800*(C1.SMS_INIT_ON_SDCCH*172+C1.O_INTRA_BS_HO_SUC*292+C1.O_INTER_BS_HO_SUC*296+C1.LOCATION_UPDATE*191+C1.CM_SERV_REQ_CA LL*417+(C1.PAGE_RESPONSE-C1.SMS_INIT_ON_SDCCH)*471+C1.MT_LCS_ON_SDCCH*179)/(65535*3600) RSLRXLOAD_VF,C1.BUSY_SDCCH_MEAN TRAFFIC,C1.SDCCH_CONGESTION/36000 PCCONGTIME,DECODE(ALLOC_SDCCH,0,0,(BUSY_SDCCH_MEAN*F_MEASUREMENT)/ALLOC_SDCCH) MHTIME,C1.CHAN_REQ_FAIL_ROL MISCDROP,C1.ALLOC_SDCCH+C1.ALLOC_SDCCH_FAIL ATTEMPTS,C1.ALLOC_SDCCH_FAIL BLOCKS,C1.AVAIL_SDCCH_MAX DEFINEDCH,C1.AVAIL_SDCCH_MEAN AVAILCH,C1.CM_SERV_REQ_CALL+C1.CM_SERV_REQ_SMS+C1.CM_SERV_REQ_SUPP+C1.CM_SERV_REQ_EMERG+C1.CM_REESTABLISH+C1.IMSI_DETACH+C1.PAGE_RESP ONSE SEIZURES,C1.SDCCH_CONGESTION/1000 CONGTIME,C1.FRAGMENT_DATE FRAGMENT_DATE,C1.NETWORK_ID NETWORK_ID,C1.BUSY_SDCCH_MAX MAXBUSY FROM NORTHI_PARSER.CELL_STATISTICS_1 C1,NORTHI_PARSER.CELL_STATISTICS_2 C2 WHERE C1.FRAGMENT_DATE= XDATA_DATE AND C1.FRAGMENT_DATE=C2.FRAGMENT_DATE AND C1.NETWORK_ID=C2.NETWORK_ID) E ON (A.FRAGMENT_DATE=E.FRAGMENT_DATE AND A.NETWORK_ID=E.NETWORK_ID) WHEN NOT MATCHED THEN INSERT (SZFAILURES,RFLOSSES,SDCCH_CONG_VF_NUM,SCCHACCSUCC_VF_NUM,SDCCHACCSUCC_VF_DENOM,SDRFLOSS_VF_DENOM,PSIGFLOSS_VF_NUM,PSIGFLOSS_VF_DENOM ,RSLTXLOAD_VF,RSLRXLOAD_VF,TRAFFIC,PCCONGTIME,MHTIME,MISCDROP,ATTEMPTS,BLOCKS,DEFINEDCH,AVAILCH,SEIZURES,CONGTIME,FRAGMENT_DATE,NETWO RK_ID,MAXBUSY) VALUES (E.SZFAILURES,E.RFLOSSES,E.SDCCH_CONG_VF_NUM,E.SCCHACCSUCC_VF_NUM,E.SDCCHACCSUCC_VF_DENOM,E.SDRFLOSS_VF_DENOM,E.PSIGFLOSS_VF_NUM,E.PS IGFLOSS_VF_DENOM,E.RSLTXLOAD_VF,E.RSLRXLOAD_VF,E.TRAFFIC,E.PCCONGTIME,E.MHTIME,E.MISCDROP,E.ATTEMPTS,E.BLOCKS,E.DEFINEDCH,E.AVAILCH,E .SEIZURES,E.CONGTIME,E.FRAGMENT_DATE,E.NETWORK_ID,E.MAXBUSY); END;
/
Re: ORA-01410: invalid ROWID [message #343470 is a reply to message #343464] Wed, 27 August 2008 06:46 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Would you please read & FOLLOW the Posting Guidelines as stated in URL above

It will not only help you but also others in this forum to understand your code

Regards,
Oli
Re: ORA-01410: invalid ROWID [message #343482 is a reply to message #343464] Wed, 27 August 2008 07:04 Go to previous messageGo to next message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member
I am doing this time please following the instructions before post.

CREATE OR REPLACE PROCEDURE NORTHI_LOADER_MTRL_BSS_GSR81.PROCEDURE_CELLCCH(XDATA_DATE IN DATE) AS
BEGIN
  MERGE INTO NORTHI.CELLCCH A
  USING (SELECT C1.ALLOC_SDCCH -
                (C1.CM_SERV_REQ_CALL + C1.CM_SERV_REQ_SMS +
                C1.CM_SERV_REQ_SUPP + C1.CM_SERV_REQ_EMERG +
                C1.CM_REESTABLISH + C1.IMSI_DETACH + C1.PAGE_RESPONSE) SZFAILURES,
                C1.RF_LOSSES_SD RFLOSSES,
                C1.ALLOC_SDCCH_FAIL * 100 SDCCH_CONG_VF_NUM,
                C1.CM_SERV_REQ_CALL + C1.CM_SERV_REQ_SMS +
                C1.CM_SERV_REQ_EMERG + C1.CM_SERV_REQ_SUPP +
                C1.CM_REESTABLISH + C1.LOCATION_UPDATE + C1.IMSI_DETACH +
                C1.PAGE_RESPONSE + C1.CM_LCS_REQUEST + C1.CM_SERV_REQ_VGCS +
                C1.CM_SERV_REQ_VBS + C1.MS_REQ_VGCS_IMM + C1.MS_ REQ_VGCS_IMM2 + C1.MS_REQ_NOTIF_RESP + C1.LOC_FLW_REQ_NRM + C1.LOC_FLW_REQ_SMS SCCHACCSUCC_VF_NUM,
                C1.OK_ACC_PROC_SUC_R - C1.CHAN_REQ_MS_BLK SDCCHACCSUCC_VF_DENOM,
                C1.ALLOC_SDCCH - C2.CHANRQFAILSDCH_ROL SDRFLOSS_VF_DENOM,
                C1.RF_LOSSES_SD + C2.RF_LOS_TCH_SIG PSIGFLOSS_VF_NUM,
                C1.ALLOC_SDCCH + C2.ALLOC_TCH_SIG - C1.CHAN_REQ_FAIL_ROL PSIGFLOSS_VF_DENOM,
                800 *
                (C1.SMS_INIT_ON_SDCCH * 131 + C1.O_INTRA_BS_HO_SUC * 242 +
                C1.O_INTER_BS_HO_SUC * 262 + C1.LOCATION_UPDATE * 355 +
                (C1.PAGE_RESPONSE - C1.SMS_INIT_ON_SDCCH) * 351 +
                C1.PAGE_REQ_FROM_MSC * 41 + C1.MT_LCS_ON_SDCC H * 165) /
                (65535 * 3600) RSLTXLOAD_VF,
                800 *
                (C1.SMS_INIT_ON_SDCCH * 172 + C1.O_INTRA_BS_HO_SUC * 292 +
                C1.O_INTER_BS_HO_SUC * 296 + C1.LOCATION_UPDATE * 191 +
                C1.CM_SERV_REQ_CA
                 LL * 417 + (C1.PAGE_RESPONSE - C1.SMS_INIT_ON_SDCCH) * 471 +
                 C1.MT_LCS_ON_SDCCH * 179) / (65535 * 3600) RSLRXLOAD_VF,
                C1.BUSY_SDCCH_MEAN TRAFFIC,
                C1.SDCCH_CONGESTION / 36000 PCCONGTIME,
                DECODE(ALLOC_SDCCH,
                       0,
                       0,
                       (BUSY_SDCCH_MEAN * F_MEASUREMENT) / ALLOC_SDCCH) MHTIME,
                C1.CHAN_REQ_FAIL_ROL MISCDROP,
                C1.ALLOC_SDCCH + C1.ALLOC_SDCCH_FAIL ATTEMPTS,
                C1.ALLOC_SDCCH_FAIL BLOCKS,
                C1.AVAIL_SDCCH_MAX DEFINEDCH,
                C1.AVAIL_SDCCH_MEAN AVAILCH,
                C1.CM_SERV_REQ_CALL + C1.CM_SERV_REQ_SMS +
                C1.CM_SERV_REQ_SUPP + C1.CM_SERV_REQ_EMERG +
                C1.CM_REESTABLISH + C1.IMSI_DETACH + C1.PAGE_RESP ONSE SEIZURES,
                C1.SDCCH_CONGESTION / 1000 CONGTIME,
                C1.FRAGMENT_DATE FRAGMENT_DATE,
                C1.NETWORK_ID NETWORK_ID,
                C1.BUSY_SDCCH_MAX MAXBUSY
           FROM NORTHI_PARSER.CELL_STATISTICS_1 C1,
                NORTHI_PARSER.CELL_STATISTICS_2 C2
          WHERE C1.FRAGMENT_DATE = XDATA_DATE
            AND C1.FRAGMENT_DATE = C2.FRAGMENT_DATE
            AND C1.NETWORK_ID = C2.NETWORK_ID) E
  ON (A.FRAGMENT_DATE = E.FRAGMENT_DATE AND A.NETWORK_ID = E.NETWORK_ID)
  WHEN NOT MATCHED THEN
    INSERT
      (SZFAILURES,
       RFLOSSES,
       SDCCH_CONG_VF_NUM,
       SCCHACCSUCC_VF_NUM,
       SDCCHACCSUCC_VF_DENOM,
       SDRFLOSS_VF_DENOM,
       PSIGFLOSS_VF_NUM,
       PSIGFLOSS_VF_DENOM,
       RSLTXLOAD_VF,
       RSLRXLOAD_VF,
       TRAFFIC,
       PCCONGTIME,
       MHTIME,
       MISCDROP,
       ATTEMPTS,
       BLOCKS,
       DEFINEDCH,
       AVAILCH,
       SEIZURES,
       CONGTIME,
       FRAGMENT_DATE,
       NETWO RK_ID,
       MAXBUSY)
    VALUES
      (E.SZFAILURES,
       E.RFLOSSES,
       E.SDCCH_CONG_VF_NUM,
       E.SCCHACCSUCC_VF_NUM,
       E.SDCCHACCSUCC_VF_DENOM,
       E.SDRFLOSS_VF_DENOM,
       E.PSIGFLOSS_VF_NUM,
       E.PS IGFLOSS_VF_DENOM,
       E.RSLTXLOAD_VF,
       E.RSLRXLOAD_VF,
       E.TRAFFIC,
       E.PCCONGTIME,
       E.MHTIME,
       E.MISCDROP,
       E.ATTEMPTS,
       E.BLOCKS,
       E.DEFINEDCH,
       E.AVAILCH,
       E.SEIZURES,
       E.CONGTIME,
       E.FRAGMENT_DATE,
       E.NETWORK_ID,
       E.MAXBUSY);
END;



below is the snipt of your code

WHEN NOT MATCHED THEN
INSERT(SZFAILURES,
RFLOSSES,
SDCCH_CONG_VF_NUM,
SCCHACCSUCC_VF_NUM,
SDCCHACCSUCC_VF_DENOM,
SDRFLOSS_VF_DENOM,

Here Your not mentioned from which table these columns belongs.
The above code should be like
WHEN NOT MATCHED THEN
    INSERT(B.SZFAILURES,
       B.RFLOSSES,
       B.SDCCH_CONG_VF_NUM,
       B.SCCHACCSUCC_VF_NUM,
       B.SDCCHACCSUCC_VF_DENOM,
       B.SDRFLOSS_VF_DENOM,

Please make the changes accrodingly and let me know if my posting is any useful to you.


[Updated on: Wed, 27 August 2008 07:05]

Report message to a moderator

Re: ORA-01410: invalid ROWID [message #343484 is a reply to message #343470] Wed, 27 August 2008 07:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-01410 invalid ROWID
Cause: A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F. A typical ROWID format is '000001F8.0001.0006'.
Action: Check the format, then enter the ROWID using the correct format. ROWID format: block ID, row in block, file ID.

Regards
Michel
Re: ORA-01410: invalid ROWID [message #343494 is a reply to message #343484] Wed, 27 August 2008 07:27 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
WHEN NOT MATCHED THEN
INSERT(A.SZFAILURES,
A.RFLOSSES,
A.SDCCH_CONG_VF_NUM,
A.SCCHACCSUCC_VF_NUM,
A.SDCCHACCSUCC_VF_DENOM,
A.SDRFLOSS_VF_DENOM,

i changed my procedure as above and ill see the result in a few minutes. Sorry for wrong posts and for my english also.
Same error ORA-01410: invalid ROWID [message #343527 is a reply to message #343494] Wed, 27 August 2008 08:21 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
Same error: ORA-01410: invalid ROWID


CREATE OR REPLACE PROCEDURE northi_loader_mtrl_bss_gsr81.procedure_cellcch (
xdata_date IN DATE
)
AS
BEGIN
MERGE INTO northi.cellcch a
USING (SELECT c1.alloc_sdcch
- ( c1.cm_serv_req_call
+ c1.cm_serv_req_sms
+ c1.cm_serv_req_supp
+ c1.cm_serv_req_emerg
+ c1.cm_reestablish
+ c1.imsi_detach
+ c1.page_response
) szfailures,
c1.rf_losses_sd rflosses,
c1.alloc_sdcch_fail * 100 sdcch_cong_vf_num,
c1.cm_serv_req_call
+ c1.cm_serv_req_sms
+ c1.cm_serv_req_emerg
+ c1.cm_serv_req_supp
+ c1.cm_reestablish
+ c1.location_update
+ c1.imsi_detach
+ c1.page_response
+ c1.cm_lcs_request
+ c1.cm_serv_req_vgcs
+ c1.cm_serv_req_vbs
+ c1.ms_req_vgcs_imm
+ c1.ms_req_vgcs_imm2
+ c1.ms_req_notif_resp
+ c1.loc_flw_req_nrm
+ c1.loc_flw_req_sms scchaccsucc_vf_num,
c1.ok_acc_proc_suc_r
- c1.chan_req_ms_blk sdcchaccsucc_vf_denom,
c1.alloc_sdcch - c2.chanrqfailsdch_rol sdrfloss_vf_denom,
c1.rf_losses_sd + c2.rf_los_tch_sig psigfloss_vf_num,
c1.alloc_sdcch
+ c2.alloc_tch_sig
- c1.chan_req_fail_rol psigfloss_vf_denom,
800
* ( c1.sms_init_on_sdcch * 131
+ c1.o_intra_bs_ho_suc * 242
+ c1.o_inter_bs_ho_suc * 262
+ c1.location_update * 355
+ (c1.page_response - c1.sms_init_on_sdcch) * 351
+ c1.page_req_from_msc * 41
+ c1.mt_lcs_on_sdcch * 165
)
/ (65535 * 3600) rsltxload_vf,
800
* ( c1.sms_init_on_sdcch * 172
+ c1.o_intra_bs_ho_suc * 292
+ c1.o_inter_bs_ho_suc * 296
+ c1.location_update * 191
+ c1.cm_serv_req_call * 417
+ (c1.page_response - c1.sms_init_on_sdcch) * 471
+ c1.mt_lcs_on_sdcch * 179
)
/ (65535 * 3600) rslrxload_vf,
c1.busy_sdcch_mean traffic,
c1.sdcch_congestion / 36000 pccongtime,
DECODE (alloc_sdcch,
0, 0,
(busy_sdcch_mean * f_measurement) / alloc_sdcch
) mhtime,
c1.chan_req_fail_rol miscdrop,
c1.alloc_sdcch + c1.alloc_sdcch_fail attempts,
c1.alloc_sdcch_fail blocks, c1.avail_sdcch_max definedch,
c1.avail_sdcch_mean availch,
c1.cm_serv_req_call
+ c1.cm_serv_req_sms
+ c1.cm_serv_req_supp
+ c1.cm_serv_req_emerg
+ c1.cm_reestablish
+ c1.imsi_detach
+ c1.page_response seizures,
c1.sdcch_congestion / 1000 congtime,
c1.fragment_date fragment_date, c1.network_id network_id,
c1.busy_sdcch_max maxbusy
FROM northi_parser.cell_statistics_1 c1,
northi_parser.cell_statistics_2 c2
WHERE c1.fragment_date = xdata_date
AND c1.fragment_date = c2.fragment_date
AND c1.network_id = c2.network_id) e
ON (a.fragment_date = e.fragment_date AND a.network_id = e.network_id)
WHEN NOT MATCHED THEN
INSERT (a.szfailures, a.rflosses, a.sdcch_cong_vf_num,
a.scchaccsucc_vf_num, a.sdcchaccsucc_vf_denom,
a.sdrfloss_vf_denom, a.psigfloss_vf_num,
a.psigfloss_vf_denom, a.rsltxload_vf, a.rslrxload_vf,
a.traffic, a.pccongtime, a.mhtime, a.miscdrop, a.attempts,
a.blocks, a.definedch, a.availch, a.seizures, a.congtime,
a.fragment_date, a.network_id, a.maxbusy)
VALUES (e.szfailures, e.rflosses, e.sdcch_cong_vf_num,
e.scchaccsucc_vf_num, e.sdcchaccsucc_vf_denom,
e.sdrfloss_vf_denom, e.psigfloss_vf_num,
e.psigfloss_vf_denom, e.rsltxload_vf, e.rslrxload_vf,
e.traffic, e.pccongtime, e.mhtime, e.miscdrop, e.attempts,
e.blocks, e.definedch, e.availch, e.seizures, e.congtime,
e.fragment_date, e.network_id, e.maxbusy);
END;
/
Re: Same error ORA-01410: invalid ROWID [message #343548 is a reply to message #343527] Wed, 27 August 2008 08:53 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Same error:

Yes, the post is NOT formated.

Regards
Michel
Previous Topic: Drop ... Cascade Constraints
Next Topic: Extract data
Goto Forum:
  


Current Time: Tue Dec 06 10:45:20 CST 2016

Total time taken to generate the page: 0.11113 seconds