[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference utrop1::linkworks_v3

Title:	LinkWorks V3.0 Notes Conference
Notice:	LNX_APO = APO issues, LINKWORKS_V3 = V3.0 issues
Moderator:	tacklr.apd.dec.com::TACK_Lm::TACK_L

Created:	Tue Jun 28 1994
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	2269
Total number of notes:	8338

2241.0. "sql-02117" by KERNEL::SIMPSONR (fred) Tue May 20 1997 18:32

Linkworks v3.08   Unix v3.2g

Users are getting sql-02117 unable to open message file they then get
sql-02113. They are then unable to get into what they want to open, this 
problem happens intermittently. I realise that the error 2117 means:

  "Invalid SQL Cursor usage: trying to open an opened cursor"

and we have checked:

  SQLDBA> show parameter open_cursors;

and he has 1500. Any ideas as to what could be causing these problems?

Cheers,
Richard.

T.R	Title	User	Personal Name	Date	Lines
2241.1	problem on error recovery	UTROP1::16.197.208.129::VISSER_J	Joop Visser @ UTO	`Wed May 21 1997 10:32`	5
	Do you have an ER* file from this situation? It can be that an error (like network) occured and Linkworks recovery went wrong. Joop Visser