...
For SOAS and LEHIGH
INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES
('OLE-PURAP', 'All', 'ZERO_ENCUMBRANCE_CHECK', 'OLE101010', '1', 'CONFG', 'Y', 'Indicator for checking Zero Encumbrance in AutoClosePO Job.', 'A', 'OLE');
For Chicago
INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES
('OLE-PURAP', 'All', 'ZERO_ENCUMBRANCE_CHECK', 'OLE101010', '1', 'CONFG', 'N', 'Indicator for checking Zero Encumbrance in AutoClosePO Job.', 'A', 'OLE');
OLE-9356
Run the following commands in mysql database.
UPDATE mysql.user SET password=PASSWORD('xxxxxxxx') WHERE user='OLE';
FLUSH PRIVILEGES;
Add the following parameter in common-config.xml file
<param name="jdbc.username">OLE</param>
<param name="jdbc.password">xxxxxxx</param>
Replace "xxxxxxx" with the password you want to set.
Workflow xml change:
NIL
4. Jiras
...
Jira Legacy server System JIRA columns components,key,summary,priority,type,labels,status,updated maximumIssues 1000 jqlQuery project = OLE AND key in (OLE-92387724,OLE-92648539,OLE-93329309,OLE-93339318,OLE-93349335,OLE-93379346,OLE-93429352,OLE-93439355,OLE-93449356,OLE-93459362,OLE-93489363,OLE-93499365,OLE-93509367) ORDER BY key serverId a6f93653-ee50-3e81-88ad-29eb84ada35c
...