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 ...
                    • Why does Analytics plus import less number of tickets from Servicedesk Plus?

                      While integrating Servicedesk Plus with Analytics Plus, only few rows/tickets are imported into Analytics Plus, while the Servicedesk Plus actually has more number of tickets. The primary reason for this behavior is that the date chosen to ...