jamesheliker
Level 1 (0 points)

Q: fcsvr_client make_link not working!

Hi,

I'm using the following command:

sudo fcsvr_client make_link --linktype 4 /asset/1/ /dev/7/testproxy.mov

As far as I know this should link my file testproxy.mov to /asset/1 as the Clip Proxy.

However, I'm receiving this error on the command line:

{ CODE = E_DATABASE, DESC = ERROR: null value in column "parententityid" violates not-null constraint, SRC_FILE = PmsTask_Db.C, SRC_LINE = 295 }

Anyone have any ideas? All the other commands on fcsvr_client work well for me, but this just won't work. I really need to be able to link up proxy files without FCS making them in Compressor.

Thanks in advance!

- James Heliker
james.heliker@gmail.com

Mac OS X (10.5.8), FCSvr Version 1.5.1

Posted on Feb 3, 2011 11:59 AM

Close
jamesheliker

Q: fcsvr_client make_link not working!

  • All replies
  • Helpful answers

  • by A. Richards,

    A. Richards A. Richards Feb 3, 2011 5:14 PM in response to jamesheliker
    Level 3 (625 points)
    Feb 3, 2011 5:14 PM in response to jamesheliker
    Maybe just a typo in your post, but you have an extra forward slassh on the end of "/asset/1". That could be throwing it off and giving you the "address must be not-null" error.

  • by jamesheliker,

    jamesheliker jamesheliker Feb 4, 2011 12:26 PM in response to A. Richards
    Level 1 (0 points)
    Feb 4, 2011 12:26 PM in response to A. Richards
    Yeah, it was a typo in my post. Any thoughts? The make_link has only successfully worked for me when linking two assets so far.

  • by A. Richards,

    A. Richards A. Richards Feb 6, 2011 11:31 AM in response to jamesheliker
    Level 3 (625 points)
    Feb 6, 2011 11:31 AM in response to jamesheliker
    I've had unpredictable results with make_link, and have therefore not played with it much. In my limited experience with it, it seemed to have undocumented limitations as to which linktypes were supported in a given situation. Are you attempting to link a proxy to an asset that does not have one, or are you trying to replace an existing clip proxy?

  • by jamesheliker,

    jamesheliker jamesheliker Feb 6, 2011 12:27 PM in response to A. Richards
    Level 1 (0 points)
    Feb 6, 2011 12:27 PM in response to A. Richards
    Hi Andrew,

    I've tested the make_link command both with assets with existing clip proxies, and assets without them. Neither works for me, and in the case of an existing clip proxy, the "--movelink" option doesn't seem to affect my results either.

    Have you had any success at all with linktype 4?

    I'm running blind with no documentation - it sure would be nice if Apple decided to support their own product. I work for what I'm sure is one of their top end customers - heck Steve Jobs is on our board of directors. That doesn't seem to make one bit of difference.

    Thanks

    - James Heliker,
    Digital Media Engineer
    Disney / ABC Television Group
    James.X.Heliker@disney.com

  • by A. Richards,

    A. Richards A. Richards Feb 6, 2011 12:33 PM in response to jamesheliker
    Level 3 (625 points)
    Feb 6, 2011 12:33 PM in response to jamesheliker
    James,

    You're seeing the same thing I saw when I tried to use make_link. I was trying to link up linktype 2 (original media) to see if I could "relink" a la FCP. It worked once, and then duplicating my actions it never worked again. I tried all kinds of combinations. I did not try linking proxies. Eventually I gave up and chalked it up as a poorly implemented command on fcsvr_client that perhaps was conceived for the purpose of making only certain links in certain situations.

    It is frustrating, I agree. Sorry I couldn't be of more help.

    -Andrew Richards,
    VP of Product Development
    Media Solutions Group
    Keeper Technology
    andrew.richards@keepertech.com

  • by jpquerette,

    jpquerette jpquerette Feb 6, 2011 4:16 PM in response to jamesheliker
    Level 1 (0 points)
    Feb 6, 2011 4:16 PM in response to jamesheliker
    James,

    Are you sure you have asset/1 on your catalog? That error should appear as a result of not having the asset on the catalog.

    One other thing: Is the file testproxy.mov already uploaded or just placed on the device 7? If it's not, try uploading it first and then repeat the same command. In my experience, make_link has only worked (for linktype 4) when the clip intended to become a proxy is already an asset. And also, when the asset to have the new proxy has no proxy already.

    Regards,

    JP.

  • by jamesheliker,

    jamesheliker jamesheliker Feb 6, 2011 5:06 PM in response to jpquerette
    Level 1 (0 points)
    Feb 6, 2011 5:06 PM in response to jpquerette
    Hi JP,

    I'm running a clean test instance of FCS, with only one asset in the catalog. And yes, I'm sure /asset/1 is there - I've run getmd/setmd and other commands referencing it with no problem.

    The testproxy.mov file is placed on the device, but not "uploaded" per se - does that mean all of my proxy files will have to be assets in their own right? I'll try uploading and see if that makes a difference. Thanks for your reply.


    - James Heliker
    james.heliker@gmail.com

  • by jamesheliker,

    jamesheliker jamesheliker Feb 6, 2011 5:31 PM in response to jamesheliker
    Level 1 (0 points)
    Feb 6, 2011 5:31 PM in response to jamesheliker
    Hi JP,

    I tried uploading the file to /dev/7/testproxy.mov, which in turn created /asset/4.

    I then tried fcsvr_client make_link --linktype 4 /asset/1 /dev/7/testproxy.mov, and also fcsvr_client make_link --linktype 4 /asset/1 /asset/4. Both commands failed with the following error:

    { CODE = E_DATABASE, DESC = ERROR: null value in column "parententityid" violates not-null constraint, SRC_FILE = PmsTask_Db.C, SRC_LINE = 295 }

    It doesn't seem like uploading changed anything, except additional metadata fields (Media Format) is now returned when I run fcsvr_client getmd /dev/7/testproxy.mov

    Any other ideas?

    Kind Regards,

    - James Heliker

    < Edited by Host >

  • by jpquerette,

    jpquerette jpquerette Feb 6, 2011 5:31 PM in response to jamesheliker
    Level 1 (0 points)
    Feb 6, 2011 5:31 PM in response to jamesheliker
    Hi James,

    Yes, try uploading the file first. I have tried to use proxies not already uploaded per se, with no success. Also, link it as a clip proxy to an asset which does not have a proxy linked already.

    The one strange thing is that your error message should read "...null value in column "cliententityid"..." instead of "parententityid".

    Anyway, let me know if uploading first does work in your case.

    Best regards,

    JP.

  • by jamesheliker,

    jamesheliker jamesheliker Feb 6, 2011 5:37 PM in response to jpquerette
    Level 1 (0 points)
    Feb 6, 2011 5:37 PM in response to jpquerette
    Hi JP,

    I don't think you understand - I just ran the tests you suggested.

    1. Uploaded the file to /dev/7/testproxy.mov (which created /asset/4)
    2. I think tried running the following commands:
    a.fcsvr_client make_link --linktype 4 /asset/1 /dev/7/testproxy.mov
    b.fcsvr_client make_link --linktype 4 /asset/1 /asset/4

    Both commands generated the following error, with the file uploaded first.

    { CODE = E_DATABASE, DESC = ERROR: null value in column "parententityid" violates not-null constraint, SRC_FILE = PmsTask_Db.C, SRC_LINE = 295 }

    Please let me know if you have any other suggestions. Should I be calling make_link with something other than /dev/7/testproxy.mov ?

    Thanks!

    - James Heliker
    james.heliker@gmail.com

  • by jamesheliker,

    jamesheliker jamesheliker Feb 6, 2011 7:46 PM in response to jamesheliker
    Level 1 (0 points)
    Feb 6, 2011 7:46 PM in response to jamesheliker
    Hi JP,

    Uploading through the FCS client GUI was not working - however, I tried running:
    fcsvr_client createasset paassetmedia /dev/7/testproxy.mov

    and then the make_link command outlined previously:
    fcsvr_client make_link --linktype 4 /asset/1 /dev/7/testproxy.mov

    - and it worked! Thanks for everyone's help here. Feel free to email me with any questions.

    Kind Regards,

    - James Heliker
    james.heliker@gmail.com

  • by RCJetPilot,

    RCJetPilot RCJetPilot Feb 7, 2011 10:23 AM in response to jamesheliker
    Level 1 (0 points)
    Feb 7, 2011 10:23 AM in response to jamesheliker
    OK That works for me also.. But what I am trying to do is move the link to the primary representation. I am able to do it but how do I get rid of the original representation link? So that I can delete the original one and have FCS point to the new one?

    Thanks