what should I do if thise error come out ? : DB_Restore_ConvertInstallation ?

Kindly help me since I cannot restore my project. I suspect it might be related to my database but I use the latest database *as I already upgraded it earlier. Pls help.

Parents
  • Hi Sofia.  Unfortunately, this probably indicates the problem is within the backup file. If you can restore other projects successfully, that would support my theory. I've not seen that exact error message before, but a similar one was caused by records missing from the database within the backup file.

    If you have the source project, you could try backing it up again, perhaps after running Rebuild Project Database. If that is not an option or does not help, we can take a look at the backup but I can't guarantee it can be repaired. You can upload it using the Communities Secure File Upload method.



  • Hi Matt,

    Thank you for replying to my message earlier, kindly see below.

  • Ok, those are different than I was somewhat expecting.

    Internal Error
    DB_Restore_ConvertInstallation
    ProjectDB Error Message: Column 'name' does not belong to table installation.
    TargetSite: System.Data.DataColumn GetDataColumn(System.String)
    DeclaringType: System.Data.DataRow
    Attributes: internal
    MemberType: Method
    StackTrace: C:\ProgramData\Bentley\Substation V8i\Config\LastError.txt
    Product Version: Substation V8i (SELECTseries 8)
    DB Version: SQLServer 8.1.45

    The error messages seem to indicate that the "name" column does not exist in the DrawingSet and Installation tables in your project database.  The project database should indeed have these columns, and you could check this using SQL Server Management Studio if that is available to you:

    If these columns were missing, I would expect error messages to occur when using the software to do other things besides restoring projects. Are you able to create a new project and page without error?

    If you are trying to use a new database that does not contain any projects yet, perhaps it is simply malformed and you could try creating a new one to use.



Reply
  • Ok, those are different than I was somewhat expecting.

    Internal Error
    DB_Restore_ConvertInstallation
    ProjectDB Error Message: Column 'name' does not belong to table installation.
    TargetSite: System.Data.DataColumn GetDataColumn(System.String)
    DeclaringType: System.Data.DataRow
    Attributes: internal
    MemberType: Method
    StackTrace: C:\ProgramData\Bentley\Substation V8i\Config\LastError.txt
    Product Version: Substation V8i (SELECTseries 8)
    DB Version: SQLServer 8.1.45

    The error messages seem to indicate that the "name" column does not exist in the DrawingSet and Installation tables in your project database.  The project database should indeed have these columns, and you could check this using SQL Server Management Studio if that is available to you:

    If these columns were missing, I would expect error messages to occur when using the software to do other things besides restoring projects. Are you able to create a new project and page without error?

    If you are trying to use a new database that does not contain any projects yet, perhaps it is simply malformed and you could try creating a new one to use.



Children
  • Hi Matt,

    Thank you for your reply. I tried to check as per your suggestion. Basically, this is what I found.

    1. The PC has Substation before, but I uninstalled & upgraded to a new version. However, I faced a problem with setup configuration, which, need to use SQL Server authentication instead of Windows authentication. I created a new database, but the access was denied. I suspect it has something to do with the database.

    2. I managed to create a new page/project, but I cannot use the default configuration. The software managed to do a backup, but when trying to restore any project - the error as per image I sent before pop out. 

    3. All the default catalog - e.g. IEC 2.1 catalog is not available in the software.

    4. I check the SQL Management Studio & the files under System Tables are not available.

    May I know what file do I need to download/install/uninstall to solve this problem?

  • Unknown said:
    1. The PC has Substation before, but I uninstalled & upgraded to a new version. However, I faced a problem with setup configuration, which, need to use SQL Server authentication instead of Windows authentication. I created a new database, but the access was denied. I suspect it has something to do with the database.

    If you mean that after creating a new database you were not able to open existing projects, then that is normal if you are using the Single Database strategy on Setup.

    If you mean that you were unable to connect to the new database on Setup. See the Troubleshooting Project Database Connection Problems article.

    Unknown said:
    3. All the default catalog - e.g. IEC 2.1 catalog is not available in the software.

    See the Add Catalog Path article.

    Unknown said:
    4. I check the SQL Management Studio & the files under System Tables are not available.

    The Substation tables are not in the System Tables. At the very bottom of your screen shot you can see the Installation table as dbo.Installation. If you expand it and expand Columns, is there a "name" item listed there?