Description:
When trying to filter for a timesheet in a prior or current time period, a "System Error. Contact system administrator." error is thrown.
Solution:
Make sure the NLS_DATE_FORMAT is set to "YYYY-MM-DD HH24:MI:SS"
How-to:
- Run the following SQL queries against your Databases:
select 1 as id, parameter, value from nls_database_parameters
where parameter = 'NLS_DATE_FORMAT'
union
select 2 as id, parameter, value from nls_instance_parameters
where parameter = 'NLS_DATE_FORMAT'
union
select 3 as id, parameter, value from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
- Log as sysdba and then run this query:
alter system set nls_date_format="yyyy-mm-dd hh24:mi:ss" scope=spfile;
- Restart Oracle Services.
For SQL Database:
The Clarity administration account must be added to the SQLAgentUserRole role (Microsoft SQL Server) in order to use the "SQL Server Agent" in Microsoft SQL Server 2005. Users added to the role will have the same SQL Server Agent experience as they had in SQL Server 2000. These users can create jobs and manage only jobs that they created. The SQL Server Enterprise Manager tool can be used to add the Clarity administrator to the SQLAgentUser Role role by using the following steps:
Here are the steps:
- Login as 'sa' user
- Open SQL Server 2005 Management Console
- Open the Security folder
- Open Logins folder
- Right click on user SQLSERVER2005SQLAGENTUSER
- Select Properties
- Select User Mapping
- Check Map box for MSDB Database
- Confirm that the roles db_owner and public are checked
- Right click on the Clarity schema owner, for example "niku"
- Select Properties
- Select User Mapping
- Check Map box for MSDB Database
- Confirm that the roles db_owner and public are checked
- Click OK to save changes
Keywords: CLARITYKB, how-to, configuration.