DSXchange

If you don't use it anywhere, especially in your tnsnames.ora file, then there shouldn't be any impact.

##W TBLD 000000 12:04:51(003) <main_program> Error when checking composite operator: Output from subprocess: /C=/Program: not found Looks like a 'long Windows pathname with spaces in it' issue to me. Change your APT configuration variables - everywhere you used "C:\Program Files" make it ...

Either that or 'Test' the routine in the UAT project (so it creates the hashed file and VOC pointer if it doesn't already exist) and then you can copy just the SDKSequences file over the top of the one it creates.

I thought mine was pretty cogent, given what I had to work with.

A "fixed width file" means each record is exactly the same number of characters long and each field is always the same size, even when "empty". Use "char" fields and make sure you populate them appropriately - as in all spaces for the ones with no data.

No, there's no log file that I've ever seen. Sometimes your SysAdmins may have usage logs for the server in general, including (perhaps) disk usage, they might be able to help. When you do the reindex, make sure you read all of the advice posted here. You will need to make sure you have exclusive ac...

So... is the dimension table empty or does it not exist? Confused about the discrepency between the text in your message and your subject.

So... any idea how it was corrupted? Space (as in lack of) issues? Did you try to do a "reindex" of that project, either from the DS.TOOLS menu or using DS.REINDEX ALL from the TCL prompt?

Suggest you pursue this with your official support provider.

Investigate the use of the Field() function.

You could always try using the substring operators - the square brackets - like so:

DSLink149.INTFC_FILE_CATG[1,4]

It's explained in the manuals. Somewhere.

Post the actual errors.

:evil: Argh, sometimes our whole workaround/resolved system makes me crazy. It shouldn't but it does. This is one of those times. This is not a "workaround", meaning your topic is "not resolved" and you had to go out of your way and do something crazy to get to your end point. Th...

Nex time, just clarify your question in your original post rather than starting over with a new one. :? In my experience, a 'large' file was somewhere in the vicinity of 300MB, anything much more than that would cause the job to fall over dead. As I said in the other thread, 'depends', as each syste...