Cannot make BusinessSpace version available for testing

aware_support

This means that the testing database (BASDBTEST) for the old business space is screwed up. Just use the new business space from now on.

Sergej

Hi, thank you very much for the answer!

Do you mean?
1.Create new BS, import current bsv

Copy current BASDB database to new BS

If I create new BS I need to transfer data from current bsv.

aware_support

Yes, import and publish the new BSV and then copy the data. DO NOT COPY the entire database - just the tables that start with OLDBS_ in BASDB to the corresponding tables that start with NEWBS_

Where OLDBS and NEWBS are the names of the old and new business spaces respectively

Sergej

Hi!
I have done what you said but now some rows are filled wirh wrong data.
For example, LoginName is filled with AccessLevel, and vice versa AccessLevel is filled with LoginName. Some other fields have same problem.

I copied in phpmyadmin only data without structure.

Is it right?

aware_support

If rows have the wrong data you haven't copied correctly. If you have a backup restore this backup and do it again

Sergej

The issue is that when I import bsv fron CURRENT BS the database that is created has different structure comparing with CURENT databease.

What could be the reason?

Sergej

I mean when I import it in newly created BS.

aware_support

You need to PUBLISH the new business space before you import the data. If you imported the same BSV then the database structure must be identical after publishing. You can then import the data

kklosson

For Sergej, ACDC, and Support

I'm in this same pickle and could use some advise. I develop on a local machine and publish my BSV to a production server. I recently updated to 5.5 from 5.3 and went about making some modifications including some that affect the database structure.

Along the way, I did a build and found that all of my data (in the test database on my local machine) was just gone. Could this happen if I chose the wrong option during the build?

Regardless, I restored from a backup from before all of this and now my BSV is out of sync.

Here's my question and I would appreciate hearing from support so I don't foul up...

My local test database is insignificant to me and losing all data within it is no concern. My only test database in on my dev machine and my only operational database in on my server machine. Can I just drop the test database from my dev machine and allow the Configuration Tool to rebuild it (empty of course) and the big question: Will my BSV update on my production system without errors?

If not, I will probably have to bring in my currently published BSV and start over on my 5.5 changes.

I would appreciate your input.

aware_support

Do not DROP the database - this should only be done if all else fails. In your case just put it under testing with no initial data. This should rebuild the testing database.

Whether or not it will publish to the production without errors - I have no idea. If you want to test it you should have the same structure on the testing machine as on the production machine, then make your changes and then publish on top of the old structure.

kklosson

Thanks,

I believe my best course of action is to go back to the published BSV, start my build with no initial data, and redo my changes from there. Can you please confirm, when I build with no initial data, does the test database get purged? I'm looking for some reason that I lost my test database - I'm thinking I must have checked that option in the fog or something.

aware_support

Yes, the testing database is purged

« Previous Page