| Author |
Message
|
| NeTsSs |
 Posted: Mon Nov 05, 2007 11:21 am Post subject: Troubles with FileOutput Node |
 |
|
Newbie
Joined: 30 Oct 2007
Posts: 6
|
Hi all,
i have the next trouble
first begin with:
Queue ->FileProxyNode -> Compute ->FileOutputNode
------- Compute -------
SET Environment.Registros[]=(SELECT * FROM Database.GAHR_FOTOS);
DECLARE x INTEGER 1;
DECLARE TOTAL INTEGER CARDINALITY(Environment.Registros[]);
SET Environment.Total = TOTAL;
SET OutputLocalEnvironment.Variables.MBFEProperties.Encoding = 546;
SET OutputLocalEnvironment.Variables.MBFEProperties.CodedCharSetId = 819;
WHILE x <= TOTAL DO
SET OutputLocalEnvironment.Variables.MBFEProperties.FileId = 'i20'|| CAST(x AS CHARACTER);
SET OutputLocalEnvironment.Variables.MBFEProperties.FileName = TRIM(Environment.Registros[x].COD_PERSONAL)||'.JPG';
SET OutputLocalEnvironment.Variables.MBFEProperties.FileExtension = 'JPG';
SET OutputRoot.BLOB.BLOB = Environment.Registros[x].FOTO;
SET OutputLocalEnvironment.Variables.MBFEProperties.action = 'close';
SET OutputLocalEnvironment.Variables.MBFEProperties.FileSize = LENGTH(OutputRoot.BLOB.BLOB);
PROPAGATE TO LABEL 'LBL.FOTO' DELETE NONE;
SET x = x + 1;
END WHILE;
-------------------------------------------------------------------------------
Well go around and under my flow if it spreads to label the number of times, I just generate a single image.
There is a property that I miss specify? |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Nov 05, 2007 11:40 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi NeTsSs,
Just a hunch, but I think your issue might just be related to this.
If not, can you please paste us the traces that you are taking during the flow.
Regards. |
|
| Back to top |
|
|
| NeTsSs |
| Posted: Mon Nov 05, 2007 12:17 pm Post subject: |
|
|
Newbie
Joined: 30 Oct 2007
Posts: 6
|
ok, First
FileOutputNode Properties
Format: Datatype - Text
RecordType - Variable Record Length
End of Record- Native
Advanced: Destination Mode - Output Directory
Disposition - Generate New File
New file name - Add counter before file extension.
I set points, because if I put the whole blob completely distorts the page
| Quote: |
========================================
Root Inicial = (
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2007-11-05 19:48:00.060'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'GH.APP.TIMERI20.RES.01'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51205742524b514d202020202020a21f2f4720001802'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRKQM '
(0x03000000):UserIdentifier = 'db2admin '
(0x03000000):AccountingToken = X'16010515000000231897d1044010bd8516aa9b1404000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'I\6.0\bin\DataFlowEngine.exe'
(0x03000000):PutDate = DATE '2007-11-05'
(0x03000000):PutTime = GMTTIME '19:48:00.060'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000010):XML = (
(0x01000000):CardFive = (
(0x01000000):TimeRequest = (
(0x01000000):Identifier = (
(0x02000000): = 'Id20'
)
(0x01000000):Action = (
(0x02000000): = 'SET'
)
(0x01000000):StartTime = (
(0x02000000): = '14:48:00'
)
(0x01000000):IgnoreMissed = (
(0x02000000): = 'FALSE'
)
(0x01000000):AllowOverwrite = (
(0x02000000): = 'TRUE'
)
)
)
)
)
========================================
========================================
Root Final = (
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2007-11-05 19:48:00.060'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'GH.APP.TIMERI20.RES.01'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51205742524b514d202020202020a21f2f4720001802'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRKQM '
(0x03000000):UserIdentifier = 'db2admin '
(0x03000000):AccountingToken = X'16010515000000231897d1044010bd8516aa9b1404000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'I\6.0\bin\DataFlowEngine.exe'
(0x03000000):PutDate = DATE '2007-11-05'
(0x03000000):PutTime = GMTTIME '19:48:00.060'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):BLOB = (
(0x03000000):BLOB = X'ffd8ffe00...'
)
)
Env = (
(0x01000000):Registros = (
(0x03000000):COD_PERSONAL = '00129961 '
(0x03000000):FOTO = X'ffd8ffe0...'
)
(0x01000000):Registros = (
(0x03000000):COD_PERSONAL = '00129962 '
(0x03000000):FOTO = X'ffd8ff...'
)
(0x03000000):Total = 2
)
Local Env = (
(0x01000000):Variables = (
(0x01000000):MBFEProperties = (
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 819
(0x03000000):FileId = 'i201'
(0x03000000):FileName = '00129961.JPG'
(0x03000000):FileExtension = 'JPG'
(0x03000000):action = 'close'
(0x03000000):FileSize = 1693
)
)
)
========================================
========================================
Root Final = (
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2007-11-05 19:48:00.060'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'GH.APP.TIMERI20.RES.01'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51205742524b514d202020202020a21f2f4720001802'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRKQM '
(0x03000000):UserIdentifier = 'db2admin '
(0x03000000):AccountingToken = X'16010515000000231897d1044010bd8516aa9b1404000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'I\6.0\bin\DataFlowEngine.exe'
(0x03000000):PutDate = DATE '2007-11-05'
(0x03000000):PutTime = GMTTIME '19:48:00.060'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):BLOB = (
(0x03000000):BLOB = X'ffd8ffe00....'
)
)
Env = (
(0x01000000):Registros = (
(0x03000000):COD_PERSONAL = '00129961 '
(0x03000000):FOTO = X'ffd8ffe00...'
)
(0x01000000):Registros = (
(0x03000000):COD_PERSONAL = '00129962 '
(0x03000000):FOTO = X'ffd8ffe0001....'
)
(0x03000000):Total = 2
)
Local Env = (
(0x01000000):Variables = (
(0x01000000):MBFEProperties = (
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 819
(0x03000000):FileId = 'i202'
(0x03000000):FileName = '00129962.JPG'
(0x03000000):FileExtension = 'JPG'
(0x03000000):action = 'close'
(0x03000000):FileSize = 1693
)
)
)
======================================== |
|
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon Nov 05, 2007 1:13 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Netsss,
Have you looked at the link shown by Elvis?
This will involve putting another file proxy node before your file output.
If yes, please tell us if this fixes your problem.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| NeTsSs |
| Posted: Mon Nov 05, 2007 1:44 pm Post subject: |
|
|
Newbie
Joined: 30 Oct 2007
Posts: 6
|
shalabh1976 thx,
Put a proxy at the end and settlement
Thanks, all
At the while seems to propagate generates journaling |
|
| Back to top |
|
|
| gecs |
| Posted: Thu Nov 15, 2007 8:56 am Post subject: say it! |
|
|
Acolyte
Joined: 14 Nov 2007
Posts: 58
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 15, 2007 9:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
|
| Back to top |
|
|
| gecs |
| Posted: Thu Dec 27, 2007 2:42 pm Post subject: say it!!! |
|
|
Acolyte
Joined: 14 Nov 2007
Posts: 58
|
| [moderator]deleted post for inflammatory content[/moderator] |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Dec 28, 2007 1:22 am Post subject: for every output file the message should |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
pass through a SYNC node.
The suggestions made above to put the SYNC node after the compute node should solve your problem.
I ran into all sorts of problems when I tried to do it the way you have described.
One further point, If you want to do anything complicated in your error handling, make a copy the whole of the input message into the Environment BEFORE you get to the sync node. This way, you can be sure of having a clean message for error processing. We can get 2-3 messages a day (out of 500,000) failing in the FileOutput process. The error handler puts a clean copy of the message onto the BOQ. A manual process send them through the flow again and so far (in 11 months) every one has been processed without problem.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
