After executing a report service document in Strategy Web 9.x and clicking on the re-prompt button, the following error message is shown:
Object with ID xxx Type 10 (Prompt) is not found in metadata, it may have been deleted. System Error 0x8000FFFF (2147549183): --- Catastrophic failure).
This issue happens with the report service documents that contain datasets previously created in Strategy 8.x which have prompt objects newly added to them in Strategy 9.x.
Contact Strategy Technical Support for an update on this issue.
Perform the following steps:
1. Edit the affected dataset and remove all of its prompt objects.
2. Save and close the dataset without any prompt.
3. Edit the dataset again and re-add all of its prompt objects.
4. Save and close.
NOTE: Read the following tech note for further information on a similar issue in Strategy Desktop 8.1.x:KB16633: Object prompts reappear on a report when clicking 'Re-prompt' after the original static report with object prompts has been modified to add a filter with normal prompts in MicroStrategy Desktop 8.1.x