Resolved issues

Review the defects that are resolved with the release of version 7.0.3.

Defect ID APAR ID Summary
570183 PH57749 Report Builder should prevent NPE during type system fetch from Web UI
569989 PH57786 LQE heap trigger for query shedding should not use totalHeap from the memory MBean
556661 PH49274 Backport: RB_SCHEDULE_TIMER] ERROR on.reporting.report.schedule.ReportScheduleManager... (556629)
555998 PH32216 Other Prevent TCP connection timeouts from occurring between Report Builder and LQE [7.0.2 maintenance]
555526 PH32216 Download Log File button not visible in Report Builder Admin page [7.0.2 maintenance]
555509 PH47207 Project id associated to the category in report query is for a different project
555156 PH32216 Backport RB export changes to include prefixes to 7.0.2
553956 PH47299 A label for configuration gets garbled in a report builder and Report Widget [7.0.2 maintenance]
553829 PH46722 report validation fails first time and then subsequent validation is successful [7.0.2 maintenance]
553082 PH46266 Primary Text displaying HTML code in Graph View of Report Builder [7.0.2 maintenance]
552876 PH46382 A report is rendered differently between Report Builder UI and ELM dashboard if there is a lot of data returned. [7.0.2 maintenance]
552862 PH46413 In ENI view, "Set condition" tab in Refine container content dialog does not stop loading [7.0.2 maintenance]
552495 PH30922 Handle null datatype in RB [7.0.2 maintenance]
552346 PH32216 Create Internal flag to stop Access synchronizer job to link user groups to project or Team area
552262 PH44930 Font size on line charts is much smaller than on bar charts
551692 PH45629 LQE data source UI keeps switching back to the Overview tab when viewing other tabs besides History
550737 PH45021 Result not getting displayed in My Results/All Results page for specific scheduled reports [7.0.2 maintenance]
550217 PH39645 Using "SUBSTR" function in RB, the results are empty with LQE data source [7.0.2 maintenance]
549256 PH44220 F_EXEC_WORKITEM_REQU_METRICS grows too big because REQUIREMENT is used as a dimensionF_EXEC_WORKITEM_REQU_METRICS grows too big because REQUIREMENT is used as a dimension
549234 PH43880 Report Builder has an issue matching - Address slow SPARQL query in RM->CCM links (548347) [7.0.2 Maintenance]
549139 PH32216 Reports that that use Work Item signature are broken [7.0.2 maintenance]
548729 PH43447 Some Test metric tables use test case as a dimension causing scale/sizing issues
548688 PH43827 Multiple subtree conditions cause incorrect results in LQE SPARQL reports
548686 PH32216 SQLParserException on using "AND NOT" and "OR NOT" on grouped conditions
548477 PH43332 Report Builder NPE when grouping reports in a folder
548251 PH41250 Problems with preview popup from hovering over links in report builder widgets on a dashboard
548202 PH43623 Reindex failed in LQE with java.io.FileNotFoundException:
548170 PH32216 7.0.2 LQE HistoryScrubbingService performs poorly and becomes untenable over time
548120 PH42685 No Drill-Down (DD) data on bar against X value with ',' char in it
547584 PH32216 [7.0.2]For a jazzAdmin user My Reports->Group by Datasource lists reports neither owned or created.
547351 PH43220 No results found in a report that shows requirements tracked by work items
547180 PH42994 Attempts to use a traceability with multiple 'Satisfies' relationships fails to return last relationship in results.
547149 PH42926 LQE may report "CRLQE1337E The query did not run" even when no query timed out in the previous 2 minutes
547099 PH42465 Potential regression caused by defect fix 512368
547078 PH32216 Discrepancy in the number of skipped resources reported by LQE
546894 PH42633 JDBC driver deadlock with Oracle, Scrubbing Services blocks TRS indexing operations
546882 PH37189 Warning messages in JRS moves the focus to the top of the page on each interaction to the attributes in the format results page
546854 PH44097 High volume of the same sparql query may result in erroneous counts on the Health Monitoring Statistics page.
546831 PH40165 Reports using LISTAGG throw error while using multiple traceability
546370 PH32216 Broken link validity report when displaying more than one validity status
546355 PH42172 Live Excel does not combine columns on data refresh
544255 PH41250 Size of popup in dashboard widget is different from the popup in JRS
544227 PH41320 CQPAR00257981: LQE/LDX permissions are missing users when membership email addresses are associated with over 100 user ids.
543665 PH44241 Improve SPARQL query performance when an enumeration (with external URI) is added as a column with FILTER added on the same attribute.
543617 PH41090 RB/QM: expected test plans not populating in add condition dialog
541677 PH32216 Delta DCC not picking up changes made to artifacts' default system attributes when the binding is edited
541669 PH32216 Broken link validity report when displaying more than one validity status
541430 PH40165 Reports using LISTAGG throw error while using multiple traceability
540844 PH36342 prefixToUrl mapping is not retained in meta model cache file
539606 PH39227 LQE requires a lot of space to create compressed backups relative to the size of the compressed files
538477 PH38632 Date format not preserved on refresh of live Excel
537739 PH38251 DB connection lost during full ETL causes DCC to hang and to stop updating data
537345 PH37381 "Does not exist" is not working for keyword-Default test script relationship in report builder.
537023 PH32216 Creator of report changes when you save a report
536869 PH32216 LDX is failing to index an ETM data source. Throwing a NPE
536437 PH36911 LQE Excel Export shows Rich Text formatting tags in the concatenated primary text fields
535754 PH37743 NPE while accessing PUB Document specification url
535229 PH36894 Displaying wrong groupname for relationship
535044 PH32216 Unable to restore LQE when using DB2
534467 PH37189 CQPAR00256578: Warning messages in JRS moves the focus to the top of the page on each interaction to the attributes in the format results page
533691 PH36774 Metamodel refresh is slow caused by redundant query execution
533185 PH35187 LQE-based report : No DD results if column data contains HTTP encoded string
532978 PH33374 JRS pop-up dialog for URLs is too small.
532973 PH36459 Creation date is empty when exporting historical trend report to static excel spreadsheet
532865 PH36291 Query timeout fetching configurations using "LQE scoped by configuration".
532628 PH32216 RM project is not listed under 'Limit the scope' when creating report with LQE data source
531478 PH35788 RB performance: RB is slow on jazz net (self host) intermittent hangs slow performance
531331 PH35446 Unauth errors in lqe.log during live excel refresh on JTS auth
530117 PH34509 Drill down of a count on a data warehouse report returns no results when a merge multiple traceability is used.
529273 PH34685 DW : Not all time entries are listed on DD Calc column (SUM) on Time entries
528894 PH33378 DCC should stop populating RIDW.F_TESTCASE_REQUI_METRICS
528890 PH34219 Report does not consider the condition for selected Test Script value if multiple projects are selected
528327 PH34573 Missing old reports of uid=email-id post SSO migration
528250 PH34258 WorkItems with Unassigned deliverable attribute are shown in an incorrect bar in graph view
528248 PH31958 Drill down in bar graph report results in CRRGW5612E
528108 PH32232 DD on combined columns bar fails with an SQL error
526633 PH32884 "Created by Me" filter shows reports for which the user is owner but not creator
526345 PH33816 JRS with Db2 z/OS as data source throws SQL error when specifying dates
525701 PH33467 Restarting during a validation leaves data source showing a validation failed status
525346 PH32216 LQE data source on selfhost server appears to be stuck due to initializing operation taking a long time
524611 PH32699 Incorrect dynamic filters in DD SQL
524600 PH33829 LQE Backup takes 82 hours
521530 PH32216 No DD data for DateScaleCalc=First/Last & Date Sacle=Months
521426 PH32216 Need an indication that the report is dirty, if it is not refreshed after a change
521110 PH32216 Restoring lqe databases from backup gives an error "server\conf\lqe\datasets\history\historyText' does not exist"
520960 PH32216 Health monitoring graphs are largely empty
520676 PH30942 Clicking + button to select more values for a condition has no effect
519731 PH31197 CQPAR00252554: Propagate fixes made to the LQE compact command to the RB compact command
518607 PH30596 CQPAR00252298: Handle connection closed when writing delta time info
518570 PH30682 CQPAR00252354: LQE should recover from closed prepared statements
516365 PH29522 CQPAR00251965: Conditions and relationships on artifacts following a 'does not exist' relationship are NOT ignored for DW reports.
516051 PH29504 CQPAR00251955: Workaround java.lang.ArrayIndexOutOfBoundsException in xerces library
515959 PH29452 CQPAR00251943: Drill down on DataWarehouse historical report shows incorrect results.
515812 PH29819 Opening a corrupt TDB may exhaust JVM file handles
515687 PH37514 No result on DD on WI Priority="Unassigned"
514799 PH29999 CQPAR00252111: Percentages in pie charts are displayed with inconsistent results
514774 PH28844 CQPAR00251724: Typo in property key for AppConfig REST API endpoint
514294 PH28524 DCC uncontrolled thread growth
514282 PH28602 CQPAR00254224: LQE Excel Export shows Rich Text formatting tags in the primary text fields
513142 PH28086 CQPAR00251386: Node statistics displays message "An error occurred while attempting to load statistics for the selected node"
512030 PH36128 [jazz.net] No DD data on Calculated Column (SUM of Story Complexity)
511973 PH27685 Configure Backups page in JTS Setup says "Lifecycle Query Engine" even for LDX
511653 PH27601 CQPAR00251233: Fix potential NPE in ReportDefinitionBean
510752 PH26953 CQPAR00250989: Drill down show all work items instead of the expected subset.
510709 PH26922 CQPAR00250982: Change in Custom Expression is not persistent in ELM 7.0
510387 PH27522 CQPAR00251198: No logging information when the a report is deleted
509986 PH30845 CQPAR00252415: Report validation error pops up for Advanced reports with custom SQL
509364 Internal EWM 7.0 upgrade creates 2 JRS jena indices after Liberty restart
508153 PH37315 DD on Calc Column (COUNT) limited by attr always works as if IS operator is selected
507379 PH25603 <query> res Triples with invalid subject URIs added in advanced reports
506401 PH25211 CQPAR00250369: JRS/LQE/CCM : Sub-iteration showing under the wrong parent iteration in LQE based Reports
503662 PH24300 CQPAR00249990: A stacked bar chart shows an empty space in the beginning and end of the bars when there are 100+ bars.
500850 PH27383 CQPAR00251145: Use optional clause for attributes in Calculated Columns
499916 PH31225 Cannot multiselect a parent value and a child value in a LQE enumeration condition
498108 PH21494 CQPAR00248838: Browser back button displays blank page when clicked from JRS report page
495062 PH21339 CQPAR00248259: No DD results on combined column of Enum attributes with same label but different URIs
470970 PH05758 CQPAR00241046: Timestamp attributes in JRS reports are are not showing in the client locale
556348 PH44241 7.0.2 regression caused by backport: Report Builder has an issue matching - Address slow SPARQL query in RM->CCM links (548347) [7.0.2 Maintenance] (549234)
554598 Internal Log4j2 : Lqe and Ldx version not change to 702 SR1 in JTS Registered Applications
554554 Internal Log4j2 : Error "The RS upgrade failed at step 0"
552347 Internal iFix readme.txt doesn't contain instructions for DCC application (repotools-dcc -clean)
536539 Internal Broken link validity report when displaying more than one validity status
524412 Internal Save issues with traceability reports
519844 Internal LQE <ITA>: translation updates not integrated
519637 Internal Dialog to add notification recipient does not use Carbon style
519426 Internal Fix compilation warnings in the 10-22 build: LQE 7.0.2 LQE_7.0.2-I20201022-1708
519420 Internal Report Builder UI hangs when compactURLService fails.
518924 Internal Clarity needed in KC article for link validity permissions in LQE
518696 Internal Configurations relationship labels are unclear in RB traceability path
518681 Internal RMM Architecture Element Link Large Preview Display Window issue
518665 Internal Applications failed to register on Registration Page.
518652 Internal <EL702 TVT:PLK:075.010.010> One string for title and button
518592 Internal RS log file shows OAuth error
518564 Internal Query getting configuration name should be cached in RB similar to the report query .
518259 Internal Axis labels are not consistent when comma is added in the name of the column
518240 Internal Trend report created through "Build a trend report" learning tutorial throws an error while saving it
518190 Internal Getting exception "CRLQE1337E The query did not run" in ldx.log for DNG in SVT environment.
518127 Internal Columns are editable even after combining them
518106 Internal New folder created from move or copy dialog is not displayed in RB when the dialog is cancelled
518102 Internal Folder icon disappears when the folder name is lengthy
518101 Internal Refresh action does not work when the folder is closed
517748 Internal Lines display data past the current date when shown on a bar graph.
517448 Internal No owner info when the last Report Manager is removed
517367 Internal EN Strings - 100.020.072, 100.020.081, 100.020.130
517345 Internal Bar value shows less then drilldown on bar
517207 Internal ELM702: English tooltip displayed in 'Choose an artifact' section
517189 Internal LQE is continuously repeating failed attempts to fetch an ACL, flooding the logs
517145 Internal Graph section does not load with a console error
516923 Internal Date Scale calculation values revert to 'Sum' when 'Refresh' button is clicked
516767 Internal Unable to DD on Custom Trend for WI's
516674 Internal "Formatting and Graphing" tour of Build a Trend report get stuck in the beginning, and a grey screen is displayed.
516525 Internal Improve metamodel refresh operation with hashmap in formatTreename method
516435 Internal Pause indexing and resume indexing are always available at the same time; one should be greyed out based on state
516407 Internal Restore process performs all DB actions as a single set of transactions
516406 Internal When performing a restore of a backed up index/database, there is no feedback to the user.
516388 Internal Data Completeness Check documentation errors
516319 Internal Misleading current status "Reindex data source failed" displayed when previous data source failed
516104 Internal Data source status incorrectly shows all skipped resources as being from most recent update
515956 Internal LQE Upgrade Fails with CRLQE0697E An error occurred perform an upgrade. java.lang.IllegalArgumentException: title can not be null or empty
515890 Internal DD on Bar of a enum value(Priority=High) gives all results.
515591 Internal Error message icon is missing from Data Source Details when there's an error fetching ACL
515574 Internal Evaluating oslc_config:selects predicates in a query when both subject and object are known still fetches the whole selection
515557 Internal LQE shows one additional skipped resources for every ETM artifact retry
515500 Internal Format of Add Color dialog is inconsistent
515306 Internal Report Builder, and therefore Report viewlets, do not save configuration settings.
515174 Internal Hovertext in report results need an explicit way to close them
514921 Internal No logging information when the last Report Manager is removed
514880 Internal Error message when there are problems fetching a tool's access context list is unclear
514841 Internal Custom Trends for WIs: No DD data on calc column limited by relative date operators
514637 Internal Base indexing throws NPE if a base member is not a resource URI
514515 Internal Add All Data Sources button does not check for missing process feeds when some are present
514397 Internal While adding Owner condition in the Conditions dialog, half text of sentence from top, not visible completely.
514242 Internal Typo in LQE's "Datasets initializing" msg: Indexing will beging when all the datasets have initialized.
514210 Internal SQL errors when generating DW reports after upgrading souldev to the final approved 7.0.2 M2 build
514175 Internal Report builder error in browser console
514006 Internal RB/LQE results shows Resolve but the actual status is Done
513992 Internal com.ibm.team.integration.lqe.lib.httpclient.ssl.SslSocketFactory needs to default to TLS1.2
513991 Internal Report Builder's warning header should use singular terminology when there is only 1 item in a group
513972 Internal The height for 'Add condition' button is too small in 'Refine container content'
513944 Internal Save issues with traceability reports
513940 Internal Count total number of artifacts is not working as expected for Filed Against attribute
513515 Internal Creating a folder with special characters breaks the parent folder and I can't delete it
513410 Internal JRS and LQE upgrade fails : Trying to Upgrade from build ELM702-I20200722-0130 to build ELM702-I20200804-0052
513334 Internal After deleting a report, it continues showing in the report list until a manual refresh of the application is done.
513324 Internal DD report ignores DD filter on default columns combined with URL
513321 Internal Wrong result on Calc Column, Count Limited by TimeSpent
513181 Internal Defects with test cases (LQE config-aware) report name needs to be corrected
513087 Internal GC components that contain the ampersand sign in their name, it does not display correctly from Report Builder, instead it shows: &amp;
513074 Internal Offline compaction is creating two copies of the nquad dump file
513030 Internal Graph does not show the bar for "No Set Value" correctly.
513026 Internal Graph with date line for future date using "days/Months/year later" option does not work
512919 Internal Refreshing live XL gives wrong dateTime value neither of client or server time zone
512917 Internal No DD data for Count Column limited by multiple tags
512846 Internal Both LQE and LDX log data source operations to lqe-audit.log
512821 Internal Server rename is failing for "rs" using Build ELM702-I20200726-1639
512740 Internal With "Fill in gaps with zero value", future dates should not be graphed
512664 Internal If a property of a resource has different name in different project area, for some cases in qm it is showing only default name
512654 Internal Can not create a condition on a subtree
512579 Internal Archiving config-scoped data source does not remove it from RB Reports view or data source selection menu
512571 Internal can't change selected config for config-scoped data source /type filter
512565 Internal Changes to fix the default port usage error in apache jena arq jar were overlaid and need to be added again
512503 Internal "Group by data source" is triggered when first tag in the explorer view is clicked
512378 Internal Drilldown on custom trend reports is sometimes empty
512368 Internal No DD data with different browser & server timezone
512140 Internal dcc upgrade fails if JAVA_HOME is set to java7
512074 Internal History reports with multiple values for a day, do not show last value
511984 Internal On graphs, lines with zero value do not show
511953 Internal Can not re-enter "DB2ADMIN Password" when connecting to Data Source
511775 Internal ReportBuilder should use instanceShape instead of dcterms:type
511706 Internal LQE-Based Report - Wrong date format and language for Date-Picker within Filter Selection
511673 Internal LQE picks different merge shape URI for SCM file that is not recognized by Report Builder
511591 Internal False alarm : Incomplete report because of limit set in JRS because of "X-LQE-Result-Modified" LQE resp header
511569 Internal Help Contents are missing from RB
511373 Internal [Pipeline] LQE calculated column counting by URL for a work item fails
511274 Internal Issue setting filters on reporting dashboard widgets - no horizontal scroll enabled
510793 Internal LQE trends: Test Case metrics are labeled inconsistently
510385 Internal Using SUM function in a custom expression for SPARQL does not give expected results
510367 Internal <ul> formating lost in incomplete report warning when LQE tracing enabled
510336 Internal LQE metrics task should not show non-enabled RM project area in configuration list
510121 Internal On query statistics page, actions for running and blocked queries have a weird background
510103 Internal After updating dialog implementation, warning dialog when showing internal properties can not be accepted
510037 Internal Work items showing up in results but should not be, based on Conditions
510024 Internal Drilldown not working for first and last entries in a Custom Trend report
509916 Internal Adding a valid external URI to a category resource in ETM makes the category to not show up in Report builder
509622 Internal LQE should revisit use of setFetchSize
509326 Internal Buttons on LQE query page are not using Carbon style
509160 Internal Pie chart displays more than 49 legends
509125 Internal Health Monitoring -> Queries page does not dynamically resize with browser window
509117 Internal Query statistics UI is cramped and confusing if there are no completed queries to graph
508989 Internal Link validity query format from Report Builder performs poorly
508585 Internal The behavior of query result caching has changed in 7.0.1.
508556 Internal FF only: Requirement tooltip is missing a space, says "Statement ofneed" and should be "Statement of need"
508519 Internal Cursor pointer changes on the Bar Graph even when Drilldown is not allowed.
508432 Internal Learning Tours get stuck
508095 Internal Button is still active after "Data Source" is saved
508061 Internal Hovertip gets cut off in French
507833 Internal Getting error message at format result page while duplicating the report
507544 Internal No hover with count and X axis label for "Unassigned" bar
506923 Internal Goal line end one day too soon on the graph
505919 Internal Calculated Column values are blank when drilled down in the reports which has combined attribute column name
505851 Internal resizing information is not getting saved properly while resizing the table column.
505412 Internal Buttons get displaced onto separate lines by long breadcrumb
504751 Internal Multiple filter lines for the same condition in generated SPARQL when filtered on an property of the merged artifact
503694 Internal LQE Query Execution Details Page is cutting off results.
503136 Internal Missing date on the x-axis of a graph
497888 Internal need to clearly define what does and doesn't work after you edit advanced query
489640 Internal Refreshing Lifecycle Query Engine scoped by configuration may show success, but no refresh is performed
486162 Internal JRS response to SPARQL query execution failure should return actual error codes and relevant message
477891 Internal Editing a previously saved report does not show selected checkbox for chosen hierarchical enumeration value
466394 Internal Busy icon spins indefinitely intermittently