Hello everybody!I have an error: Conversion from varchar data type to datatime data type resulted in out of range. The execution of this instruction has been interrupted.Promise is integrated with Project Wise, a new project database is created and Promise is reinstalled after an error occurs. Did not help.
Hi Pavel,We would like to know when do you get this Error Message ? Do you get this while launching Promis.e or while using a particular command in Promis.e ? Also are you using Promis.e CONNECT with ProjectWise with Managed WorkSpace ? Regards,Satish Saptasagar
Hi, Satish!
The message appears when trying to return a sheet ("check in"). Apart from this error, nothing critical happens. And I am using Promis.e CONNECT with ProjectWise with Managed WorkSpace.Thank you)
Hello Satish!
The problem occurs for everyone who uses PromisE on this server.
ProjectWise 10.00.03.280
The error did not appear immediately, but after some manipulations with the project databases.
Reinstallation of the project databases gave no results.Regards, Pavel Shemelin
Hi Pavel,Can you provide details on what manipulation was done with database ? Did you modify some data in Project Database for Promis.e or some other changes were made ?Regards,Satish Saptasagar
Satish,
I tried to update the project database, I did not interfere with the database structure. I performed all manipulations with the project database from the PromisE interface. Maybe I did something else, but it was not with the project database.
Regards, Pavel Shemelin
Pavel,If you had just updated the Database for Promis.e from the UI in that case can you try Updating the Database once again but directly on SQL Server and not from Promis.e UI and check if the issue still exists ? You can refer the below Wiki Link for the steps Update the Database Method 2: Executing a Script. If you don't have accesses to the Network SQL Server you can contact your SQL Admin or IT Team to help in executing the script.
Thank you for your help. We found the reason for the error. This concerns the language settings of the server. It will be useful for users from Russia.
You need to set English as default in these settings:
Thanks again for your help. Good luck!
Best regards,
Pavel Shemelin