Forum Discussion

Wikus's avatar
Wikus
New Contributor III
3 years ago
Solved

Unable to cast object of type 'System.DateTime' to type 'System.String'.

Hi,

I'm getting this error on different applications in my OS instance.

Apologies if it is not relevant to this forum.

Methodology
  • JackLacava's avatar
    JackLacava
    3 years ago

    This is typically a result of attaching an old application database to a more recent version of OneStream, or viceversa. Go to the Database Configuration Utility and upgrade the schema, the procedure is documented in the Upgrade Guide. If your application db is newer than the actual OS version, you'll have to install a more recent OS.

  • Wikus's avatar
    Wikus
    3 years ago

    Thank you very much Jack, I thought it was a DB issue but not sure how to  solve.

    I think I'm running incompatible versions. Windows 11, SQL Server 2022 and OS 7.22.

    Much appreciated.

  • JackLacava's avatar
    JackLacava
    Community Manager
    3 years ago

    This is typically a result of attaching an old application database to a more recent version of OneStream, or viceversa. Go to the Database Configuration Utility and upgrade the schema, the procedure is documented in the Upgrade Guide. If your application db is newer than the actual OS version, you'll have to install a more recent OS.

    • Wikus's avatar
      Wikus
      New Contributor III
      3 years ago

      Thank you very much Jack, I thought it was a DB issue but not sure how to  solve.

      I think I'm running incompatible versions. Windows 11, SQL Server 2022 and OS 7.22.

      Much appreciated.