Implementing Usage tracking

Background
Implementing Usage tracking, using direct insertion method

SolutionSiebel Configuration
If data insertion process does not work properly for Usage Tracking, do the following:
1. In the RPD, make a separate database object with a dedicated connection pool for insertion into S_NQ_ACCT table, i.e. only S_NQ_ACCT physical table will exist under this database object.
2. Check the connection pool properties, the 'Data source name' should be the TSN name, and the call interface is specified as OCI (in case of oracle db).

Note that the error details are recorded in NQServer.log, this would help in tracking the cause of the insertion failure.


http://www.siebeldigest.com/