When attempting to publish with Datamaker, it fails with the following error:
Error 1018 for Row #1 in table EventDetail. SQLSTATE = 37000
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
The failing query:
INSERT INTO dbo.TestTable1 ( Id, Type, DateStamp, Transaction, EffectiveDate, Charge, Group, AccountID, Index) VALUES ( 5, 'onset', '2017-08-15 17:41:11.000', 'IssueAcct', '2017-08-16', '0', 'taDA2BB8ABC36C495A113350ATF42', '5168675309', 1)
Placing "Index" in brackets "[Index]" and testing that query manually works.
Using Portal and or Enterprise Publish from within Datamaker is successful. The problem is only present when publishing directly from Datamaker.
This issue is resolved in TDM 4.5. If running a version prior to 4.5, upgrade to 4.5 or later.
After upgrading the "reserved name" that is causing the problem - in this case "index" must be added to the list in the repo. This can be done with the following query:
INSERT INTO gtrep_reserved_names (rn_word, date_created, who_created) VALUES ('RESERVED WORD', getdate(), 'USER NAME');
INSERT INTO gtrep_reserved_names (rn_word, date_created, who_created) VALUES ('index', getdate(), 'jsmith01');