You are viewing limited content. For full access, please sign in.

Question

Question

"unable to find requested .net data provider" when configuring WF server at 9.1.1

asked on February 25, 2014

 Hi, my customer installed WF 9.1.1 and is getting ‘Unable to find the requested .Net Framework Data Provider. It may not be installed"  when she tries to configure WF server.  They have uninstalled WF and reinstalled to no avail. .Net Framework 4.5 is installed.  win2008 r2 std sp1

 

I and others believe that this is a .net issue but user does not think so.

Any help would be appreciated.

Thanks, Valerie

 

 

0 0

Answer

SELECTED ANSWER
replied on February 26, 2014

I think your bottom right screenshot is going to help us resolve this issue.

 

Can you check this http://forums.asp.net/t/1693277.aspx?+DbProviderFactories+section+can+only+appear+once+per+config+file+error article to see if it resolves this issue.

 

The article content is to:
 

Check these two files on the machine (start with the 4.0 version first).


C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\Machine.Config

C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\Machine.Config

 

Look for the <system.data> element.

 

Underneath it, check if there are two DbProviderFactories elements. One element most likely will have elements, the other would be blank. It might look like <DbProviderFactories />. Remove the blank.

 

If there are two and they both have elements, combine the elements into one block.

 

0 0

Replies

replied on February 25, 2014

Are you getting this in the WF Configuration Manager? If so, there should be a log file under C:\ProgramData\Laserfiche\WF\ConfigurationLogs with the full error message. Can you attach it here?

0 0
replied on February 25, 2014

Hi Miruna, I have attached log. Why would it wanting ODAC if using SQL?

0 0
replied on February 25, 2014

Are you trying to use Workflow with Oracle?

0 0
replied on February 26, 2014

Hi Miruna, no they are not.

0 0
replied on February 26, 2014 Show version history
  • Is this an upgrade installation?
    • If so, from what version of workflow?
  • When you open the configuration manager, does the workflow server say 'Not configured' or 'Please click to upgrade'?
  • Do you know when this error is reported?
    • Is it when you click on the link from the configuration manager
    • After a certain step in the workflow wizard?
      • If so what step?

 

 

 

0 0
replied on February 26, 2014

One other thing to check for is older config files named 'Laserfiche.Workflow.Service.exe.90.config' or 'Laserfiche.Workflow.Service.exe.83.config' in the workflow install directory. If they are present, open them in a text editor and search for the value oracle="true". If that is present, try setting it to be oracle="false".

0 0
replied on February 26, 2014

Ed, User does not have either of the config files like you mentioned. She has only  Laserfiche.Workflow.Service.exe.config and there is not ‘oracle’ reference in the file.

 

•Is this an upgrade installation? •If so, from what version of workflow?
No this is a new installation of workflow 9.1.1

•When you open the configuration manager, does the workflow server say 'Not configured' or 'Please click to upgrade'? Yes ( see attached)
 
•Do you know when this error is reported? •Is it when you click on the link from the configuration manager
When I click on the link to configure the server and I click the dropdown list to give me all the SQL Servers on the network. ( see attached)

0 0
replied on February 27, 2014

Ed, thanks. That worked.

0 0
replied on May 22, 2014

Hi Ed.  What ended up being the fix for this issue?  I'm running into the very same issue all the way down to Valerie's last response about only having the Laserfiche.Workflow.Service.exe.config and there is not ‘oracle’ reference in the file.  Thanks.

0 0
replied on May 22, 2014

If you are upgrading, you might need to check Laserfiche.Workflow.Service.exe.83.config or Laserfiche.Workflow.Service.exe.90.config as well.

 

 

You can also manually add it though if its not there I'm less sure if its the same issue. Find the <serviceConfig element in the Laserfiche.Workflow.Service.exe.config file and add oracle="false". 

0 0
replied on November 13, 2014

I'm having this exact symptom with a brand new Server 2012 R2 installation of 9.2 we started today. I looked in the config files for that <DbProviderFactories /> entry and found that in the 4.x version file referenced in the "answer" post. I cleaned that up and restarted but the symptom persists. I have also looked for the oracle=true statement in Laserfiche.Workflow.Service.exe.config and cannot find it.

0 0
replied on November 14, 2014

For anyone still struggling with this you need to search your entire machine for all instances of machine.config files and fix the DbProviderFactories error in all of them, not just the two folders mentioned above.

0 0
replied on November 18, 2014

Here is the kb that discusses the issue and how to address it.

https://support.laserfiche.com/KB/1013583

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.