Error lastexporttime when publish datasets

19 views
Skip to first unread message

Piano Song Cover

unread,
Jul 17, 2020, 9:53:03 AM7/17/20
to Dataverse Users Community
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

unread,
Jul 17, 2020, 10:48:28 AM7/17/20
to dataverse...@googlegroups.com
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.


--
Reply all
Reply to author
Forward
0 new messages