Exception while Publishing business space

thom

I got a error message while publishing a business spaces that states

"Exception publishing businesss space version Aware IM server encounteered the following error .Error creating data base table. There is already an object named 'businessspace_bo' in the database"

I can't seem to get around this - restore, reload previous versions,....

any ideas

thanks

tford

Could you:

1) export the bsv
2) create a new bsv with different name
3) import the bsv from #1 into the bsv from #2.
4) publish the new bsv.

thom

Hi Tom,

Yes I could .... because time pressure it was want i had to do.
I couldn't change the name of the bsv, because there are several links floating around the customer (i.e. guest login, admin login, links from websites) that could not be changed as quickly.

The process itself was a little tricky in order to keep the business space.

I renamed then tables on the database
I exported the bsv.
Delete the business space
Created a new business space wiht the same name and import the bsv
Did a insert into tablename select from oldtablename and populated all of my current data.

#4 & 5 where some what problematic because the column order that was created after i imported was not the same as the column order that was on the previous database tables. I had to insert and select with column names for most of the objects ....

The real leason here is I had backups of everything before my last publish.

Thanks for the response