BusinessObjects Board

DSL could not create the Provider (XLS 000020).

other Xcelsius - Crystal Dashboard Design
#1

Hi,

I have this peculiar issue with Dashboards all of a sudden. I was in the process of wrapping up a dashboard and had 60+ queries built out when I started seeing this error: DSL could not create the Provider (XLS 000020). This happens when I edit an existing query - the objects and filters show up, but when I hit ‘next’, it throws this error. I see the same error when I try to create a new query as well. When I use one object in a query, it lets me go to the next screen and shows me the data, as soon as I add another object, it throws the error again. This happens on a blank dashboard also and even when I download the dashboard on another users machine as well, so its probably not local to my installation.

Whats more funky is that, when I compile and publish the entire dashboard, all 60+ queries refresh just fine on Infoview. I can change selections using drop downs and radio buttons and every single query refreshes fine.

I have tried restarting the APS, tried using the Java updater tool to refresh the universe for the dashboard, captured logs and fiddler outputs and am able to share that if needed. I would appreciate any help I can get here.

Thanks,
Amit

amitmishra4 :us: (BOB member since 2007-11-05)

#2

Fixed the issue. Just wanted to update the post in case anyone else ever has this issue in the future. It was not caused by anything on the server or the dashboard, but a simple @prompt in the universe. I had hard-coded the list of values in the @prompt and the Query Browser in Dashboards was not liking something about it. It was working fine in IDT and also when published as a flash file, but just not in Query Browser.

I wish the errors were a little more descriptive. Looking through the logs and fiddler exports did not help at all. We had no clue where the issue originated from. We started painfully undoing any changes we made to the universe one at a time and when we reversed this change, it fixed it. Then we proceeded to re-apply other changes and the dashboard behaved fine.

Thank you and good luck!

amitmishra4 :us: (BOB member since 2007-11-05)