Recent content by shelts

I'm writing a map (Mercator vsn 6.71) to 'clean' a csv file that is sent with some fields containing commas or CR/LF values (which are the record delimiter and terminator respectively). The fields are surrounded by " marks (good old Excel). After much messing around I've managed to get it...

I found the issue - I had had rule that did a calcualtion on 2 different values, both surrounded by a TEXTTONUMBER() function. This seemed to trigger a bug in Mercator that crashed the map. Chaning it to TONUMBER() fixed the issue.

I don't use version 8.2, but I realise that you can validate the file with an XML schema rather than (alternative to) a type tree - I assume that's what you're doing? 2 ideas on this: 1) Send it back to the client as invalid XML 2) If 1 not an option, use a type tree instead of a schema to...

This problem seems to have surfaced again for a different map. The problem is that sometimes the data will process fine through the map and sometimes the identical data will cause the map to crash. I'm completely unable to replicate the problem locally. I could switch the Workspace settings...

The log file doesn't get beyond the first line, and remains as a .tmp file (as the map has 'crashed' rather than completed in error). I've managed to track the problem down to the input type tree. Adding an <OWSP> to a few of the intiators and terminators (it is an XML type tree) appears to...

Any help much appreciated on this!! I have a map that is crashing with a Windows error (on Windows 2003 Server)on specific data files, but only in the Production environment. The map is being run by the Command Server (command line call from Java), only has file inputs and outputs, and only...

Yeah, I did the GETRESOURCENAME in a previous rule. I also used -T and -AUDIT (also quite helpful), and they basically all showed that the script was being called but the filename not being passed - that was until I added the SYMBOL(34)s to surround the full command line. Anyway, it's working...

I did try using the -INLINE option, but still couldn't get it to pass the filename to the script, although I was using GET rather than PUT.

Thanks Boca. The only thing I've been able to get to work is making sure that the Script and filename being called are surrounded by SYMBOL(34) (quotes). e.g. "-CMD " + SYMBOL(34) + "Script_Name " + file_to_pass + SYMBOL(34)

Anyone know how to pass a filename to a Unix Shell script using the GET("SHL"...) function. The shell script works fine on the command line: >sh Listener_Unzip filename_to_unzip I've tried every command option for the shell adapter, but cannot get it to successfully pass the filename.

Are you using the -SPROTO command in your syntax? This will only work if the security options are installed. Are you specifying a Private Key?

Can you not just point the output card at the database adapter and use -UPDATE to update the table?

jmanj, No offence taken. My team are seperate from the AS400 development people, hence making it difficult to get them to do things. Plus, in a big company, these things sometimes take time. I don't doubt they have the expertise, just the will to do it.

I agree. Unfortunately company politics got involved. Thanks for your help, it may aid me to push them in the future.

The program you have running on your AS400 waiting for the files is exactly how I wanted to do it. Unfortunately the AS400 people didn't want to do this (long story), as it involved them doing some work. I assume this program is constantly polling a certain library?