Update on BC_MSG Table

[Former Member]

When I try running the following statement in SQL Command Editor in DBACOCKPIT,  I get the following error:

update BC_MSG set status = 'NDLV' where MSG_ID = '53bb3f5b-4f28-1760-e100-8000a1f1ff54'

ORA-00903: invalid table name.

But when I run a select statement ( select status from bc_msg ) on bc_msg table it works fine.

Please advice.

[Former Member]

Anyone?

[Former Member]

Are you getting same error in ABAP program as well,when running update query?

Regards

Osman

[Former Member]

maybe if you add the database name in front of the table name? for example:

    update PSAPXYZ.BC_MSG set status = 'NDLV'...

Regards,

Thomas

[Former Member]

I added the JAVA schema name infront.

SAPXXXDB.BC_MSG

still no luck.

[Former Member]

Try with

XXX.SAPXXXDB.BC_MSG

XXX=system name (same as XXX in SAPXXXDB)

Regards

Osman

[Former Member]

Tried that too. Still no luck.

Could it be that you cannot run update commands from SQL Command Editor?

[Former Member]

BS_MSG is the standard table and ideally we should not update/edit these tables directly from DB.

SAP suggest's not to update the production tables manually and they won't be able to provide any support in case of any issues.

Regards

Osman

Message was edited by: Osman Jabri

[Former Member]

I am just trying it in non-prod:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/07/23/michals-pi-tips-how-to-restart-a-...

[Former Member]

If it is a dev system then fine, but don't try the same in Test or Prod environment.(even in michal's blog he mention the same.)

Note:

Please remember that this approach is not supported by SAP and should never be used on TEST, PRD systems.

1. Might be the user that you are using is having only read only access on the table. Check the permissions of the user.

2. Check with the DB team. Ask them to execute this query and check.

Regards

Osman

[Former Member]

I think it's the limitation of SQL command editor. You cannot run update statements there.

[Former Member]

In that case, try to update some custom table and see if it is getting updated of giving the same error.

[Former Member]

You can only do select statements through SQL Command Editor. That is confirmed.

But I tried updating the table using dbcon connection in abap program. Still unable to update the table. The select statment works fine.

[former_member184720]

use the quotes around table name and try? "BC_MSG" or lower case bc_msg?

[Former Member]

Nope that didnt help.