web
You’re offline. This is a read only version of the page.
close
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 SL (Archived) / Dbbuild - Error Code: ...
Microsoft Dynamics SL (Archived)

Dbbuild - Error Code: -2146232060

(0) ShareShare
ReportReport
Posted on by Svante Kandel 382

We are moving from 6.5 to SL 2011.

When updating the databases, all application databases gets the error messages indicated in the above header, and they seem all to be related to the invalid object name 'SolomonSystem..usergrp' (see attachment).

Please note that SolomonSystem is the old 6.5 system database (the new one is SLSystem).

Looking through earlier articles I have so far taken the following action;

  • verified that ServerName in the Domain table is correct,
  • cleared out old Registration information,
  • cleared out Customizations.
The error message in dbbuild.log is nonetheless there.

Grateful for your input.

*This post is locked for comments

I have the same question (0)
  • Blaine Bryant Profile Picture
    Blaine Bryant on at

    SLK,

    Can you paste the actual errors from the DBBuild log, so I can look at them?

  • Svante Kandel Profile Picture
    Svante Kandel 382 on at

    Blaine,

    There’s an attachment linked to my initial posting. Please let me know if it's not accessible?

    Thanks for the support.

  • Blaine Bryant Profile Picture
    Blaine Bryant on at

    It looks like there is probably a problem with your vs_usergrp view.  Here are some things to check on:

    1 - What is the name of your SL system DB?

    2 - In SQL, try running the following against that system DB:

    select * from usergrp

    Does this come back with records?  

    3 - On your SL application dartabase, run the following:

    sp_helptext vs_usergrp

    This would normally show "Create View vs_usergrp as select * from nameofsystemDB..usergrp".   Is this showing the correct system database name?  If not, check your company and domain table to make sure those records look OK.  If they do, I would have expected that the "update views" process should have fixed this.  

    Let me know what you find and we can go from there.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    if the name on the system DB has changed you may have this issue many other places.  Run the SQL Script below in each application DB.  It will give you a list of all objects that referance the old system DB name.  Each one will have to be corrected.

    select O.[name],o.xtype,c.[text]

    from sysobjects O

    inner join syscomments C on c.[id] = o.[id]

    where o.xtype in  ('P','V','TR','FN','TF')

    /* V View, P Proc, TR Trigger,FN Scaler Functions, TF Table Functions*/

    and c.[text] like '%SolomonSystem%'

    order by o.name

  • Svante Kandel Profile Picture
    Svante Kandel 382 on at

    Blaine,

    1- The name of our (new) system DB is SLsystem.

    2- Yes, it comes back with the values I would expect to find here. That is, Users and Group Id's as defined in SLsystem.

    3- In our case the script shows;

    CREATE VIEW vs_usergrp AS SELECT * FROM SolomonSystem..usergrp

    which thus the name of the old system DB.

    I have checked Company and Domain and they look just fine, contain all data and ServerName in Domain is correct.

    Thanks for the support.

  • Svante Kandel Profile Picture
    Svante Kandel 382 on at

    Thanks Dwight,

    Your query return the following;

    name                       xtype text

    -------------------------- ----- ---------------------------------------------------------------
    vs_usergrp                 V     CREATE VIEW vs_usergrp AS SELECT * FROM SolomonSystem..usergrp

    (1 row(s) affected)

    Thanks for your assistance

  • Blaine Bryant Profile Picture
    Blaine Bryant on at

    With Dwight's assistance were you able to resolve this issue, or do you need further assistance?

  • Svante Kandel Profile Picture
    Svante Kandel 382 on at

    Yes, Dwight's answer directed me to the solution.

    Fortunately I had a few db’s that where in shape (no master in sql scripting) from which I could create a script to correct the views in vs_userrec (and vs_acctxref which also showed out to have the same issue).

    Thanks a lot for your assistance!

  • aliRana Profile Picture
    aliRana 5 on at

    {System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Order_Details_Orders". The conflict occurred in database "Northwind", table "dbo.Orders", column 'OrderID'.
    The statement has been terminated.
    at WindowsFormsApplication.NorthwindDataSet1TableAdapters.TableAdapterManager.UpdateAll(NorthwindDataSet1 dataSet) in c:\Users\aliRana\Documents\Visual Studio 2012\Projects\WindowsFormsApplication\WindowsFormsApplication\NorthwindDataSet1.Designer.cs:line 16491
    at WindowsFormsApplication.order_form.ordersBindingNavigatorSaveItem_Click(Object sender, EventArgs e) in c:\Users\aliRana\Documents\Visual Studio 2012\Projects\WindowsFormsApplication\WindowsFormsApplication\order_form.cs:line 28
    ClientConnectionId:fe5b7fc2-eb61-4bb7-b00d-95fc66b031cd}

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans