How to establish the connection on the content server database owner page under cs administration???

Hi all,

I would like to use existing database of cs on the content server database owner page of another system but I am unable to setup the database connection.I am getting the error like "Cannot execute the sql Statement". while checking the connection logs folder , its showing like " ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'KIni'.' "

KConnect::Connect(...) .. open the connection.
KSqlODBC::SubclassConnect BCPEnabled() = TRUE
KSqlODBC::SubclassConnect() DSN (connection string): DRIVER={SQL Server};SERVER=192.168.1.55,9090;UID=sa;DATABASE=CS16;
KSqlODBC::SubclassConnect() --> system: 'Microsoft SQL Server'
KSqlODBC::SubclassConnect() --> version: '12.00.4100'
KSqlODBC::SubclassConnect() --> SQLSERVER: DB batching enabled
KSql::Connect('192.168.1.55,9090','CS16','sa','*','','API100') --> 'SUCCESS',[sec: 0 msec: 12]
KSql::Connect .. ConnectionType = ODBC
KSql::Connect .. DatabaseType = SQLSERVER
KSql::Connect .. MaxLength = 32767
KSql::Connect .. MaxLongLength = 32767
KSql::Connect .. SubQueryBlobs = TRUE
KConnect::Connect(...) --> 'SUCCESS'
KConnect::AllocConnect() .. allocate new connection.
****** CAPIExec called ...
KSql::StartTransaction() --> 0,'SUCCESS'
KSqlCursor::Open(201f,'DELETE FROM KIni WHERE IniSection='Module.VersionInfo' AND IniKeyword= :A') -->'SUCCESS'
KSqlCursor::Prepare() --> 'SUCCESS'
KSqlCursor::Bind(1,{'undelete'}) --> 'SUCCESS'
ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'KIni'.
ODBC diagnostic error: 2 ODBC error code: 8180 ODBC state: 42000 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
KSqlCursor::Execute() --> 'Could not execute cursor.'
KSqlCursor::Close() --> 'SUCCESS'
KSql::EndTransaction('Error from Evaluate',FALSE) --> 0
KSql::Execute(...) --> 'Error executing an Sql statement.',0 records,[sec: 0 msec: 3]

Could anyone guide me how to resolve this issue?

Thanks in advance

Regards

Murali D

Find more posts tagged with

Comments

appuGmail

Hi Murali,

What exactly do you want to happen because the way that Livelink works is when you install Livelink for the first time, you have to give it a DB, its privileged owner(or the schema owner with lots of higher things on DB side).

Mostly one uses either the admin. index sections like "Do tasks for SQL server/Oracle create a database, create owner etc". After that, you connect to the newly created database and Livelink starts populating the schema with tables/views what it needs inserts Module Version information and so on. Hopefully, you get success and can add and remove objects through the web interface. This is very necessary for establishing success.

Now if we call that Host1/DB1 then if you install the same Livelink software on Host2 it will know that you are creating a Livelink cluster and go from there. is this what you tried?

Your screencap shows SA in SQL server I am just wondering why you want to put the application's tables into SA's logon Database? Most of us would have expected to see

a screen where you are actually filling in a new DB and the new user you created and an EFS text box...

KSqlCursor::Open(201f,'DELETE FROM KIni WHERE IniSection='Module.VersionInfo' AND IniKeyword= :A') -->'SUCCESS'

If you went and did SQLserver Management Studio and logged in like your screen cap do you see Kini table there? That's a very important table for a Livelink installation so

if the software has been able to do its job it better be there. Perhaps you did not do the SQLserver maintenance tasks for Livelink as I mentioned? Read the first time install a guide

to cross check. Newer versions have very informative screencap included documentation.

Now if you have a fully working LL system and its DB then those lines are very suspect but in many time older schema aware modules have the tendency of throwing "chicken & egg " kind of errors

but if you are to be helped the forum or OT support may need to know if you do have an at least a working system or the tables a prior install created. Even in the "chicken and egg" situation

