Self-Solve Knowledge Search

Minimize Maximize
TeMIP-What logs and proper trace mask to set for troubleshooting the problem abo...
Title :
TeMIP-What logs and proper trace mask to set for troubleshooting the problem about archiving through oracle_extended_archiving_fm
Document ID :
KM01443668
Product - Version:
temip knowledge ware 5.3 ;
OS :
Updated :
Wed Mar 18 09:30:02 GMT 2015
Summary :
What logs and proper trace mask to set for troubleshooting the problem about archiving through oracle_extended_archiving_fm
What logs and proper trace mask to set for troubleshooting the problem about archiving through oracle_extended_archiving_fm?
Solution

In order to troubleshoot the issue, the following trace mask available :

For EAFM :

MASK CODE                            DESCRIPTION
0x0000000000000010          Exceptions and Errors. Should always be set to trace the exceptions and errors (included in all masks).
0x0000000000000020          Entry and exit of all called functions.
0x0000000000000040          All EAFM processing.
0x0000000000000080          EACs global management processing.
0x0000000000000100           Archive processing.
0x0000000000000200           Translation processing.
0x0000000000000400           EAC management processing.
0x0000000000000800          Collection processing.
0x0000000000001000             Schedule processing.
0x0000000000002000           Exporting processing.
0x0000000000004000            Database processing
0x0000000000008000            Response processing.
0x0000000000010000            Rule processing.
0x0000000000020000             Attribute Translation processing.
0x0000000000040000             Error processing. Reserved for internal use.
0x0000000000100000              Table manager processing.

For KNWA :


MASK CODE                                     DESCRIPTION
0x0000000000000010                  Exceptions and Errors. Should always be set to trace the exceptions and errors (included in all masks).
0x0000000000000020                  Entry and exit of all called functions.
0x0000000000000040                   Entry and exit of all modules.
0x0000000000100000                   ACANTHIS KnowledgeWare FM processing.
0x0000000001000000                      ACANTHIS KnowledgeWare FM Session processing (HP TeMIP and ORACLE).
0x0000000002000000                   ACANTHIS KnowledgeWare FM Transformation Session processing (ORACLE only).

Set the trace mask and activate only 1 EAC. Then watch for the full archiving process via log files.

In knowledgeware_fm.log you will have the session between TeMIP and Oracle detail.
In oracle_extended_archiving_fm.log you will see only ORACLE_EAC process.
In knowledgeware_oracle.log (at Oracle Server side) you will have the detail of pl/sql procedure execution. This could be usefull in order to see detailed SQL Queries sent to your database area.