Pages

Wednesday, July 23, 2014

DAC task synchronization failed with the error Whitespace required

Issue: DAC task synchronization failed with the error "Whitespace required"

 Today when I synchronized the task in DAC, it got failed with below error. 

MESSAGE:::oracle.xml.parser.v2.XMLParseException: Whitespace required.
EXCEPTION CLASS::: com.siebel.etl.gui.core.MetaDataIllegalStateException

com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parse(Infa7WfXmlDomParser.java:97)
com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parseAll(Infa7WfXmlDomParser.java:79)
com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parseAll(Infa7WfXmlDomParser.java:75)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:158)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:145)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)
com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)
java.lang.Thread.run(Unknown Source)

::: CAUSE :::
MESSAGE:::Whitespace required.
EXCEPTION CLASS::: oracle.xml.parser.v2.XMLParseException

oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:323)
oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:376)
oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:226)
oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:155)
javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parse(Infa7WfXmlDomParser.java:91)
com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parseAll(Infa7WfXmlDomParser.java:79)
com.siebel.analytics.etl.infa.fileParsing.Infa7WfXmlDomParser.parseAll(Infa7WfXmlDomParser.java:75)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:158)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:145)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)
com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

Did some investigation to resolve the issue. Verified the "Task name", "Command for Full load" and "Incremental load for naming"...etc.

And finally got some clues to resolve the issue.

Solution: Remove the escape characters from the description of the objects( Either in folder,mapping or session...etc objects description).


If you see the workflow xml, description field values in not parsing correctly because of the " (extra double quotes".


 So you just make sure the description column should not contain any special characters and escape characters.

CHEERS :)


No comments:

Post a Comment