DB/User Profile XML problems

DB/User Profile XML problems

Solution :


You will have to perform the below steps on the machine on which SOHODOX is installed in the Server mode.

Please make sure that you back up the SOHODOX Databases.

https://helpdesk.sohodox.com/portal/en/kb/articles/backup-using-the-new-sohodox-database-backup-utility


FIXING THE DB PROFILE


To solve this issue follow the steps below...

  • Close SOHODOX on all the machines

  • Open the Windows Command Line window.

  • You can open the Windows Command Line by opening the Run dialog (Windows button + R) and in the RUN dialog type cmd. Press Enter, the Windows Command Line Window will be launched.

  • In the Command Line window type the following at the cursor...

                "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /resetdbprofile /dbid=1

             (Assuming SOHODOX is installed in the default location)


  • Now, hit the Enter key.

  • You will be prompted to login with the credentials of the superadmin user.You will receive a confirmation message 'Command line tasks performed successfully'

  • Now start SOHODOX and check if the issue is resolved.

In case the issue persists, then you will have  to follow the instructions below...


FIXING THE USER PROFILE

  • In the Command Line window type the following at the cursor if you are facing the issue for a particular user...

          "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /resetuserdbprofile /dbid=1 /username=Bob

     (where Bob is the username for a user in SOHODOX who currently faces the issue)


  • In the Command Line window type the following at the cursor if you are facing the issue for all the users...

    "C:\Program Files (x86)\SOHODOX Desktop\Sohodox.exe" /resetuserdbprofile /dbid=1 /username=#all                               

  • Now, hit the Enter key.

  • You will be prompted to login with the credentials of the superadmin user. 

  • You will receive a confirmation message 'Command line tasks performed successfully'

  • Now start SOHODOX and check if the issue is resolved.

    • Related Articles

    • Convert your existing SQL Express Sohodox DB to SQL Server Standard/Enterprise Sohodox DB

      Note: The below instructions will only work if… You have an existing installation of SQL Server Standard or Enterprise (if you are unsure, drop an email to support@sohodox.com) You have purchased the SQL Server upgrade module. You have the new ...

    • Install SOHODOX DB Engine utility

      When you install SOHODOX, it creates and uses a basic database engine. This keeps the SOHODOX installation simple and lets you quickly try SOHODOX. However, for a speedier and more stable user experience, we highly recommend that you download and run ...

    • Troubleshooting SOHODOX multi-user (multi-machine) installations.

      First verify if SOHODOX is working fine on the server machine... If SOHODOX is working fine on the Server machine (in other words the machine on which you installed SOHODOX in server mode), you will be able to... Start SOHODOX by double-clicking its ...

    • Migrating SOHODOX v10 or above to a new machine

      Note: The instructions in this article will only work for... users who only want to move the SOHODOX to another machine. users using the latest version (v10) of SOHODOX. SOHODOX is configured with the DB Engine utility (a utility which converts your ...

    • Configure Sohodox to point to an existing SQL Server DB

      To to this... Press the Windows + R button. The Run dialog will be launched. In the Open: textbox, type the following command… "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremssqlmainDB /dbname=MainDB_sdx (Assuming Sohodox is ...