Print query/mantain log with parameters
Summary
when the querie or a mantain execution fails (for example duplicate primary key), the system logs show querie or mantain with parameters without filling in "?"
AWE version
4.4.1
Steps to reproduce
Create insert with querie to have an insert into select and force duplicate primary key.
Example Project
FitOre
What is the current bug behavior?
insert into OreCalDtaEstAIFTab02 (IdeOreRepESMA, IdeOreCalDtaEstESMA, IdeOreCalDtaEstAIFTab02, Itm024, Itm025, Itm026, Itm027, Itm028, Itm029, Itm030, Itm031, Itm032, Itm033, Itm034, Itm035, Itm036, Itm037, Itm038, Itm039, Itm040, Itm041, Itm043, Itm044, RowTyp)
select distinct (select max(IdeOreRepESMA) as IdeOreRepESMA
from OreCalDtaEstESMA OreCalDtaEstESMA
where TypEtt = ? or TypEtt = ? or TypEtt = ? or TypEtt = ?) as IdeOreRep, (select IdeOreCalDtaEstESMA as IdeOreCalDtaEstESMA
from OreCalDtaEstESMA OreCalDtaEstESMA
where IdeOreCfgEst = (select IdeOreCfgEst as IdeOreCfgEs from OreCfgEst OreCfgEstwhere CfgEst like ? escape '\')
and IdeOreRepESMA = (select max(IdeOreRepESMA) as IdeOreRepESMA from OreCalDtaEstESMA OreCalDtaEstESMA where TypEtt = ? or TypEtt = ? or TypEtt = ? or TypEtt = ?)) as IdeOreCalDtaEst, ((select max(KeyVal) as IdeOreCalDtaEstFiaTab02
from AweKey a where a.KeyNam like ? escape '\') + s.RowNb) as IdeOreCalDtaEstAIFTab02, s.Field1 as ColItm024, s.Field2 as ColItm025, s.Field3 as ColItm026, s.Field4 as ColItm027, s.Field5 as ColItm028, s.Field6 as ColItm029, s.Field7 as ColItm030, s.Field8 as ColItm031, s.Field9 as ColItm032, s.Field10 as ColItm033, s.Field11 as ColItm034, s.Field12 as ColItm035, s.Field13 as ColItm036, s.Field14 as ColItm037, s.Field15 as ColItm038, s.Field16 as ColItm039, s.Field17 as ColItm040, s.Field18 as ColItm041, s.Field19 as ColItm043, s.Field20 as ColItm044, s.RowTyp as RowTyp
from (select RowNb as RowNb, Field1 as Field1, Field2 as Field2, Field3 as Field3, Field4 as Field4, Field5 as Field5, Field6 as Field6, Field7 as Field7, Field8 as Field8, Field9 as Field9, Field10 as Field10, Field11 as Field11, Field12 as Field12, Field13 as Field13, Field14 as Field14, Field15 as Field15, Field16 as Field16, Field17 as Field17, Field18 as Field18, Field19 as Field19, Field20 as Field20, RowTyp as RowTyp
from OreImpGlbGenAIF OreImpGlbGenAIF
inner join OreImpGlb OreImpGlb
on OreImpGlbGenAIF.IdeOreImpGlb = OreImpGlb.IdeOreImpGlb
where IdeOreCfgEst = (select IdeOreCfgEst as IdeOreCfgEst
from OreCfgEst OreCfgEst
where CfgEst = ?) and IdeOreCfgEtt = ? and RepMon = ? and RepYea = ? and Tabla = ?) as s
What is the expected correct behavior?
insert into OreCalDtaEstAIFTab01 (IdeOreRepESMA, IdeOreCalDtaEstESMA, IdeOreCalDtaEstAIFTab01, Itm001, Itm002, Itm003, Itm004, Itm005, Itm006, Itm007, Itm008, Itm009, Itm010, Itm011, Itm012, Itm013, Itm014, Itm015, Itm016, Itm017, Itm018, Itm019, Itm020, Itm021, Itm022, Itm023, RowTyp)
select distinct (
select max(IdeOreRepESMA) as IdeOreRepESMA from OreCalDtaEstESMA OreCalDtaEstESMA
where TypEtt = 'IIC' or TypEtt = 'SGIIC' or TypEtt = 'ECR' or TypEtt = 'SGECR') as IdeOreRep,
(select IdeOreCalDtaEstESMA as IdeOreCalDtaEstESMA from OreCalDtaEstESMA OreCalDtaEstESMA
where IdeOreCfgEst = (select IdeOreCfgEst as IdeOreCfgEst from OreCfgEst OreCfgEst where CfgEst like 'AIF' escape '\')
and IdeOreRepESMA = (select max(IdeOreRepESMA) as IdeOreRepESMA from OreCalDtaEstESMA OreCalDtaEstESMA
where TypEtt = 'IIC' or TypEtt = 'SGIIC' or TypEtt = 'ECR' or TypEtt = 'SGECR')) as IdeOreCalDtaEst,
((select max(KeyVal) as IdeOreCalDtaEstFiaTab01 from AweKey a where a.KeyNam like 'CalDtaEAIFAIFTab01' escape '\') + s.RowNb) as IdeOreCalDtaEstAIFTab01,
s.Field1 as ColItm001, s.Field2 as ColItm001, s.Field3 as ColItm001, s.Field4 as ColItm001, s.Field5 as ColItm001, s.Field6 as ColItm001, s.Field7 as ColItm001,
s.Field8 as ColItm001, s.Field9 as ColItm001, s.Field10 as ColItm001, s.Field11 as ColItm001, s.Field12 as ColItm001, s.Field13 as ColItm001, s.Field14 as ColItm001,
s.Field15 as ColItm001, s.Field16 as ColItm001, s.Field17 as ColItm001, s.Field18 as ColItm001, s.Field19 as ColItm001, s.Field20 as ColItm001,
s.Field21 as ColItm001, s.Field22 as ColItm001, s.Field23 as ColItm001, s.RowTyp as RowTyp
from (select RowNb as RowNb, Field1 as Field1, Field2 as Field2, Field3 as Field3, Field4 as Field4, Field5 as Field5, Field6 as Field6, Field7 as Field7,
Field8 as Field8, Field9 as Field9, Field10 as Field10, Field11 as Field11, Field12 as Field12, Field13 as Field13, Field14 as Field14, Field15 as Field15,
Field16 as Field16, Field17 as Field17, Field18 as Field18, Field19 as Field19, Field20 as Field20, Field21 as Field21, Field22 as Field22, Field23 as Field23,
RowTyp as RowTyp from OreImpGlbGenAIF OreImpGlbGenAIF
inner join OreImpGlb OreImpGlb on OreImpGlbGenAIF.IdeOreImpGlb = OreImpGlb.IdeOreImpGlb
where IdeOreCfgEst = (select IdeOreCfgEst as IdeOreCfgEst from OreCfgEst OreCfgEst where CfgEst = 'AIF')
and IdeOreCfgEtt = '66' and RepMon = '12' and RepYea = '2021' and Tabla = 1) as s
Relevant logs and/or screenshots
(Paste any relevant logs - please use code blocks (```) to format console output, logs, and code as it's very hard to read otherwise.)
Possible fixes
(If you can, link to the line of code that might be responsible for the problem)
Edited by Pablo Javier García Mora