How to overcome IN clause limitation in Analytics?

In analytics, whever we use In caluse in filetr condition, the default
value is 8192.

If we expect thevalue be more than 8192 then we can increase it by
setting the parameter
MAX_EXPANDED_SUBQUERY_PREDICATES = 16384; in NQSConfig.ini file.

But this definetely impacts performance.

In obiee, you can use write back as work around for this issue.

ibot not delivering mails

this is one of the ibot issue which we face very often.
Scenario: The ibot was delivering mail if the report is in text format. it fails if it's in mhtml/pdf format.
on analysing we found it related to setting in SMTP server. the SMTP server was allowing only 3MB size of mail.

iBot running only one time upon scheduling

Sometime back we come across an issue in ibot. the ibot was running only once.
on analysing, we found that the next schedule time is getting update with randon date.
on further digging we found that, one more scheduler in different time zone was accessing this nq_job table.

Upon fixing it, ibot started running without any issue.

how to run DAC server in background?

DAC server is a program so as soon as you log off, the program also will be killed.
In order to run DAC server continuously, it should run in background.

this is achieble by running it under windows scheduler, using PSexec and running thro' remote login
In Unix , nohup can be used so that the program runs in back ground