Error ERR_CHECK_VALFILS while installation Sage X3

Question

Hello, 
 I'm trying to install SageX3 v12, first time, on my windows computer with MSSQL DB. 
 
 I'm having the following error ERR_CHECK_VALFILS , do you have any idea how to fix or find the cause ? Maybe a list of log files to check? 
 
 1/18/2021 9:59:22 AM : INFO - ---------------------------------------------------------------------
1/18/2021 9:59:22 AM : INFO - Sage Application setup 1/18/2021 9:59:22 AM
1/18/2021 9:59:22 AM : INFO - ---------------------------------------------------------------------
1/18/2021 9:59:22 AM : INFO - Starting application configuration
1/18/2021 9:59:22 AM : INFO - 
1/18/2021 9:59:22 AM : INFO - *--- Sage Application setup ---*
1/18/2021 9:59:22 AM : INFO - Application : reading adxinstalls on localhost...
1/18/2021 9:59:22 AM : INFO - Information from adxinstalls.xml on application server retrieved.
1/18/2021 9:59:22 AM : INFO - Ok
1/18/2021 9:59:22 AM : INFO - Database : reading adxinstalls on localhost...
1/18/2021 9:59:22 AM : INFO - Information from adxinstalls.xml on data server retrieved.
1/18/2021 9:59:22 AM : INFO - Ok
1/18/2021 9:59:22 AM : INFO - Information from adxinstalls.xml retrieved.
1/18/2021 9:59:22 AM : INFO - Ok
1/18/2021 9:59:22 AM : INFO - Main runtime : reading adxinstalls on localhost...
1/18/2021 9:59:22 AM : INFO - Information from adxinstalls.xml on main runtime server retrieved.
1/18/2021 9:59:22 AM : INFO - Ok
1/18/2021 9:59:22 AM : INFO - Reading solution.xml on localhost...
1/18/2021 9:59:22 AM : INFO - Information from solution.xml retrieved.
1/18/2021 9:59:22 AM : INFO - Ok
1/18/2021 9:59:22 AM : INFO - Starting configuration from Runtime SAFEX3RUNTIME, localhost:
1/18/2021 9:59:22 AM : INFO - File c:\Sage\SAFEX3APPLICATION\folders\X3\X3APPLI.ini retrieved from localhost. (LibAdm.GenerationScriptsAppliNT)
1/18/2021 9:59:25 AM : INFO - Database user X3 and roles are not available. (LibAdm.RunVerifSchemaBaseSqlServer)
1/18/2021 9:59:25 AM : INFO - Database schema check failed. (LibAdm.RunVerifSchemaBaseSqlServer)
1/18/2021 9:59:25 AM : INFO - User for folder X3 will be created. (LibAdm.GenerationScriptsAppliNT)
1/18/2021 9:59:26 AM : INFO - Directory c:\Sage\SAFEX3APPLICATION\folders\X3\FIL initialized.
1/18/2021 9:59:27 AM : INFO - Creation of sagex3_CrUsr.bat done. 
1/18/2021 9:59:27 AM : INFO - Creation of _adxmainfil.bat.
1/18/2021 9:59:28 AM : INFO - Tables list from FILPLAT in main folder created. (LibAdm.GenerationScriptsAppliNT)
1/18/2021 9:59:29 AM : INFO - Tables list from FILPLATSYS in main folder created. 
1/18/2021 9:59:29 AM : INFO - Creation of _adxmainfil.bat done.
1/18/2021 9:59:31 AM : INFO - File c:\Sage\SAFEX3APPLICATION\folders\X3\X3APPLI.ini sent on application server localhost.
1/18/2021 9:59:31 AM : INFO - File c:\Sage\SAFEX3APPLICATION\folders\X3\FILPLAT\sagex3_CrUsr.bat sent on application server localhost.
1/18/2021 9:59:31 AM : INFO - Launching sagex3_CrUsr.bat ... (LibAdm.RunCreateUserSQLMainNT)
1/18/2021 9:59:34 AM : INFO - Execution of sagex3_CrUsr.bat done.
1/18/2021 9:59:37 AM : INFO - Database schema X3 is available and storages are online (LibAdm.RunVerifSchemaBaseSqlServer)
1/18/2021 9:59:46 AM : INFO - Valfil test performed with success.
1/18/2021 9:59:46 AM : INFO - Database sagex3 loading... 
1/18/2021 9:59:46 AM : INFO - 778 tables found
1/18/2021 9:59:46 AM : INFO - 0038 tables loaded - 05% - AABREV - ACLBSYS
1/18/2021 9:59:57 AM : ERROR - Error No 76

