Copied to clipboard

Flag this post as spam?

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


  • Dennis Spijkerboer 53 posts 95 karma points
    Nov 06, 2015 @ 13:27
    Dennis Spijkerboer
    0

    Courier media types not deployed

    Hi,

    We have a 7.3.0 umbraco installation with the latetst version of courier. Now we want to deploy a media type. This fails with the message:

    System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsPropertyType] [SQL: INSERT INTO cmsPropertyType (Alias, contentTypeId, dataTypeId, uniqueID, Description, mandatory, Name, sortOrder, validationRegExp, propertyTypeGroupId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] ---> Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'. The duplicate key value is (00000000-0000-0000-0000-000000000000). The statement has been terminated.

    I don't have a .dll with v6 in there so I guess this namespace is still being used somewhere.

    In the Courier folder I found the MediaType Courier file. All properties have a UniqueId of 00000000-0000-0000-0000-000000000000.

    See the following part in my .courier file:

    <Properties>
            <ContentTypeProperty>
                <UniqueId>00000000-0000-0000-0000-000000000000</UniqueId>
                <Alias>sizeumbracoBytes</Alias>
                <DataTypeDefinitionId>f0bc4bfb-b499-40d6-ba86-058885a5178c</DataTypeDefinitionId>
                <Description />
                <Mandatory>false</Mandatory>
                <Name>Size</Name>
                <SortOrder>3</SortOrder>
                <TabCaption>afbeelding </TabCaption>
                <Validation />
            </ContentTypeProperty>
    

    How to fix this?

  • Dennis Spijkerboer 53 posts 95 karma points
    Nov 09, 2015 @ 10:06
    Dennis Spijkerboer
    0

    Another issue. The propertydata is not being updated. If there is a change in the value of a property is not being updated on the target.

    If I look into the files generated by courier the right version of the content is in there. The log says it's extracting the property data and it's finishing as well. But I see no change in the doucment and no errors in the logs.

  • Niels Hartvig 1951 posts 2391 karma points c-trib
    Nov 09, 2015 @ 10:12
    Niels Hartvig
    0

    Hi Dennis!

    Sorry to hear that it's not working as it should. What version of Courier are you using?

    Best, Niels...

  • Dennis Spijkerboer 53 posts 95 karma points
    Nov 09, 2015 @ 10:17
    Dennis Spijkerboer
    0

    Hi Niels,

    Thanks for you reply. We use 2.51.2, the hotfix.

  • Claus Jensen 49 posts 157 karma points hq
    Nov 09, 2015 @ 11:53
    Claus Jensen
    0

    Hi Dennis,

    We are aware of these issues and have bugfixes for it in the next release of Courier which is due to be released soon. Hopefully that will solve your problems with deployments.

    The namespace thing is a leftover compatibility thing. It should just be ignored - don't worry - everything is v7 ;-)

    Here's a link for the issue on our tracker if you have interest in knowing what the problem was about: http://issues.umbraco.org/issue/COU-203

    Best,

    Claus

  • Dennis Spijkerboer 53 posts 95 karma points
    Nov 09, 2015 @ 12:09
    Dennis Spijkerboer
    0

    Hi Claus,

    Thanks for your response. I updated my solution with the nightly Courier.v2.51.3-nightly265.HotFix.zip. Still run into this issue, wrong nightly? (updated this on the issuetracker as well).

    Maybe you can create an issue for the 'error screen'? Instead of an update message with 'something went wrong', you just see a blank screen. I use the rightclick 'courier' button on my media item. If deployments succeed you get a nice confirmation, but there is no error message.

    Beside my mediatype issue, I have issues with normal content as well, are they fixed a nightly build?

  • Sebastiaan Janssen 5044 posts 15475 karma points MVP admin hq
    Nov 09, 2015 @ 13:16
    Sebastiaan Janssen
    0

    DId you update Courier on both ends (source and destination)?

    Also, do you get the exact same error in the logs? (Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'.)

  • Dennis Spijkerboer 53 posts 95 karma points
    Nov 09, 2015 @ 13:22
    Dennis Spijkerboer
    0

    Yes, both ends. Deleted courier folders in app_data and restarted app pool.

    could not insert: [Umbraco.Courier.Persistence.V6.NHibernate.EntityClasses.CmsPropertyType][SQL: INSERT INTO cmsPropertyType (Alias, contentTypeId, dataTypeId, uniqueID, Description, mandatory, Name, sortOrder, validationRegExp, propertyTypeGroupId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.cmsPropertyType' with unique index 'IXcmsPropertyTypeUniqueID'. The duplicate key value is (00000000-0000-0000-0000-000000000000). The statement has been terminated.

    Part of the .courier file for the mediatype:

    <ContentTypeProperty>
                <UniqueId>00000000-0000-0000-0000-000000000000</UniqueId>
                <Alias>sizeumbracoBytes</Alias>
                <DataTypeDefinitionId>f0bc4bfb-b499-40d6-ba86-058885a5178c</DataTypeDefinitionId>
                <Description />
                <Mandatory>false</Mandatory>
                <Name>Size</Name>
                <SortOrder>3</SortOrder>
                <TabCaption>afbeelding </TabCaption>
                <Validation />
            </ContentTypeProperty>
    

    If you want to, I can send you the entire .courier file for this media item.

  • Sebastiaan Janssen 5044 posts 15475 karma points MVP admin hq
    Nov 09, 2015 @ 13:25
    Sebastiaan Janssen
    0

    Yes, I'd definitely like to have the whole courier file for this mediatype.

  • Luciox 22 posts 115 karma points
    Nov 18, 2015 @ 09:35
    Luciox
    0

    Hi - Where can I find Courier.v2.51.3-nightly265.HotFix.zip? We're having issues too and I've like to try this. Thanks

  • Claus Jensen 49 posts 157 karma points hq
    Nov 18, 2015 @ 09:42
    Claus Jensen
    0

    Hi Luciox,

    You can find the nightly builds here: http://nightly.umbraco.org/?container=umbraco-deploy

    Best, Claus

  • Sebastiaan Janssen 5044 posts 15475 karma points MVP admin hq
    Nov 18, 2015 @ 09:41
    Sebastiaan Janssen
    100

    Make sure to use 268, 265 was actually the wrong version (my bad, sorry):

    http://nightly.umbraco.org/?container=umbraco-deploy

  • Luciox 22 posts 115 karma points
    Nov 18, 2015 @ 09:43
    Luciox
    0

    Thank you both for your quick replies :-) I shall try it! Kind regards

Please Sign in or register to post replies

Write your reply to:

Draft