locked
Appending Entities to User Entity - CRM 4, On Premise RRS feed

  • Question

  • I have a requirement to connect "issues" to the normal User Entity. I created a 1-N relationship to a new entity called "user issues". Issues is then linked to another entity that actually contains the issues. Yes, I am creating my own Many-2-Many relationship with a linker table.

    I have turned the dev errors on but they are not providing anything. When I access the user entity and apply an issue to a user I get an error on save. I have allowed Append and Append To for the user entity. Anyone have any ideas, anyone ever successfully appended anything to the user entity? I get the same error with the same cusomizations in two enviornments.

     

    Thanks.

    Wednesday, April 14, 2010 12:18 PM

Answers

  • Put a debugger; statement in your LoadAreaOverride function, and do debugging from there. Make sure you have enabled script debugging in IE.

    It's the custom script code problem, not something to do with CRM platform.

    Let us know how it goes.


    Daniel Cai | http://danielcai.blogspot.com
    • Marked as answer by sixty4 Thursday, April 15, 2010 5:57 PM
    Thursday, April 15, 2010 4:47 PM

All replies

  • You probably need to grant "Append" and "Append To" privileges for the new custom entity as well. 

    What did you see from trace log?


    Daniel Cai | http://danielcai.blogspot.com
    Wednesday, April 14, 2010 12:38 PM
  • I have granted full organizaitonal priveldges to the custom entity, still same issue. I looked at the trace log and could not see anything that appeared to be related to this error. Any other suggestions?
    Wednesday, April 14, 2010 1:35 PM
  • I am suspecting that the error you are receiving is a client side error, which could be related to your client script code. Otherwise, there should be something in trace log. 

    What's the error message you got when you save? 

    I actually have a little difficulty to understand when you say "apply an issue to a user I get an error on save".

    In 1:N or N:N relationship, we pretty much add a relationship between two record, what do you mean by "apply an issue to a user"?  Also when the relationship has been built two records, there is no need to save either of them. 


    Daniel Cai | http://danielcai.blogspot.com
    Thursday, April 15, 2010 2:04 AM
  • Well let me clarify it. There are 3 entities here.

    1. Users
    2. Issues
    3. User Issues

    The relationships are set in the following configuration:

    Users to User Issues to Issues

    1. Users to User Issues: 1:N
    2. User Issues to Issues: N:1

    I created my own N:N because I need to be able to use advanced find to locate records by searching users who have a specific issue. If your in the users entity you pick an issue, your prompted with a form that has a lookup value that can be used for the issue. I read a while back that N:N relationships do not show up in advanced find hence this implementaiton.

    What's the error message you got when you save? 

    After you Save or Save and Close an issue against a user then attempt to save the User record you get the error message.

     

    Thursday, April 15, 2010 1:35 PM
  • What is the error message exactly?
    My blog : http://mscrmtools.blogspot.com

    All my tools on my new dedicated site: MSCRMTools Repository
    Thursday, April 15, 2010 1:40 PM
    Moderator
  • I am getting the standard

    "Microsoft Dynamics CRM has encountered an error."

    Please tell Microsoft about this problem.

    I get the same error messsage with DEV errors on. If I actually Click the View the data that will be sent to Microsoft I get the following but the Issue is actually added to the User record?

    ----

    Microsoft Dynamics CRM Error Report Contents

    <CrmScriptErrorReport>
      <ReportVersion>1.0</ReportVersion>
      <ScriptErrorDetails>
     <Message>Object expected</Message>
     <Line>55</Line>
     <URL>/CRMOrganization-Test&#47;biz&#47;users&#47;edit.aspx&#63;id&#61;&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;</URL>
     <PageURL>/CRMOrganization-Test&#47;biz&#47;users&#47;edit.aspx&#63;id&#61;&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;&#35;</PageURL>
     <Function>LoadAreaOverride&#40;&#41;</Function>
     <CallStack>
       <Function>LoadAreaOverride&#40;&#41;</Function>
     </CallStack>
      </ScriptErrorDetails>
      <ClientInformation>
     <BrowserUserAgent>Mozilla&#47;4.0 &#40;compatible&#59; MSIE 7.0&#59; Windows NT 5.1&#59; .NET CLR 1.1.4322&#59; .NET CLR 2.0.50727&#59; .NET CLR 3.0.04506.30&#59; .NET CLR 3.0.04506.648&#59; .NET CLR 3.0.4506.2152&#59; .NET CLR 3.5.30729&#59; InfoPath.2&#59; MS-RTC LM 8&#59; MS-RTC LM 8&#41;</BrowserUserAgent>
     <BrowserLanguage>en-us</BrowserLanguage>
     <SystemLanguage>en-us</SystemLanguage>
     <UserLanguage>en-us</UserLanguage>
     <ScreenResolution>1680x1050</ScreenResolution>
     <ClientName>Web</ClientName>
      </ClientInformation>
      <ServerInformation>
        <OrgLanguage>1033</OrgLanguage>
        <OrgCulture>1033</OrgCulture>
        <UserLanguage>1033</UserLanguage>
        <UserCulture>1033</UserCulture>
        <OrgID>&#123;9026CCE3-3430-DF11-8419-0019B9EE141F&#125;</OrgID>
        <UserID>&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;</UserID>
        <CRMVersion>4.0.7333.2644</CRMVersion>
      </ServerInformation>
    </CrmScriptErrorReport>

    <CrmScriptErrorReport>
      <ReportVersion>1.0</ReportVersion>
      <ScriptErrorDetails>
     <Message>Object expected</Message>
     <Line>55</Line>
     <URL>/CRMOrganization-Test&#47;biz&#47;users&#47;edit.aspx&#63;id&#61;&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;</URL>
     <PageURL>/CRMOrganization-Test&#47;biz&#47;users&#47;edit.aspx&#63;id&#61;&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;&#35;</PageURL>
     <Function>LoadAreaOverride&#40;&#41;</Function>
     <CallStack>
       <Function>LoadAreaOverride&#40;&#41;</Function>
       <Function>down&#40;o&#41;</Function>
       <Function>function anonymous&#40;&#41;&#10;&#123;&#10;down&#40;&#41;&#10;&#125;</Function>
     </CallStack>
      </ScriptErrorDetails>
      <ClientInformation>
     <BrowserUserAgent>Mozilla&#47;4.0 &#40;compatible&#59; MSIE 7.0&#59; Windows NT 5.1&#59; .NET CLR 1.1.4322&#59; .NET CLR 2.0.50727&#59; .NET CLR 3.0.04506.30&#59; .NET CLR 3.0.04506.648&#59; .NET CLR 3.0.4506.2152&#59; .NET CLR 3.5.30729&#59; InfoPath.2&#59; MS-RTC LM 8&#59; MS-RTC LM 8&#41;</BrowserUserAgent>
     <BrowserLanguage>en-us</BrowserLanguage>
     <SystemLanguage>en-us</SystemLanguage>
     <UserLanguage>en-us</UserLanguage>
     <ScreenResolution>1680x1050</ScreenResolution>
     <ClientName>Web</ClientName>
      </ClientInformation>
      <ServerInformation>
        <OrgLanguage>1033</OrgLanguage>
        <OrgCulture>1033</OrgCulture>
        <UserLanguage>1033</UserLanguage>
        <UserCulture>1033</UserCulture>
        <OrgID>&#123;9026CCE3-3430-DF11-8419-0019B9EE141F&#125;</OrgID>
        <UserID>&#123;B5C9E46A-3630-DF11-8419-0019B9EE141F&#125;</UserID>
        <CRMVersion>4.0.7333.2644</CRMVersion>
      </ServerInformation>
    </CrmScriptErrorReport>

     

    Thursday, April 15, 2010 4:29 PM
  • Put a debugger; statement in your LoadAreaOverride function, and do debugging from there. Make sure you have enabled script debugging in IE.

    It's the custom script code problem, not something to do with CRM platform.

    Let us know how it goes.


    Daniel Cai | http://danielcai.blogspot.com
    • Marked as answer by sixty4 Thursday, April 15, 2010 5:57 PM
    Thursday, April 15, 2010 4:47 PM
  • THANKS! I disabled the OnEvent for now and it works....

    Thursday, April 15, 2010 5:57 PM
  • Good to know that you have identified the problem.

    Have a nice day.


    Daniel Cai | http://danielcai.blogspot.com
    Thursday, April 15, 2010 6:07 PM