Scheduler Service config and setup




If one installs scheduler via the typical setup; they will not or should not have any issues.  It is pretty simple.  You need a database for your scheduler tables(This is a given and requirement).  You need the scheduler service and you need the presentation service.  Now, you really don’t need the presentation services if you are just using scheduler to run only bi publisher jobs!  But don’t get me started on BI Punisher…err… I mean BI Publisher(This is another post topic entirely).  Scheduler is just a service whose sole purpose is.. you guessed it…scheduling jobs.  We use the scheduler with presentation server for iBots.  iBots are presentation server specific jobs to pre-run long running reports or run reports to be sent via email, dashboards or to other devices.  Oracle highly recommends running scheduler service on the same box as presentation server.  This is for reasons discussed later and also due to fact that scheduler will more than likely be used solely with presentation server to scheduler iBot jobs via Delivers.  Now, don’t get me wrong you could run scheduler on a different box; but, there are more specific configurations needed.  For example, lets say you want to run presentation services on box1, bi server and scheduler on box2.  This is what needs to be done.
1. Configure you scheduler either via the job manager UI or at the root config file, which is located at OracleBIData\scheduler\config\instanceconfig.xml (NOTICE HOW THIS IS LOCATED WITHIN THE ORACLEBIDATA DIRECTORY.  That is because it is presumed to run on the same machine as the presentation services!!!)
config_options
You will want to add the tns entry for your scheduler database here along with the userid/password to access scheduler tables. (As seen below)
config_options_database
Here are the contents of the schedulers instanceconfig.  As you can see there are lots of entries.  I find it best to use the UI in order to not make XML errors!  But for those with lots of XML experience its up to you.  As for me I can do both;)  (In any case please keep note of the settings highlighted in blue. PLEASE TAKE NOTICE OF DATABASE PASSWORD AS IT IS ENCRYPTED THAT’S WHY IT IS GOOD TO USE THE UI TOOL TO CONFIGURE ALSO.)





Administrator
a9ff96857fba4f6a
33792
12
9708

S_NQ_ERR_MSG
S_NQ_INSTANCE
S_NQ_JOB
S_NQ_JOB_PARAM

tnsnames_entry_here
e:\OracleBI\server\Scripts\Common

localhost:9810

False

Oracle Delivers
0
a9ff96857fba4f6a
25
defaultmailserver.com
defaultuser@defaultmailserver.com


0

1
True
False


100
1
5
True
False
f0126d06538c5ad301b41bb70f50912d0cf9f2f3e7b923d8
60
S_NQ_SCHED
9705
7
5



e:\OracleBI\server\config\private.pem
e:\OracleBI\server\config\public.pem
0

e:\OracleBIData\scheduler\config\passphrase


False
False

e:\OracleBI\server\Scripts\Scheduler

9707

46
e:\OracleBIData\tmp

706b3e23758697344f58fc12b0b1487b
sadmin
http://localhost
ANALYTICS
eai_enu


False
True
7
e:\OracleBI\server\Log\iBots
10
10
10
10000
5
3
2
4
2
3
box1:9710
2. Run job manager to validate the scheduler services is running correctly and can communicate with the scheduler tables.  You could do this on any machine with the job manager exe but just make it simple and run on the box it is setup on.  In our case box2.  If job manager connects fine to our scheduler all is well with the service itself.  If you have issues, look in OracleBI\server\log\ for the scheduler.log for specific issues.
job_mgr_success
3. Now since scheduler is verified and running, we need to configure presentation services for scheduler so that it can talk with the scheduler service and create jobs.  First we need to run cryptotools like it says within the infrastructure guide.  Cryptotools.exe can be found in “OracleBI\web\bin” dir.  This tool is used to enter the username and password for scheduler within the credentialstore.xml located in “OracleBIData\web\config” and to encrypt it, if need be, with passphrase.  Scheduler uses the alias of “admin”.  Once this is complete you will need to tell presentation services where the scheduler services is and also to find and locate the credentialstore.xml.  If schedulerServer is not specified correctly you will get error from delivers when trying to create ibot.  Something like service or server can not be found or communication error. (This is not a problem with standard install where sched server is on same machine as presentation server)  Also if you get Authentication error when trying to create iBot this is because the credential store and alias is either not setup or not setup right.
Your instanceconfig.xml for presentation services should now look like this after making entries.  The entries for this step is highlighted in blue.



AnalyticsWeb
E:/OracleBIData/web/catalog/samplesales

box2


XmlP
XmlP
http://FRANK-G8ANIAY3K:9704/xmlpserver/services/XMLPService
http://FRANK-G8ANIAY3K:9704/xmlpserver
http://FRANK-G8ANIAY3K:9704/xmlpserver/servlet/admin
bipublisheradmin

C:\Program Files (x86)\Java\jdk1.5.0_12
client/OracleBIOffice.exe
tag below and choose a subset set of language tags from the list. Values must be comma separated. –>
ar,cs,da,de,el,en,es,fi,fr,hr,hu,it,iw,ja,ko,nl,no,pl,pt,pt-br,ro,ru,sk,sv,th,tr,zh,zh-tw –>
tag below and choose a subset set of locale tags from the list. Values must be comma separated. –>
ar-dz,ar-bh,ar-dj,ar-eg,ar-iq,ar-jo,ar-kw,ar-lb,ar-ly,ar-ma,ar-om,ar-qa,ar-sa,ar-so,ar-sd,ar-sy,ar-tn,ar-ae,ar-ye,cs-cz,da-dk,de-at,de-ch,de-de,de-li,de-lu,el-gr,en-au,en-ca,en-cb,en-gb,en-hk,en-ie,en-in,en-jm,en-nz,en-ph,en-us,en-za,en-zw,es-ar,es-bo,es-cl,es-co,es-cr,es-do,es-ec,es-es,es-gt,es-hn,es-mx,es-ni,es-pa,es-pe,es-pr,es-py,es-sv,es-uy,es-ve,fi-fi,fr-be,fr-ca,fr-ch,fr-fr,fr-lu,fr-mc,hr-hr,hu-hu,id-id,it-ch,it-it,iw-il,ja-jp,ko-kr,ms-my,nl-be,nl-nl,no-no,pl-pl,pt-br,pt-pt,ro-ro,ru-ru,sk-sk,sv-fi,sv-se,th-th,tr-tr,zh-cn,zh-mo,zh-sg,zh-tw –>
truedisconnected –>



4. One last thing to remember and this is important and is typically overlooked.  You need to configure scheduler to communicate with the presentation server.  This way when it runs reports via an iBot, it can run them.  Scheduler runs iBots through presentation server as that is where the reports themselves live.  And then presentation server in turn submits the report to BI Server to fulfill the logical data request like usual.  If you setup scheduler on another box other than presentation server you might get the 77030 error when running an ibot job since the default value for this is local:9710.
config_options_pres_serv
So thinking about it, it does not make sense to have scheduler on another box as it needs to communicate directly with presentation server.  Thus one more network hop to get a job complete.  In our example scheduler on box2 needed to communicate to box 1 (presentation server) to run an iBot job.  Then box1 (presentation server) need to communicate to box 2(bi server) to run the report.  If we kept presentation server and scheduler on box1 then we would eliminate that one network request as it would just be local request.
If you have any ?s or comments please let me know and I will try to answer them.
-Frank

No comments:

Post a Comment

Popular Posts