OraFAQ Forum: Streams & AQ » Message Text: ORA-01003: no statement parsed

Home » Server Options » Streams & AQ » Message Text: ORA-01003: no statement parsed (10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Message Text: ORA-01003: no statement parsed [message #383438]

Wed, 28 January 2009 21:35

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,

Report message to a moderator

Re: Message Text: ORA-01003: no statement parsed [message #407332 is a reply to message #383438]

Tue, 09 June 2009 13:01

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:10:57 CST 2024