My Oracle Support Banner

P6 EPPM XML Import Service Fails with Error "Text: Mismatched UDF data type. ColumnType: 3 ExpectedType: 0" When Using A Non-English P6 Setup (Doc ID 2604672.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.10.0 to 17.12.14.0 [Release 17.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.12.10.0 to 17.12.14.0 [Release 17.12]
Information in this document applies to any platform.

Symptoms

When attempting to import a Microsoft XML into P6 configured for a language other than English (Example: German) regional settings with a import template created in the other language (Example: German), import fails the following error occurs in the log file.

ERROR

SEVERE:
Errors located:
Text: Mismatched UDF data type. ColumnType: 3 ExpectedType: 0
com.primavera.integration.client.xml.xmlimporter.XMLImporterException:
Errors located:
Text: Mismatched UDF data type. ColumnType: 3 ExpectedType: 0
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.persist(PersistenceProviderImpl.java:131)
at com.primavera.integration.client.xml.xmlimporter.handler.DefaultProcessor.importObject(DefaultProcessor.java:1009)
at com.primavera.integration.client.xml.xmlimporter.ImportWorker.a(ImportWorker.java:1052)
at com.primavera.integration.client.xml.xmlimporter.ImportWorker.a(ImportWorker.java:309)
at com.primavera.integration.client.xml.xmlimporter.ImportWorker.a(ImportWorker.java:220)
at com.primavera.integration.client.xml.xmlimporter.ImportWorker.createNewProject(ImportWorker.java:104)
at com.primavera.integration.client.xml.xmlimporter.XMLImporter.createNewProject(XMLImporter.java:559)
at com.primavera.guiservices.impexp.ImportExportServiceImpl.b(ImportExportServiceImpl.java:2242)
at com.primavera.guiservices.impexp.ImportExportServiceImpl.doImport(ImportExportServiceImpl.java:432)
at com.primavera.guiservices.impexp.ImportExportWorker.execute(ImportExportWorker.java:17)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.primavera.bo.base.BOFieldException:
Errors located:
Text: Mismatched UDF data type. ColumnType: 3 ExpectedType: 0
at com.primavera.bo.base.BOFieldException.addFieldError(BOFieldException.java:264)
at com.primavera.bo.rules.update.UserDefinedFieldValueUE.performFieldValidationRow(UserDefinedFieldValueUE.java:356)
at com.primavera.bo.base.UpdateEngineImpl.performFieldValidationRow(UpdateEngineImpl.java:1070)
at com.primavera.bo.base.CreateEngineImpl.create(CreateEngineImpl.java:178)
at com.primavera.bo.base.CreateEngineImpl.createBatch(CreateEngineImpl.java:131)
at com.primavera.bo.remotable.ReqMgr.createObjectsWithWbsContext(ReqMgr.java:939)
at com.primavera.bo.remotable.ReqMgr.createObjects(ReqMgr.java:717)
at com.primavera.bo.remotable.qproxy.ReqMgr.createObjects(ReqMgr.java:600)
at com.primavera.bo.DBReqMgr.createObjects(DBReqMgr.java:149)
at com.primavera.integration.server.mediator.BusinessObjectMediator.create(BusinessObjectMediator.java:218)
at com.primavera.integration.server.ServerFacadeBOMgr.create(ServerFacadeBOMgr.java:286)
at com.primavera.integration.server.ServerFacade.create(ServerFacade.java:21)
at com.primavera.integration.client.LocalSession.a(LocalSession.java:353)
at com.primavera.integration.client.BOBase.a(BOBase.java:368)
at com.primavera.integration.client.BOHelperBase.a(BOHelperBase.java:46)
at com.primavera.integration.client.bo.helper.UDFValueHelper.a(UDFValueHelper.java:376)
at com.primavera.integration.client.bo.BOHelperImpl.create(BOHelperImpl.java:2291)
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.a(PersistenceProviderImpl.java:236)
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.b(PersistenceProviderImpl.java:333)
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.a(PersistenceProviderImpl.java:144)
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.persist(PersistenceProviderImpl.java:123)
... 11 more
Original Exception:

STEPS

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

  1. On an environment where the locale is set to another language (Example: German), sign into P6 with the language set to the same as the locale.
  2. Go File > Import > Microsoft XML.
  3. Navigate to the location of the XML file.
  4. Create a new import template and use it to import.
  5. Notice that import fails and the reported error shows in the log file.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.