Sailpoint Notes
========================================================================
Sailpoint API
Software on Linux
Documents for installing/configuration
Certification matrix
DB config for IIQ 6.4 & & 7.0 & 7.1
1) Application onboarding using CSV files
2) Application onboarding using LDAP
Notes:
identity attribute - unique data
Everything is in sailpoint is object
FAQs:
Total how many web consoles are there? Document for Jconsole ?
What is " j " option in below script
./iiq console -j
How to take backup of existing configuration?
How to edit source mappings
How you can start the development directly from the production server or test server what is the approach you follow?
How can we provide the administration capabilities to a specific user?
Admin Password Reset? / Forgot password?
Alternative preview option for attributes? instead of preview option?
Who will decide that how many roles need to be created in the organization?
How to take backup of the UIConfig xml file? location? I guess we can't keep multiple files content in files manually.
SailPoint Checklist before onboarding?
When you create DB tables by default it will create some columns.
What if the CSV column is not there at the DB table while application onboarding?
While customizing something went wrong how to troubleshooting? logs location?
How can we transfer the Implementation code from Test to Prod?
Deployment of custom J2EE application?
Log4j Configuration?
Troubleshooting
Error:1
When giving the CSV patch and do the Test Connection, am receiving below error
Unable to open filestream for file: C:\Backup_Drive\Training\SailPoint\AuthEmployees.csv
Solution:
Check the files copied locally
Error: 2
While loading init.xml file with script ( ex: ./iiq console )
2017-07-01 22:44:27,603 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 933, SQLState: 42000
2017-07-01 22:44:27,604 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-00933: SQL command not properly ended
> 2017-07-01 22:44:28,871 ERROR ServerThread hibernate.id.enhanced.TableStructure:181 - could not read a hi value
java.sql.SQLSyntaxErrorException: ORA-02201: sequence not allowed here
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:171)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:61)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:249)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:70)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:74)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:131)
at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:191)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:346)
at sailpoint.persistence.SPSequenceStyleGenerator.generate(SPSequenceStyleGenerator.java:81)
at sailpoint.persistence.Sequencer.generateId(Sequencer.java:139)
at sailpoint.api.logging.SyslogAppender.append(SyslogAppender.java:102)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:206)
at org.apache.log4j.Category.forcedLog(Category.java:391)
at org.apache.log4j.Category.log(Category.java:856)
at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:218)
at sailpoint.api.Explanator.checkRefresh(Explanator.java:893)
at sailpoint.server.CacheService.execute(CacheService.java:235)
at sailpoint.server.Servicer.execute(Servicer.java:937)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
2017-07-01 22:44:28,877 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 2201, SQLState: 42000
2017-07-01 22:44:28,877 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-02201: sequence not allowed here
2017-07-01 22:44:27,606 ERROR ServerThread sailpoint.api.Explanator:893 - Unable to check cache refresh
2017-07-01 22:44:28,881 ERROR ServerThread hibernate.id.enhanced.TableStructure:181 - could not read a hi value
java.sql.SQLSyntaxErrorException: ORA-02201: sequence not allowed here
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:171)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:61)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:249)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:70)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:74)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:131)
at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:191)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:346)
at sailpoint.persistence.SPSequenceStyleGenerator.generate(SPSequenceStyleGenerator.java:81)
at sailpoint.persistence.Sequencer.generateId(Sequencer.java:139)
at sailpoint.api.logging.SyslogAppender.append(SyslogAppender.java:102)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:206)
at org.apache.log4j.Category.forcedLog(Category.java:391)
at org.apache.log4j.Category.log(Category.java:856)
at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:218)
at sailpoint.api.Explanator.checkRefresh(Explanator.java:894)
at sailpoint.server.CacheService.execute(CacheService.java:235)
at sailpoint.server.Servicer.execute(Servicer.java:937)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
2017-07-01 22:44:28,884 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 2201, SQLState: 42000
2017-07-01 22:44:28,884 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-02201: sequence not allowed here
2017-07-01 22:44:28,879 ERROR ServerThread sailpoint.api.Explanator:894 - sailpoint.tools.GeneralException: could not execute query using iterate
2017-07-01 22:44:28,943 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 933, SQLState: 42000
2017-07-01 22:44:28,943 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-00933: SQL command not properly ended
2017-07-01 22:44:28,949 ERROR ServerThread hibernate.id.enhanced.TableStructure:181 - could not read a hi value
java.sql.SQLSyntaxErrorException: ORA-02201: sequence not allowed here
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:171)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:61)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:249)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:70)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:74)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:131)
at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:191)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:346)
at sailpoint.persistence.SPSequenceStyleGenerator.generate(SPSequenceStyleGenerator.java:81)
at sailpoint.persistence.Sequencer.generateId(Sequencer.java:139)
at sailpoint.api.logging.SyslogAppender.append(SyslogAppender.java:102)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:206)
at org.apache.log4j.Category.forcedLog(Category.java:391)
at org.apache.log4j.Category.log(Category.java:856)
at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:218)
at sailpoint.server.Servicer.execute(Servicer.java:940)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
2017-07-01 22:44:28,954 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 2201, SQLState: 42000
2017-07-01 22:44:28,954 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-02201: sequence not allowed here
2017-07-01 22:44:28,943 ERROR ServerThread sailpoint.server.Servicer:940 - Unable to execute service: Cache
2017-07-01 22:44:28,963 ERROR ServerThread hibernate.id.enhanced.TableStructure:181 - could not read a hi value
java.sql.SQLSyntaxErrorException: ORA-02201: sequence not allowed here
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:171)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:61)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:249)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:70)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:74)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:131)
at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:191)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:346)
at sailpoint.persistence.SPSequenceStyleGenerator.generate(SPSequenceStyleGenerator.java:81)
at sailpoint.persistence.Sequencer.generateId(Sequencer.java:139)
at sailpoint.api.logging.SyslogAppender.append(SyslogAppender.java:102)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:206)
at org.apache.log4j.Category.forcedLog(Category.java:391)
at org.apache.log4j.Category.log(Category.java:856)
at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:218)
at sailpoint.server.Servicer.execute(Servicer.java:941)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
2017-07-01 22:44:28,971 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 2201, SQLState: 42000
2017-07-01 22:44:28,971 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-02201: sequence not allowed here
2017-07-01 22:44:28,961 ERROR ServerThread sailpoint.server.Servicer:941 - sailpoint.tools.GeneralException: could not execute query using iterate
2017-07-01 22:44:28,979 ERROR ServerThread hibernate.id.enhanced.TableStructure:181 - could not read a hi value
java.sql.SQLSyntaxErrorException: ORA-02201: sequence not allowed here
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:171)
at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:61)
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:249)
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:70)
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:74)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:131)
at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:191)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:346)
at sailpoint.persistence.SPSequenceStyleGenerator.generate(SPSequenceStyleGenerator.java:81)
at sailpoint.persistence.Sequencer.generateId(Sequencer.java:139)
at sailpoint.api.logging.SyslogAppender.append(SyslogAppender.java:102)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:206)
at org.apache.log4j.Category.forcedLog(Category.java:391)
at org.apache.log4j.Category.log(Category.java:856)
at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:218)
at sailpoint.server.Servicer.execute(Servicer.java:942)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
2017-07-01 22:44:28,983 WARN ServerThread org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 2201, SQLState: 42000
2017-07-01 22:44:28,983 ERROR ServerThread org.hibernate.util.JDBCExceptionReporter:101 - ORA-02201: sequence not allowed here
2017-07-01 22:44:28,974 ERROR ServerThread sailpoint.server.Servicer:942 - sailpoint.tools.GeneralException: could not execute query using iterate
at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2028)
at sailpoint.persistence.ClassPersistenceManager.search(ClassPersistenceManager.java:334)
at sailpoint.server.InternalContext.search(InternalContext.java:853)
at sailpoint.server.AbstractSailPointContext.search(AbstractSailPointContext.java:288)
at sailpoint.api.CorrelationModel.getLastDate(CorrelationModel.java:381)
at sailpoint.api.CorrelationModel.getLastMod(CorrelationModel.java:355)
at sailpoint.api.CorrelationModel.<init>(CorrelationModel.java:245)
at sailpoint.api.CorrelationModel.refresh(CorrelationModel.java:229)
at sailpoint.server.CacheService.execute(CacheService.java:241)
at sailpoint.server.Servicer.execute(Servicer.java:937)
at sailpoint.server.Servicer.processServices(Servicer.java:899)
at sailpoint.server.Servicer.run(Servicer.java:653)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:496)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:405)
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:248)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1329)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2022)
... 11 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:472)
Solution:
Check the .oracle scripts generated after ./iiq schema
Uncomment the DATAFILE location and other parameters which are marked as red from create_identityiq_tables-7.1.oracle script
Ex:
--
-- The DATAFILE location must be modified to match your environment.
-- Because of this, these commands are commented out in this script.
--
--
-- CREATE BIGFILE TABLESPACE identityiq_ts
-- DATAFILE '/usr/local/oradata/identityiq.dbf' SIZE 1G
-- AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED
-- EXTENT MANAGEMENT LOCAL;
--
-- CREATE USER identityiq IDENTIFIED BY identityiq
-- DEFAULT TABLESPACE identityiq_ts
-- QUOTA UNLIMITED ON identityiq_ts;
--
-- GRANT CREATE SESSION to identityiq;
-- GRANT CREATE TABLE to identityiq;
--
-- The DATAFILE location must be modified to match your environment.
-- Because of this, these commands are commented out in this script.
--
--
-- CREATE BIGFILE TABLESPACE identityiqPlugin_ts
-- DATAFILE '/usr/local/oradata/identityiqPlugin.dbf' SIZE 128M
-- AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED
-- EXTENT MANAGEMENT LOCAL;
--
-- CREATE USER identityiqPlugin IDENTIFIED BY identityiqPlugin
-- DEFAULT TABLESPACE identityiqPlugin_ts
-- QUOTA UNLIMITED ON identityiqPlugin_ts;
--
-- GRANT CREATE SESSION to identityiqPlugin;
-- GRANT CREATE TABLE to identityiqPlugin;
--
-- A hint submitted by a user: Oracle DB MUST be created as "shared" and the
-- job_queue_processes parameter must be greater than 2, otherwise a DB lock
-- will happen. However, these settings are pretty much standard after any
-- Oracle install, so most users need not worry about this.
--
-- IdentityIQ NOTES
--
-- Since things like Application names can make their way into TaskSchedule
-- object names we have to be careful with the sizes of various Quartz name
-- columns. The original size was 80, this has been raised to 2000. The
-- maximum size of a varchar2 in Oracle is 4000.
--
Error: 3
Permgen issue
02-Jul-2017 01:00:49.380 SEVERE [Catalina-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectories Error waiting for multi-thread deployment of directories to complete
java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: PermGen space
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:188)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1025)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:409)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1551)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:284)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:395)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:339)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:956)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:872)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.OutOfMemoryError: PermGen space
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2277)
at org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:811)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1254)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
at org.apache.catalina.util.Introspection.loadClass(Introspection.java:153)
at org.apache.catalina.startup.ContextConfig.checkHandlesTypes(ContextConfig.java:2118)
at org.apache.catalina.startup.ContextConfig.processAnnotationsStream(ContextConfig.java:2054)
at org.apache.catalina.startup.ContextConfig.processAnnotationsWebResource(ContextConfig.java:1952)
at org.apache.catalina.startup.ContextConfig.processAnnotationsWebResource(ContextConfig.java:1946)
at org.apache.catalina.startup.ContextConfig.webConfig(ContextConfig.java:1153)
at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:775)
at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:299)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5105)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1107)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1841)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
... 4 more
Exception in thread "main"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "main"
2017-07-02 01:01:36,859 WARN ServerThread sailpoint.server.HeartbeatService:340 - Servers missed a heartbeat: [sailpointiiq.example.com]
Solution:
Go to Apache Tomcat /bin directory.
By default you wont see setenv.sh (for Linux/Mac) or setenv.bat (for windows) file under /bin directory. You have to create one with below parameters.
setenv.sh
export CATALINA_OPTS="$CATALINA_OPTS -Xms512m"
export CATALINA_OPTS="$CATALINA_OPTS -Xmx8192m"
export CATALINA_OPTS="$CATALINA_OPTS -XX:MaxPermSize=512m"
Go to command prompt.
Go to <Tomcat Directory>/bin directory
Execute command: ./catalina.sh run
Monitor logfile and you should see your Tomcat started with all your specified parameters in setenv.sh file.
Error 4:
Exception during aggregation of 1a. Reason: BeanShell script error: bsh.EvalError: Sourced file: inline evaluation of: ``import sailpoint.object.identity; identity.setPassword('Welcome1");'' Token Parsing Error: Lexical error at line 2, column 24. Encountered: "e" (101), after : "\'W" : at Line: 1 : in file: inline evaluation of: ``import sailpoint.object.identity; identity.setPassword('Welcome1");'' : import sailpoint .object .identity ; BSF info: Password for AuthEmployees at line: 0 column: columnNo
Solution:
Its unable to parse, because the string given below not matched with double quotes
identity.setPassword('Welcome1");
Error 4:
Exception during aggregation of 1a. Reason: BeanShell script error: bsh.EvalError: Sourced file: inline evaluation of: ``import sailpoint.object.identity; identity.setPassword('Welcome1");'' Token Parsing Error: Lexical error at line 2, column 24. Encountered: "e" (101), after : "\'W" : at Line: 1 : in file: inline evaluation of: ``import sailpoint.object.identity; identity.setPassword('Welcome1");'' : import sailpoint .object .identity ; BSF info: Password for AuthEmployees at line: 0 column: columnNo
Solution:
Its unable to parse, because the string given below not matched with double quotes
identity.setPassword('Welcome1");
Job Description:
1.Good knowledge of existing SailPoint APIs and implementation experience of these APIs in LCM workflows, tasks, rules, SailPoint report and task development.
2.Create JAVA Bean Shell rules for each of the above applications to ensure entitlements are properly identified, marked up and displayed within the application: Skill (Java Bean Shell, knowledge of SailPoint Java Objects exposed through application)
3.Application integration in SailPoint IIQ using different types of connectors. Development experience of various connector rules like build map rule, customization rule, pre-iterate rule etc.
4. Deliver identity management consulting services including client interaction, design, architecture, and interaction with offshore teams.
5.Support business and technology strategy and planning by leveraging knowledge in both technical and business areas
6.Communicating to clients aspects of SailPoint IIQ at appropriate functional and technical level for the client audience.
7.Demonstrate ability to gather IAG, Certification solution requirements and develop analysis and design documentation
8.Working with clients to support user acceptance testing, debugging and migration to production environment
9.Managing project scope, schedule, status and documentation
10.Designing and Deploying SailPoint IIQ Connectors for various target systems
11.Developing and delivering SailPoint IIQ technical training designed to enable/educate client IT resources.
Role Summary/Purpose:
This position is responsible for developing and supporting a third party application SailPoint Identity IQ and Life Cycle Manager (LCM) This individual will need to be on-site to provide necessary project development and service maintenance for this deployed application. This individual needs to have experience in the development and support of this third party application. We are looking for someone that has experience for version 5.1 – 6.2. This position will be directing other Sailpoint developers so leadership and drive are key qualities.
Essential Responsibilities:
• Good knowledge of existing SailPoint APIs and implementation experience of these APIs in LCM workflows, tasks, rules, SailPoint report and task development.
• Create JAVA Bean Shell rules for each of the above applications to ensure entitlements are properly identified, marked up and displayed within the application: Skill (Java Bean Shell, knowledge of SailPoint Java Objects exposed through application)
• Application integration in SailPoint IIQ using different types of connectors. Development experience of various connector rules like build map rule, customization rule, pre-iterate rule etc.
• Knowledge of SailPoint access certification process and various rules like pre-delegation, exclusion, etc for access certification customization
• Edit Email templates to be business friendly: Skill (XML, HTML)along with IIQ Task Tuning
• Create Aggregation Tasks within IIQ: Skill (IIQ Configuration, Bean Shell)
• Tune Aggregation Tasks: Skill (IIQ Configuration, Bean Shell, knowledge of applications task is leveraging)
• LCM form and workflow design and development experience in SailPoint IIQ.
• Design and development of quicklinks, workflow, forms, rules and email templates to implement a complex business process in IIQ.
• LCM provisioning using Integration Config and custom Java code to various application repositories (LDAP(TDS, AD), JDBC Databases etc)
• JAVA
• LDAP – (Active Directory, Tivoli Directory Server(TDS)) concepts and tree structure knowledge
• XML
• JDBC (DB2, Oracle, SQL,IMS) concepts
• UNIX commands – basic administration
• Subversion(SVN) – check in and check out processes
• Tomcat
• ANT deployment knowledge
• Scripting experience
Qualifications/Requirements:
Minimum 5 + years of experience in SailPoint Identity IQ and Life Cycle Manager (LCM)
For internal candidates 18 months in SYF and 12 months in current role
Should not be on active formal corrective or PIP
Desired Characteristics:
Handled large teams
Understanding of BFSI Domain
Grade/Level: 10
Hyderabad Job1:
Job Description:
Job Description Send me Jobs like this
Role Summary/ Purpose
This successful candidate, under the supervision of team lead, will be responsible for requirements analysis, design of IdM Resource Adapters (RA), development, release management and integration testing. IdM Developer will analyze Change Requests and Problem/Incident tickets, provide LOE estimates, attend system requirements reviews, JAD /RAD sessions, create technical documentation, and provide support to system testing team.
Essential Responsibilities
Responsible for IdM RA Development, Enhancements and bug fixes Responsible for handling Release Management
Automating provisioning/ de-provisioning and reconciliation processes
Participate in Projects and initiatives in support of regulatory, audit and IdM directives.
Working closely with Corporate IdM and Retail Finance IdM Infrastructure & Operations Support teams as and when necessary.
Participation in status review meetings
Support and train other team members with Provisioning/ LifeCycle Management systems such as Sun IdM, Sailpoint IIQ .
Desired Candidate Profile
Qualifications/Requirements
Minimum of 4 -5 years of Information Technology experience
Must have hands-on integration and deployment experience with Sun IdM and Sailpoint IIQ systems
Hands-on experience with development of complex forms, work flows, custom tasks and resource adapters
Experience with programming languages such as Java, XML and HTML
Basic understanding of SQL statements
Must have proven strong analytical and problem solving skills
Experience with working with remote teams
Desired Characteristics
Working knowledge of Mainframe, AS400, UNIX and Active Directory
An understanding of Six Sigma tools and processes
Strong oral and written communication skills
Strong interpersonal skills
Strong strategic thinking skills.
Desired Candidate Profile
Qualifications/Requirements
Minimum of 4 -5 years of Information Technology experience
Must have hands-on integration and deployment experience with Sun IdM and Sailpoint IIQ systems
Hands-on experience with development of complex forms, work flows, custom tasks and resource adapters
Experience with programming languages such as Java, XML and HTML
Basic understanding of SQL statements
Must have proven strong analytical and problem solving skills
Experience with working with remote teams
Desired Characteristics
Working knowledge of Mainframe, AS400, UNIX and Active Directory
An understanding of Six Sigma tools and processes
Strong oral and written communication skills
Strong interpersonal skills
Strong strategic thinking skills.
