Subject:err:XPST0005 - Error at line 92, column 81. Static error. The static type of step 'child::agent-name' is empty-sequence(). Author:Tony Serva Date:12 Dec 2007 01:21 PM
I get this error for this node:
<agent>
<agent-name>
{collection("CBHarper.dbo.vListings_Trulia_Export")/vListings_Trulia_Export/agent-name/text()}
</agent-name>
<agent-phone>
{collection("CBHarper.dbo.vListings_Trulia_Export")/vListings_Trulia_Export/agent-phone/text()}
</agent-phone>
<agent-email>
{collection("CBHarper.dbo.vListings_Trulia_Export")/vListings_Trulia_Export/agent-email/text()}
</agent-email>
<agent-picture-url>
{collection("CBHarper.dbo.vListings_Trulia_Export")/vListings_Trulia_Export/agent-picture-url/text()}
</agent-picture-url>
</agent>
If I remove the offending link (agent-name), then it errors out on the next one (agent-phone).
Any ideas?
I am probably misunderstanding the meaning of the error but there is data in those fields.
Subject:err:XPST0005 - Error at line 92, column 81. Static error. The static type of step 'child::agent-name' is empty-sequence(). Author:Tony Serva Date:12 Dec 2007 01:26 PM
IF it helps here are the details:
com.ddtek.xquery3.XQQueryException: [DataDirect][XQuery][err:XPST0005]Error at line 92, column 81. Static error. The static type of step 'child::agent-name' is empty-sequence().
at com.ddtek.xquery3.xqj.Util.XQQueryException(Util.java:376)
at com.ddtek.xquery3.xqj.Util.XQException(Util.java:250)
at com.ddtek.xquery3.xqj.layer.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:606)
at com.ddtek.xquery3.xqj.layer.DDXQExpression._executeQuery(DDXQExpression.java:99)
at com.ddtek.xquery3.xqj.layer.DDXQExpression.executeQuery(DDXQExpression.java:117)
Caused by: com.ddtek.xquery.typing.TypeVisitor$TypeVisitorException: [XPST000501][DataDirect][XQuery][err:XPST0005]Static error. The static type of step 'child::agent-name' is empty-sequence().
at com.ddtek.xquery.typing.TypeVisitor.createException(TypeVisitor.java:4526)
at com.ddtek.xquery.typing.TypeVisitor.resolveStep(TypeVisitor.java:4618)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:1181)
at com.ddtek.xquery.expr.AxisStep.accept(AxisStep.java:325)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:3465)
at com.ddtek.xquery.expr.PathExpr.accept(PathExpr.java:108)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:309)
at com.ddtek.xquery.expr.DefaultExpressionList.accept(DefaultExpressionList.java:376)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:284)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:2061)
at com.ddtek.xquery.expr.DirElemConstructor.accept(DirElemConstructor.java:188)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:309)
at com.ddtek.xquery.expr.DefaultExpressionList.accept(DefaultExpressionList.java:376)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:284)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:2061)
at com.ddtek.xquery.expr.DirElemConstructor.accept(DirElemConstructor.java:188)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:309)
at com.ddtek.xquery.expr.DefaultExpressionList.accept(DefaultExpressionList.java:376)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:284)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:2061)
at com.ddtek.xquery.expr.DirElemConstructor.accept(DirElemConstructor.java:188)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:309)
at com.ddtek.xquery.expr.DefaultExpressionList.accept(DefaultExpressionList.java:376)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:284)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:2061)
at com.ddtek.xquery.expr.DirElemConstructor.accept(DirElemConstructor.java:188)
at com.ddtek.xquery.expr.AllExpressionVisitor.visit(AllExpressionVisitor.java:455)
at com.ddtek.xquery.typing.TypeVisitor.visit(TypeVisitor.java:3113)
at com.ddtek.xquery.expr.MainModule.accept(MainModule.java:57)
at com.ddtek.xquery.typing.TypeVisitor.typeExpression(TypeVisitor.java:570)
at com.ddtek.xquery.mediator.ContextFactory$MediatorTypeVisitor.typeExpression(ContextFactory.java:515)
at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:197)
at com.ddtek.xquery3.xqj.layer.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:597)
Subject:err:XPST0005 - Error at line 92, column 81. Static error. The static type of step 'child::agent-name' is empty-sequence(). Author:(Deleted User) Date:14 Dec 2007 07:40 AM
Hi Tony,
thank you for the screenshot; however, the only thing that looked suspicious (i.e. the source being fetched was a database view) seems to be working in our tests. Can you tell us which database are you using? Can you retrieve the SQL statement used to build the view?
Subject:err:XPST0005 - Error at line 92, column 81. Static error. The static type of step 'child::agent-name' is empty-sequence(). Author:Minollo I. Date:12 Dec 2007 02:51 PM
The error would suggest that the columns you are trying to fetch are not correctly specified; can you attach, or email us at stylus-field-report@progress.com, a screenshot of the XQuery editor, including the expanded connection tree in the right panel describing the structure of the vListings_Trulia_Export table?