LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rbonneux

Hello, i have another error while trying to automate (cron) my graphs that i cannot figure out.

I have to use mulitpl Brds as an input to my graph.
I first use a parameter to distinguish which files i need.
node:Filter_Files_by_Date_Range_and_Version
bretype:core::Filter
editor:Label=Filter Files by Date Range and Version
editor:sortkey=4d4ad7312994480d_2
input:@40fd2c74167f1ca2/data=Extract_File_Name__Date.40fd2c7420761db6
output:@40fd2c7420761db6/data=
inclock:/=Extract_File_Name__Date
prop:Script=<<EOX
{{^VariableExpr^}}

emit
*
where
fileDate >= beginDate
and
fileDate <= endDate


EOX
prop:VariableExpr=<<EOX
beginDate = "{{^Begin_Date_Range^}}".date("CCYY-MM-DD")
endDate = "{{^End_Date_Range^}}".date("CCYY-MM-DD")
fileDate = 'FileDate'

EOX
editor:XY=200,220
editor:propdef=VariableExpr|brainscript|1||None
end:Filter_Files_by_Date_Range_and_Version


I then use a mulitple BRD node, to get those files.

node:Join_History_BRDs
bretype:core::Multiple BRD Files
editor:Label=Join History BRDs
editor:sortkey=4d4ad7312a922b24_2
input:@40fd2c7405e716f4/data=Filter_Files_by_Date_Range_and_Version.40fd2c 7420761db6
output:@40fd2c74028104af/dout=
inclock:/=Filter_Files_by_Date_Range_and_Version
prop:ConcatenationMode=union
prop:Filename=<<EOX
'FileNamePath'
EOX
editor:XY=280,160
end:Join_History_BRDs

When i cron this everything works fine to this point. I've tried to use a CAT, filter and outputs. everyone fails with the same message, so i thought its the input node.

Node Started 11/03/2011 11:36:50 Environment:brain@localhost:7721

Error 11/03/2011 11:36:50 ERROR opening i/o streams:nPremature EOF trying to read header line
Error 11/03/2011 11:36:50 Error while starting execution of node 'Data+Due+Date+Scorecard.Output+BRD+File'n caused by: Error executing node: Process exited before ENDIO message received.

any ideas or help would be great

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

rbonneux,

This may be a situation better handled by Support. But before going that route, it would help if you could perhaps post (as attachments) some examples of the BRD files you are trying to join. Enough to reproduce the problem would be advisable. If there is not an obvious reason, I recommend you contact the support line.

Can each of these BRD files be loaded on their own without any problems? If you run the BRG version in BRE does it work, but fails when run by cron on the server?

Regards,
Timon Koufopoulos
MDA Support.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rbonneux

Hi Tim, I can open the BRD's independently, I can also run the graph as a brx - if i add a node for each brd (concatenating them).

Its when I use the Multiple BRD File Node that i get the error.

Thanks Ryan

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

rbonneux,

Then we really need to see some of the data you are trying to put together as I noted. If any combo of the brd files cause a problem, then just a few rows from 2 which can cause the problem will do.

-Timon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jodycrutchfield

Try using a directory list to read the files, then submitting them to a multiple brd node. I have used this in the past.

Jody