Search found 24 matches

by drmccue
Wed Mar 19, 2008 2:54 pm
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

remote session next

I don't understand why these queries are all returning no data. I'll need to be able to see what's happening. Please send an email to support@sourcegear.com with your email, your phone number, and reference this forum post: http://support.sourcegear.com/viewtopic.php?t=9826 Also, please include time...
by drmccue
Tue Mar 18, 2008 2:02 pm
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

Sorry, I was out sick yesterday. A remote session will be the next step after running this query. If this does not yield useful results, I'll need to see your database. Until then, please run this query and post the results: USE [sgvault] GO select CU.TABLE_NAME, CU.CONSTRAINT_NAME, CU.COLUMN_NAME, ...
by drmccue
Fri Mar 14, 2008 3:14 pm
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

New approach

Here's what we know: 1 - There are no foreign keys defined for tblcheckoutlistitems. 2 - When you tried to create the foreign keys I instructed you to create, we received a conflict error, which implies that the foreign key named in the conflict does exist. Since the conflict is not on any foreign k...
by drmccue
Thu Mar 13, 2008 12:39 pm
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

OK, something's not right here. EITHER that foreign key exists, in which case it should show up in the query that we sent which should identify foreign keys, OR it doesn't exist, in which case you should be able to create it. Here's another idea. I'd like you to try the following query, which is the...
by drmccue
Thu Mar 13, 2008 8:48 am
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

need to add foreign key definitions to tblcheckoutlistitems

Thank you for sending the query results. There are supposed to be 3 foreign keys defined for table [tblcheckoutlistitems], but your Vault database has none defined for that table. Please run the SQL script below to recreate the foreign keys on that table, and then attempt your upgrade again. Best re...
by drmccue
Wed Mar 12, 2008 8:10 am
Forum: Support (Vault)
Topic: Migration VaultServer_3_5_1 to VaultServer_3_5_2 or 4_1_0_16
Replies: 15
Views: 11109

updated query

My apologies: I created the query Linda sent to you. I tested it on SQL Server 2005, but not SQL Server 2000. Based on the results you posted, it appears that your Vault database is installed on SQL Server 2000, so please try this revised query and post the results for us to examine. Thank you. Dan ...
by drmccue
Wed Dec 05, 2007 2:55 pm
Forum: Gold Support (Vault) -- Read-only
Topic: sgvault_log.LDF is enormous
Replies: 4
Views: 7908

syntax clarification

The SQL syntax for the first step is:

BACKUP LOG sgvault WITH TRUNCATE_ONLY
by drmccue
Tue Aug 14, 2007 8:46 am
Forum: Support (Fortress)
Topic: Installation Error Code 450, Upgrade Vault/Dragnet->Fortr
Replies: 3
Views: 4780

AUTO_CLOSE

The cause of this problem was eventually identified as the setting of AUTO_CLOSE in the sgvault database. A later problem was reported by Darren -- upgrading from Fortress 1.0.1 to 1.0.2 failed. AUTO_CLOSE was set to ON/True for both sgvault and sgdragnet. Once AUTO_CLOSE was set to OFF/False for bo...
by drmccue
Thu Jun 21, 2007 3:29 pm
Forum: Support (Fortress)
Topic: Some more 1.0.1 problems
Replies: 6
Views: 6819

follow-up

Michael,

I've responded via our support tracking system with a request for server log information.

Thanks,
Dan McCue
SourceGear