Something is re-writing SPFILES

[SQLWilts]

Hi guys,
I am not getting an answer from the people who are supposed to give us support, so I thought I would ask here.

I am trying to create a setup system for our helpdesk so that they can build (and rebuild) a number of Goldmine undocked laptops - with a lot of customisation.

For some reason, during the install process, the Goldmine installer adds a database called "upgrade1". I do not know where it gets this from, but this is in addition to the correct one. This happens on all of the installers that I create.

No problems, as part of the install process, I create an OSQL package that corrects the file code (DIRCODE) in SPFILES and removes the erroneous entry.

And this is where the mystery starts. On my PC (Windows XP SP2) this works like a dream. On the Vista laptops, it re-writes the "upgrade1" entry. Odd, I thought, so I ran a trace just to make sure that it was Goldmine and not Windows somewhere. Sure as eggs are eggs, there are 3 lines looking for U_DIRPATH = another installs DIRPATH, and if it doesnt find it, it inserts it to SPFILES.

I have created a sproc to search all tables in the DB looking for "upgrade1" and "GOLDMINE" and the only place it exists is in the SPFILES.

Please help - I'm going round the twist here!

BTW, this is a completely fresh install - no shared system tables

thanks

 

[SQLWilts]

Sussed it:

There was an entry in the gm.ini that was looking for the incorrect database and DBalias. Gawd knows where it got it from, but as soon as I altered that, it worked fine.