alexpreyer
17th July 2008, 17:05
I defined a new table in our customization VRC. Then i modified an existing session to write some records in the new table. What I forgot, was that this session using "switch.to.company" to switch to company 000. But anyway it worked and my records where written in company 000. Because these records are about user rights, it is ok for me. But now I have to add one more field to the table and this is where the problem begins. I cannot reconfigure the table in company 000, and also deleting it is not allowed. Does anyone have a hint for me
Thanks
Alex
mark_h
17th July 2008, 17:22
Can't you just log into company 000 and delete the table from there?
alexpreyer
17th July 2008, 17:24
Unfortunatelly not. When I try with session "delete tables" and there select company 000 I'll get the message "company not allowed"
Kozure Ohashi
17th July 2008, 17:44
Can you try:
Swith User to company 000 and proper Package Combination (B40Ustnd).
And try again deleting the table.
Regards,
Kozure
mark_h
17th July 2008, 17:52
Unfortunatelly not. When I try with session "delete tables" and there select company 000 I'll get the message "company not allowed"
Someone should be able to set "-set BSE_COMPNR=0" in the .bwc login file and then try the delete table. You might want to export it and import it to the correct company. Have you actually tried it?
I forgot to mention I can not use change company to 0 because of different start days of the week, but I can log in directly to company 000.
alexpreyer
18th July 2008, 09:25
Can you try:
Swith User to company 000 and proper Package Combination (B40Ustnd).
And try again deleting the table.
Regards,
Kozure
That's was it what I tried first. I set my user to B40Ustnd and Company 000. Then logged in again. Also in this case the message when selecting company 0 in "delete tables": "company not allowed" appears. It seems to be a security feature that it is not allowed to delete company 0 tables.
Also the users bsp and root are not able to delete.
alexpreyer
18th July 2008, 10:31
I found a way.
I deleted the table for company 000 directly in Oracle and then I could create it in Baan for company 000 with the new structure.
Thanks anyway for your help.
jclju1
28th November 2010, 23:14
Normal way for deleting tables in company 000 in Baan / INfor ERP LN is using session Create ASCII dunmp of tables and check field "Drop tables ...".