Error: Failed to convert dateadd(second,(-1),sysutcdatetime()), also Unpassable date for "'9999"

[AlokEY21]

1. I am getting error for the table defined below while inserting through latest jar.
2. For validTo date it is not able to parsed.

Caused by: java.text.ParseException: Unparseable date: "dateadd(second,(-1),sysutcdatetime())"
at java.base/java.text.DateFormat.parse(DateFormat.java:399)
at com.rapiddweller.common.converter.String2DateConverter.convert(String2DateConverter.java:91)
... 38 common frames omitted

CREATE TABLE [dbo].[User](
[UserAccountID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL,
[AccountID] [int] NULL,
[CreatedBy] varchar NULL,
[CreatedDate] [datetime] NULL,
[UpdatedBy] varchar NULL,
[UpdatedDate] [datetime] NULL,
[ValidFrom] datetime2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL,
[ValidTo] datetime2 GENERATED ALWAYS AS ROW END HIDDEN NOT NULL,
CONSTRAINT [PK_User_UserAccountID] PRIMARY KEY CLUSTERED
(
[UserAccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
PERIOD FOR SYSTEM_TIME ([ValidFrom], [ValidTo])
) ON [PRIMARY]
WITH
(
SYSTEM_VERSIONING = ON ( HISTORY_TABLE = [dbo].[UserHistory] )
)
GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_CreatedBy] DEFAULT (suser_sname()) FOR [CreatedBy]
GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_CreatedDate] DEFAULT (getdate()) FOR [CreatedDate]
GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_ValidFrom] DEFAULT (dateadd(second,(-1),sysutcdatetime())) FOR [ValidFrom]
GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_ValidTo] DEFAULT ('9999.12.31 23:59:59.99') FOR [ValidTo]
GO

[ake2l]

Hi,

thanks for the details. Two quick questions so I can reproduce precisely:

1.	Could you share your Benerator XML model (the entity/insert part for dbo.User)?
2.	And the table DSL/config you use for connecting/inserting (driver, dialect, column mappings)?

What’s going wrong (root cause):
String2DateConverter is trying to parse a literal string
"dateadd(second,(-1),sysutcdatetime())" as a date. That’s a T-SQL expression, not a timestamp.

Since we stopped further development for Benerator, we strongly recommend migrating to DATAMIMIC.

Best Regards
DATAMIMIC Team

[AlokEY21]

Hi,

This is our xml where insert statement has been made. I am trying to insert in SQL and using jdbc:sqlserver in the connection string.

<generate consumer="ConsoleExporter" count="10" type="User">
		<attribute type="int" name="UserID" pattern="^[1-9]{1,9}$"></attribute>
</generate>

insert log for above script:-
com.rapiddweller.common.exception.ServiceFailedException: Error in persisting User[UserID=6921, UserAccountID=1, AccountID=[null], CreatedBy=(suser_sname()), CreatedDate=2025-08-11T19:33:03, UpdatedBy=[null], UpdatedDate=[null], ValidFrom=2025-08-11T19:33:03, ValidTo=2025-08-11T19:33:03]

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert an explicit value into a GENERATED ALWAYS column in table 'DB.dbo.User'. Use INSERT with a column list to exclude the GENERATED ALWAYS column, or insert a DEFAULT into GENERATED ALWAYS column.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:276)

For the second issue- Delete validFrom column from table and then tried to insert then it was throwing error like not able to parsed default value.

Hope this will help you to reproduce. I believe if we will remove the GENERATED ALWAYS column while inserting the data, then it will not through error and at DB layer it should be handled .

Thanks