OGG Error code while doing sync up activity

-
OGG Error code while doing sync up activity:- 

OCI Error ORA-01502: index 'DBUCDS.ORDER_LINE_ITEMS_PK' or partition of such index is in unusable state (status = 1502), SQL <INSERT INTO "DBUCDS"."ORDER_LIN
E_ITEMS_BC" ("COMPANY_CODE","DIVISION_CODE","LOCATION_CODE","TRANSACTION_TYPE_CODE","ORDER_REFERENCE_NUMBER","SEQ#","LINE_TYPE_CODE","ITEM_NUMBER","ITEM_PROD
UCT_CODE","SUB_LOCATION","ORDER_QUANTITY","SHIPPED_QUANTITY","UOM","NONSTOCK_TYPE","EXPENSE_TYPE","PRICE_LEVEL_CODE","ITEM_SELL","ITEM_COST","DISCOUNT_MULTIP
LIER","DISCOUNT_AMOUNT","VENDOR_NUMBER","SERIAL_NUMBER","TAX_ITEM","PRINT_ON_INVOICE","EXPECTED_DATE","REQUIRED_DATE","LINE_COMMENT","ORIGINAL_PRICE_LEVEL","
ORIGINAL_SELL","EXCHANGE_SEQUENCE","CREATE_DATE","CREATE_USER","CHANGE_DATE","CHANGE_USER","CHANGE_SELL_DATE","CHANGED_SELL_USER","ITEM_DESC","ORIGINAL_DISC_
MULT","KIT_SEQ#","POSTED_TO_GL","PICK_TICKET#","PICK_TICKET_DATE","SURCHARGE_AMT","MODEL_NUMBER","OPTION_ID","PRIMARY_BIN","BACK_ORDER_QUANTITY","TOTAL_SHIPP
ED_QUANTITY","TAX_GROUP","PO_NUMBER","PO_DATE","PO_SHIP_DIRECT","ORDERED_ITEM_NU
Operation failed at seqno 0 rba 0
Discarding record on action DISCARD on error 1502
Problem replicating SDS_BMS.ORDER_LINE_ITEMS to DBUCDS.ORDER_LINE_ITEMS_BC
Mapping problem with insert record (target format)...

Sol:-

We rebuild the index () ,But it did not work and we got the same error. So we dropped the index & recreate the index. Then the sync up is working fine.

Comments

Post a Comment

Popular posts from this blog

Oracle Golden Gate FAQ

-
Image
                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of log
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:                  1586.3900894393 (6815719025849)  Redo Seq:             74058 Redo RBA:             104066064          Status:               Running            ------------------------------------------------------------ XID:            
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the forward operations Reversing the ordering of database operations in an extract file, a series of extract
Read more