Hi All,
Thank you for our reply.
The query which was used in Development environment is running successfully and the portlet also loading in 5 seconds as expected.
The same query is getting error in test and prod environments(in Database) that too error in Financial data. If i change the outer joins(Financial data Attachment) then it is running with out any error but portlet performance is very worst. More than 5 mins and facing issue in year filter(Logout and 500 internal server error).
I can confirm the below points,
1.While checking with financial data in the database its getting this issue and there is no issue with attributes.
2. Years are created till 2022.
3. I am creating the portlet in this way: Queries-->Portlet--> Portlet page
Log:
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1437) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.niku.union.web.WebException: WebServiceAdapter::processRequest -> failed to process service request at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:223) at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1431) at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:914) ... 50 more Caused by: java.lang.NullPointerException
Database and portlet error when using the development query to Test and PROD:
NPT-0103: Error when trying to execute the query. Native message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01417: a table may be outer joined to at most one other table
Thanks,
Thenmozhi K