Attached Files | 42875.diff [^] (11,245 bytes) 2020-01-20 10:49 [Show Content] [Hide Content]# HG changeset patch
# User David Miguelez <david.miguelez@openbravo.com>
# Date 1579023808 -3600
# Tue Jan 14 18:43:28 2020 +0100
# Node ID 56de3688e3ef315eecb552721d8bf91be3716b23
# Parent 82de1963f8ba67943052301c118704352a9cae3f
Fixes Issue 42875: Accouting Background process is not scheduled
at System level anymore.
It is scheduled for F&B and QA Admin clients.
diff --git a/referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml b/referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
--- a/referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
+++ b/referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
@@ -4231,6 +4231,43 @@
</AD_PROCESS_REQUEST>
<AD_PROCESS_REQUEST>
+ <AD_PROCESS_REQUEST_ID><![CDATA[D2306AB53BA74AA0931661053038A201]]></AD_PROCESS_REQUEST_ID>
+ <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID>
+ <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+ <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+ <CREATED><![CDATA[2020-01-09 08:49:26.8]]></CREATED>
+ <CREATEDBY><![CDATA[100]]></CREATEDBY>
+ <UPDATED><![CDATA[2020-01-09 08:50:57.119115]]></UPDATED>
+ <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
+ <AD_PROCESS_ID><![CDATA[800064]]></AD_PROCESS_ID>
+ <AD_USER_ID><![CDATA[100]]></AD_USER_ID>
+ <ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY>
+ <OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":"100","role":"42D0EEB1C66F497A90DD526DC597E6F0","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"23C59575B9CF467C9620760EB255B389","organization":"0","warehouse":"B2D40D8A5D644DD89E329DC297309055","command":"DEFAULT","userClient":"'23C59575B9CF467C9620760EB255B389'","userOrganization":"'0','E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','BAE22373FEBE4CCCA24517E23F0C8A48','DC206C91AA6A4897B44DA897936E0EC3','19404EAD144C49A0AF37D54377CF452D','2E60544D37534C0B89E765FE29BC0B43','7BABA5FF80494CAFA54DEBD22EC46F01'","dbSessionID":"3022E4677BDE45B5B95CC9504AC58009","javaDateFormat":"dd-MM-yyyy","javaDateTimeFormat":"dd-MM-yyyy HH:mm:ss","jsDateFormat":"%d-%m-%Y","sqlDateFormat":"DD-MM-YYYY","accessLevel":"7","roleSecurity":true}}]]></OB_CONTEXT>
+ <STATUS><![CDATA[SCH]]></STATUS>
+ <CHANNEL><![CDATA[Process Scheduler]]></CHANNEL>
+ <TIMING_OPTION><![CDATA[S]]></TIMING_OPTION>
+ <START_TIME><![CDATA[2020-01-10 00:00:00.0]]></START_TIME>
+ <START_DATE><![CDATA[2020-01-09 00:00:00.0]]></START_DATE>
+ <FREQUENCY><![CDATA[2]]></FREQUENCY>
+ <MINUTELY_INTERVAL><![CDATA[5]]></MINUTELY_INTERVAL>
+ <DAILY_INTERVAL><![CDATA[1]]></DAILY_INTERVAL>
+ <DAY_MON><![CDATA[N]]></DAY_MON>
+ <DAY_TUE><![CDATA[N]]></DAY_TUE>
+ <DAY_WED><![CDATA[N]]></DAY_WED>
+ <DAY_THU><![CDATA[N]]></DAY_THU>
+ <DAY_FRI><![CDATA[N]]></DAY_FRI>
+ <DAY_SAT><![CDATA[N]]></DAY_SAT>
+ <DAY_SUN><![CDATA[N]]></DAY_SUN>
+ <MONTHLY_OPTION><![CDATA[S]]></MONTHLY_OPTION>
+ <FINISHES><![CDATA[N]]></FINISHES>
+ <DAILY_OPTION><![CDATA[N]]></DAILY_OPTION>
+ <SCHEDULE><![CDATA[N]]></SCHEDULE>
+ <RESCHEDULE><![CDATA[N]]></RESCHEDULE>
+ <UNSCHEDULE><![CDATA[N]]></UNSCHEDULE>
+ <ISGROUP><![CDATA[N]]></ISGROUP>
+</AD_PROCESS_REQUEST>
+
+<AD_PROCESS_REQUEST>
<AD_PROCESS_REQUEST_ID><![CDATA[D23B20AA0EE3422E87706DFE63DF59F1]]></AD_PROCESS_REQUEST_ID>
<AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID>
<AD_ORG_ID><![CDATA[E443A31992CB4635AFCAEABE7183CE85]]></AD_ORG_ID>
@@ -4615,15 +4652,15 @@
<ISACTIVE><![CDATA[Y]]></ISACTIVE>
<CREATED><![CDATA[2013-07-04 23:45:49.006]]></CREATED>
<CREATEDBY><![CDATA[0]]></CREATEDBY>
- <UPDATED><![CDATA[2019-12-19 19:10:07.002273]]></UPDATED>
+ <UPDATED><![CDATA[2020-01-09 08:50:07.002425]]></UPDATED>
<UPDATEDBY><![CDATA[100]]></UPDATEDBY>
<AD_PROCESS_ID><![CDATA[3F2B4AAC707B4CE7B98D2005CF7310B5]]></AD_PROCESS_ID>
<AD_USER_ID><![CDATA[100]]></AD_USER_ID>
<ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY>
<OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":"100","role":"42D0EEB1C66F497A90DD526DC597E6F0","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"23C59575B9CF467C9620760EB255B389","organization":"0","warehouse":"","command":"DEFAULT","userClient":"","userOrganization":"","dbSessionID":"","javaDateFormat":"","jsDateFormat":"","sqlDateFormat":"","accessLevel":"","roleSecurity":true}}]]></OB_CONTEXT>
<STATUS><![CDATA[SCH]]></STATUS>
- <NEXT_FIRE_TIME><![CDATA[2019-12-19 19:15:07.0]]></NEXT_FIRE_TIME>
- <PREVIOUS_FIRE_TIME><![CDATA[2019-12-19 19:10:07.0]]></PREVIOUS_FIRE_TIME>
+ <NEXT_FIRE_TIME><![CDATA[2020-01-09 08:55:07.0]]></NEXT_FIRE_TIME>
+ <PREVIOUS_FIRE_TIME><![CDATA[2020-01-09 08:50:07.0]]></PREVIOUS_FIRE_TIME>
<CHANNEL><![CDATA[Process Scheduler]]></CHANNEL>
<TIMING_OPTION><![CDATA[S]]></TIMING_OPTION>
<START_TIME><![CDATA[2013-04-23 14:10:07.0]]></START_TIME>
diff --git a/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml b/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml
--- a/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml
+++ b/referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml
@@ -328,4 +328,41 @@
<ISGROUP><![CDATA[N]]></ISGROUP>
</AD_PROCESS_REQUEST>
+<AD_PROCESS_REQUEST>
+ <AD_PROCESS_REQUEST_ID><![CDATA[F9E2EFB876D642D185893C394A02DBE3]]></AD_PROCESS_REQUEST_ID>
+ <AD_CLIENT_ID><![CDATA[4028E6C72959682B01295A070852010D]]></AD_CLIENT_ID>
+ <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+ <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+ <CREATED><![CDATA[2020-01-09 08:49:59.333]]></CREATED>
+ <CREATEDBY><![CDATA[100]]></CREATEDBY>
+ <UPDATED><![CDATA[2020-01-09 08:51:18.657805]]></UPDATED>
+ <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
+ <AD_PROCESS_ID><![CDATA[800064]]></AD_PROCESS_ID>
+ <AD_USER_ID><![CDATA[100]]></AD_USER_ID>
+ <ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY>
+ <OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":"100","role":"4028E6C72959682B01295A071429011E","language":"en_US","theme":"ltr\/org.openbravo.userinterface.skin.250to300Comp\/250to300Comp","client":"4028E6C72959682B01295A070852010D","organization":"0","warehouse":"4D7B97565A024DB7B4C61650FA2B9560","command":"DEFAULT","userClient":"'4028E6C72959682B01295A070852010D'","userOrganization":"'5EFF95EB540740A3B10510D9814EFAD5','0','43D590B4814049C6B85C6545E8264E37','357947E87C284935AD1D783CF6F099A1'","dbSessionID":"3022E4677BDE45B5B95CC9504AC58009","javaDateFormat":"dd-MM-yyyy","javaDateTimeFormat":"dd-MM-yyyy HH:mm:ss","jsDateFormat":"%d-%m-%Y","sqlDateFormat":"DD-MM-YYYY","accessLevel":"7","roleSecurity":true}}]]></OB_CONTEXT>
+ <STATUS><![CDATA[SCH]]></STATUS>
+ <CHANNEL><![CDATA[Process Scheduler]]></CHANNEL>
+ <TIMING_OPTION><![CDATA[S]]></TIMING_OPTION>
+ <START_TIME><![CDATA[2020-01-10 00:00:00.0]]></START_TIME>
+ <START_DATE><![CDATA[2020-01-09 00:00:00.0]]></START_DATE>
+ <FREQUENCY><![CDATA[2]]></FREQUENCY>
+ <MINUTELY_INTERVAL><![CDATA[5]]></MINUTELY_INTERVAL>
+ <DAILY_INTERVAL><![CDATA[1]]></DAILY_INTERVAL>
+ <DAY_MON><![CDATA[N]]></DAY_MON>
+ <DAY_TUE><![CDATA[N]]></DAY_TUE>
+ <DAY_WED><![CDATA[N]]></DAY_WED>
+ <DAY_THU><![CDATA[N]]></DAY_THU>
+ <DAY_FRI><![CDATA[N]]></DAY_FRI>
+ <DAY_SAT><![CDATA[N]]></DAY_SAT>
+ <DAY_SUN><![CDATA[N]]></DAY_SUN>
+ <MONTHLY_OPTION><![CDATA[S]]></MONTHLY_OPTION>
+ <FINISHES><![CDATA[N]]></FINISHES>
+ <DAILY_OPTION><![CDATA[N]]></DAILY_OPTION>
+ <SCHEDULE><![CDATA[N]]></SCHEDULE>
+ <RESCHEDULE><![CDATA[N]]></RESCHEDULE>
+ <UNSCHEDULE><![CDATA[N]]></UNSCHEDULE>
+ <ISGROUP><![CDATA[N]]></ISGROUP>
+</AD_PROCESS_REQUEST>
+
</data>
diff --git a/src-db/database/sourcedata/referencedData/AD_PROCESS_REQUEST.xml b/src-db/database/sourcedata/referencedData/AD_PROCESS_REQUEST.xml
--- a/src-db/database/sourcedata/referencedData/AD_PROCESS_REQUEST.xml
+++ b/src-db/database/sourcedata/referencedData/AD_PROCESS_REQUEST.xml
@@ -142,37 +142,6 @@
<!--88814B57EFB34E9AAE699CADA395BD1E--> <CHANNEL><![CDATA[Direct]]></CHANNEL>
<!--88814B57EFB34E9AAE699CADA395BD1E--></AD_PROCESS_REQUEST>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--><AD_PROCESS_REQUEST>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <AD_PROCESS_REQUEST_ID><![CDATA[9B2B32C0BAF146F783A50C6F69251BC4]]></AD_PROCESS_REQUEST_ID>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <AD_PROCESS_ID><![CDATA[800064]]></AD_PROCESS_ID>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <AD_USER_ID><![CDATA[100]]></AD_USER_ID>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <ISROLESECURITY><![CDATA[Y]]></ISROLESECURITY>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <OB_CONTEXT><![CDATA[{"org.openbravo.scheduling.ProcessContext":{"user":100,"role":0,"language":"en_US","theme":"ltr\/Default","client":0,"organization":0,"warehouse":"","command":"DEFAULT","userClient":"","userOrganization":"","dbSessionID":"","javaDateFormat":"","jsDateFormat":"","sqlDateFormat":"","accessLevel":"","roleSecurity":true}}]]></OB_CONTEXT>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <STATUS><![CDATA[SCH]]></STATUS>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <NEXT_FIRE_TIME><![CDATA[2009-08-25 00:31:49.0]]></NEXT_FIRE_TIME>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <PREVIOUS_FIRE_TIME><![CDATA[2009-08-25 00:30:49.0]]></PREVIOUS_FIRE_TIME>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <CHANNEL><![CDATA[Process Scheduler]]></CHANNEL>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <TIMING_OPTION><![CDATA[S]]></TIMING_OPTION>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <FREQUENCY><![CDATA[2]]></FREQUENCY>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <MINUTELY_INTERVAL><![CDATA[5]]></MINUTELY_INTERVAL>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_MON><![CDATA[N]]></DAY_MON>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_TUE><![CDATA[N]]></DAY_TUE>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_WED><![CDATA[N]]></DAY_WED>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_THU><![CDATA[N]]></DAY_THU>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_FRI><![CDATA[N]]></DAY_FRI>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_SAT><![CDATA[N]]></DAY_SAT>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAY_SUN><![CDATA[N]]></DAY_SUN>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <MONTHLY_OPTION><![CDATA[S]]></MONTHLY_OPTION>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <FINISHES><![CDATA[N]]></FINISHES>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <DAILY_OPTION><![CDATA[N]]></DAILY_OPTION>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <SCHEDULE><![CDATA[N]]></SCHEDULE>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <RESCHEDULE><![CDATA[N]]></RESCHEDULE>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--> <UNSCHEDULE><![CDATA[N]]></UNSCHEDULE>
-<!--9B2B32C0BAF146F783A50C6F69251BC4--></AD_PROCESS_REQUEST>
-
<!--BF28BB94BF374A819E6B429F37751154--><AD_PROCESS_REQUEST>
<!--BF28BB94BF374A819E6B429F37751154--> <AD_PROCESS_REQUEST_ID><![CDATA[BF28BB94BF374A819E6B429F37751154]]></AD_PROCESS_REQUEST_ID>
<!--BF28BB94BF374A819E6B429F37751154--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
|