Hi @anasazii You can always pre-set the prompt values with a Go&URL passing also the "&Option=d" to download to excel. This could save you time if done properly For more information about the Go&Url check https://docs.oracle.com/cd/E14571_01/bi.1111/e16364/apiwebintegrate.htm#BIEIT357

there are multiple ways to achieve this, One of them would be to create a column in the RPD e.g. "Sales at year level" <- setting the level in the time hierarchy to Year The rest is usual columns and filtering

is the biee-config.lock; file still there after the restart? If so can you try deleting it before uploading the RPD?

I would try: 1) Release Configuration 2) a server restart. The old RPD should still be there if you didn't manually deleted it

Have you tried releasing the lock?

If you upload an RPD generated on a newer system (12.2.1.2) to an older one (12.2.1.1) there is no guarantee that it will work. There was in 11g an utility to downgrade RPD version, worth checking if it still exists in 12c https://www.jamescoyle.net/how-to/1824-downgrade-an-obiee-rpd-version

In the Log message there is nothing wrong... have you tried checking other server logs?

As others said, are you sure the user you are using has the necessary privileges?

The problem is not in the OBIEE-LDAP filter I would say... The problem is in your static list of users... Do you have specific data filters tied up with those users? do you need the Run-as for this purpose? Can you take the list of users from an analysis instead of a static list? If so you could create a SA on top of MSAD…

@Christian Berg i believe he doesn't use a dynamic list but rater a static list. But when a user in his static list gets disabled, since he Agent "run As" the recipient the whole agent fails.

The problem is that the list you're showing is a fixed list of users. So if you add a user there and after it's disabled you'll always have the same error. If you have more than 1 user (with at least one disabled) does it fail for all of them?

I believe it's also strange you have two prompts based on the same column "Time"."Date". I would create one of the two as "Variable prompt" (if they exist in 11g) or change the "select column" for one of them

Are you running the Agent as a deleted user? If so it makes sense that the Agent fails since the user is no longer there. If it's in the recipient list it should only fail for that particular user but still sending it to all other users.

Pasting a thousand of log file lines means you don't have any idea on how log files are structured 1) there is a timestamp that you should use to parse only relevant information -> If you do the restart now you don't need to paste logs from yesterday 2) Info -> OK, warning -> not too OK, ERROR -> BAD this gives you a clue…

can you check the biserver1.log of the time of the restart and check if there are ERRORS? 3rd time i say the same thing...

Again, what happens if you restart the whole processes now. Have a look at biserver1.log and report back errors

Where have you got the informations? the log seems to be of yesterday... what happens if you shutdown everything and start it up again? 3036454 wrote:Please check if this gives more information: ####<Apr 18, 2017 9:03:55 AM AST> <Error> <HTTP> <skvorabitest1.emaarec.com> <bi_server1> <[ACTIVE] ExecuteThread: '0' for queue:…

There is not much in the logs... there should be a line with ERROR somewhere at least...

Are you exporting manually or are you using an iBot? if using the iBot are you setting a particular user there that is not the one with the correct timezone?

It may be due to Logical Table Source Levels set up incorrectly like other 100 reasons... but is hard to tell with almost 0 informations