Error lastexporttime when publish datasets

[Piano Song Cover]

Hi, im upgraded to dataverse 4.20, but now when i try to publish datasets, it will remain error in server.log as below :

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: "Fri Jul 17 20:29:35 WIB 2020"
  Position: 35
Error Code: 0
Call: UPDATE Dataset SET lastExportTime='Fri Jul 17 20:29:35 WIB 2020' WHERE id=42864
Query: DataModifyQuery(sql="UPDATE Dataset SET lastExportTime='Fri Jul 17 20:29:35 WIB 2020' WHERE id=42864")
    at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1611)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:898)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
    at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
    at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:271)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:251)
    at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
    at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
    at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1751)
    at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:298)
    ... 122 more

i try to describe my Dataset table as follow :

dvndb=> \d Dataset;
                          Table "public.dataset"
             Column              |            Type             | Modifiers
---------------------------------+-----------------------------+-----------
 id                              | bigint                      | not null
 fileaccessrequest               | boolean                     |
 harvestidentifier               | character varying(255)      |
 lastexporttime                  | timestamp without time zone |
 citationdatedatasetfieldtype_id | bigint                      |
 harvestingclient_id             | bigint                      |
 guestbook_id                    | bigint                      |
 thumbnailfile_id                | bigint                      |
 usegenericthumbnail             | boolean                     |
Indexes:
    "dataset_pkey" PRIMARY KEY, btree (id)
    "index_dataset_guestbook_id" btree (guestbook_id)
    "index_dataset_thumbnailfile_id" btree (thumbnailfile_id)
Foreign-key constraints:
    "fk_dataset_citationdatedatasetfieldtype_id" FOREIGN KEY (citationdatedatasetfieldtype_id) REFERENCES datasetfieldtype(id)
    "fk_dataset_guestbook_id" FOREIGN KEY (guestbook_id) REFERENCES guestbook(id)
    "fk_dataset_harvestingclient_id" FOREIGN KEY (harvestingclient_id) REFERENCES harvestingclient(id)
    "fk_dataset_id" FOREIGN KEY (id) REFERENCES dvobject(id)
    "fk_dataset_thumbnailfile_id" FOREIGN KEY (thumbnailfile_id) REFERENCES dvobject(id)

lastexporttime is timestamp without timezone, but the application trying to store timestamp with timezone, how can i deal with this? Thankyou

[Philip Durbin]

This sounds like a bug to me. Can you please create a new issue at https://github.com/IQSS/dataverse/issues and copy all of this great detail into it?

Thanks,

Phil

--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/a1398fc7-8551-4903-90d3-df1d174ac22eo%40googlegroups.com.

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin