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

Conference orarep::nomahs::dbintegrator_public_public

Title:DB Integrator Public Conference
Notice:Database Integration - today! Kit/Doc info see note 36
Moderator:BROKE::ABUGOV
Created:Mon Sep 21 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1171
Total number of notes:5187

1125.0. "NSDS-E-NOTRESERVED" by ORAREP::ELIS::EIJKHOUT () Wed Feb 19 1997 08:07

We recently migrated from RDB 6.0 to 6.1 and to CDD 6.1.
Now there is a problem with one of the applications.

What I do is the following:

SQL> attach 'alias dms filename /type=nsds/pathname=codmI$$c_path';
SQL> set transaction on dms using (read only reserving dms.hi_record
	for shared read);
SQL> show table;

The error that follows is:

%RDB-F-SYS_REQUEST, error from system services request
-NSDS-E-EXECUTEERROR, Error in query execution in data collection manager
-NSDS-E-NOTRESERVED, Unreserved relation in a transaction with RESERVING clause

I suspect it has to do with the RESERVING option, because if I use the
statement SET TRANSACTION ON DMS USING (READ ONLY), there is no problem.

Does anyone know a solution?

regards,
Marga
T.RTitleUserPersonal
Name		DateLines
1125.1Version? and some debug flags to try...BROKE::WRIGHTNYO&W-Trains Spoken Here-SUSIEQWed Feb 19 1997 15:0210
Marga,

I have a question something you can try which may shed some light on the problem.

First, what version of NSDS are you running?

Second, you can try defining NSDS$DEBUG_FLAGS to be "FE" and posting the results
here.

					Tom
1125.2ORAREP::ELIS::EIJKHOUTThu Feb 20 1997 05:41120
Tom,

We're running NSDS 3.0.
Below the output with debug flags.

Marga 

CODMI> define nsds$debug_flags "FE"
CODMI> mc sql$
SQL> attach 'alias dms file /type=nsds/pathname=codmi$$c_path'; 
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
NSDS::   CODMI010_TEMP_DB7   :: is NOT a RMS File Definition
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0000, Engine Mask: 0000
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_GET_DBKEY_LENGTH
RMS DDI: Call to DDI function
RMS DDI: Ini
NSDS RMS Driver DDI Protocol V2.1-2
  Negotiated Capability Mask: 0001, Engine Mask: 0001
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_ATTACH_DATABASE
RMS DDI:  Dbkey scope:  TRANSACTION
SQL> set transaction on dms using
cont> (read only reserving dms.hi_record_db for shared read);
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_START_TRANSACTION
RMS DDI:  Access is READ ONLY
RMS DDI:  Wait time 5
*** RMS data driver: VMS version 'V6.2    ', major=6, minor=2
SQL> sh table;
User tables in database with alias DMS
%RDB-F-SYS_REQUEST, error from system services request
-NSDS-E-EXECUTEERROR, Error in query execution in data collection manager
-NSDS-E-NOTRESERVED, Unreserved relation in a transaction with RESERVING clause
SQL> exit;
RMS DDI: Call to DDI function
RMS DDI: NSDS$DDI_ROLLBACK_TRANSACTION
RMS DDI: Call to DDI function
RMS DDI: cleanup_xact
CODMI> log
1125.3Not in the release notes, but...BROKE::WRIGHTNYO&W-Trains Spoken Here-SUSIEQThu Feb 20 1997 09:517
Marga,

I can't find any reference to it in the release notes, but testing indicates
that this was fixed in V3.0A. I would strongly suggest that you upgrade to the
current version which is V3.0E.

					Tom
1125.4V3.0D works too!ORAREP::ELIS::EIJKHOUTTue Feb 25 1997 08:128
    Tom,
    
    We installed V3.0D (which was the latest version we had lying on the
    shelves) and it works perfectly!
    
    Thanks for your help.
    Marga