Unable to Download Data Templates With XDOLoader: java.lang.NullPointerException (Doc ID 428956.1)

Last updated on JUNE 24, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.5 to 11.5 [Release 11.5]
BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.0 to 11.5.10.2
Checked for relevance on 07-DEC-2013


Symptoms

The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publisher database tables. It also allows Data Templates to be downloaded using e.g. the following command:

$ java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps \

-DB_PASSWORD apps -JDBC_CONNECTION pbreugel.be.oracle.com:10200:vispb01 \

-LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME FND -LOB_CODE PB10000 \

-LOG_FILE download.log -LANGUAGE 00 -TERRITORY 00 -DEBUG TRUE

This process does not download the Data Template successfully. The download.log log file will show the following errors:

XDOLoader started: Thu Apr 26 14:28:03 CEST 2007





Parameters passed to XDOLoader...

[TERRITORY] [00]

[LOG_FILE] [download.log]

[APPS_SHORT_NAME] [FND]

[DB_USERNAME] [apps]

[LOB_TYPE] [DATA_TEMPLATE]

[LOB_CODE] [PB10000]

[LANGUAGE] [00]

[JDBC_CONNECTION] [pbreugel.be.oracle.com:10200:vispb01]

[DB_PASSWORD] [apps]

[DOWNLOAD] [DOWNLOAD]

[DEBUG] [TRUE]



Exiting validateProperties()...

Entering initAppsContext()...

Registering Oracle JDBC driver...

Creating Oracle JDBC connection...

USE_APPS_CONTEXT is set to false. AppsContext won't be initialized...

Exiting initAppsContext()...

Entering resolveProperties()...

Resolving OWNER_ID. Calling OAHelper.getOwnerId()...

Exiting resolveProperties()...

Entering process()...

Entering processDownload()...

Start downloading...

Entering saveDownloadFiles()...

Downloading files from XDO_LOBS: SELECT FILE_DATA, LOB_CODE, LOB_TYPE, APPLICATION_SHORT_NAME, FILE_NAME, LANGUAGE, TERRITORY, XDO_FILE_TYPE FROM XDO_LOBS WHERE LOB_CODE in  (:LOB_CODE )  AND APPLICATION_SHORT_NAME = :APPS_SHORT_NAME  AND LOB_TYPE = :LOB_TYPE  AND LANGUAGE = :LANGUAGE  AND TERRITORY = :TERRITORY 

Downloading a file from repository: PB10000.xml

Done downloading a file: PB10000.xml

Adding OA Headers to the downloaded file: PB10000.xml

java.lang.NullPointerException

	at java.io.FilterOutputStream.write(FilterOutputStream.java:80)

	at oracle.apps.xdo.oa.util.XDOLoader.saveDownloadFiles(XDOLoader.java:1641)

	at oracle.apps.xdo.oa.util.XDOLoader.processDownload(XDOLoader.java:1504)

	at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:927)

	at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:436)

A file is created on the file system having the filename of the data template yet the file size is 0 (zero).

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