So I packed up and took my project to a customer. After I came back and opened my project on the server all my systems are gone. Also my next numbers are gone.

When i open the project on my computer (so no the one stored on the network where i work in normally) the systems are gone as well.
A check-in doesn’t fix the problem. I hope I can get a backup of the server.

I found that this method is not very clear what is happening when you do a pack up. I think the following happens: All the SQL Databases involved with the project (including the Global Database) are copied to the project folder so you can copy the whole folder to your own machine. Is this correct?

Happy Holidays

Tim

So after a quick investigation i found that the SQL tables are in tact. Only the data is not copied to the VISTADB. I found the following points:

• An extra row in project info is added so the project info shows now info like:
o Name: LAWA2,
o description: asdf
o etc.
• The project switched to VISTADB, here a couple of tables are missing. The tables I miss:
o Systems
o Next Numbers
• The information is present on the SQL but not in the VISTADB.
• How to switch from VISTADB to SQL?

So I fixed the problem by changing my project XML File to SQL Again. I have all my systems back and also my next numbers. The only thing is that also the SQL is changed. The project info has a new row with weird data. I have manually removed this.

I feel a big investigation ccoming up.

Raw Info from the SQL:


Name Description CurrentProjectRevision DateCreated DateModified LastModifiedBy TotalEditTime IsSticky CheckedOut CheckedOutBy ExpectedReturnDate Creator Dirty User1 User2 User3 ProejctInfoGUID User4 user5 ProjectLeadPerson CreatedOn ModifiedOn RepGUID User6 User7 User8 User9 User10 User11 User12 UserInt1 UserInt2 UserInt3 UserInt4 UserInt5 UserInt6 UserInt7 UserInt8 UserInt9 UserInt10 UserInt11 UserInt12 UserBool1 UserBool2 UserBool3 UserBool4 UserBool5 UserBool6 UserBool7 UserBool8 UserBool9 UserBool10 UserBool11 UserBool12
LAWA2 asdf NULL 2012-05-02 00:00:00.000 2012-05-02 00:00:00.000 NULL 1.07:53:09.9859340 0 0 NULL NULL NULL 0 NULL NULL NULL 6FAC1C82-F86D-4620-A40F-60467720ECF9 NULL NULL 2012-05-02 20:36:32.697 2015-12-24 12:11:13.897 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

The row has data from 2012???? So this is a program bug I think.

So the problem is also related to the AccountInfo Table. There are 2 rows with the following data:

AccountInfoGUID AccountName ContactName ContactPhone ContactFax ContactEmail AccountWebsite AccountAddress1 AccountAddress2 AccountCity AccountState AccountPostalCode User1 User2 User3 ProjectID User4 CreatedOn ModifiedOn RepGUID User5 User6 User7 User8 User9 User10 User11 User12 UserInt1 UserInt2 UserInt3 UserInt4 UserInt5 UserInt6 UserInt7 UserInt8 UserInt9 UserInt10 UserInt11 UserInt12 UserBool1 UserBool2 UserBool3 UserBool4 UserBool5 UserBool6 UserBool7 UserBool8 UserBool9 UserBool10 UserBool11 UserBool12
9FF69102-B05B-4283-8E30-EAB4D29F600E NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 6FAC1C82-F86D-4620-A40F-60467720ECF9 NULL 2012-05-02 20:36:33.273 2012-05-02 20:36:33.273 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

AccountInfoGUID AccountName ContactName ContactPhone ContactFax ContactEmail AccountWebsite AccountAddress1 AccountAddress2 AccountCity AccountState AccountPostalCode User1 User2 User3 ProjectID User4 CreatedOn ModifiedOn RepGUID User5 User6 User7 User8 User9 User10 User11 User12 UserInt1 UserInt2 UserInt3 UserInt4 UserInt5 UserInt6 UserInt7 UserInt8 UserInt9 UserInt10 UserInt11 UserInt12 UserBool1 UserBool2 UserBool3 UserBool4 UserBool5 UserBool6 UserBool7 UserBool8 UserBool9 UserBool10 UserBool11 UserBool12
D0F1E82D-DB5C-48C1-AF25-ECF04C3397BE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 6FAC1C82-F86D-4620-A40F-60467720ECF9 NULL 2012-05-02 20:36:32.757 2012-05-02 20:36:32.757 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

I had to first remove this rows before i could remove the projectinfo row.