MSSQL Error

fjcortes

Unable to initialise the database tables due to the following exception com.bas.basserver.persistence.PersistenceException Internal error. Error persisting business object RegularUser La conversión del tipo de datos nvarchar en smalldatetime produjo un valor fuera de intervalo.

aware_support

When does this happen? What does the error in Spanish mean?

fjcortes

This happens when I try to initialize AwareIM using engine mssql database, the error appears in Spanish, because the engine is installed in Spanish.

aware_support

What does the message in Spanish mean? Are you trying to load a BSV or is it just brand new Aware IM installation?

fjcortes

This is just brand new Aware IM installation. the message say Error persisting business object RegularUser The conversion from data type nvarchar to smalldatetime value was out of range.

aware_support

Is it Aware IM installation built using Aware IM Runtime?

It doesn't look like a brand new installation. It looks like Aware IM is trying to load a BSV where one of the standard fields of the RegularUser object has been changed from PlainText to Date or TimeStamp. This is where the error happens - conversion fails.

In a brand new Aware IM installation RegularUser does not have date fields and there is no reason to convert anything as the table is brand new

fjcortes

I thought, so delete the database and reinstall but I still leave the error

aware_support

Please purchase a support ticket and let us know how we can have a look at the issue ourselves