Triggered work objects -- assignment node not working correctly

 0 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
ThomasT
Advanced Member
Posts: 27
Advanced Member
    I have a pflow which has a simple node to a work object (which calls a second pflow).

    Within the second pflow there is a query. Query is name Query9100. Here's the query:

    PROD=&FILE=REQLINE&FIELD=COMPANY;LINE-NBR;REQ-NUMBER&SELECT=COMPANY=<!--COMPANY-->%26REQ-NUMBER=<!--REQ_NUMBER-->&OUT=CSV&DELIM=~

    Within the query loop there's a simple assignment node:

    linenumber = Query9100_LINE_NBR

    Should be simple thing, I believe.Works on all other flows I've worked on but maybe not workobjects...

    Anyways when the 1st pflow runs, it calls the work object. The log file of the second work unit (the work object) has an error log. Within it, there is the error on the assignment:

    ErrorLog in Process : ReqLineAction_V19 Workunit : 1044, ActivityType=ASSGN, ActivityName=Assign4680, ActivityId=ASSGN3 Date:12/07/2010 Time:13:31:26
    Exception while evaluating expression: linenumber = Query9100_LINE_NBR;
    ReferenceError: "Query9100_LINE_NBR" is not defined. (threadScript#1)

    I have reviewed the flow, rebuilt the query and the assignment a few times, refreshed the pflow, ... pretty much everything. I did not type anything in, I used point and click on the assignment. The global variable 'linenumber' has already been defined. And this still does not work. It is somehow not working with this assignment of  Querry9100_LINE_NBR. (it says Query9100_LINE_NBR" is not defined) And I can't figure out why... unless there's another way to do the assignment? Or is there a patch??

    Does anyone know why this would not work? Ideas? I am stumped.