MessageBuilder returning undefined

Sort:
You are not authorized to post a reply.
Author
Messages
Ward Mitchell
Veteran Member
Posts: 81
Veteran Member
    Friends,

    I have been working on a process flow that pulls some info out of CBTRANS and puts some key fields in csv format that are then saved into a csv file via a FileAccess object.

    Everything works well except the most important part, the data showing up.

    I have a DME query that executes and is returning data, but when it gets to the MessageBuilder, the MessageBuilder does not show the values. In the log below you cna see the data but when you open the csv file, all cells say undefined.

    I am a beginner at process flows but have built a few now and feel pretty good about things. Just trying to understand why this is the case.

    So I need to know how do I get the actual data values back. Let me know what you may need outside of the log and the csv file (attached as a txt since csv cannot be uploaded) that is being generated, and I will try my best to post that to get this little issue resolved! Thanks in advance and hope this is not too much of a noob-ie question!:D

    +++


    Starting Execution of Activities .....
    currentDate = Thu Aug 19 2010 11:11:07 GMT-0500 (GMT-05:00)
    custBillData =
    currentMonth = 8
    currentYear = 2010
    currentDay = 19
    requestDateTime = 20100819
    fileNameMonthSection = 08
    currentMonthName = August
    fileExtractSaveFileName = lr08apach.csv
    fileExtractSavePath = C:\Documents and Settings\mitchellw\Desktop\
    fileCSVExtract = C:\Documents and Settings\mitchellw\Desktop\lr08apach.csv


    Executing ProcessQuery Activity CBQuery.....
    Calling host: *********************
    Query string: PROD=tmp&FILE=CBTRANS&INDEX=CBTSET1&KEY=ACH&FIELD=BANK_INST_CODE;DIST_DATE;CASH_CODE&OUT=CSV&DELIM=%2C&MAX=3
    CBQuery_errorCode = 0
    CBQuery_informationCode = 0
    CBQuery_returnMessage = Query completed.
    CBQuery_outputData =
    CBQuery_0_0 = "ACH","01/03/2003","100A"
    CBQuery_0_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    CBQuery_1_0 = "ACH","01/03/2003","100A"
    CBQuery_1_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    CBQuery_2_0 = "ACH","01/03/2003","100A"
    CBQuery_2_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    CBQuery_RECORD_COUNT = 3
    Executing Iteration Start Activity (loop 1 of 3 ).....
    CBQuery_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    Executing FgaVarString Activity MsgBuilder7150.....

    CBQuery_RECORD_COUNT = 3
    Executing Iteration Start Activity (loop 2 of 3 ).....
    CBQuery_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    Executing FgaVarString Activity MsgBuilder7150.....

    CBQuery_RECORD_COUNT = 3
    Executing Iteration Start Activity (loop 3 of 3 ).....
    CBQuery_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
    Executing FgaVarString Activity MsgBuilder7150.....

    RemoveCSVFile_errorCode = 0
    RemoveCSVFile_informationCode = 0
    RemoveCSVFile_returnMessage = File C:\Documents and Settings\mitchellw\Desktop\lr08apach.csv deleted.
    RemoveCSVFile_outputData =
    File C:\Documents and Settings\mitchellw\Desktop\lr08apach.csv deleted.
    CreateCSVFile_errorCode = 0
    CreateCSVFile_informationCode = 0
    CreateCSVFile_returnMessage = 91 bytes written to file C:\Documents and Settings\mitchellw\Desktop\lr08apach.csv
    CreateCSVFile_outputData = undefined,undefined,undefined
    undefined,undefined,undefined
    undefined,undefined,undefined
    91 bytes written to file C:\Documents and Settings\mitchellw\Desktop\lr08apach.csv
    Executing Email Activity Email1980.....

    Executing Stop Activity .....
    Attachments
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      This seems to indicate that you're not referencing your variables correctly from your Query or the variables (being non-persistent) are losing their value before you hit the MsgBuilder. You can try to assign your Query values to actual defined variables and pass those into the MsgBuilder.
      David Williams
      Ward Mitchell
      Veteran Member
      Posts: 81
      Veteran Member
        I tried that David and got the following for just one of my rows:

        Query string: PROD=tmp&FILE=CBTRANS&INDEX=CBTSET1&KEY=ACH&FIELD=BANK_INST_CODE;DIST_DATE;CASH_CODE&OUT=CSV&DELIM=%2C&MAX=3
        CBQuery_errorCode = 0
        CBQuery_informationCode = 0
        CBQuery_returnMessage = Query completed.
        CBQuery_outputData =
        CBQuery_0_0 = "ACH","01/03/2003","100A"
        CBQuery_0_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
        CBQuery_1_0 = "ACH","01/03/2003","100A"
        CBQuery_1_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
        CBQuery_2_0 = "ACH","01/03/2003","100A"
        CBQuery_2_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
        CBQuery_RECORD_COUNT = 3
        Executing Iteration Start Activity (loop 1 of 3 ).....
        CBQuery_BANK_INST_CODE,DIST_DATE,CASH_CODE = "ACH","01/03/2003","100A"
        Exception while evaluating expression: dataColumn1 = CBQuery_BANK_INST_CODE;
        "CBQuery_BANK_INST_CODE" is not defined.
        Exception while evaluating expression: dataColumn2 = CBQuery_DIST_DATE;
        "CBQuery_DIST_DATE" is not defined.
        Exception while evaluating expression: dataColumn3 = CBQuery_CASH_CODE;
        "CBQuery_CASH_CODE" is not defined.

        It is finding data but for some reason, even assigning it to variables, does not work. Any more ideas?
        David Williams
        Veteran Member
        Posts: 1127
        Veteran Member
          Please send me your flow file. David@ConsultDavidW.com
          David Williams
          David Williams
          Veteran Member
          Posts: 1127
          Veteran Member
            Stupid question - are you including the angle brackets in your variable reference? // <!VARIABLE>
            David Williams
            Ward Mitchell
            Veteran Member
            Posts: 81
            Veteran Member
              I sent you the file.
              David Williams
              Veteran Member
              Posts: 1127
              Veteran Member
                I'm glad I was able to help.
                David Williams
                Ward Mitchell
                Veteran Member
                Posts: 81
                Veteran Member
                  [quote]
                  Posted By ConsultDavidW on 08/19/2010 12:22 PM
                  I'm glad I was able to help. <img src='https://www.lawsonguru.com/DesktopModules/ActiveForums/themes/lawsonguru//emoticons/smile.gif' align="absmiddle" border="0" />
                  [/quote]

                  Yes, thank you very much for your help! It always pays to have a second set of eyes! :)
                  You are not authorized to post a reply.