Integration

Get Involved. Join the Conversation.

Topic

    Cesar Tepetla Corte
    consult database table and repeat a determined process for...Answered
    Topic posted March 28, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, API, Case Management, Cloud, Connection, Database, Events, Integration, Mapping, Orchestration, Process 
    64 Views, 1 Comment
    Title:
    consult database table and repeat a determined process for each value obtained from a specific field of the table.
    Summary:
    consult database table and repeat a determined process for each value obtained from a specific field of the table.
    Content:

    Hi everyone,

    I am working on a requirement in which I must obtain a record of a table and for each record to generate a file, I am currently working only with the name field I try to recover all the names of the table and for each one to generate a .txt file where print that name but I get an error:

    "XPath query string returns multiple nodes. The assign activity part and query $messagecontext_30.parameters/../nsmpr2:HomeDirectoryCollection/nsmpr2:HomeDirectory/nsmpr2:fname are returning multiple nodes. The assign activity part and query named in the error message returned multiple nodes. It should return single node. According to BPEL4WS specification 1.1 section 14.3, the assign activity part and query named in the error message should not return multiple nodes. Verify the part and xpath query named in the error message at line number 932 in the BPEL source."

    Best Comment

    Hemanth Lakkaraju

    Fair enough I think. The HomeDirectory must be a repeating element and hence fname returns multiple values. Can you try using for loop iterating through each HomeDirectory and then use assign to read fname for the current element in the loop?

    Comment