Content Is Not Allowed In Prolog

I have gotten this error many times, and most of the time the issue comes from some accidental leading characters in the XML request to MDM.  However today, while migrating from one database to a brand new one, I got the error.  However, I validated my XML was clean.

Here is what the debug log:







From the logs, you can see that the configuration piece is not working (messages like getConfigItem: Item Name /IBM/DWLCommonServices/MultiTimeZoneDeployment/enabled cannot be found!).  It turns out when I did my export/import of the configuration tables from the old database (APPSOFTWARE, CONFIGELEMENT, APPDEPLOYMENT), the LOB(s) in APPSOFTWARE did not come in.

I used the .del format in my original import and changed to use .ixf

C:\CONFIGDATA>db2 export to appsoftware.ixf of ixf lobfile lob1 select * from ap
psoftware
SQL3104N  The Export utility is beginning to export data to file
"appsoftware.ixf".

SQL3105N  The Export utility has finished exporting "1" rows.


Number of rows exported: 1

{{CONNECT TO THE NEW DATABASE}}

C:\CONFIGDATA>db2 import from appsoftware.ixf of ixf insert into appsoftwar
SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date
"20120717", and time "121406".

SQL3153N  The T record in the PC/IXF file has name "appsoftware.ixf",
qualifier "", and source "            ".

SQL3109N  The utility is beginning to load data from file "appsoftware.ixf"

SQL3110N  The utility has completed processing.  "1" rows were read from th
input file.

SQL3221W  ...Begin COMMIT WORK. Input Record Count = "1".

SQL3222W  ...COMMIT of any database changes was successful.

SQL3149N  "1" rows were processed from the input file.  "1" rows were
successfully inserted into the table.  "0" rows were rejected.


Number of rows read         = 1
Number of rows skipped      = 0
Number of rows inserted     = 1
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 1
--------------

Note, I had to delete configelement & appinstance before adding these rows, then add them back due to foreign key dependencies.

Things seem to work fine now.