nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

unable to update SDT in BAM database

anujgarg

hi all,

we are using BAM 6.6

whenever we are creating a new SDT and updating it in the BAM database then we are able to see it in the PRS to create report but while saving the new report after configuring it we get an error stating that the report contains an attribute that does not exist in the repository.

i verified that that BAM is up and running .

Can anyone please help in this.

Thanks in advance,

anuj garg

Find more posts tagged with

Comments

Imran_Yusubov

Hi,

We are facing similar problems too.

From task space you can delete sdt tables from bam database and recreate it?Have you tried it?

But in our environment we can delete and recreate some sdt-s but a few sdt-s can't be re created or updated.

shp_boris

Hi,

Can you please supply the complete trace of the error stating "report contains an attribute that does not exist in the repository"

Can you please elaborate more on "saving the new report after configuring it" ?

Meaning, which steps exactly you are executing and in which order ?

D9103546-enUmQ

I am having the same issue and I am using BAM 6.7. Below is the error message -

When i created a new database and created BAM tables, it worked fine initially and all of a sudden, it stopped updating SDT's. I followed what Imran said in his post (delete and recreate sdt tables from taskspace administration). Can anyone please help?

03 Nov 2011 17:11:01 ERROR [QUARTZ_Worker-23] org.quartz.core.ErrorLogger - Job (DCTM.DCTMPackagePipe threw an exception.

org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

--- The error occurred in config/application/bam-sql-map-daos.xml.

--- The error occurred while applying a parameter map.

--- Check the getDataFieldDefinition-InlineParameterMap.

--- Check the parameter mapping for the 'tableName' property.

--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/application/bam-sql-map-daos.xml.

--- The error occurred while applying a parameter map.

--- Check the getDataFieldDefinition-InlineParameterMap.

--- Check the parameter mapping for the 'tableName' property.

--- Cause: java.lang.NullPointerException]

at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)

Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

--- The error occurred in config/application/bam-sql-map-daos.xml.

--- The error occurred while applying a parameter map.

--- Check the getDataFieldDefinition-InlineParameterMap.

--- Check the parameter mapping for the 'tableName' property.

--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/application/bam-sql-map-daos.xml.

--- The error occurred while applying a parameter map.

--- Check the getDataFieldDefinition-InlineParameterMap.

--- Check the parameter mapping for the 'tableName' property.

--- Cause: java.lang.NullPointerException

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)

at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)

at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)

at com.emc.documentum.bpm.daos.impl.AbstractIbatisBaseDaoImpl.queryForList(AbstractIbatisBaseDaoImpl.java:75)

at com.emc.documentum.bpm.bamengine.daos.impl.FieldsDefinitionDaoImpl.getDataFieldsDefinition(FieldsDefinitionDaoImpl.java:51)

at sun.reflect.GeneratedMethodAccessor219.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)

at $Proxy73.getDataFieldsDefinition(Unknown Source)

at com.emc.documentum.bpm.bamengine.services.sharedservices.impl.BamDataDefinitionServiceImpl.getDataFieldsDefinitionByTableName(BamDataDefinitionServiceImpl.java:71)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.PackagePipeHelperServiceImpl.formatPackageFields(PackagePipeHelperServiceImpl.java:120)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.PackagePipeHelperServiceImpl.formatElements(PackagePipeHelperServiceImpl.java:76)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.PackagePipeHelperServiceImpl.getBOListFromXml(PackagePipeHelperServiceImpl.java:54)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.PackagePipeHelperServiceImpl.getUpdatedBOList(PackagePipeHelperServiceImpl.java:44)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.DctmPackagePipeImpl.getPipeBusunessDataEventsList(DctmPackagePipeImpl.java:96)

at com.emc.documentum.bpm.bamengine.services.pipe.impl.DctmPackagePipeImpl.pipe(DctmPackagePipeImpl.java:41)

at com.emc.documentum.bpm.bamengine.services.sharedservices.impl.TaskManagerServiceImpl.doPipe(TaskManagerServiceImpl.java:1126)

at com.emc.documentum.bpm.bamengine.services.sharedservices.impl.TaskManagerServiceImpl.executePackagePipe(TaskManagerServiceImpl.java:1049)

at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)

at $Proxy75.executePackagePipe(Unknown Source)

at com.emc.documentum.bpm.bamengine.scheduler.impl.PackagePipeJobImpl.execute(PackagePipeJobImpl.java:16)

at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

... 1 more

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/application/bam-sql-map-daos.xml.

--- The error occurred while applying a parameter map.

--- Check the getDataFieldDefinition-InlineParameterMap.

--- Check the parameter mapping for the 'tableName' property.

--- Cause: java.lang.NullPointerException

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:204)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)

at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)

... 28 more

Caused by: java.lang.NullPointerException

at com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(Unknown Source)

at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)

at com.microsoft.sqlserver.jdbc.AppDTVImpl.setValue(Unknown Source)

at com.microsoft.sqlserver.jdbc.DTV.setValue(Unknown Source)

at com.microsoft.sqlserver.jdbc.Parameter.setValue(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setNull(Unknown Source)

at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:105)

at com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameter(ParameterMap.java:172)

at com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameters(ParameterMap.java:126)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:183)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)

... 34 more