Running Multiple Instances of Tessitura

Hi Britt,

Check the system table within tessitura TX_MACHINE_LOCATION and make sure the "location" is assigned for machine name which I assume would be TESTHOST.

Normally I just look for the row in TX_MACHINE_LOCATION that has a blank location and assign it.

Thanks Ryan! I didn't see any blank fields, so I just added a new row, then saved my work.

Hmm, well someone else may need to help you out on this since I'm not too familiar with the process but here are a couple things I noticed about my test environment
which I have set to run at the same time as my production.

Local .ini file has different hostname
Ex. here is some of the content of my local file so I can have my test environment

[sqlca]
HOSTNAME=rrowell-ps-tst02
MasterIniFilePath="t:\startup\tessitura_test02_master.ini"

The target in the shortcut properties points to the local file
Ex. here is my target

T:\Startup\Tessitura_test02_Start.bat "c:\windows\system32\tessitura_test02.ini

I believe the process is the same for having two instances of production.
Hope you get it figured out!

Cheers!

Thanks Ryan! I'm set up the same way.

I think the error must be in the way I am configuring the entry in the TX_MACHINE_LOCATION table...

Anybody else have any ideas? :  )

You should be able to fix this problem by editing the tx_machine_location table from another instance of Tessitura accessing the same database.

To do so, open tx_machine_location in System Tables, and on the row with machine name "TESTHOST", choose a location value from the dropdown in the Location column.

Thanks Steven! I guess I don't understand. Administration is my only choice from the Location drop down menu (other than "none").

We only have one location built in the TR_Location table, and that is Administration. I'm relatively new here, so I'm not sure why that decision was made. Every row in the TX_Machine_Location table uses Administration as the location.

That's fine; you can just set it to Administration. That location is part of the default Tessitura setup; basically, this field would be to track the general location of a particular workstation if a site wishes to do so.

We just require that this value be specified, as an additional means of security, in order to allow a particular "host" or machine to run the Tessitura software against a particular database.

Thanks Steven! I set it to Administration initially, since that was my only choice. Still got the error. I feel like there's something simple I'm just missing...   :  )