Wednesday, April 28, 2010

crpetrace parameters








The 7 option above can also be replaced with the following options
-crpetrace , means trace only CRPE functions
-crpetrace 1, means trace only CRPE functions
-crpetrace 2, means trace only CRPE background thread
-crpetrace 3, means trace both CRPE functions and CRPE background thread
-crpetrace 4, means trace internal CRPE diagnostics
-crpetrace 7, means trace CRPE functions and CRPE background thread and internal CRPE diagnostics

BO XI Audit DB setup

Following 6 tables are required to create a Audit report.

APPLICATION_TYPE,
AUDIT_DETAIL,
AUDIT_EVENT,
DETAIL_TYPE,
EVENT_TYPE,
SERVER_PROCESS

Query to pull the date:

SELECT AUDIT_EVENT.EVENT_ID,
AUDIT_EVENT.USER_NAME,
AUDIT_EVENT.START_TIMESTAMP,
AUDIT_EVENT.DURATION,
DETAIL_TYPE.DETAIL_TYPE_DESCRIPTION,
SERVER_PROCESS.SERVER_FULLNAME,
AUDIT_EVENT.ERROR_CODE,
AUDIT_DETAIL.DETAIL_TEXT,
EVENT_TYPE.EVENT_TYPE_DESCRIPTION
FROM
AUDIT_EVENT,
DETAIL_TYPE,
SERVER_PROCESS,
AUDIT_DETAIL,
EVENT_TYPE
WHERE ( AUDIT_EVENT.EVENT_ID=AUDIT_DETAIL.EVENT_ID ) AND ( AUDIT_EVENT.SERVER_CUID=SERVER_PROCESS.SERVER_CUID ) AND ( AUDIT_EVENT.EVENT_TYPE_ID=EVENT_TYPE.EVENT_TYPE_ID ) AND ( AUDIT_DETAIL.DETAIL_TYPE_ID=DETAIL_TYPE.DETAIL_TYPE_ID )


Universe Design:

Using -maxChildReqs Business Objects Enterprise XI R2 Report Job server settings

• The default report job server children for Windows have been changed in
BusinessObjects Enterprise XI from OUTPROC to MIXEDPROC. This
causes the report job server children to remain open longer after
processing (for the lesser of 100 jobs or 2 hours of not being used.). This
is now consistent with the UNIX report job servers and with the other
types of job servers included with BusinessObjects Enterprise.
The following lists information on job server settings:
• -maxJobs
Sets the maximum number of concurrent jobs processed by one job
server.
• -type
Presets the job server type. Can be OUTPROC or MIXEDPROC.
OUTPROC causes the job server children to shutdown after every
job (like CE10 report job servers), MIXEDPROC causes the job
server children to shutdown after every 100 jobs.
• -maxChildReqs
Sets the maximum number of jobs processed by one job server child
before it shuts down and restarts (in case you want a to use a
number between 1 [OUTPROC] and 100 [MIXEDPROC])
Job server children will also automatically shut down if left unused for a
period longer than 2 hours.


Example to use in Linux or Unix for BO XI R2:

Open the ccm.config file and change like below:

reportjobserverLAUNCH='"/bobje/enterprise115/generic/bobjrestart.sh" -protect "/bobje/enterprise115/linux_x86/boe_jobsd" -lib procreport -jsTypeDescription "Crystal Reports Job Server" -objectType CrystalEnterprise.Report -name xxxxxxxx.reportjobserver -ns xxxxxxxxx..com -type OUTPROC -loggingPath "/bobje/logging" -pidFile "/bobje/serverpids/xxxxxx_reportjobserver.pid" -restart -fg -maxChildReqs 1'


For XI R3 follow same instruction but do the changes from CMC to report job server.

For windows follow this video:

http://www.youtube.com/watch?v=WQ8R477SRIA

Sonarqube Upgrade from 9.4.4 to 9.9.4 LTS

 Issue:  1) Java hasbeen upgraded from 11 to Open JDK 17. And Sonarqube is upgraded from 9.4 to 9.9.4. 2) After the upgrade sonarqube servic...