Excel Add-in Logs
This topic describes the logs generated by the Excel Add‑in, including the Excel.log files created on both the server and the client machine. Knowing where to find these logs is useful when scheduled report distributions fail, when report data appears incorrect, or when any other issue occurs.
Log
Purpose
Where to find
Distribution Add-in
Provides a detailed trace of the SQL statements generated by the Excel Add-in and processed by the BIService during scheduled distributions.
The log may include warnings and error messages when a distribution fails, helping you identify the cause of the issue.
Open File Explorer and navigate to:
C:\Windows\System32\config\systemprofile\AppData\Roaming\Sage\SEIDocuments\Excel.log
Excel Add‑in Client
Provides a trace of the SQL statements generated locally by the Excel Add-in on the client machine.
The log includes warnings and error messages when SQL queries or processes fail, helping you troubleshoot issues directly from the client side.
Open File Explorer and navigate to:
C:\Users\[username]\Documents\SEI\EXCELYYYYMMDD.log
Examples
Distribution Add‑in log sample
---------------------------- Information 4/26/2021 11:46:45 AM ----------------------------
SELECT COMPANY.CPY_0 as "CPY_0",COMPANY.CPYNAM_0 as "CPYNAM_0" FROM @LIB_[COMPANY] [COMPANY] ORDER BY COMPANY.CPY_0 ASC
---------------------------- Information 4/26/2021 11:47:11 AM ----------------------------
select Sum((CASE WHEN GACCENTRYA.AMTCUR_0 IS Not NULL THEN
GACCENTRYA.AMTCUR_0 * (GACCENTRYD.SNS_0) * ZTABCHANGE.RAT_0
ELSE
GACCENTRYD.AMTCUR_0 * (GACCENTRYD.SNS_0) * ZTABCHANGE.RAT_0
END)) as directCalculation from
[x3v12].[SEED].[GACCENTRYD] [GACCENTRYD] LEFT JOIN [x3v12].[SEED].[GACCENTRY] [GACCENTRY] ON [GACCENTRYD].[TYP_0] = [GACCENTRY].[TYP_0] and [GACCENTRYD].[NUM_0] = [GACCENTRY].[NUM_0] LEFT JOIN
[x3v12].[SEI21_TEST10].[ZTABCHANGE] [ZTABCHANGE] ON [GACCENTRYD].[ACCDAT_0] = [ZTABCHANGE].[DATE_0] and [GACCENTRY].[CUR_0] = [ZTABCHANGE].[CUR_0] and [GACCENTRY].[TYPATR_0] = [ZTABCHANGE].[CHGTYP_0] LEFT JOIN
[x3v12].[SEED].[GACCENTRYA] [GACCENTRYA] ON [GACCENTRYD].[TYP_0] = [GACCENTRYA].[TYP_0] and [GACCENTRYD].[NUM_0] = [GACCENTRYA].[NUM_0] and [GACCENTRYD].[LIN_0] = [GACCENTRYA].[LIN_0] and [GACCENTRYD].[LEDTYP_0] = [GACCENTRYA].[LEDTYP_0] Where ([GACCENTRYD].[CPY_0] in (@param0,@param1)) and ([GACCENTRY].[FIY_0]=@param2) and ([GACCENTRY].[PER_0]=@param3) and ([GACCENTRYD].[ACC_0]=@param4) and ([GACCENTRY].CAT_0 = 1)
*** (@param0=A010;@param1=A020;@param2=2;@param3=4;@param4=0210;) ***************
---------------------------- Information 4/26/2021 11:47:11 AM ----------------------------
SELECT COALESCE([GACCENTRYD].[ACC_0],'*NECNULL') as [ACC_0],Sum((CASE WHEN GACCENTRYA.AMTCUR_0 IS Not NULL THEN
GACCENTRYA.AMTCUR_0 * (GACCENTRYD.SNS_0) * ZTABCHANGE.RAT_0
ELSE
GACCENTRYD.AMTCUR_0 * (GACCENTRYD.SNS_0) * ZTABCHANGE.RAT_0
END)) as [SumOf_SERVER_FLD00000015] from
[x3v12].[SEED].[GACCENTRYD] [GACCENTRYD] LEFT JOIN [x3v12].[SEED].[GACCENTRY] [GACCENTRY] ON [GACCENTRYD].[TYP_0] = [GACCENTRY].[TYP_0] and [GACCENTRYD].[NUM_0] = [GACCENTRY].[NUM_0] LEFT JOIN
[x3v12].[SEI21_TEST10].[ZTABCHANGE] [ZTABCHANGE] ON [GACCENTRYD].[ACCDAT_0] = [ZTABCHANGE].[DATE_0] and [GACCENTRY].[CUR_0] = [ZTABCHANGE].[CUR_0] and [GACCENTRY].[TYPATR_0] = [ZTABCHANGE].[CHGTYP_0] LEFT JOIN
[x3v12].[SEED].[GACCENTRYA] [GACCENTRYA] ON [GACCENTRYD].[TYP_0] = [GACCENTRYA].[TYP_0] and [GACCENTRYD].[NUM_0] = [GACCENTRYA].[NUM_0] and [GACCENTRYD].[LIN_0] = [GACCENTRYA].[LIN_0] and [GACCENTRYD].[LEDTYP_0] = [GACCENTRYA].[LEDTYP_0] Where ([GACCENTRYD].[CPY_0] in (@param0,@param1)) and ([GACCENTRY].[FIY_0]=@param2) and ([GACCENTRY].[PER_0]=@param3) and ([GACCENTRY].CAT_0 = 1) Group By [GACCENTRYD].[ACC_0]
*** (@param0=A010;@param1=A020;@param2=2;@param3=4;) ***************Excel Add‑in Client log sample
---------------------------- Information 4/26/2021 11:38:28 AM ----------------------------
SELECT DISTINCT 'ACC_0' = [GACCENTRYD].[ACC_0], 'TEXTE_0' = [ATEXTRA_11].[TEXTE_0]
from [x3v12].[SEED].[GACCENTRYD] [GACCENTRYD] LEFT JOIN [x3v12].[SEED].[ATEXTRA_11] [ATEXTRA_11] ON [GACCENTRYD].[COA_0] = [ATEXTRA_11].[IDENT1_0] and [GACCENTRYD].[ACC_0] = [ATEXTRA_11].[IDENT2_0] and [ATEXTRA_11].[CODFIC_0] = [GACCONT] and [ATEXTRA_11].[ZONE_0] = 'DESTRA' and [ATEXTRA_11].[LANGUE_0] = 'ENG' LEFT JOIN [x3v12].[SEED].[GACCENTRY] [GACCENTRY] ON [GACCENTRYD].[TYP_0] = [GACCENTRY].[TYP_0] and [GACCENTRYD].[NUM_0] = [GACCENTRY].[NUM_0] WHERE [GACCENTRY.CAT_0 = 1) order by [GACCENTRYD].[ACC_0]
---------------------------- Information 4/26/2021 11:39:33 AM ----------------------------
SELECT DISTINCT FISCALYEAR.FIYNUM_0 as "FITNUM_0", (BI_YEAR(:FISCALYEAR.FIYSTA_0)) as "FLD00000001",FISCALYEAR.CPY_0 as "CPY_0" FROM @LIB_[FISCALYEAR] [FISCALYEAR] LEFT JOIN @LIB_[COMPANY] [COMPANY] ON [FISCALYEAR].[CPY_0] = [COMPANY].[CPY_0] LEFT JOIN @LIB_[APLSTD] [APLSTD] ON [FISCALYEAR].[FIYSTA_0] = [APLSTD].[LANNUM_0] and [APLSTD].[LANCHP_0] = 2618 and [APLSTD].[LAN_0] = #CurrentLang ORDER BY FISCALYEAR.FIYNUM_0 ASC
---------------------------- Error 4/26/2021 11:41:43 AM ----------------------------
Error in NectariQuery: System.NullReferenceException: Object variable or with block variable not set.
at Microsoft.VisualBasic.CompilerServices.Symbols.Container..ctor(Object Instance)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Ebisoft.Excel.Functions.NectariQuery(String catalogProcessID, String environementKey, String dimensionsForGroupBy, String measureToOperateOn, String operation, String dimensionList, Int32 optionalOrderingSettingForList,