Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kevin Page 15 posts 35 karma points
    Feb 01, 2012 @ 15:01
    Kevin Page
    0

    Can't create or run XSLT scripts from hosted site

    Hi all !

    This is my first post so please be gentle ;)

    I've uploaded my first project to a hosting company (PipeTen) and have found that I'm not able ti either create or execute XSLT functions on the site.

    When I initially uploaded the site it was at version 4.6 and found that I needed to upgrade to 4.7.1.1 so that I could get it to work in a mudium trust environment.

    Since doing this most of the site is working,  but none of the XSLT's will run and I get the debug output below which complains about SQLServer CE (Which I'm not using as far as I know).

    I've spoken to the hosting company and they are sating that this is because Umbraco wants to run in full trust mode, but if that's the case I don't see how they can have anybody running as they also tell me that a full trust solution won't be available for a couple of weeks yet.

    I'm really lost at this point so any input would be greatly appreciated.

    Many Thanks in advance

    Kevin

     

    Request Details

    Session Id: id1qvb3abrlewpdogzgkuq5k Request Type: GET
    Time of Request: 01/02/2012 11:27:34 Status Code: 200
    Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)

    Trace Information

    CategoryMessageFrom First(s)From Last(s)
    aspx.page Begin PreInit    
    umbracoInit handling request 2.2784E-05 0.000023
    request handler current url '/virtual-tour/classroom-1.aspx' 0.000116288 0.000094
    umbracoRequestHandler Just before xPath query (True, '1345') 0.000152848 0.000037
    umbracoRequestHandler After xPath query 0.000175056 0.000022
    umbracoRequestHandler Access checking started 0.000206624 0.000032
    umbracoRequestHandler Page not protected 0.0002308 0.000024
    umbracoRequestHandler Access checking ended 0.000249088 0.000018
    umbracoInit Done handling request 0.00026704 0.000018
    umbracoPage Element loaded: mediaFolderId 0.000444832 0.000178
    umbracoPage Pagedata loaded for Classroom 1 (ID: 1345) 0.00047256 0.000028
    umbracoPage Looking up skin information 0.000501072 0.000029
    aspx.page End PreInit 0.000716992 0.000216
    aspx.page Begin Init 0.000743744 0.000027
    renderMacro Rendering started (macro: umb2ndLevelNavigation, type: 1, cacheRate: 0) 0.000779808 0.000036
    umbracoMacro Before adding extensions 0.00082256 0.000043
    umbracoMacro InnerException Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
    System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
    Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
    System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
      at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute)
      at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute)
      at umbraco.macro.GetXsltExtensionsImpl()
      at umbraco.macro.b__6()
      at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
      at umbraco.macro.GetXsltExtensions()
      at umbraco.macro.AddMacroXsltExtensions()
      at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
      at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
    0.030990384 0.030168
    item Start parsing 'pagecontent' 0.031235744 0.000245
    item Done parsing 'pagecontent' 0.031288592 0.000053
    renderMacro Rendering started (macro: Get Gallery Images, type: 1, cacheRate: 0) 0.031326048 0.000037
    umbracoMacro Before adding extensions 0.031374304 0.000048
    umbracoMacro InnerException Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
    System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
    Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
    System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
      at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute)
      at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute)
      at umbraco.macro.GetXsltExtensionsImpl()
      at umbraco.macro.b__6()
      at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
      at umbraco.macro.GetXsltExtensions()
      at umbraco.macro.AddMacroXsltExtensions()
      at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
      at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
    0.063219264 0.031845
    aspx.page End Init 0.063629408 0.000410
    aspx.page Begin InitComplete 0.063655968 0.000027
    aspx.page End InitComplete 0.063675168 0.000019
    aspx.page Begin PreLoad 0.0636932 0.000018
    aspx.page End PreLoad 0.06371296 0.000020
    aspx.page Begin Load 0.063731104 0.000018
    aspx.page End Load 0.063779712 0.000049
    aspx.page Begin LoadComplete 0.063800992 0.000021
    aspx.page End LoadComplete 0.063819568 0.000019
    aspx.page Begin PreRender 0.063837648 0.000018
    aspx.page End PreRender 0.063861904 0.000024
    aspx.page Begin PreRenderComplete 0.063882192 0.000020
    aspx.page End PreRenderComplete 0.063900752 0.000019
    aspx.page Begin SaveState 0.0643628 0.000462
    aspx.page End SaveState 0.06444592 0.000083
    aspx.page Begin SaveStateComplete 0.06446936 0.000023
    aspx.page End SaveStateComplete 0.064488144 0.000019
    aspx.page Begin Render 0.06450592 0.000018
    Resolve Urls 0 0.064761008 0.000255
    aspx.page End Render 0.06504376 0.000283

    Control Tree

    Control UniqueIDTypeRender Size Bytes (including children)ViewState Size Bytes (excluding children)ControlState Size Bytes (excluding children)
    __Page ASP.default_aspx 4233 0 0
        ctl00 ASP.masterpages_gallery_master 0 0 0
            ctl00$ctl00 ASP.masterpages_common_master 0 0 0
                ctl00$ctl00$ctl00 ASP.umbraco_masterpages_default_master 0 0 0
                    ctl00$ctl00$ctl00$ContentPlaceHolderDefault System.Web.UI.WebControls.ContentPlaceHolder 0 0 0
                        ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl00 System.Web.UI.LiteralControl 0 0 0
                        ctl00$ctl00$ctl00$ContentPlaceHolderDefault$stylesheet System.Web.UI.WebControls.ContentPlaceHolder 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$stylesheet$ctl00 System.Web.UI.LiteralControl 0 0 0
                        ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl01 System.Web.UI.LiteralControl 0 0 0
                        form1 System.Web.UI.HtmlControls.HtmlForm 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl02 System.Web.UI.LiteralControl 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$Nav System.Web.UI.WebControls.ContentPlaceHolder 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$Nav$ctl01 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$Nav$ctl00 umbraco.presentation.templateControls.Macro 0 0 0
                                    ctl00$ctl00$ctl00$ContentPlaceHolderDefault$Nav$ctl02 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$Nav$ctl03 System.Web.UI.LiteralControl 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl03 System.Web.UI.LiteralControl 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container System.Web.UI.WebControls.ContentPlaceHolder 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl02 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl00 umbraco.presentation.templateControls.Item 0 0 0
                                    ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl00$ctl00 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl03 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl01 umbraco.presentation.templateControls.Macro 0 0 0
                                    ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl04 System.Web.UI.LiteralControl 0 0 0
                                ctl00$ctl00$ctl00$ContentPlaceHolderDefault$main_container$ctl05 System.Web.UI.LiteralControl 0 0 0
                            ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl04 System.Web.UI.LiteralControl 0 0 0
                        ctl00$ctl00$ctl00$ContentPlaceHolderDefault$ctl05 System.Web.UI.LiteralControl 0 0 0

    Session State

    Session KeyTypeValue
    windowHeight System.String  
    windowWidth System.String  

    Application State

    Application KeyTypeValue
    umbracoUrl System.String www.osbit.co.uk:80/umbraco
    umbracoNeedConfiguration System.Boolean False

    Request Cookies Collection

    NameValueSize
    UMB_UCONTEXT 0f466746-6a09-44d4-a209-4543d0a52297 49
    ASP.NET_SessionId id1qvb3abrlewpdogzgkuq5k 42
    UMB_UPDCHK 1 12

    Response Cookies Collection

    NameValueSize

    Headers Collection

    NameValue
    Connection Keep-Alive
    Via 1.0 SOHTMG003, 1.1 SOHTMG002
    Accept image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
    Accept-Encoding gzip
    Accept-Language en-gb
    Cookie UMB_UCONTEXT=0f466746-6a09-44d4-a209-4543d0a52297; ASP.NET_SessionId=id1qvb3abrlewpdogzgkuq5k; UMB_UPDCHK=1
    Host www.osbit.co.uk
    User-Agent Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; AskTbESP/5.12.2.16749)
    X-Forwarded-For 10.146.41.21

    Response Headers Collection

    NameValue
    X-AspNet-Version 4.0.30319
    Cache-Control private
    Content-Type text/html

    Form Collection

    NameValue

    Querystring Collection

    NameValue
    umbdebugshowtrace true

    Server Variables

    NameValue
    ALL_HTTP HTTP_CONNECTION:Keep-Alive HTTP_VIA:1.0 SOHTMG003, 1.1 SOHTMG002 HTTP_ACCEPT:image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* HTTP_ACCEPT_ENCODING:gzip HTTP_ACCEPT_LANGUAGE:en-gb HTTP_COOKIE:UMB_UCONTEXT=0f466746-6a09-44d4-a209-4543d0a52297; ASP.NET_SessionId=id1qvb3abrlewpdogzgkuq5k; UMB_UPDCHK=1 HTTP_HOST:www.osbit.co.uk HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; AskTbESP/5.12.2.16749) HTTP_X_FORWARDED_FOR:10.146.41.21
    ALL_RAW Connection: Keep-Alive Via: 1.0 SOHTMG003, 1.1 SOHTMG002 Accept: image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* Accept-Encoding: gzip Accept-Language: en-gb Cookie: UMB_UCONTEXT=0f466746-6a09-44d4-a209-4543d0a52297; ASP.NET_SessionId=id1qvb3abrlewpdogzgkuq5k; UMB_UPDCHK=1 Host: www.osbit.co.uk User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; AskTbESP/5.12.2.16749) X-Forwarded-For: 10.146.41.21
    APPL_MD_PATH /LM/W3SVC/481/ROOT
    APPL_PHYSICAL_PATH H:\hshome\osbit\osbit.co.uk\
    AUTH_TYPE  
    AUTH_USER  
    AUTH_PASSWORD  
    LOGON_USER  
    REMOTE_USER  
    CERT_COOKIE  
    CERT_FLAGS  
    CERT_ISSUER  
    CERT_KEYSIZE  
    CERT_SECRETKEYSIZE  
    CERT_SERIALNUMBER  
    CERT_SERVER_ISSUER  
    CERT_SERVER_SUBJECT  
    CERT_SUBJECT  
    CONTENT_LENGTH 0
    CONTENT_TYPE  
    GATEWAY_INTERFACE CGI/1.1
    HTTPS off
    HTTPS_KEYSIZE  
    HTTPS_SECRETKEYSIZE  
    HTTPS_SERVER_ISSUER  
    HTTPS_SERVER_SUBJECT  
    INSTANCE_ID 481
    INSTANCE_META_PATH /LM/W3SVC/481
    LOCAL_ADDR 89.248.51.22
    PATH_INFO /default.aspx
    PATH_TRANSLATED H:\hshome\osbit\osbit.co.uk\default.aspx
    QUERY_STRING umbdebugshowtrace=true
    REMOTE_ADDR 194.176.105.135
    REMOTE_HOST 194.176.105.135
    REMOTE_PORT 54481
    REQUEST_METHOD GET
    SCRIPT_NAME /default.aspx
    SERVER_NAME www.osbit.co.uk
    SERVER_PORT 80
    SERVER_PORT_SECURE 0
    SERVER_PROTOCOL HTTP/1.1
    SERVER_SOFTWARE Microsoft-IIS/7.0
    URL /default.aspx
    HTTP_CONNECTION Keep-Alive
    HTTP_VIA 1.0 SOHTMG003, 1.1 SOHTMG002
    HTTP_ACCEPT image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
    HTTP_ACCEPT_ENCODING gzip
    HTTP_ACCEPT_LANGUAGE en-gb
    HTTP_COOKIE UMB_UCONTEXT=0f466746-6a09-44d4-a209-4543d0a52297; ASP.NET_SessionId=id1qvb3abrlewpdogzgkuq5k; UMB_UPDCHK=1
    HTTP_HOST www.osbit.co.uk
    HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; AskTbESP/5.12.2.16749)
    HTTP_X_FORWARDED_FOR 10.146.41.21

    Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

  • Kevin Page 15 posts 35 karma points
    Feb 02, 2012 @ 13:59
    Kevin Page
    0

    I found the solution to this problem !

    So, just in case someone else has it, here's what I did wrong . . .

    When I transferred the database from my dev environment to the live environment I use the SQL Server Export/Import tool.

    This tool only transfers the data and creates the 'basic' tables, but does not create primary/foriegn keys and identity fields, etc so my data was a bit of a mess :(

    I had to use the 'Generate Scripts' tool (right click on database in SSMS and it's under the 'tasks' menu) to create the tables correctly, without the foriegn keys.

    I then used the tool again to transfer just the data (Without blowing any foriegn key contraints as they haven't been created).

    Then I ran the tool a third time to create the missing foriegn keys.

    BTW - I also used SQL Data Compare (Redgate tool) to make sure the databases were in sync).

    Hope it helps !

Please Sign in or register to post replies

Write your reply to:

Draft