Posts

Showing posts from January, 2019

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","

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: