I've got an odd conundrum. I'm working on a data file that is a shell of sorts. Its goal is to migrate data from our old database structure to our new one. I've written a script that I *should* be able to perform on the server and have it work. It works great on my client. However, when I fire it on the server it's not working. Here's what I'm doing:
• Gathering a list of record IDs to be migrated
• Sending that list to a server-side script that creates a found set with those IDs
• Run my migration script with the context of step 2.
When I perform the script steps normally it works. When I run the script in step 2 as a Perform Script on Server step it fails. What I'm discovering is my relationships don't get setup when the file opens for the FMSE session on the server. If I log the RelationInfo ( ) function from the server, it comes up with <File Missing> references. I think this is due to some permissions issue but I'm not certain. The user accounts I'm using are identical across the files that I need access to.
Is there a trick to this? Thanks!