Home » Server Options » Streams & AQ » Message Text: ORA-01003: no statement parsed (10.2.0.2)
Message Text: ORA-01003: no statement parsed [message #383438] Wed, 28 January 2009 21:35 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
Instead of replicating the data from one site to other site
streaming is throwing all errors in dba_apply_errors queue with
error message:-
Message Text: ORA-01003: no statement parsed
If I am trying to resolve errors with conflict handler
It is not able to resolve.
Please tell me What could be the reason behind that.
Regards,
Varun Punj,
Re: Message Text: ORA-01003: no statement parsed [message #407332 is a reply to message #383438] Tue, 09 June 2009 13:01 Go to previous message
upanwar82
Messages: 5
Registered: January 2009
Location: Cincinnati
Junior Member

Hi,

I am also getting the same the error many times and related tables are out of sync....manually i brought them in sync.

did u find anything regarding the same?

Please let me know...

I have one more issues :

We have implemented bi-directional replication via oracle streams..Oracle 10g 10.2.0.4

We are getting following error in conflict resolution .ORA-23460: missing value for column "ASSIGNED_APPL_USER_ID" in resolution method "<method>" for
"TMADMIN"."PATIENT_VISITS"."REP_UPDATE" ORA-01403: no data found .

Above column ASSIGNED_APPL_USER_ID is NULL column ,We are using MAXIMUM resolution method for update conflict handler .We tried many times on toad the same scenarios and working fine.

We have set supplemental logging on primay and unique columns.

I found many docs on internet and they all said add supplemental logging on all columns.

We did set up like this ...:


DECLARE
COLS DBMS_UTILITY.NAME_ARRAY;
BEGIN
cols(1) := 'STUDY_ID';
cols(2) := 'KENDLE_STUDY_SUB_ID';
cols(3) := 'SITE_ID';
cols(4) := 'PATIENT_ID';
cols(5) := 'VISIT_NUMBER';
cols(6) := 'VISIT_TYPE';
cols(7) := 'VISIT_DATE';
cols(Cool := 'CRF_COLLECTION_DATE';
cols(9) := 'DT_CREATED';
cols(10) := 'DT_MODIFIED';
cols(11) := 'MODIFIED_BY';
cols(12) := 'MONITOR_VISIT_DATE';
cols(13) := 'UNSCHEDULED_VISIT_REASON';
cols(14) := 'LAST_SCHEDULED_VISIT_NUMBER';
cols(15) := 'VISIT_DATE_IN_TRIALBASE';
cols(16) := 'PROJECTED_VISIT_DATE';
cols(17) := 'SEND_CERTIFIED_LETTER_YN';
cols(18) := 'ASSIGNED_APPL_USER_ID';
cols(19) := 'DATE_CERTIFIED_LETTER_SENT';
cols(20) := 'DURATION_OF_CALL_IN_MINUTES';
cols(21) := 'COMPLETED_APPL_USER_ID';
cols(22) := 'CALL_STATUS';
cols(23) := 'VISIT_HYPERLINK';
cols(24) := 'NEXT_CALL_DATE';
cols(25) := 'DT_PMNT_REQUESTED_TO_SPONSOR';
cols(26) := 'VISIT_DATE_NAP_YN';
cols(27) := 'MONITOR_VISIT_DATE_NAP_YN';
cols(28) := 'CRF_COLLECTION_DATE_NAP_YN';
cols(29) := 'IMPORTED_SUBJECT_VISIT_DATE';
cols(30) := 'REMINDER_SENT_DATE';
DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(
OBJECT_NAME =>'TMADMIN.PATIENT_VISITS',
METHOD_NAME =>'MAXIMUM',
RESOLUTION_COLUMN =>'DT_MODIFIED',
COLUMN_LIST =>cols);
END;
/
DT_MODIFIED is our resolution columns......

Any help would be appreciate...
Thanks in advance.

Thanks,
Singh


Previous Topic: AQ or replication
Next Topic: Add_Subset_propagation_rules for BLOB data type
Goto Forum:
  


Current Time: Fri Mar 29 08:07:35 CDT 2024