An error occurred while running the screen. Error details: the underlying provider failed on open

Question

Hi,

We have deployed an application as follows:

• 3 Tier Application (SQL Server 2008, IIS 6.0, Desktop client)
• Windows authentication

The application was working fine. Suddenly, after a power failure this morning, the customer informed us that the application opens, menus appear as expected but, when opening any screen, she is getting the error message: "An error occurred while running the screen. Error details: the underlying provider failed on open".

We have checked that all related databases are online and accessible from the application server (i.e. I can connect to them using Management Studio from the application server). I have searched the web for this error but no luck.

Please help me find a solution to this. Any hint would be highly appreciated!

Thanks in advance,

Kostas

Answer 1

Hi

You said after a power failure, that's can't work, I belive there may have some service you haven't start.

I would like to suggest you read this first:

http://lightswitchhelpwebsite.com/MyWall/tabid/74/asuid/956/Default.aspx

You may have same problem.

If still have the problem, please post your trace message here.

Answer 2

Someimes, in cases like this, I've found that deleting the ApplicatIonDatabase's log file (from the bin\Data folder), or renaming1 if you want to be more careful, can help. But it's not a magic bullet, it doesn't always work. It rally depends on what the underlying problem is.

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.

Answer 3

Hi friends, thanks for the answers.

Finally there was an issue with the external db connection strings. I recompiled the application and now it works. Not sure why we hadn't noticed so far. Anyway, problem solved so thanks again and sorry for the misguidance!

Regards,

Kostas

Answer 4

No problem. I'm just glad that you got it working again.

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.