what the software is doing is basically querying KIni to say does a particular module version exist, the answer is important for it to move forward, but not like "I don't even know

what KIni is " not what I would have expected.

Anyways if you are new to this I showed some info https://knowledge.opentext.com/knowledge/cs.dll/Properties/76528820

if not I hope it will help someone.

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Fri, Feb 8, 2019 at 4:49 AM eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

How to establish the connection on the content server database owner page under cs administration??? Posted bymurali.d@thebentech.com (Dulipudi, Murali)On 02/08/2019 05:45 AM

Hi all,I would like to use existing database of cs on the content server database owner page of another system but I am unable to setup the database connection.I am getting the error like "Cannot execute the sql Statement". while checking the connection logs folder , its showing like " ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'KIni'.' "KConnect::Connect(...) .. open the connection.
KSqlODBC::SubclassConnect BCPEnabled() = TRUE
KSqlODBC::SubclassConnect() DSN (connection string): DRIVER={SQL Server};SERVER=192.168.1.55,9090;UID=sa;DATABASE=CS16;
KSqlODBC::SubclassConnect() --> system: 'Microsoft SQL Server'
KSqlODBC::SubclassConnect() --> version: '12.00.4100'
KSqlODBC::SubclassConnect() --> SQLSERVER: DB batching enabled
KSql::Connect('192.168.1.55,9090','CS16','sa','*','','API100') --> 'SUCCESS',[sec: 0 msec: 12]
KSql::Connect .. ConnectionType = ODBC
KSql::Connect .. DatabaseType = SQLSERVER
KSql::Connect .. MaxLength = 32767
KSql::Connect .. MaxLongLength = 32767
KSql::Connect .. SubQueryBlobs = TRUE
KConnect::Connect(...) --> 'SUCCESS'
KConnect::AllocConnect() .. allocate new connection.
****** CAPIExec called ...
KSql::StartTransaction() --> 0,'SUCCESS'
KSqlCursor::Open(201f,'DELETE FROM KIni WHERE IniSection='Module.VersionInfo' AND IniKeyword= :A') -->'SUCCESS'
KSqlCursor::Prepare() --> 'SUCCESS'
KSqlCursor::Bind(1,{'undelete'}) --> 'SUCCESS'
ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'KIni'.
ODBC diagnostic error: 2 ODBC error code: 8180 ODBC state: 42000 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
KSqlCursor::Execute() --> 'Could not execute cursor.'
KSqlCursor::Close() --> 'SUCCESS'
KSql::EndTransaction('Error from Evaluate',FALSE) --> 0
KSql::Execute(...) --> 'Error executing an Sql statement.',0 records,[sec: 0 msec: 3] Could anyone guide me how to resolve this issue?Thanks in advance RegardsMurali D
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: My Support

appuGmail

One other thing recently that I have understood is many times LL is now installed as a Case Sensitive Accent Sensitive DB collation.

In the old school, one would be able to do Select * from KINI, Kini or some combination thereof. In newer collations

one is forced to use what the OT software code is looking for

for e.g select * from KIni

select * from KUAF

select * from DTreeACL like that

I just thought I will say that as well.

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Fri, Feb 8, 2019 at 6:10 PM eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

[EXTERNAL] - Re How to establish the connection on the content server database owner page under cs administration??? Posted byappnair@gmail.com (Nair, Krishnankutty)On 02/08/2019 07:08 PM

Hi Murali,
What exactly do you want to happen because the way that Livelink works is when you install Livelink for the first time, you have to give it a DB, its privileged owner(or the schema owner with lots of higher things on DB side).
Mostly one uses either the admin. index sections like "Do tasks for SQL server/Oracle create a database, create owner etc". After that, you connect to the newly created database and Livelink starts populating the schema with tables/views what it needs inserts Module Version information and so on. Hopefully, you get success and can add and remove objects through the web interface. This is very necessary for establishing success.

Now if we call that Host1/DB1 then if you install the same Livelink software on Host2 it will know that you are creating a Livelink cluster and go from there. is this what you tried?
Your screencap shows SA in SQL server I am just wondering why you want to put the application's tables into SA's logon Database? Most of us would have expected to see
a screen where you are actually filling in a new DB and the new user you created and an EFS text box...

