@X3.TRT/TRTLIC$adx(223) File nonexistant [Microsoft][SQL Server Native Client 10.0]
[SQL Server] Invalid object name ‘X3.AUDITH’

Question

Sage X3 
 Version 6.5 
 Patch 29 
 We have done a server migration. 
 Installed Sage X3 v 6.5 on new server. 
 Imported the folders +svg from old server 
 On the new server when we log on to Sage we get the error message below. 
 
 &ldquo;@X3.TRT/TRTLIC$adx(223) File nonexistant [Microsoft][SQL Server Native Client 10.0] 
 [SQL Server] Invalid object name &lsquo;X3.AUDITH&rsquo; &ldquo; 
 
 Any ideas on how to resolve?

JamesG-ACD · Accepted Answer

If it's actual X3 code that's doing something silly, I suppose you'd have to take that up with Sage. I don't have access to the source code so I can't see what TRTLIC is doing on line 223. If this is on the SQL Server side, which the error suggests, meaning that auditing is set up on one or more X3 tables - I suppose I'd try to track down which tables have auditing, then comment that out of the specific database triggers. I would think that would be enough to at least let you log in to X3, then remove the auditing and re-validate those tables properly. 
 I used the query here to search for 'AUDITH', which should find triggers doing some kind of auditing. Specifically you want to find tables with triggers in the X3 schema: stackoverflow.com/.../how-to-find-a-text-inside-sql-server-procedures-triggers 
 The X3.ATABAUD table shows which specific fields have auditing set up. Mine has six entries, five in TABVAT and one in ECCSTA, but I've never had any issues. 
 Or I'm barking up the wrong tree entirely. In V12 I tried to add auditing to tables from the X3 folder, and although it saved and validated, it didn't actually create the database triggers. Maybe in older versions it would?

Sage X3

@X3.TRT/TRTLIC$adx(223) File nonexistant [Microsoft][SQL Server Native Client 10.0] [SQL Server] Invalid object name ‘X3.AUDITH’

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING