Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

GG replicate is failing

NirvairJan 10 2017 — edited Jan 10 2017

We have 12.2 GG with 11g RDBMS. We have two extra columns on target, which we are populating with inserts and updates on source tables. Our GG replicate is failing with below errors. Replicate is looking for old trail file which was purged by GG itself. Please find the attached log files for more details.

2017-01-10 10:33:57 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Triggers will be suppressed by default.

2017-01-10 10:33:57 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: The previous message, 'INFO OGG-06451', repeated 1 times.

2017-01-10 10:33:57 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Virtual Memory Facilities for: COM

anon alloc: mmap(MAP_ANON) anon free: munmap

file alloc: mmap(MAP_SHARED) file free: munmap

target directories:

/opt/gg/bin/12.2.1/dirtmp.

2017-01-10 10:33:57 WARNING OGG-05673 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.

2017-01-10 10:33:57 INFO OGG-02545 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.

2017-01-10 10:33:57 INFO OGG-02527 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Integrated Replicat does not populate a trace table.

2017-01-10 10:33:58 INFO OGG-02530 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Integrated replicat successfully attached to inbound server OGG$RFCRS01A.

2017-01-10 10:33:58 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: REPLICAT RFCRS01A started.

2017-01-10 10:33:58 ERROR OGG-02171 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Error reading LCR from data source. Status 500, data source type 0.

2017-01-10 10:33:58 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: Unable to open file "/opt/gg/dirdat/FACS02A/pn000000001" (error 2, No such file or directory).

2017-01-10 10:33:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ggadmin): info all.

2017-01-10 10:34:04 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rfcrs01a.prm: PROCESS ABENDING.

Replicat mapping:

Replicat RFCRS01A

SETENV (ORACLE_HOME = "/opt/oracle/product/12.1.0.2")

SETENV (ORACLE_SID='FCRS01A')

AssumeTargetDefs

DiscardFile /opt/gg/bin/12.2.1/dirrpt/rpsb.dsc, purge, megabytes 3

UserIdAlias ggadmin_fcrs01a

--HANDLECOLLISIONS

ALLOWDUPTARGETMAP

GETTRUNCATES

--BATCHSQL

--This fires for everything, but only processes deletes

IGNOREINSERTS

IGNOREUPDATES

GETDELETES

MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*;

IGNOREINSERTS

IGNOREUPDATES

GETDELETES

MAP FACETS.*, TARGET FACETS.*;

--Fires for everything but only processes inserts

IGNOREDELETES

IGNOREUPDATES

GETINSERTS

MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*

COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'), INSERT_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));

IGNOREDELETES

IGNOREUPDATES

GETINSERTS

MAP FACETS.*, TARGET FACETS.*

COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'), INSERT_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));

--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('JULIANTIMESTAMP'), INSERT_DATE=@GETENV('JULIANTIMESTAMP'));

--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@DATENOW(), INSERT_DATE=@DATENOW());

--Fires for everything only processes updates.

IGNOREINSERTS

IGNOREDELETES

GETUPDATES

MAP FACETS_CUSTOM.*, TARGET FACETS_CUSTOM.*

COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));

IGNOREINSERTS

IGNOREDELETES

GETUPDATES

MAP FACETS.*, TARGET FACETS.*

COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@GETENV('GGHEADER','COMMITTIMESTAMP'));

--COLMAP(USEDEFAULTS, LAST_UPDATE_DATE=@DATENOW());

Comments

Timo Hahn

You call resetValue() on the component after you done

this.getInputFileBinding().resetValue();


Timo

Vidya Hugar

No. Its not resetting.

Timo Hahn

Works for me (using 12.1.3)

Bild 095.png

chosse file

Bild 096.png

after clicking on reset

Bild 097.png

the actionälistener

public void onReset(ActionEvent actionEvent) {

    getInfile().resetValue();

}

and this is hte page part

                    \<!-- Content -->

                    \<af:inputFile label="Label 1" id="if1" binding="#{viewScope.InputFileBean.infile}"/>

                    \<af:button text="reset" id="b1" actionListener="#{viewScope.InputFileBean.onReset}"/>

Timo

Vino Sarathy

Hi,

Try this..

