Re: TNS-12571 when editing text boxes in developer 6i with Oracle 9.2

Carlos wrote:

> 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.

Nope - doesn't ring bell - sorry.
Tried logging an iTar? Comes up with more suggestions than I ever managed to find searching Metalink

-- 
Regards, Frank van Bortel