Go Back > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 12

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 24th March 2017, 08:51
adapalak adapalak is offline
Junior Member
Join Date: Aug 2014
Posts: 10
adapalak is on a distinguished road
Baan: fp7 - DB: oracle - OS: windows
unable to create table

A new blog entry has been added:

unable to create table

Reply With Quote
Old 24th March 2017, 12:30
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,903
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c - OS: HP-UX, W2K3, SLES, RHLE
leave after CRDD an login again !!!!!!!


after maintaining a new table Definition and CRDD you have to leave the application an log in again.

After NEW Login the create table should be successful.

Post in proper Forum , please.

Reply With Quote
Old 31st March 2017, 08:49
jclju1's Avatar
jclju1 jclju1 is offline
Join Date: Jan 2002
Posts: 584
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, Infor LN - DB: Oracle, Sql Server, PostgreSQL - OS: Unix, Linux, Windows
I saw that you have this error: "Error 510 - Database not on" and "Cannot open new ODBC connection for session".
Probably, there is something wrong with database group on DB level - changed password or missing authorization.
Reply With Quote
Sponsored Links
Old 3rd February 2021, 19:37
manish.singh17 manish.singh17 is offline
Join Date: Jun 2017
Posts: 1
manish.singh17 is on a distinguished road
Baan: Baan 4 C4 - DB: Oracle - OS: Linux
We are facing exactly same error in 10.5 .
How did you resolve this error? Please suggest.
Reply With Quote
Old 4th February 2021, 17:32
vinceco252's Avatar
vinceco252 vinceco252 is offline
Join Date: Mar 2002
Location: Frederick, CO
Posts: 458
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
Sounds like the database login that corresponds to the database group doesn't have permissions to execute DDL statements. For SQL Server, anyway, if your LN database group is "lndb", there should be a SQL login named "lndb", and the database name for LN should be "lndb". The SQL login "lndb" should either be the db_owner for lndb or have a corresponding lndb database user that has the db_owner role.
Vincent Murphy
ERP Practice Manager / Senior Consultant
Reply With Quote

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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to remove table reference Stacy Long Tools Development 4 27th November 2016 00:34
Create a Logical temporary table in Baan som.papai Tools Development 11 27th September 2016 09:19
cannot create table error 1951 preethi Operating Systems & Databases 9 14th August 2010 03:36
Create Table from Sequential Dump « Error in running bdbpost » BOBBYLYON Tools Development 1 2nd February 2009 11:22
unable to create a table VishalMistry Tools Administration & Installation 1 13th April 2007 10:42

All times are GMT +2. The time now is 15:12.

©2001-2021 - -