Error: "Unabled to parse database url jdbc:oracle:thin" When Importing Microsoft Project XML Into Primavera P6 Professional (Doc ID 1207554.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Symptoms

The following error is observed in the XML import file when attempting to import a Microsoft Project XML file into Project Management:

Unabled to parse database url jdbc:oracle:thin
com.primavera.PhoenixException: Unabled to parse database url jdbc:oracle:thin:@(DESCRIPTION=(SDU=<port>)(ADDRESS=(COMMUNITY=<community>)(PROTOCOL=TCP)(Host=<host>)(Port=1521))(CONNECT_DATA=(SID=<sid>)(GLOBAL_NAME=<global name>)))
at com.primavera.infr.admin.MetaCfg.getMetaJDBCDriver(MetaCfg.java)
at com.primavera.infr.admin.CfgAccessMgr.<init>(CfgAccessMgr.java)
at com.primavera.integration.app.importexport.ImportExportAction.do(Unknown Source)
at com.primavera.integration.app.importexport.ImportExportAction.init(Unknown Source)
at com.primavera.integration.app.importexport.ImportExportMain.main(Unknown Source)
Original Exception:
java.sql.SQLException: Unsupported url format: jdbc:oracle:thin:@(DESCRIPTION=(SDU=<port>)(ADDRESS=(COMMUNITY=<community>)(PROTOCOL=TCP)(Host=<host>)(Port=1521))(CONNECT_DATA=(SID=<sid>)(GLOBAL_NAME=<global name>)))
at com.primavera.common.db.DatabaseURLParser.<init>(DatabaseURLParser.java)
...

Cause

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