Baanboard.com

Go Back   Baanboard.com > Blogs > adapalak's blog

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
55%
Installation Wizard into new VRC
18%
Manual into existing VRC
9%
Manual into new VRC
18%
Total votes: 11

Baanboard at LinkedIn


Reference Content

 
unable to create table
By adapalak at 24 Mar 2017 - 08:51

Hi

 

In My live 10.5 environment. when i create a table and then done CRDD. Files are created in dict folder. but when i create table getting error 510. Where as i am able to login to ln application aswell as db environment also. two days back i had created users and they are also able to login.Please provide a solution ASAP because as we are in live.

Please find the below event log 
Env : inforln105 (E:\Infor\ERPLN\bse)
Program : dbserver_dll file \db\servers\msql\msql_odbc.cpp # 383
Keyword : MSQL Error
User : inforln type:S language:2 locale:ISO88591/NULL package_comb:b61alive
Process : 1760
Proc.Set : inforln@W2K12R2InforLN10X:1760
Lasterror : 0
Errno : 0
Bdberrno : 0
ExtraInfo : N/A
Message : dbs_errno = 510, Error 510 occurred:
Cannot open new ODBC connection for session.
Flushed at \db\servers\msql\msql_odbc.cpp : #384.
Env : inforln105 (E:\Infor\ERPLN\bse)
Program : dbserver_dll file \db\servers\msql\msql_odbc.cpp # 883
Keyword : MSQL Error
User : inforln type:S language:2 locale:ISO88591/NULL package_comb:b61alive
Process : 1760
Proc.Set : inforln@W2K12R2InforLN10X:1760
Lasterror : 0
Errno : 0
Bdberrno : 0
ExtraInfo : N/A
Message : dbs_errno = 510, Error 510 occurred:
Check the SQL server connection (resource and/or environment variable) settings:
msql_dsn = 
msql_odbc_driver = 
msql_serverhost = W2K12R2-SQL04
msql_odbc_custom_parameters = 
Flushed at \db\servers\msql\msql_odbc.cpp : #883.
Env : inforln105 (E:\Infor\ERPLN\bse)
Program : dbserver_dll file \db\servers\msql\msql_odbc.cpp # 883
Keyword : MSQL Messages
User : inforln type:S language:2 locale:ISO88591/NULL package_comb:b61alive
Process : 1760
Proc.Set : inforln@W2K12R2InforLN10X:1760
Lasterror : 0
Errno : 0
Bdberrno : 0
ExtraInfo : N/A
Message : dbs_errno = 510, Error 510 occurred:
Error sqlcode 18456 (sqlstate: 28000, Return code: -1, diagRecNum: 1) during SQLConnect.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'inforln105'.
Flushed at \db\servers\msql\msql_odbc.cpp : #883.

Resolution

 

  


0
No votes yet

by bdittmar on March 24, 2017 - 12:30pm
bdittmar's picture
Hello,

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.
NO BLOG !

Regards

by jclju1 on March 31, 2017 - 7:49am
jclju1's picture
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.


All times are GMT +2. The time now is 07:41.


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