Reports With Date Values Return Error "Operand Type Clash: Datetimeoffset is Incompatible With Int" When Connecting To SQL DB 2008 And Higher (Doc ID 2217262.1)

Last updated on JANUARY 12, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run reports that contain date parameters, connected to a SQL Server 2008 or higher database, the following error occurs.

ERRORS:
On Screen:
Errors have been encountered while running the report. To resolve, contact your administrator.

P6 Web Log:
Dec-22-2016 09:37:49 877, EST [ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 25 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper12gr1LWF ?:? oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/P6Reports/Project/Weekly Schedule Performance.xdo] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Operand type clash: datetimeoffset is incompatible with int
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/P6Reports/Project/Weekly Schedule Performance.xdo] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Operand type clash: datetimeoffset is incompatible with int

STEPS:
The issue can be reproduced at will with the following steps:

  1. From P6, run a report that contains a date parameter selection
  2. View the P6 Web Access log

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms