Question

Photo of Joachim Pfeifer

0

Trouble by creating database

4

Hello,

I've tried to install RockRMS but got some trouble by creating the database. Here is the beginning of the error message:

That Wasn't Suppose To Happen An error occurred creating database. Message: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs. Die Anweisung wurde beendet. Current Script: INSERT [dbo].[AttributeQualifier] ([Id], [IsSystem], [AttributeId], [Key], [Value], [Guid], [ForeignKey], [ForeignGuid], [ForeignId]) VALUES (321, 1, 1333, N'definedtype', N'59', N'd03418da-bc29-47c3-aa36-1051841c62f9', NULL, NULL, NULL) INSERT [dbo].[AttributeQualifier] ([Id], [IsSystem],

The message is still going on for round about 300 lines...

Has somebody any idea what's going wrong?

Thank you in advance!

Joachim

  • Don Smallman

    Don Smallman

    Do you have a screenshots, or can you create some, that shows the info you are using to do the setup? Sans passwords of course.

    • Photo of Joachim Pfeifer

      0

      B90BBF8B-5D97-4253-AC37-4A078033EC8A.png

      014A0FC0-B196-4710-AB66-7AD7BC1828D8.png

      373B9B63-969E-4B63-9AA1-7949A366E37C.png

      A63D6ABA-E7AC-425A-9AD3-7867BA330F42.png

      C2E479C1-302D-4AB7-A024-2F53AFD420B8.png

      D8951C43-B0FD-4DAF-BAD2-E4AF99FE8E27.png

      B00012AF-D178-48CB-B049-DC83626065E9.png

    • Photo of Joachim Pfeifer

      0

      Yes I could login. Until now I haven’t any other database. The error means:

      By converting a nvarchar type to a datetime type the value is out of a  valid area.


      EdiT. I think the official english description is:

      "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."

    • Photo of Don Smallman

      0

      Verify your server date. If that is correct, change your date format to mm/dd/yyyy or M/d/yyyy

      Or, just make everything match this.

      Capture102017.JPG

    • Photo of Joachim Pfeifer

      0

      No changes after adapting the date format.... :(Skizze.png