Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Upgrade script fails for oracledate at generateDDL step



User is trying to upgrade Pega 7.1.5 to 7.1.6 using the upgrade script bundled in Pega 7.1.6 full package (not the upgrade package). Upon triggering the upgrade script, they observe an error during the DDL generation step.

Error Messages

Error generating ddl for oracledate, RULES
Problem running XPath expression (//* except //pega:routineGroup[@filter='udf']/*) intersect (//pega:table[tokenize(@schematype, ',')[.='data']] | //pega:privilege[tokenize(@schematype, ',')[.='data']] | //pega:viewGroup[tokenize(@schematype, ',')[.='data']]/* | //pega:routineGroup[tokenize(@schematype, ',')[.='data']]/* | //pega:trigger[tokenize(ancestor::pega:table/@schematype, ',')[.='data']] | //pega:index[tokenize(ancestor::pega:table/@schematype, ',')[.='data']]| //pega:dataUpdateGroup[tokenize(@schematype, ',')[.='data']]/* ) on the DOM.Original Message: null Problem running XPath expression (//* except //pega:routineGroup[@filter='udf']/*) intersect (//pega:table[tokenize(@schematype, ',')[.='data']] | //pega:privilege[tokenize(@schematype, ',')[.='data']] | //pega:viewGroup[tokenize(@schematype, ',')[.='data']]/* | //pega:routineGroup[tokenize(@schematype, ',')[.='data']]/* | //pega:trigger[tokenize(ancestor::pega:table/@schematype, ',')[.='data']] | //pega:index[tokenize(ancestor::pega:table/@schematype, ',')[.='data']]| //pega:dataUpdateGroup[tokenize(@schematype, ',')[.='data']]/* ) on the DOM.Original Message: null
at Source)
at Source)
at Source)
at Source)
at Source)
Caused by: javax.xml.xpath.XPathExpressionException
at org.apache.xpath.jaxp.XPathImpl.evaluate(
... 7 more
Caused by: javax.xml.transform.TransformerException: Expected ), but found: except
at org.apache.xpath.compiler.XPathParser.error(
at org.apache.xpath.compiler.XPathParser.consumeExpected(
at org.apache.xpath.compiler.XPathParser.PrimaryExpr(
at org.apache.xpath.compiler.XPathParser.FilterExpr(
at org.apache.xpath.compiler.XPathParser.PathExpr(
at org.apache.xpath.compiler.XPathParser.UnionExpr(
at org.apache.xpath.compiler.XPathParser.UnaryExpr(
at org.apache.xpath.compiler.XPathParser.MultiplicativeExpr(
at org.apache.xpath.compiler.XPathParser.AdditiveExpr(
at org.apache.xpath.compiler.XPathParser.RelationalExpr(
at org.apache.xpath.compiler.XPathParser.EqualityExpr(
at org.apache.xpath.compiler.XPathParser.AndExpr(
at org.apache.xpath.compiler.XPathParser.OrExpr(
at org.apache.xpath.compiler.XPathParser.Expr(
at org.apache.xpath.compiler.XPathParser.initXPath(
at org.apache.xpath.XPath.<init>(
at org.apache.xpath.XPath.<init>(
at org.apache.xpath.jaxp.XPathImpl.eval(
at org.apache.xpath.jaxp.XPathImpl.evaluate(
... 7 more

Steps to Reproduce


Root Cause

The root cause of this problem is because the upgrade script picked up the incorrect version of XPathImpl. The upgrade script needs XPathImpl that is bundled in Saxon library, but it was picking up Xalan libraries (xalan jar and serializer jar) instead as they have been put to the JVM's endorsed folder.


The issue is resolved by making the following change to the PRPC operating system: temporarily remove the xalan jars from endorsed folder when doing the generate ddl step.

Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us