INtools Forum

Forum Home

Aggregated

Discussions

Intools Ver 6

Repetative erro...

Repetative errors after checkdb

5/13/2009 12:31:52 PM

14 posts

Repetative errors after checkdb

Hi all,

SPI Version-06.00.07.03

Backend-Oracle9i

Following is the result obtained after performing CHECKDB.

I have executed this queries through Internal Setup Utility, and again performed CHECKDB but still it gives same set of queries.

alter table CALIBRATION_RESULT disable all triggers;

UPDATE CALIBRATION_RESULT set CALIB_RES_1_ID = 0 where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_1_ID);

UPDATE CALIBRATION_RESULT set CALIB_RES_2_ID = 0 where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_2_ID);

UPDATE CALIBRATION_RESULT set CALIB_RES_3_ID = 0 where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_3_ID);

UPDATE CALIBRATION_RESULT set CALIB_RES_4_ID = 0 where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_4_ID);

alter table CALIBRATION_RESULT enable all triggers ;

commit;

So pl. help how to resolve these queries.

Regards,

PJD

5/13/2009 1:20:26 PM

admin

177 posts

Re: Repetative errors after checkdb

Hi,

Please send me the complog file to admin@asbuilt-dba.com

Regards

Ilan Hills

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com

5/13/2009 3:57:53 PM

admin

177 posts

Re: Repetative errors after checkdb

Hi Again,

Please check the results of the following:

select count('x') from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = 0;

Regards

Ilan Hills

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com

5/14/2009 6:33:20 AM

14 posts

Re: Repetative errors after checkdb

Thanks Ilan for your prompt reply.

The result of the select query is 0.

I have only 4 rows in CALIBRATION_POINT Table and CALIB_PNT_ID are 1,2,3,4.

Pl. find the following as it is the content of complog.txt file.

          Comparison report
          -----------------
Database platform:   Oracle
Date: 5/13/2009 Time: 15:01:08
Project name        TEST


Data validation - references
------------------
select count(*) from CALIBRATION_RESULT where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_1_ID)
There are 1 rows found.
select count(*) from CALIBRATION_RESULT where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_2_ID)
There are 1 rows found.
select count(*) from CALIBRATION_RESULT where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_3_ID)
There are 1 rows found.
select count(*) from CALIBRATION_RESULT where not exists (select 'x' from CALIBRATION_POINT where CALIBRATION_POINT.CALIB_PNT_ID = CALIBRATION_RESULT.CALIB_RES_4_ID)
There are 1 rows found.

Special Operations - Checking :
------------------
select count(*) from DRAWING , CONTROL_VALVE where DRAWING.DWG_ID = CONTROL_VALVE.DWG_ID and DRAWING.DWG_ID > 0 and not exists (select 'x' from REVISION where DWG_ID = DRAWING.DWG_ID) and DRAWING.ENG_PROJ_ID >= 0
The result = 5; Should be 0

Invalid objects
----------------------
DDP_EXPORT_VIEW;

FIELDBUS_SPEC;

INSTR_CSTAG_CHANNEL_PANEL;

MATRIX_DDP1_VIEW;

MATRIX_DDP_VIEW;

P1_PREVENTPIPE;

P2_PREVENTPIPE;

P3_PREVENTPIPE;

P4_PREVENTPIPE;

PANEL_FROM_VIEW;

PANEL_LEFT_VIEW;

PANEL_RIGHT_VIEW;

PANEL_TO_VIEW;

RANGE;

REVISION_SPEC;

SCHEMA_VIEW_AREA;

SCHEMA_VIEW_CABINETRACK_8;

SCHEMA_VIEW_CARD_1;

SCHEMA_VIEW_CARD_2;

SCHEMA_VIEW_CHANNEL_1;

SCHEMA_VIEW_CIRCUIT_1;

SCHEMA_VIEW_CONTROLLER_1;

SCHEMA_VIEW_CONTROLSYSTEMTAG_1;

SCHEMA_VIEW_DRAWING;

SCHEMA_VIEW_ELEC_EQUIPMENT_1;

SCHEMA_VIEW_EPROJECT;

SCHEMA_VIEW_EQUIPMENT_6;

SCHEMA_VIEW_FIELDBUS_INSTR;

SCHEMA_VIEW_FUNCTION_BLOCK;

SCHEMA_VIEW_INSTRUMENT_1;

SCHEMA_VIEW_INSTRUMENT_2;

SCHEMA_VIEW_INSTRUMENT_3;

SCHEMA_VIEW_INSTRUMENT_4;

SCHEMA_VIEW_LINE_6;

SCHEMA_VIEW_LOOP_1;

SCHEMA_VIEW_PANEL_1;

SCHEMA_VIEW_PANEL_2;

SCHEMA_VIEW_PANEL_3;

SCHEMA_VIEW_PIPING_PORT_1;

SCHEMA_VIEW_PLANT;

SCHEMA_VIEW_SIGNAL_7;

SCHEMA_VIEW_UNIT;

TERM_FROM_VIEW;

TERM_LEFT_VIEW;

TERM_RIGHT_VIEW;

TERM_TO_VIEW;

V_INSTRUMENT_FUNCTION_BLOCK;

V_INSTRUMENT_JB;

CHECK PART FINISH. Date: 5/13/2009 Time: 15:04:49

RECREATING OF DATABASE OBJECTS:
------------------------------------------------------------------
Correcting errors of reference data. See Recreate.txt
-----------------------------------------

RECREATE PART FINISH. Date: 5/13/2009 Time: 15:04:56