Sybase Adapter Environment Varible MERC_TEMPDB

[jwjoiner]

I am a Sybase dba on a project using Mercator to move data between two companies. I have worked with the Mercator admin to setup the Environment Varible MERC_TEMPDB = merc_tempdb on the Windows 200 host machine.

I have created a Sybase db merc_tempdb and have given the mercator user "Create Procedure Rights" in this database, as described in the Chapter 1 of the Sybase Adapter reference guide.

The merc admin only restarted the Mercator server, not the Windows 2000 host machine. We have tested the Mercator maps and found that some maps find the MERC_TEMPDB=merc_tempdb environment varible and successfully create temporary stored procedures in the merc_tempdb database.

Other maps fail. This is happening on the same Mercator server and host. The failed maps report that the varible MERC_TEMPDB is not set and defaults to creating procs in the Sybase sever tempdb database. The mercator user does not have rights to do this so, the map fails.

Can anyone provide an explaination for why some maps pick up the environment varible and others do not?

Any help in get this working for all maps is greatly appreciated. Thanks.

 

[janhes]

You would be better off using the Mercator Resource Registry for holding variables.

 

[BocaBurger]

What version of Event Server are you using? Did you create the variable as a user or system variable? This could be set up as both to make sure all can see it.
You may need to reboot the OS, sometimes setting environment variables needs a reboot. Not sure why, ask MS.

Resource Registry can't be used for OS environment variables or settings.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[jwjoiner]

I was told by Mercator Administrator that the version is 6.7.

The environment variable was created at the system level. We will add the variable at the user level to see if this makes a difference.

We will have to wait for the Mercator Administrator to return on Monday before attempting a restart of the host server.