It's all about the answers!

Ask a question

RLKS ART - There has been no response from database


Ankit Shah (15712) | asked Sep 20 '17, 2:21 p.m.

 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

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.