RLKS ART - There has been no response from database
I deployed 8.1.5 RKLS ART. Working with DB2 and Sussie Linux. All connections are working fine. Even the data is being picked up from the floating log file, converted to json by agent, passing to admin so daa can be converted and put into DB. I can see data in the DB. When i try to run the report, it says "CRALUR0006I :- No license usage information is available for the selected parameters."
Since i have enabled "DEBUG" option, in the RLKS_ART.log file, i see the following which i dont understand why I get this and also why no usage information is reported since i know data does exist in the DB
[LargeThreadPool-thread-5146][com.ibm.rcl.reporting.dataProviders.GetChartBasedReportData][145] - There has been no response from the database.
I also see this query being run:
select username, hostname, product, token_count, time_of_day, license_hours from per_user_fact as PUF inner join served_license as SL on PUF.served_license_id = SL.served_license_id inner join license as L on SL.license_id = L.license_id inner join user_host as UH on PUF.user_host_id = UH.user_host_id where hostname_portnumber in ('clm.company.com_4080') and product in ('') and (token_count = -2) and time_of_day >= TIMESTAMP_FORMAT('2017-09-08 04:00:00', 'YYYY-MM-DD HH24:MI:SS') and time_of_day < TIMESTAMP_FORMAT('2017-09-15 04:00:00', 'YYYY-MM-DD HH24:MI:SS') order by username, hostname, product, token_count, time_of_day
When i run this query in DB, i get 0 record. But if run this with Product = Collaborative Lifecycle Management, i get 15 records
select username, hostname, product, token_count, time_of_day, license_hours from per_user_fact as PUF inner join served_license as SL on PUF.served_license_id = SL.served_license_id inner join license as L on SL.license_id = L.license_id inner join user_host as UH on PUF.user_host_id = UH.user_host_id where hostname_portnumber in ('clm.company.com_4080') and product in ('Collaborative Lifecycle Management') and (token_count = -2) and time_of_day >= TIMESTAMP_FORMAT('2017-09-08 04:00:00', 'YYYY-MM-DD HH24:MI:SS') and time_of_day < TIMESTAMP_FORMAT('2017-09-15 04:00:00', 'YYYY-MM-DD HH24:MI:SS') order by username, hostname, product, token_count, time_of_day
Any insight would be appreciated