Test Mode Error (bastestdomainafp_job_ref already exists)

GaryBartlett

I am getting the following error when going into Test Mode:

Exception changing status of the business space version Aware IM server encountered the following error .Error creating reference table Table ‘bastestdomainafp_job_ref’ already exists.

Any advice, Support?

Thanks very much.

Gary

himanshu

Try to delete reference business object and create relationship again.

Powerm

This is a database error. Just delete the table "‘bastestdomainafp_job_ref" on your database.

GaryBartlett

Thanks or the advice, Folks; here's what I got from support, who I contacted directly, when the site went down:

You have inconsistency between your BSV and your database structure. This can happen in the following scenario, for example. You have published a BSV and it works fine. You take this BSV on some other machine and start changing it. In the meantime you or someone else changes the BSV on the current machine and publishes the changes. Then you bring back the BSV changed on another machine and try to publish it on the old machine. The changes made to the BSV on the current machine and the changes made to it on a different machine can be incompatible with each other and so you have this problem.

You need to do the following:

Don't attempt to fix anything, but restore the system from the backup when everything was consistent.

Review the changes in the BSV you are trying to publish compared to the BSV published on the machine and then see what is incompatible.

If you don't have a backup or if you don't care about the data in the database you can just create a new business space, import your BSV and publish this business space

I took option 3 - as I had exported all my tables earlier....went swimmingly.

Thanks, Support!

Gary