Re: TNS-12571 when editing text boxes in developer 6i with Oracle 9.2
Date: 9 Dec 2003 07:38:19 -0800
Message-ID: <1de5ebe7.0312090738.52a616c9_at_posting.google.com>
[Quoted] We've found that this weird error occurs when the Forms 6i client tries to block a row. If we set up blocking method 'immediate' the error raises when editing text box (just when forms tries to block the row). If the blocking is deferred the error raises when pushing the 'save' button (again, when forms tries to block the row). No difference if we block by ROWID or by Primary Key.
Set tracing on, and this is what it shows :
ntt2err: soc 496 error - operation=6, ntresnt[0]=530, ntresnt[1]=54,
ntresnt[2]=0
ntt2err: exit
nttwr: exit
nspsend: transport write error nspsend: error exit nserror: entry nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54,nt[2]=0
snsbitts_ts: entry snsbitts_ts: acquired the bit snsbitts_ts: normal exit snsbitcl_ts: entry snsbitcl_ts: normal exit
nsdofls: error exit
snsbitts_ts: entry snsbitts_ts: acquired the bit snsbitts_ts: normal exit
nsdo: nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: error exit
nioqsn: Error: Inconsistent trace parameters line: 836
nioqper: error from nioqsn nioqper: nr err code: 0 nioqper: ns main err code: 12571 nioqper: ns (2) err code: 12560 nioqper: nt main err code: 530 nioqper: nt (2) err code: 54 nioqper: nt OS err code: 0
nioqer: entry
nioqer: incoming err = 12150
niqme: entry niqme: reporting ns (2) error: (12571) as rdbms err (12571) niqme: exit nioqce: entry nioqce: exit nioqer: returning err = 12571 nioqer: exit nioqsn: returning error: 12571 nioqsn: exit nioqbr: entry nioqbr: state = normal (0)
nioqsm: entry
nioqsm: Sending break packet (1)...
nsdo: entry
nsdo: cid=0, opcode=67, *bl=1, *what=17, uflgs=0x100, cflgs=0x3
snsbitts_ts: entry snsbitts_ts: acquired the bit snsbitts_ts: normal exit
nsdo: rank=64, nsctxrnk=0
snsbitcl_ts: entry snsbitcl_ts: normal exit nsdo: nsctx: state=8, flg=0x420d, mvd=0
nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
nsdofls: entry nsdofls: DATA flags: 0x0 nsdofls: normal exit
nsdo: sending NSPTMK packet
nspsend: entry
nspsend: plen=11, type=12
nttwr: entry
ntt2err: entry
ntt2err: soc 496 error - operation=6, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0
ntt2err: exit
nttwr: exit
nspsend: transport write error
nspsend: error exit
nsdo: error sending NSPTMK packet
nserror: entry
nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0
snsbitts_ts: entry snsbitts_ts: acquired the bit snsbitts_ts: normal exit snsbitcl_ts: entry snsbitcl_ts: normal exit snsbitts_ts: entry snsbitts_ts: acquired the bit snsbitts_ts: normal exit
nsdo: nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: error exit
nioqsm: send-break: failed to send break...
nioqper: error from send-marker nioqper: nr err code: 0 nioqper: ns main err code: 12571 nioqper: ns (2) err code: 12560 nioqper: nt main err code: 530 nioqper: nt (2) err code: 54 nioqper: nt OS err code: 0
nioqer: entry
nioqer: incoming err = 12152
niqme: entry niqme: reporting ns (2) error: (12571) as rdbms err (12571) niqme: exit nioqce: entry nioqce: exit nioqer: returning err = 12571 nioqer: exit nioqbr: returning 12571 nioqbr: exit
nioqds: entry
nioqds: disconnecting...
And the errors are:
Oracle errors:
12571: TNS-12571 TNS:packet writer failure 12560: TNS-12560 TNS:protocol adapter error 12152: TNS-12152 TNS:unable to send break message
NT errors:
530: Logon Failure. (Account time restrition violation) (An attempt to
log on was made and rejected because the user tried to log on before
or after the hours that the user is allowed to !!!????)
54: Network Number conflicts with an existing router. (Source:
Appletalk!!)
This DOES NOT happens when issueing SQL commands from Oracle Forms
(inside built-in packages).
This DOES NOT happens when issueing SQL commands from SQL*Plus.
We have tried almost everything with no results (even increased the licensing number at the W2K Server because the RPC's). Tired of reading every documentation related to this...
...and, to my desperation, developed a very simple ACCESS 2000 front end via ODBC and It worked with no problems from the very first time!!!
So, please HEEELLLPPP!!!
Regards. Received on Tue Dec 09 2003 - 16:38:19 CET