Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Celedon Auto Numbering...
Microsoft Dynamics CRM (Archived)

Celedon Auto Numbering SQL Error

(0) ShareShare
ReportReport
Posted on by Aimsc

Hi, 

I am receiving a SQL Error when testing out the below configuration. The desired outcome is that a claim number is entered when a date reported is entered. I have double checked all the field names and the entity name and they are all correct but it won't work on update. It just keeps giving the SQL error. 

Autonumber.PNG

6825.SQL-Error.PNG

I have successfully setup auto numbering on another entity on create but can't get this one to work. I have tried using capitals and lowercase but still no success. 

Many thanks, 

Aimee  

*This post is locked for comments

  • Verified answer
    Aimsc Profile Picture
    Aimsc on at
    RE: Celedon Auto Numbering SQL Error

    The issue was that the field I was trying to write too had a character limit on it.

  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: Celedon Auto Numbering SQL Error

    Hi Aimee,

    Then I suggest your best option is to reach out directly to Celedon or you can have a look at their source code (if you have some developer skills) and reverse engineer the process github.com/.../Celedon-Autonumber-RTM

    Regards,

    Radu  

  • Aimsc Profile Picture
    Aimsc on at
    RE: Celedon Auto Numbering SQL Error

    Hi Radu,

    It is a solution provided by Celedon. They have an auto-numbering solution which I have used successfully on another entity but can't get it to work for this one.

    celedonpartners.com/.../celedon-autonumber-solution-for-dynamics-crm

    Many thanks,

    Aimee  

  • Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: Celedon Auto Numbering SQL Error

    Hi Aimee,

    If there isn't any plug-in involved, could you please explain how the autonumbering should work? Is this a solution you got from a 3rd party vendor or is it something you developed yourself?

    Thanks,

    Radu

  • Aimsc Profile Picture
    Aimsc on at
    RE: Celedon Auto Numbering SQL Error

    Hi Radu,

    The error message is below.

    I am just trying to add an auto number to an entity when the qas_claimnumber field is updated.

    There isn't any plugins involved and unfortunately we are still on v8.2 at the moment with no plans to upgrade until next year.

    Many thanks,

    Aimee  

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ActivityId>846ad172-1351-4e98-a46e-ae6a90e71889</ActivityId>

     <ErrorCode>-2147204784</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

     <Message>Generic SQL error.</Message>

     <Timestamp>2018-10-03T11:02:57.5609275Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault i:nil="true" />

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: Celedon Auto Numbering SQL Error

    Hello,

    Can you provide more details on the SQL Error? Is it a DEADLOCK, TIMEOUT, DUPLICATE KEY error?

    Can you share more details on what you are trying to accomplish and an architecture / code of any plug-ins that are involved?

    Also if you are trying to set up AutoNumbering - if you are using CRM 9.0 or above, you could consider the built in Auto Number Attributes docs.microsoft.com/.../create-auto-number-attributes

    Hope this helps,

    Radu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
dkrishna Profile Picture

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans