Originally posted by: SystemAdmin

Having problems calling the resource registry variables from within the event server, it doesn't happen often, but when it does can be quite "interesting", has anybody else encountered this? Is this a known bug in 7.5.1? Is there a patch out for it?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: john.gibby

Can you detail how you are trying to use the RR alias. RR aliases can only be used in certain places in formulas.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Yeah, values can not be passed in run maps and some other place maybe, but if you went to pass :

ECHOIN(1, %TEST%), it wouldn't work. Other then that, if it's working sometimes, it should work all the time. Are the varibles in the same mrn, the ones working and not working, or different mrns?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

yes as a matter of fact it is in a put statement like this
=IF(COUNT(REJECT(Row:Group:File_In)) > 0,
PUT("EMAIL","-PR INET -SVR ProductionOutlookServer -FROM svc_datastage@anyoldemail.com -TO JaneDoe@anyoldemail.com -CC JonDoe@anyoldemail.com -SUB Errors_%Servername% -TEXT",PACKAGE(Error_Message)))

the "%Servername%" doesn't work for this command sometimes.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: john.gibby

I always put single quotes around the email arguments such as protocol, server, etc. Also, when you use RR Aliases, you need for them to be in their own double quotes as I did below.

Try this:

=IF(COUNT(REJECT(Row:Group:File_In)) > 0,PUT("EMAIL","-PR 'INET' -SVR 'ProductionOutlookServer' -FROM 'svc_datastage@anyoldemail.com' -TO 'JaneDoe@anyoldemail.com' -CC 'JonDoe@anyoldemail.com' -SUB 'Errors_" + "%Servername%" + "'",PACKAGE(Error_Message)))

John
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

This statement works for me.

PUT ( "EMAIL" , " -PR INET -SVR '%EMAIL_SERVER%' -TO rpanzer@ups.com -FROM '%EMAIL_FROM%' -SUB '%EMAIL_CROSSREF_ENV_PREFIX% US Monitor - Email CrossReference Record Invalid ' -TRACE emailCR.mtr
EMAIL_CROSSREF_ENV_PREFIX is whether DEV, Mirror, Or production, is where the email came from.

Using them in a PUT is not what I meant, I meant passing the value to a run map.

If it works sometimes or not sometimes off the same server defined in the mrc, I have no idea. If it's from different servers, then it's either in the setup for that server, whether it's pointing to the incorrect mrn value through the mrc, or the actual data in the resource registry mrn varible has something for the virtual server it's working for that the same varible doesn't have for the virturl server it's not working for.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

whoops

Message was edited by: rep
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I don't know if it will help you but this problem may append when you link several .mrn file with one .mrc file and when you use the same alias name in this linked .mrn file.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Thanks, the Quotes worked!! I think I am good for now..

-Steve Brock
sabrock@transfermations.com
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks, the Quotes worked!! I think I am good for now..

-Steve Brock
sabrock@transfermations.com
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Thanks, the Quotes worked!! I think I am good for now..

-Steve Brock
sabrock@transfermations.com
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

Understanding that your issue is resolved I thought I'd add some info for future debugging RR issues.

Typical issues are:

1. what you found above, syntax.
2. you can't use registry values to represent data.
3. registry values can only represent a path of some sort. But may include security info for logging in etc...
4. in some instances a registry value for a path may not work. I've had problems with them executing DBLOOKUPs (for example dblookup("select x from y where z is true", " -mdq "+ "%rr_value%" + " -dn dnname") as well as certain other commands. Executing a run or put command with a path registry value typically works great though.
5. something is missing in your .mrc configuration. you might be missing a reference to your resource file for either the Event Server, Command Server and/or Global.
6. in windows, in the case of a registry value as an input/output not working right, you may not have restarted the windows services after the last mrc or mrn file change.

jvanboga

PS: It would be nice if we could use a registry value for a log and trace file paths as well as type tree paths.

Message was edited by: jvanboga
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange