walter01
16th June 2004, 10:17
Since about 2 weeks we get the following error when we try to enter a new sales order with session tdsls4101m000. I can enter the first 2 fields but when I press the TAB key the session is closed and the message appears.
Everything else seems to work fine.
I can't find ant info on error 13224 I hope someone can help me on this one.

log.bshell
--------------------------------
******* S T A R T of Error message *******
Log message called from /port.6.1c.04.02/vobs/tt/mir/mir/bdb_fun.c: #1029 keyword: DB error
Pid 22335 Uid 5491 Euid 5491 Gid 125 Egid 125
user_type S language 1 user_name wg01 tty ote locale ISO88591/NULL
Errno 0 bdb_errno 13224 (bdb_errno 13224)
Log_mesg: Error 13224 (bdb_errno 13224) on SELECT
******* E N D of Error message *******

SQLNET.log in my home dir shows :
----------------------------------
Fatal NI connect error 12224, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=neptunus)(Port=1521))(CONNECT_DATA=(SID=test)(CID=(PROGRAM=)(HOST=neptunus)(USER=wg01))))

VERSION INFORMATION:
TNS for HPUX: Version 8.0.6.0.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 8.0.6.0.0 - Production
Time: 16-JUN-04 09:08:18
Tracing not turned on.
Tns error struct:
nr err code: 12224
TNS-12224: TNS:no listener
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 239
nt OS err code: 0

Thx,

Walter

dave_23
16th June 2004, 13:26
Hi Walter,

What does your tabledef6.X look like?

Dave

walter01
16th June 2004, 15:01
Hi Dave,

thanks for your quick reply.
Tabledef6.1 says that table tfacr200 used by tdsls4101m000) comp 160 is in a different database on a different server which is not running !
I changed it to the correct database and it is working fine now.
I thought that the database connection was broken, but instead it could never be established.

Thanks a lot

Walter

dave_23
16th June 2004, 15:24
Great to hear!

Dave