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

 

Executed:

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&yesAction=projmgr.teamDeleteAndClose%26ui.page.space%3Dmainnav.work&confirmType=confirmRemove&noAction=union.closeAndRefreshParent&id=5219696&spaceID=mainnav.work&uitk.navigation.location=Modal&uitk.navigation.parent.location=Workspace&uitk.navigation.last.workspace.action=npt.setPage 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.

Outcomes