DSXchange

If I recall correctly, some instance names don't work as expected, I think I had strange issues with instance "000" that would get trunated to an empty string when used in some functions.

Moderator - please delete this duplicate thread, the original is found here

Moderator - please delete this duplicate thread, the original is found here

Sorry, you should just have replaced the derivations with SetNull() but you still need to declare correct datatypes.

Select the columns in the right that you wish to modify, then right-mouse click and one of the options will let you replace derivations; you will enter "SetNull($1)" in the bottom box and -presto- the modifications will get done with just a few keystrokes.

Also, what is the instance name that fails?

In the director job log, right-mouse click on the message you wish to handle and one of the options is, if I recall correctly, "message handler" or something very similar. The documentation also details how to create and use message handlers.

In that case almost certainly something has changed from the iis console with user access rights Have your admin check the users and roles.

Are you certain that your Admin client has the correct version? If you have the CD you might try to reinstall the client software in case the program or associated library might have been overwritten.

What datatype is "field"? Perhaps it is your "if" construct that isn't working. What happens when you explicitly set a bigint(19) to all those 's?

This error relates to the repository storage of metadata that has been introduced at version 8. There isn't that much knowledge on those error "out here" yet. Is this a new installation or have you been able to save/compile jobs before? What has changed between the time it worked and the time it sto...

This looks like a problem with V8, since the error occurs when it attempts to write to the (new) repository. What if you exported jobs only, do those load? I have had issues at V8 with the table metadata definitions so this might be a related issues and limited to table information only.

Hello and welcome to DSXchange, NSIT-DVP-01 a) "pb" is the accepted symbol for the element "lead" but not a word in English. b) What version are you exporting from? c) What error(s) do you get when importing into version 8? d) Can you import single element types (tables, routines, jobs) or does ever...

If you set the variable in the Administrator, then all you need to do in order to access (or modify the default) value is declare it as a parameter to the job.

If the hashed file is being referenced, i.e. read-only with no updates, then by all means run in parallel. Each job referencing this file will have it's own memory copy if the file is designated "pre-load to memory", but there might be some benefit if many jobs are reading the file at the same time ...