[Microsoft][SQL Server Native Client 11.0][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'X3.ABITRAUNV' and the index name 'ABITRAUNV_ATV0'. The duplicate key value is (MFGCOST, MFC1-MFGCSTPE

1/18/2021 9:59:57 AM : WARN - Warning ! Following group or table could not be loaded into database : 0000-AABREV-ACLBSYS. (LibAdm.RunValFilMain)
1/18/2021 9:59:57 AM : INFO - 0076 tables loaded - 10% - ACLOB - ADOVALHIS
1/18/2021 10:01:04 AM : INFO - 0114 tables loaded - 15% - AELT - AMAINT
1/18/2021 10:01:13 AM : INFO - 0152 tables loaded - 20% - AMEMO - APLLCK
1/18/2021 10:01:34 AM : INFO - 0190 tables loaded - 25% - APLSTD - ASHWMET
1/18/2021 10:02:08 AM : INFO - 0228 tables loaded - 30% - ASHWOPT - AVIEWE
1/18/2021 10:03:07 AM : ERROR - Error No 76

[Microsoft][SQL Server Native Client 11.0][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'X3.ATEXTRA' and the index name 'ATEXTRA_AXX0'. The duplicate key value is (AVOLUME, DES, CHI, zSVG, 

1/18/2021 10:03:07 AM : WARN - Warning ! Following group or table could not be loaded into database : 0005-ASHWOPT-AVIEWE. (LibAdm.RunValFilMain)
1/18/2021 10:03:07 AM : INFO - 0266 tables loaded - 35% - AVOCAB - AYTLINES
1/18/2021 10:03:15 AM : INFO - 0304 tables loaded - 40% - AYTMEN - CCMACTION
1/18/2021 10:03:22 AM : INFO - 0342 tables loaded - 44% - COMPANY - EDIFRM
1/18/2021 10:03:29 AM : INFO - 0380 tables loaded - 49% - EDIMSG - EMPLOCTRSTG
1/18/2021 10:03:39 AM : INFO - 0418 tables loaded - 54% - EMPLOCTRUKI - GACCOUNT
1/18/2021 10:03:50 AM : INFO - 0456 tables loaded - 59% - GACCOUNTA - HRDESCTRCOT
1/18/2021 10:04:04 AM : INFO - 0494 tables loaded - 64% - HRDSCFCY - HRDSNDMV5
1/18/2021 10:04:11 AM : INFO - 0532 tables loaded - 69% - HRDSNDMV6 - HRTAXCERTDED
1/18/2021 10:04:18 AM : INFO - 0570 tables loaded - 74% - HRTAXCERTINC - PARSTOACC
1/18/2021 10:04:27 AM : INFO - 0608 tables loaded - 79% - PARTRZL - PRTSCRWRK
1/18/2021 10:05:44 AM : INFO - 0646 tables loaded - 84% - PRVCLOB - SNPOPEAFF
1/18/2021 10:05:52 AM : INFO - 0684 tables loaded - 88% - SPREASON - TABSAFSTO
1/18/2021 10:06:02 AM : INFO - 0722 tables loaded - 93% - TABSDHTYP - TMPSRPTDET
1/18/2021 10:06:33 AM : INFO - 0760 tables loaded - 98% - TRAINER - AECLIDBG
1/18/2021 10:06:58 AM : INFO - Database sagex3 loaded in 00:07:20.5628553
1/18/2021 10:06:58 AM : INFO - Launching X3_misc.sql. (LibAdm.LaunchMisc)
1/18/2021 10:06:59 AM : INFO - c:\Sage\SAFEX3APPLICATION\folders\X3\FILPLAT\X3_Misc.sql executed.
1/18/2021 10:06:59 AM : WARN - Error(s) detected in sagex3 database loading. (LibAdm.RunValFilMain)
1/18/2021 10:06:59 AM : FATAL - Configuration aborted
1/18/2021 10:06:59 AM : FATAL - ERR_CHECK_VALFILS 
 Thanks for your support. 
 Alexandre

G@G · Accepted Answer

First of all, double check port for adonix, it must be different from main runtime port. As a second thing, what version of MSSQL do you have right now, anything older then MS SQL 2016 is not supported. As far as I can see, you are using unsupported version of MS SQL (2012).

G@G · Answer

Then as a last question to double check is to have clear SQL database, without anything within it. Could you try to start configuration of solution from blank page to make sure that you are not missing anything. BTW, this usually means you need to install new database server component.

Alexandre S · Answer

I found the way to reinstall DB and Runtime components... (rename old component folders, and reinstall with new names). 
 Note, after updating the DB to 2019 version + reinstalling these 2 components, the app installation went all good.

Sage X3

Error ERR_CHECK_VALFILS while installation Sage X3

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING