Ok. Thank´s for helping us, Mr. @RonAgresta ... View more

Thank´s Ron,   I´ve turned on advanced "DAC" logging (TRACE) and can´t find any explicit reason for the problem. So, now we are mantaining contacts with our DBA for monitoring that long-running queries.  ... View more

Thank´s Ron. Reading about "Update Macros" on the Admin Guide, we found this procedure below: " Update Macros for Process Services, Batch Jobs, and Profile Jobs For real-time process services, batch jobs, and profile jobs, all of which are executed by separate instances of the DFWFPROC process: 1. In the Data Management Servers tree in Studio, select a server by name. 2. Right-click on the server name and select Unload idle processes from the dropdown menu. Unloading idle processes also updates macros for all subsequent instances of the DFWFPROC process. " The question is if unloading idle processes will stop (or interrupt) the running jobs. ... View more

There are lots of ways using the expression language to dynamically respond to changing columns from the node above the expression node but I don't think you'll be able to turn a variable value into a column name on the fly. If you haven't seen reviewed the Expression Language Guide yet, you may find suggestions there.   Ron ... View more