BObj Server Clone Copy giving WIS 00027 error

[Former Member]

Apologies but I am new to BOBJ so I may be overlooking something simple here.

We are going through a process of moving our BObj Hardware.

As part of this we have created a clone copy of the BObj Server, same host name, different IP, different domain. After testing, this clone copy will become our Live BOBJ Server.

Both systems are connected to our LIVE BW Server.

I am comparing a WEBI report on the Live BOBJ Server against what the Clone BOBJ Server shows.

When I go to a WEBI report on Live and same in Clone via Document List I get the same results....good!

However, when I refresh the report in both environments, on Live this works OK, but in Clone I am getting an error, and I don't understand why I am getting this error but just on Clone Copy!!!!

The error states:

Removing skipped prompts from the query will introduce new prompts. This introduces complexities that cannot be supported (Error: WIS 00027)

Anyone got any ideas what is going on, what does the error mean and why am I only getting this on Clone?

We are BObj Enterprise XI

Many Thanks

SImon

[Former Member]

Some further information....

There are 2 Optional prompts I can see when I hit refresh all, these are for Fiscal Period and Fiscal Week. This is the same for both Live and Cloned environment.

However I can see one difference....

On Live when I hit refresh all, I get a selection screen for these variables, which has on the left hand side a List of Values, which is populated, with then a date of 30 August 2012 11:22:08 GMT+1 underneath. If I hit refresh values then the LOV is refreshed but the date changes to todays date.

On Clone, this LOV is empty and no date underneath. However if I hit refresh values, it does then populate the LOV and puts todays date underneath. I then run, but I still get the original error.

When I logged out and back in again on clone, I then got LOV populated by default, but still get WIS 00027 error. So no further forward on understanding why Live and Clone are behaving differently.

NOTE: Other WEBI queries seem to be behaving correctly and retrieve the same data for both Live and Clone with no errors.

Cheers

Simon