Skip to main content
Member
Feb 9, 2023 4:51 AM UTC
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.

Employee - Sage
Feb 9, 2023 8:12 AM UTC

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.

2 replies

Employee - Sage
Feb 9, 2023 8:12 AM UTC

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.

WikusAuthor
Member
Feb 9, 2023 8:23 AM UTC

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.