UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
Absent Member.. Absent Member..
Absent Member..
427 views

Error 500:Unknown error

Hi All,

 

We recently did an upgrade to PPM 8.
Now we found 2 problems which were not in earlier version.

 

1)We get Error 500:Unknown error when we click a button on decision step(No log is also obtained)

 

2)A rule which was working in the previous version is not working

SELECT
(SELECT CASE WHEN
 INSTR('[REQ.REQUEST_SUB_TYPE_NAME]', 'Insurance') > 0
  THEN REPLACE('[REQD.P.AXA_RM_RTF_USERGRP_CONFIGMAN]', ', ', '#@#')
   ELSE REPLACE('[REQD.P.AXA_RM_RTF_USERGRP_EMERGENCY]', ', ', '#@#')
   END FROM DUAL),
(SELECT CASE WHEN
 INSTR('[REQ.REQUEST_SUB_TYPE_NAME]', 'Insurance') > 0
  THEN REPLACE('[REQD.VP.AXA_RM_RTF_USERGRP_CONFIGMAN]', '; ', '#@#')
   ELSE REPLACE('[REQD.VP.AXA_RM_RTF_USERGRP_EMERGENCY]', '; ', '#@#')
   END FROM DUAL),
'',''
FROM DUAL

 

Can you guys please me?

 

Thanks in advance,
Roobesh

0 Likes
2 Replies
Absent Member.. Absent Member..
Absent Member..

Hi,

 

1. check the serverLog.txt file for the HTTP 50 error - for sure you will find more details there.

2. How do you know that the rule is not working? is it throwing any error? you can try scrambling the SQL statement (replace FROM with FROOOOM) to see the values replacing the tokens at runtime.

 

cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
Cadet 1st Class
Cadet 1st Class

Where is the Location of this log file

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.