DSXchange

Hi,

I am sorry to say that i am still dealing with this issue.

Regards,

John Fitz

Hi, I am running a job which writes the results of an sql query to a tab delimited .txt file. The file is then imported into a MS Access DB. When i run the job with the file name set to A.txt, it all works fine. I want to add the date to the file title to avoid overwritting the file (this is a daily...

Hi, Not sure if this means anything but just in case .... When i am clearing out the outstanding PID's, there is always one that once you clear all the remaining ones remove themselves. With this last issue the PID that did this was the following: APT_CombinedOperatorController,4: APT_PMPlayer: new ...

Hi, So the jobs failed again. Again the fail has occurred on the KCARD job, however when i check the PID of the remaining osh.exe processess against the listings in the logs, most of the PIDs refer to the previous xml job - Transaction. The transaction job has finished with the following log entries...

ArndW

Will do, i'll come back with the details after the next fail.

Regards,

John FItz

Hi, Still struggling with this, i am posting the log entries from the latest job failure in the hope it might mean something to someone. As always, i appreciate any helo you might be able to offer. Thanks, John Fitz Starting Job NK_Card_XML. WJF_Parameters = (As pre-defined) WJF_Parameters.$MQQNameT...

Hi, I have four levels of job. The high level is a very simple loop which call a sequence job, this job in turn calls a number of process jobs in a strict order. Each of these process jobs move a nujmber of text files to a particular folder, call an xml job to read these input files and finally move...

Hi, I have a number of jobs running in a loop for quite a while at this stage. In recent days they have started to hang regularly, but never consistently on the same job. The job starts as normal and the first few lines in the log look perfectly normal. then nothing! The only way I can restart the l...

Hi, I am sorry to say that i found nothing definitive so i just went back through DB connections passwords, server connections and passwords etc. Somewhere in there something must have been amiss, after a bit of pulling and dragging the jobs sorted themselves and have been running fine since. I am s...

Thanks for coming back to me.
That is more efficient in that it would save me the use of the filter stage.

Thanks for the suggestion.

Regards,

John Fitz

Hi, i created a seperate job to preprocess the file. read each record in as 1 field. pass the data through a transformer to isolate the first 2 characters, then use this new field in a filter stage to identify headers and trailers (might be processing multiple input files) finally write data records...

Morning, Thanks to all for the responses. To answer a few of queries raised: 1. the header is marked with HR in the first 2 characters & the trailer is marked with TR 2. i have tried to read it as a single field but the read is rejecting all the data records Is it possible to turn off all the wa...

Hi, There are many topics out there which almost answer my question, but none which actually do. Hopefully someone willbe good enough to give me a hand. I have a job that process a number of files on each run. the job currently starts with a sequential file read by file pattern. each file consists o...

That sounds like what i need to be doing.

Thanks.

Craig, the data is required to be placed in a further CDATA[] tag.eg <CARD_HOLDER_NAME><![CDATA[MS B NIC GIOLLA PHADRAIG]]></CARD_HOLDER_NAME> this is a third party requirement that i have no control over. the net effect of such a tag is to tell the parser to treat it's contents as text and not xml,...