Policy store failed operation 'MultipleSearch' for object type 'IMSOptionList'. Table or view not found. Error code -1056 (Legacy_Onyx KB Id: 175220)
search cancel

Policy store failed operation 'MultipleSearch' for object type 'IMSOptionList'. Table or view not found. Error code -1056 (Legacy_Onyx KB Id: 175220)

book

Article ID: 54798

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

The following error is seen in the auth log when IdentityMinder is trying to connect to the policy server.

[24/Aug/2004:20:09:51 0000][1-IMSObjModuleLoader] IMSObjModuleLoader:getIMSObjModuleHandle() - succeeded
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSDirectory' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSDirectory' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-E] Policy store failed operation 'MultipleSearch' for object type 'IMSDirectory'. Table or view not found. Error code -1056
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSEnvironment' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSEnvironment' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-E] Policy store failed operation 'MultipleSearch' for object type 'IMSEnvironment'. Table or view not found. Error code -1056
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSOptionList' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Searching for object 'IMSOptionList' in domain '0a-00000000-0000-0000-0000-000000000000(0 props)
[24/Aug/2004:20:09:51 0000][1-E] Policy store failed operation 'MultipleSearch' for object type 'IMSOptionList'. Table or view not found. Error code -1056
[24/Aug/2004:20:09:51 0000][1-SmObjProvider] Fetching object 'Admin' 12-0002d483-1b71-1119-995f-832f9d94fd21

Environment

Release:
Component: IDMIND

Resolution

The oracle script needs to be run on your policy store.

From installion guide:

IdentityMinder Web Edition Installation Guide for JBoss
Configuring an SQL Database as a Policy Store
If you are using an SQL database as the policy store, extend the policy store
schema for IdentityMinder:
1. See "Storing SiteMinder data in an Oracle or SQL Server database" in the
Netegrity Policy Server Installation Guide.
Starting IdentityMinder 41
2. On systems where you installed the Netegrity Policy Server Extensions for
IdentityMinder, run one of the following SQL scripts for IdentityMinder:
- For Windows: &ltpolicyserver_inst_dir>\Netegrity\Site-
Minder\Db\Sql\ims_mssql_ps.sql
- For UNIX: &ltpolicyserver_inst_dir>/netegrity/siteminder/
db/SQL/ims_oracle_ps.sql