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

Document ID : KB000054798
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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


Solution:

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