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");

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.