Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th July 2008, 17:05
alexpreyer's Avatar
alexpreyer alexpreyer is offline
Member
 
Join Date: Sep 2002
Location: South Germany
Posts: 83
alexpreyer is on a distinguished road
Baan: BIV c4 AGS2 SP 22 - DB: Oracle 10g - OS: Suse Linux Enterprise Server 10
Drop a table from company 000
Baan: Other/Unknown
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 17th July 2008, 17:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,930
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Can't you just log into company 000 and delete the table from there?
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 17th July 2008, 17:24
alexpreyer's Avatar
alexpreyer alexpreyer is offline
Member
 
Join Date: Sep 2002
Location: South Germany
Posts: 83
alexpreyer is on a distinguished road
Baan: BIV c4 AGS2 SP 22 - DB: Oracle 10g - OS: Suse Linux Enterprise Server 10
Unfortunatelly not. When I try with session "delete tables" and there select company 000 I'll get the message "company not allowed"
Reply With Quote
  #4  
Old 17th July 2008, 17:44
Kozure Ohashi's Avatar
Kozure Ohashi Kozure Ohashi is offline
Guru
 
Join Date: Dec 2003
Location: Tokyo-Otsuka
Posts: 324
Kozure Ohashi is on a distinguished road
Baan: Baan IV c4 SP 19, ERP LN 6.1 FP3 - DB: 10g R2 - OS: Linux SLES 10 64 Bit
Change User to company 000

Can you try:

Swith User to company 000 and proper Package Combination (B40Ustnd).

And try again deleting the table.

Regards,

Kozure
Reply With Quote
  #5  
Old 17th July 2008, 17:52
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,930
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Quote:
Originally Posted by alexpreyer View Post
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

Last edited by mark_h : 17th July 2008 at 17:54. Reason: forgot...
Reply With Quote
  #6  
Old 18th July 2008, 09:25
alexpreyer's Avatar
alexpreyer alexpreyer is offline
Member
 
Join Date: Sep 2002
Location: South Germany
Posts: 83
alexpreyer is on a distinguished road
Baan: BIV c4 AGS2 SP 22 - DB: Oracle 10g - OS: Suse Linux Enterprise Server 10
Quote:
Originally Posted by Kozure Ohashi View Post
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.
Reply With Quote
Sponsored Links
  #7  
Old 18th July 2008, 10:31
alexpreyer's Avatar
alexpreyer alexpreyer is offline
Member
 
Join Date: Sep 2002
Location: South Germany
Posts: 83
alexpreyer is on a distinguished road
Baan: BIV c4 AGS2 SP 22 - DB: Oracle 10g - OS: Suse Linux Enterprise Server 10
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.
Reply With Quote
  #8  
Old 28th November 2010, 23:14
jclju1's Avatar
jclju1 jclju1 is offline
Guru
 
Join Date: Jan 2002
Posts: 555
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, SSA ERP LN 6.1 - DB: bisam, Oracle, Informix, Sql Server - OS: Unix (all), Windows
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 ...".
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Audit file structure baan_user Tools Development 8 4th May 2007 15:32
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 15:08
copy records c_siek Tools Development 9 18th June 2004 16:43
using table in company 000 as a main table Ilansu Tools Administration & Installation 3 19th August 2002 14:32


All times are GMT +2. The time now is 20:18.


©2001-2017 - Baanboard.com - Baanforums.com