use value binding variable of the inputFile to reset the value like below,

setFile(null);

AdfFacesContext.getCurrentInstance().addPartialTarget(inputFileBinding);


-Vinoth

Ashish Awasthi

User

Do as Timo Suggests

You are calling reset on ActionEvent component that means you are resetting your button not inputFile

ResetUtils.reset(actionEvent.getComponent());

Instead of this code bind your inputFile to bean and call Reset on that component binding

Ashish

Pra$hant Hole

Hi,

  check this:

            inputFileBinding.setValue(null);

            AdfFacesContext.getCurrentInstance().addPartialTarget(inputFileBinding);

Thanks,

Prashant

Vidya Hugar

I tried

  inputFileBinding.setValue(null);

            AdfFacesContext.getCurrentInstance().addPartialTarget(inputFileBinding);

also

but its taking lot of time, actually its loading . when i explicitly refresh then its fine.

even i tried ResetUtils.reset(actionEvent.getComponent());

still the same.

Vidya Hugar

I can do like theis, it works but as per my requirement i cannot add reset button

Timo Hahn

Sorry, I don't get you. I just added a button to get to the bean ad have a chance to reset the inputfile component. You can do it in your code as you are already in a bean method. You may have to ppr the inputFile component but it shoudl work.

Timo

Ashish Awasthi

2997680 wrote:

I tried

  inputFileBinding.setValue(null);

            AdfFacesContext.getCurrentInstance().addPartialTarget(inputFileBinding);

also

but its taking lot of time, actually its loading . when i explicitly refresh then its fine.

even i tried ResetUtils.reset(actionEvent.getComponent());

still the same.

Have you really read my comment ??

I am saying that you have used ResetUtils.reset(actionEvent.getComponent());  but you should not use this
Bind your inputFile to managed bean and call reset on that binding As Timo already told you

Ashish

Vidya Hugar

I gave binding to the input file and tried to reset but still its not working for me, its trying to reset.

Here is my code for that

<af:panelGroupLayout id="pgl350" layout="horizontal">

                        <af:inputFile label="Select" id="if51" value="#{ContractDocumentUploadDwn.file}"

                                      showRequired="true" binding="#{ContractDocumentUploadDwn.inputFileBinding}"/>

                        <af:button text="Upload" id="b353" action="#{ContractDocumentUploadDwn.uploadPortfolioDoc}"/>

</af:panelGroupLayout>

and JAVA class is

        genericSaveDocuments(actionEvent, iter, myfile, binding, popUpId, "Portfolio"); // Saves the Document

        setInputFileBinding(null);

As Timo suggested its works but I cannot add the reset button for resetting the input file,

Thanks

Timo Hahn

Again, you don't need a special reset button. You can reset the inputFile after you saved the document

genericSaveDocuments(actionEvent, iter, myfile, binding, popUpId, "Portfolio"); // Saves the Document

this.getInputFileBinding().resetValue();

should do.

Timo

Vidya Hugar

No. its not working for me.. next time when i try to add a record still its showing last inserted documentCapture.PNG

Timo Hahn

A you have set the value property of the inputFile, you have to set the value to null too.

Timo

Ashish Awasthi
Answer

See this line in your code

  <af:inputFile label="Select" id="if51" value="#{ContractDocumentUploadDwn.file}"

You are using a variable as value of inputFile so you have to set it's value to null

Write like this -

this.setFile(null);

// Reset inputFile component after upload

  ResetUtils.reset(inputFileBinding);


Ashish

Marked as Answer by Vidya Hugar · Sep 27 2020
Vidya Hugar

hi Timo,

I did like this.

        genericSaveDocuments(actionEvent, iter, myfile, binding, popUpId, "Portfolio");

        this.getInputFileBinding().resetValue();

        this.setInputFileBinding(null);

but still its not resetting.       

Cvele_new_account

Try with:

this.getInputFileBinding().resetValue();

this.getInputFileBinding().setValue(null);

AdfFacesContext.getCurrentInstance().addPartialTarget(getInputFileBinding());

Vidya Hugar

Thanks a lot . its working @"Timo Hahn" @ashish awasthi

1 - 18
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 7 2017
Added on Jan 10 2017
2 comments
2,817 views