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