Refresh problem

system · June 21, 2004, 1:37pm

Hi,
I have a report when I refresh it for first time it says Data provider has not been successfully refreshed DMA0007.when I refresh it second time it pulls the data with out any problem.Its happening in full client.
Did any one encountered such type of problem?.

Thankyou

karen (BOB member since 2003-06-18)

system · June 21, 2004, 2:01pm

I would check on the database and see if it is executing a query the first time. The problem may be on the DB side of it and not the BO side.

scott copeland (BOB member since 2002-08-15)

system · June 21, 2004, 2:14pm

Scott,
How can we check that query is executing on first time on database side?

karen (BOB member since 2003-06-18)

system · June 21, 2004, 2:58pm

Your DBA should be able to help with this - either by watching active threads, looking in log files or setting up a trace. Even if the problem is not on the database this time, you’ll still need to be able to check this at some point for other bugs that come up.

scott copeland (BOB member since 2002-08-15)

system · June 21, 2004, 4:12pm

Thankyou

karen (BOB member since 2003-06-18)

system · June 22, 2004, 1:35pm

The query is running fine on database.Is this anything to do with prompts on the report?

karen (BOB member since 2003-06-18)

system · June 22, 2004, 6:09pm

Unlikely it has to do with the prompts, but it could.

Also, check your universe connection. It should be set to disconnect after each transaction. Also, if this is being done via ZABO, it has to be a Syncrhonous connection.

Steve Krandel (BOB member since 2002-06-25)

system · June 22, 2004, 6:18pm

What version and are you using WEBi or full client?

Randy Jones (BOB member since 2002-08-19)

system · June 22, 2004, 9:01pm

Thanks for th einfo guys.We are running on webi2.7.3/5.1.7.The report is having problem both on full client and webi.Universe connections is set to disconnect after each transaction.i checked all the connection stuff.

Report has 3 dataproviders using the same universe.

karen (BOB member since 2003-06-18)

system · August 9, 2004, 4:19am

How do i set the connection to Synchronous. I’m facing the same problem in ZABO 518. Also i’m getting the error message: DMA0007 even though i’m selecting correct value in the prompt and then clicking OK. The report works fine in full client. Could you please shed some light ?

BOisBest (BOB member since 2004-04-05)

system · August 9, 2004, 1:50pm

You use Designer or Supervisor to edit Connections (Tools, Connections, Edit, Advanced tab).

Dwayne Hoffpauir (BOB member since 2002-09-19)