Error When Putting BSV Under Test

bssxfire8

We get the following error every time we try to put any of our BSV's under test.

"Exception changing status of the business space version Aware IM server
encountered the following error. Error reading business object. Table
'basdb.purchaseorders_regularuser' doesn't exist."

The backstory to the bsv PurchaseOrders is that we needed to rename it so we created a new bsv imported all the data from PurchaseOrders to the new bsv and then removed that bsv. We have also migrated to MySQL since this.

Any Suggestions?

Jaymer

from some other BSV, copy its definition of RegularUser and create the needed table:
basdb.purchaseorders_regularuser

its saying it can't find that database table, so make it be there.

also, in case that doesn't fix it,
what do you mean you needed to rename PurchaseOrders - it appears its still looking for POs, except all lower case.
whats the new name if its not "purchaseorders"?

and do you mean you get the error and cannot move forward (when going into test),
or you get the error, but can still test anyway?

and, in the meantime, make sure you have a working SQL tool (like MySqlWorkbench, or Toad Edge)
cause thats going to be needed to rectify this (i think).

jaymer...

BobK

Have you solved this yet :?:

bssxfire8

Jaymer wrote
from some other BSV, copy its definition of RegularUser and create the needed table:
basdb.purchaseorders_regularuser

its saying it can't find that database table, so make it be there.

also, in case that doesn't fix it,
what do you mean you needed to rename PurchaseOrders - it appears its still looking for POs, except all lower case.
whats the new name if its not "purchaseorders"?

and do you mean you get the error and cannot move forward (when going into test),
or you get the error, but can still test anyway?

and, in the meantime, make sure you have a working SQL tool (like MySqlWorkbench, or Toad Edge)
cause thats going to be needed to rectify this (i think).

jaymer...

So I did copy a different Business Space's RegularUser table to the basdb as basdb.purchaseorders_regularuser and that solved the problem with not being able to put our BSV's under test.

The main question I have now is why is it referring to a Business Space that we deleted a long time ago?

We needed to remove the purchaseorders Business Space and transfered all the tables from it to a business space with another name. purchaseorders was our first business space we ever created and it seems like there are weird lingering issues with that name constantly.

BobK

Jaymer wrote
and, in the meantime, make sure you have a working SQL tool (like MySqlWorkbench, or Toad Edge)
cause thats going to be needed to rectify this (i think).

jaymer...

Use the aforementioned SQL tool and have a look at the P4 column of the bas_system table.

It is probably purchaseorders because that was the first BSV you created and was considered your default BSV.