AnsweredAssumed Answered

Error in app-ca log

Question asked by sravani_nidamanuri on Jun 9, 2016
Latest reply on Jun 20, 2016 by Chris_Hackett

App-ca log is frequently filled with below error


ERROR 2016-06-07 10:27:43,797 [http-bio-80-exec-121] niku.xql2 (clarity:JERICKS5:20013979__3FCC0DA6-08F3-45FC-A00A-1973C3260D17:projmgr.teamSelitemCheckConfirm) Internal Processing exception

java.lang.Exception: Invalid expression qTeam: com.niku.union.persistence.PersistenceException:

SQL error code: 936

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00936: missing expression



SELECT      prID, prresourceid, prprojectid, prbooking

          FROM        PRTeam

          WHERE       PRTeam.prid IN ()2:51 PM


This is the URL which I see in app-access log with the same timestamp


/niku/nu?uitk.vxml.form=1&action=projmgr.teamSelitemCheckConfirm&confirmMsg=projmgr.CONFIRM_DELETE_TEAM& HTTP/1.1|200|3122|62|20013979__3FCC0DA6-08F3-45FC-A00A-1973C3260D17



In order to replicate the issue I just opened a project page and went to team tab. Then without selecting any resource click on

remove. I get this error in GUI



But we are not seeing any error in app-ca log when I perform these steps.


Do the errors be generated in app-ca log when we get this type of error in GUI?


Can anyone also help to replicate the error which I have mentioned at the top.