StrataFrame Forum

Webservice error

http://forum.strataframe.net/Topic27436.aspx

By Chris Diesel - 6/15/2010

I am getting a strange web service error message.  We have had a web service and sql data hosted by Network Solutions running for about 6 months. 

We have not made any code updates.  On Monday morning, we started receiving this message when calling a web method that uses business objects.

For a test I tried adding a new web method that accessed the data directly via a sqlconnection, sqldataadaptor and dataset (no business object call).  This method executes and returns the data without error.

Network Solutions said everything looks good from their end. Wink

Any ideas would be appreciated.

System.Web.Services.Protocols.SoapException: Server was unable to process request.

---> MicroFour.StrataFrame.Data.DataLayerException: An error occurred while creating a new DataLayer for the business object.

---> System.Security.SecurityException: Request failed.
   at MicroFour.StrataFrame.Data.DataLayer.Create(BusinessLayer BusinessObject, ISynchronizeInvoke SyncObject, Boolean CheckDesignTime)
   at MicroFour.StrataFrame.Business.BusinessLayer.CreateDataLayer()
   at MicroFour.StrataFrame.Business.BusinessLayer.get__DataLayer()
The action that failed was:
LinkDemand
The type of the first permission that failed was:
System.Security.PermissionSet
The demand was for:
<PermissionSet class="System.Security.PermissionSet"
version="1"
Unrestricted="true"/>

The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="TEMP;TMP;USERNAME;OS;COMPUTERNAME"/>
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="E:\0\1\75\29\1890355\user\2056053\htdocs"
Write="E:\0\1\75\29\1890355\user\2056053\htdocs"
Append="E:\0\1\75\29\1890355\user\2056053\htdocs"
PathDiscovery="E:\0\1\75\29\1890355\user\2056053\htdocs"/>
<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Allowed="AssemblyIsolationByUser"
UserQuota="9223372036854775807"/>
<IPermission class="System.Security.Permissions.ReflectionPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="RestrictedMemberAccess"/>
<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion, Execution, ControlThread, ControlPrincipal, RemotingConfiguration"/>
<IPermission class="System.Security.Permissions.StrongNameIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100D78C4B09190B122AF925789234101807299AA768F67178065DC7649

5DD0F4DCE2AC3376CDCD428DC32816C30144D5729E358057A2D43145C1DA91F38FA98061ABB73C1C722FACE829A7F7B605834D3FD8291D5BA8EA411BA54DE87F9

A9044BC7155522AE2BEC7259A79002DF45E486D715E94CFC50274A14201C01F89434A2A2"
Name="MicroFour StrataFrame Business"
AssemblyVersion="1.7.0.0"/>
<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file:///E:/0/1/75/29/1890355/user/2056053/htdocs/bin/MicroFour StrataFrame Business.DLL"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="MyComputer"/>
<IPermission class="System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Level="Medium"/>
<IPermission class="System.Net.DnsPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
version="1"
Level="DefaultPrinting"/>
<IPermission class="System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Access="Connect"/>
<IPermission class="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
</PermissionSet>

The assembly or AppDomain that failed was:
MicroFour StrataFrame Business, Version=1.7.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7
The Zone of the assembly that failed was:
MyComputer
The Url of the assembly that failed was:
file:///E:/0/1/75/29/1890355/user/2056053/htdocs/bin/MicroFour StrataFrame Business.DLL
   --- End of inner exception stack trace ---
   at MicroFour.StrataFrame.Business.BusinessLayer.get__DataLayer()
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
   at IWPBusinessObjects.IwbLicenses.FillBySerialNbr(String serialNbr) in C:\VssProjs\IwSystems\IwSystems\IWPBusinessObjects\IwbLicenses.cs:line 77
   at IWPBusinessObjects.IwbActivations.RecordProductStartup(String serialNbr, String computerName, String macAddress) in

C:\VssProjs\IwSystems\IwSystems\IWPBusinessObjects\IwbActivations.cs:line 281
   at IWProductServices.IWProducts.RecordProductStartup(String serialNbr, String workstationName, String macAddress) in

C:\VssProjs\IwSystems\IwSystems\IwPServer\IWProducts.asmx.cs:line 51
   --- End of inner exception stack trace ---
By Ivan George Borges - 6/15/2010

Hi Chris.

Were you running on 1.7.0.0 before or have you just upgraded?

By Chris Diesel - 6/15/2010

I upgraded the web service when I just published the test method.  I don't have the original exception text from the prior version except in a screen shot (which I can't seem to find on my tidy desk).  Best I can tell, this exception is the same as the original besides the version numbers.
By Ivan George Borges - 6/16/2010

It looks like the application attempted to perform an operation not allowed by the security policy. See if this points you in the right direction:

http://support.microsoft.com/kb/555466/en-us

http://www.eggheadcafe.com/forumarchives/NETsecurity/Jan2006/post25834724.asp

By Chris Diesel - 6/22/2010

Network Solutions finally admitted that they are having issues.w00t

Thanks for your time!

By Ivan George Borges - 6/22/2010

Got it, Chris.

You are welcome! Wink

By Chris Diesel - 7/12/2010

Unfortunately Network Solutions is not helping with this. 

The following tests worked:

  • Access the same data from the web service method using ADO.NET
  • Call a DLL from the web service method that uses ADO.NET to access the same data

But when I try to use the FillDataTable or GetDataTable methods from my business object module, I get the above error.  What  are these methods doing different that would cause a SecurityException when ADO.NET does not?