The date for any columns is set to 01 Jan 1970 01:00:00.000000

The date for any columns is set to 01 Jan 1970 01:00:00.000000

Issue:
The date columns are filled with 01 Jan 1970 01:00:00.000000 instead of being empty.

Root Cause:
ServiceDesk Upgrade did not handle it

Solution:

Add the entry " ZOHO_UPDATE_NULL_FOR_NEGATIVEVALUE=true" in <SDP_HOME>\zreports\uploadtool\conf\common_params.conf

Hit re-sync button.

Note: ServiceDesk Plus restart not necessary.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Steps to import approval date

                        We can fetch the approval date data from ServiceDesk Plus using the following workaround. Below are the steps to be followed to successfully import the data. Step 1: Click Import data within the ServiceDesk Plus database in Analytics Plus. Step 2: ...
                      • Date format wrongly set in A+ DB

                        To correct date format in A+ Database Find the ID for the table       https://localhost:8443/ZROPQueryTool.cc       select * from zdbdbobject where displayname like 'table name or column name' Connect to psql \AnalyticsPlus\pgsql\bin>psql.exe -h ...
                      • How to add/view current date in a dashboard

                        1. Click on "Edit Design" in a dashboard 2. Choose Add Text and select edit HTML( refer attached screenshot) 3. Watch this video to see how you can do it. Video link: https://youtu.be/hcaTPUuM9PE Clock ...
                      • Query to Fetch Inactive Columns from a Workspace

                        Requirement: Customer wanted to determine the number of used or unused columns in a workspace. Solution: To achieve this, we need to connect to the Analytics Plus database by using local database import method (PostgrSQL) and then use the custom ...
                      • Query to Fetch Warranty Details from Endpoint Central

                        Requirement: The requirement is to fetch warranty expiry details of managed machines from Endpoint Central into Analytics Plus using a custom query through local database import. This enables users to track warranty coverage, identify machines ...