Bonjour,

j'essaye de creer un fichier de sortie SQL avec log4j de ce type :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
<param name="ConversionPattern" value="insert into log4j (time,warning,class,environment,server_name,id) values ( '%d{yyyy-MM-dd}','%-5p','%-50.50c{3}','SIT','DUBEPAP1',NULL); %n"/>
le petit souci c'est que les premieres lignes sont nickels et puis tout d'un cout je me retrouve avec des saloperies du genre :
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','FATAL','pegarules.util.PRParseUtils ','SIT','DUBEPAP1',NULL);
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','FATAL','pegarules.util.PRParseUtils ','SIT','DUBEPAP1',NULL);
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','DEBUG','pegarules.parserule.XMLParserBase ','SIT','DUBEPAP1',NULL);
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','DEBUG','pegarules.parserule.XMLParserBase ','SIT','DUBEPAP1',NULL);
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','DEBUG','pegarules.parserule.XMLParserBase ','SIT','DUBEPAP1',NULL);
insert into log4j (time,warning,class,environment,server_name,id) values ( '2006-11-01','ERROR','pegarules.util.PRParseUtils ','SIT','DUBEPAP1',NULL);
(A673C9EDF726E58561B49F491E085B5F7)
com.pega.pegarules.pub.clipboard.InvalidParameterException: cannot be null or blank. page: ERWorkPage.Client.Declines. Details: Invalid value for aReference passed to com.pega.pegarules.engine.clipboard.ClipboardPageImpl.getProperty(String, char)
at com.pega.pegarules.engine.clipboard.ClipboardPageImpl.getProperty(ClipboardPageImpl.java:816)
at com.pega.pegarules.engine.clipboard.ClipboardPageImpl.getProperty(ClipboardPageImpl.java:797)
at com.pega.pegarules.engine.clipboard.ClipboardPageImpl.getProperty(ClipboardPageImpl.java:777)
at com.pega.pegarules.engine.clipboard.ClipboardPropertyImpl.getPropertyValue(ClipboardPropertyImpl.java:1454)
at ra_parse_xml_aiu_extra_work_sbs__clientdecline_outputscenario_1139675075626.parseElement(ra_parse_xml_aiu_extra_work_sbs__clientdecline_outputscenario_1139675075626.java:115)
at com.pega.pegarules.parserule.XMLParserBase.parse(XMLParserBase.java:368)
at com.pega.pegarules.util.PRParseUtils.parseXML(PRParseUtils.java:183)
at com.pegarules.generated.activity.ra_activity_aiu_extra_work_sbs__at_nb_maperdecline_5e96224a477dda1a2edde8724fd3ec29.step6_circum0(ra_activity_aiu_extra_work_sbs__at_nb_maperdecline_5e96224a477dda1a2edde8724fd3ec29.java:763)
at com.pegarules.generated.activity.ra_activity_aiu_extra_work_sbs__at_nb_maperdecline_5e96224a477dda1a2edde8724fd3ec29.perform(ra_activity_aiu_extra_work_sbs__at_nb_maperdecline_5e96224a477dda1a2edde8724fd3ec29.java:215)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:2691)
at com.pegarules.generated.activity.ra_activity_aiu_extra_work_sbs_leipac_at_nb_mapexpectedresults_8cf70b608359c531538b28324f2269f6.step10_circum0(ra_activity_aiu_extra_work_sbs_leipac_at_nb_mapexpectedresults_8cf70b608359c531538b28324f2269f6.java:1008)
at com.pegarules.generated.activity.ra_activity_aiu_extra_work_sbs_leipac_at_nb_mapexpectedresults_8cf70b608359c531538b28324f2269f6.perform(ra_activity_aiu_extra_work_sbs_leipac_at_nb_mapexpectedresults_8cf70b608359c531538b28324f2269f6.java:294)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:2691)
at com.pegarules.generated.flow.ra_flow_aiu_extra_work_sbs_leipac_
et ceci de manière periodique. C'est pareil pour le fichier texte .log tout bete.

Merci pour vos réponses,