hp-support-head-portlet
Actions
- ${title}
hp-contact-secondary-navigation-portlet
Actions
- ${title}
hp-share-print-widget-portlet
Actions
- ${title}
hp-concentra-wrapper-portlet
Actions
- ${title}
HP Access Control Job Accounting - SQL Query mode does not display years later than 2020
Learn about an issue involving missing years in the Database Manager for HP Access Control when running a query in parameterized mode.
SQL Query mode does not have years later than 2020
Follow these steps to learn about and solve the issue.
Issue
When running a query in parameterized mode using the SQL Query mode option in HP Access Control Database Manager or SQL Management Studio, the last year available for selection is 2020, and years 2021 and later are not available for selection.
Solution
Run the following script(s) in Database Manager or SQL Management Studio.
-
Login into Database manager using Windows or SQL credentials.
-
Select SQL query mode from the Database menu.
-
Copy and run the script to modify the dates.
-
Use HPACJA -
Update T_DefaultValue set lab_Value = '2010-01-01 00:00:00' where lab_Name = 'DEF_DATE_START' -
Update T_DefaultValue set lab_Value = '2030-12-31 23:59:59' where lab_Name = 'DEF_DATE_END'
-
-
Wait for the Results pane to display the status 2 row(s) affected.
-
Select Disconnect from the Database menu to log off from Database manager.
hp-feedback-input-portlet
Actions
- ${title}
hp-feedback-banner-portlet
Actions
- ${title}
hp-country-locator-portlet
Actions
- ${title}
Canada
hp-detect-load-my-device-portlet
Actions
- ${title}
hp-hero-support-search
Actions
- ${title}
