MS Project XML Import Fails With "Error happened in the Import/Export Project Service", "java.lang.NullPointerException" In the P6WebAccess.html File (Doc ID 2910361.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Symptoms

When attempting to import a specific Microsoft Project XML file, via P6 Professional or P6Web, the import fails with the following log errors:

ERROR IN XML_Import_Log:

SEVERE: DBEngine.executeSelect() error while executing: {select 1 from dual where exists (select 1 from projshar, usession, task where projshar.access_level>1 and task.proj_id = projshar.proj_id and projshar.session_id = usession.session_id and ((((task.task_id>=XXXXXX) and (task.task_id<=XXXXXX)) or ((task.task_id>=XXXXXX) and (task.task_id<=XXXXXX)) or (task.task_id in (XXXXXX, XXXXXX)))) and usession.user_id <> XX)}
--IO Error: Socket read timed out
com.primavera.integration.client.xml.xmlimporter.XMLImporterException: DBEngine.executeSelect() error while executing: {select 1 from dual where exists (select 1 from projshar, usession, task where projshar.access_level>1 and task.proj_id = projshar.proj_id and projshar.session_id = usession.session_id and ((((task.task_id>=XXXXXX) and (task.task_id<=XXXXXX)) or ((task.task_id>=XXXXXX) and (task.task_id<=XXXXXX)) or (task.task_id in (XXXXXX, XXXXXX)))) and usession.user_id <> XX)}
--IO Error: Socket read timed out
at com.primavera.integration.client.xml.xmlimporter.persistence.PersistenceProviderImpl.persist(PersistenceProviderImpl.java:132)
at com.primavera.integration.client.xml.xmlimporter.handler.DefaultProcessor.importObject(DefaultProcessor.java:1057)
-
ERROR IN P6WEBACCESS.HTML:

PrmThread-294 ERROR com.primavera.guiservices.impexp.ImportExportServiceImpl Error happened in the Import/Export Project Service
java.lang.NullPointerException
  at com.primavera.guiservices.impexp.ImportExportServiceImpl.a(ImportExportServiceImpl.java:2946)
  at com.primavera.guiservices.impexp.ImportExportServiceImpl.b(ImportExportServiceImpl.java:2476)
  at com.primavera.guiservices.impexp.ImportExportServiceImpl.doImport(ImportExportServiceImpl.java:472)
  at com.primavera.guiservices.impexp.ImportExportWorker.execute(ImportExportWorker.java:22)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
  at java.lang.Thread.run(Thread.java:748)

STEPS

The issue can be reproduced at will with the following steps:
1. Attempt to import a specific Microsoft Project XML file via P6 Professional or P6Web.
2. Observe the reported errors in the logs.

Cause

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