DATABASE STRUCTURE HAS BEEN MODIFIED PROBLEM

[Former Member]

Dear Experts

Am getting a message continuesly in SBO 2007B PL 15

DATABASE STRUCTURE HAS BEEN MODIFIED, Inorder to resume system will close all the windows open

There are UDTs created in system by ADDon after that am getting this message

I have gone through below links

Other than this any help please,.. This message ideally should come at the time of creation but it is continuesly coming! even if i have stopped all my addons

Best Regards

sandeep

[Former Member]

Closed

[former_member196081]

Hi Sandeep,

I am facing the same problem. How did you correct it. Please Help.

[Former Member]

Hi Deepak,

The developer may write the Addon code which will always create UDT when you start the addon.

[former_member196081]

Addon is working well since last 6 month.This error message start to appeared since last two days and one more thing....Journal entry form is not being open. System giving the error message "first define the numbering series in admin module"

[Former Member]

Hi

Does the user has authorization for numbering series?

Are you getting this error only on particular system or particular user?

[former_member196081]

User is the super user. All System all Users effected with this.

[Former Member]

try stopping the addon and work.

If its not worked,the do a workaround,restore the previous backup(which you took before the affected issue) as 'test database' and check for the issue.

If the issue was not affected,then i suspect that somebody might updated the standard B1 table at backend.

You run  'DBCC Checkdb' in sql server to check for any consistency errors.

If there is no any consistency,log a message to SAP.

[former_member196081]

Thanks Kamba,

Problem Resolved.

Actually  I Restored the File Numbering (Help>Support>Restore>File Numbering).

[Former Member]

In this case, the add-on may not be compatible with your PL.

[Former Member]

But the addon was running fine before and its running fine with other database in the same server, any was the addon providers have many customers running in 2007B PL 15

Can you suggest me what should i do to stop this

Regards

Sandeep

[Former Member]

Something may be wrong with your DB then. That would be hard to troubleshoot since it is live. I am afraid you need to log a message to SAP support now.

[Former Member]

Dear Sandeep,

Is this add-on by 3rd party vendor? If it is by yourself, you need to check the logic. UDT creation should be one time action and the restarting of the database is mandatory. Whenever creating new UDT, nobody should use the system.

Thanks,

Gordon

[Former Member]

Hi Gordon

Yes while creating UDT there were users Logged in to the system, that is third party ADDon

now what should i do to avaoid this messege now?

Regards

Sandeep

[Former Member]

I hope this add-on only creating UDT when you install it. If that is true, try to reinstall it when nobody is logged in and restart your server after install. If not, you need to contact with add-on vendor to seek more helps.

[Former Member]

Hi

Thanks for your reply

I tried uninstalling the product and Reinstalled when No Users were Logged into the system

But Still am getting the same message

Any Other Help Please

Regards

Sandeep