Access: 007 : Data at the root level is invalid. Line 1, position 1

Access: 007 : Data at the root level is invalid. Line 1, position 1

Cause: 

While opening SOHODOX or while browsing through Document Types you may encounter this error. The cause for this is the User profile (for e.g. Superadmin or user Bob) in SOHODOX has gone corrupt.


Solution:

To solve this issue follow the steps below...
  1. Please make sure that you back up the Sohodox Databases.
  2. Close SOHODOX and Open the Windows Command Line window.
  3. 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.
  4. 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)
  5. Now, hit the Enter key and try logging into Sohodox.
  6. In case the issue persists, then you will have to run another command...
    "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /resetuserdbprofile /dbid=1 /username=#all
  7. In case none of the above commands resolves your issue, please try running the below command...
    "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /resetuserprofile /dbid=1 /username=superadmin

You can drop in an email to support@sohodox.com, in case none of the above commands resolves your issue.

    • Related Articles

    • Access: 006 : Invalid use of Null

      Cause: A table named LogonSession in your Database contains Invalid values Solution: You will have to zip the 'MainDB.gxdb' file and send us this file (MainDB.gxdb file is located in C:\Sohodox Databases folder).This file does not contain your ...

    • Access: 009 : Data provider or other service returned an E_FAIL status

      Cause: A table LogonSession in your DB contains Invalid values Solution: You will have to zip the 'MainDB.gxdb' file and send us this file (MainDB.gxdb file is located in C:\Sohodox Databases folder).This file does not contain your physical ...

    • Access: 001 : Unrecognized Database Format

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB.gxdb'. (ErrNo:-2147467259 Details:Unrecognized database format '\\machinename\sohodoxdatabases\MainDB.gxdb'.) Cause:  This error usually appears when there are ...

    • SQL: 001 : SQL Server does not exist or access denied

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB_sdx'. (ErrNo:-2147467259 Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) Cause: The error indicates that SOHODOX is unable to ...

    • Access: 010 : Record is deleted

      Error Message: ErrorCode: 65535 Message: ErrNo: -2147155969 ErrDescription: Record is deleted. Cause: A table named LogonSession in your Database contains Invalid values Solution : You can make a Copy (create a ZIP / RAR file) of the 'MainDB.gxdb' ...