java.lang.RuntimeException

data-import for ./admin.profile.xml failed

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web50

  • via Unknown by Eric Dalquist,
  • via Unknown by Eric Dalquist,
  • Stack trace

    • java.lang.RuntimeException: data-import for ./admin.profile.xml failed at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) at upshell_270242091.run(upshell_270242091.groovy:13) at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) at groovy.lang.GroovyShell.run(GroovyShell.java:229) at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: Origin Document: jar:file:/home/edalquist/.m2/repository/org/jasig/portal/uportal-war/4.0.2-SNAPSHOT/uportal-war-4.0.2-SNAPSHOT-classes.jar!/org/jasig/portal/io/import-profile_v3-2.crn Source: /with/subtasks/with/subtasks/sql-transaction/sql-query/subtasks
    • ode-iterator[2]/sql-upsert Entity Name: <sql-upsert> at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:93) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) at org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) at org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58) at org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193) at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1421) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:685) at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) at org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40) at org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) at org.danann.cernunnos.runtime.PojoTask.perform(PojoTask.java:202) at org.jasig.portal.io.xml.crn.CernunnosDataImporter.importDataElement(CernunnosDataImporter.java:59) at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86) at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53) at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518) at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481) at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448) at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426) at org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) at upshell_270242091.run(upshell_270242091.groovy:10) ... 3 more Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ UPDATE up_ss_user_parm SET param_val = ? WHERE user_id = ? AND profile_id = ? AND ss_id = ? AND ss_type = 2 AND param_name = ? ]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867) at org.danann.cernunnos.sql.UpsertTask.doUpdate(UpsertTask.java:167) at org.danann.cernunnos.sql.UpsertTask.perform(UpsertTask.java:147) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) ... 50 more Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74) at $Proxy94.prepareStatement(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) ... 55 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    pradhulpradhul
    7 times, last one
    Unknown visitor
    Unknown visitorOnce,