OLQ 094012 04 The subschema-name subschema cannot be found in the dictionary-name dictionary

Document ID : KB000071597
Last Modified Date : 03/04/2018
Show Technical Document Details
Question:
Trying to sign on to the subschema in OLQ command mode fails with the following message:  

SIG SS subschema-name 
OLQ 094012 04 The subschema-name subschema cannot be found in the DEFAULT dictionary


 
Answer:
Either the subschema source is really not in the default dictionary or OLQ Security is ON and the USER statement in IDD does not include clause:
ACCESS TO SUBSCHEMA subschema-name.

To quickly check, follow these steps:

1. While in OLQ command mode, you can find the available subschemas in the dictionary by issuing the following command:   SHOW SUB


For example: 

User-added image

If you have already verified that the subschema source is indeed in the dictionary but you still get the error message:

OLQ 094012 04 The subschema-name subschema cannot be found in the DEFAULT dictionary

Then most likely it is because OLQ Security is ON and your USER statement in IDD does no t include the ACCESS TO SUBSCHEMA subschema-name clause.

To determine, go into IDD and signon to the dictionary where the subschema source resides.
Issue the command: 

DISPLAY USER user-id. 

Do you see the clause: ACCESS TO SUBSCHEMA subschema-name ?

If not you can modify the USER statement to include the ACCESS TO SUBSCHEMA
clause as follows: 

MOD USER user-id 
ACCESS TO SUBSCHEMA subschema-name OF SCHEMA schema-name VERSION IS version-number.




 

Additional Information:
USER statements

https://support.ca.com/cadocs/0/CA%20IDMS%2018%205%20User%20Bookshelf-ENU/Bookshelf_Files/PDF/IDMS_IDD_DDDL_Ref_ENU.pdf?