KSqlCursor::Open(201f,'DELETE FROM KIni WHERE IniSection='Module.VersionInfo' AND IniKeyword= :A') -->'SUCCESS'
If you went and did SQLserver Management Studio and logged in like your screen cap do you see Kini table there? That's a very important table for a Livelink installation so
if the software has been able to do its job it better be there. Perhaps you did not do the SQLserver maintenance tasks for Livelink as I mentioned? Read the first time install a guide
to cross check. Newer versions have very informative screencap included documentation.

Now if you have a fully working LL system and its DB then those lines are very suspect but in many time older schema aware modules have the tendency of throwing "chicken & egg " kind of errors
but if you are to be helped the forum or OT support may need to know if you do have an at least a working system or the tables a prior install created. Even in the "chicken and egg" situation
what the software is doing is basically querying KIni to say does a particular module version exist, the answer is important for it to move forward, but not like "I don't even know
what KIni is " not what I would have expected.

Anyways if you are new to this I showed some info https://knowledge.opentext.com/knowledge/cs.dll/Properties/76528820
if not I hope it will help someone.

Ciao,
..... appnair appunair( Livelink Rocks )
Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Fri, Feb 8, 2019 at 4:49 AM eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

How to establish the connection on the content server database owner page under cs administration??? Posted bymurali.d@thebentech.com (Dulipudi, Murali)On 02/08/2019 05:45 AM

Hi all,I would like to use existing database of cs on the content server database owner page of another system but I am unable to setup the database connection.I am getting the error like "Cannot execute the sql Statement". while checking the connection logs folder , its showing like " ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'KIni'.' "KConnect::Connect(...) .. open the connection.
KSqlODBC::SubclassConnect BCPEnabled() = TRUE
KSqlODBC::SubclassConnect() DSN (connection string): DRIVER={SQL Server};SERVER=192.168.1.55,9090;UID=sa;DATABASE=CS16;
KSqlODBC::SubclassConnect() --> system: 'Microsoft SQL Server'
KSqlODBC::SubclassConnect() --> version: '12.00.4100'
KSqlODBC::SubclassConnect() --> SQLSERVER: DB batching enabled
KSql::Connect('192.168.1.55,9090','CS16','sa','*','','API100') --> 'SUCCESS',[sec: 0 msec: 12]
KSql::Connect .. ConnectionType = ODBC
KSql::Connect .. DatabaseType = SQLSERVER
KSql::Connect .. MaxLength = 32767
KSql::Connect .. MaxLongLength = 32767
KSql::Connect .. SubQueryBlobs = TRUE
KConnect::Connect(...) --> 'SUCCESS'
KConnect::AllocConnect() .. allocate new connection.
****** CAPIExec called ...
KSql::StartTransaction() --> 0,'SUCCESS'
KSqlCursor::Open(201f,'DELETE FROM KIni WHERE IniSection='Module.VersionInfo' AND IniKeyword= :A') -->'SUCCESS'
KSqlCursor::Prepare() --> 'SUCCESS'
KSqlCursor::Bind(1,{'undelete'}) --> 'SUCCESS'
ODBC diagnostic error: 1 ODBC error code: 208 ODBC state: 42S02 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'KIni'.
ODBC diagnostic error: 2 ODBC error code: 8180 ODBC state: 42000 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
KSqlCursor::Execute() --> 'Could not execute cursor.'
KSqlCursor::Close() --> 'SUCCESS'
KSql::EndTransaction('Error from Evaluate',FALSE) --> 0
KSql::Execute(...) --> 'Error executing an Sql statement.',0 records,[sec: 0 msec: 3] Could anyone guide me how to resolve this issue?Thanks in advance RegardsMurali D
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: My Support

[To post a comment, use the normal reply function]
Topic:	How to establish the connection on the content server database owner page under cs administration???
Forum:	Content Server Development Forum
Content Server:	My Support