Oracle Analytics Cloud and Server

Products Banner

Data Sync Error when updating the job

Received Response
22
Views
1
Comments

Summary

Data Sync Error when updating the job

Content

HI There,

 

this is what I got when i tried to update the job. what is this persist error?

 

 

MESSAGE:::persists error: Enterprise Performance Dashboard DEV Cloud Replication Error while trying to create record.

MESSAGE:::INSERT INTO W_ETL_DEFN(ROW_WID, LAST_UPD, NAME, INACTIVE_FLG, KEEP_DATES_FLG, FULL_ETL_FLG, ANALYZE_FLG, ANALYZE_TRUNC_FLG, DRP_CRT_IND_FLG) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

A truncation error was encountered trying to shrink VARCHAR 'Enterprise Performance Dashboard DEV Cloud Replication' to length 50.

Values :

KEY NAME = VALUE

1 = Enterprise Performance Dashboard DEV Cloud Replication

2 = 2018-05-11 11:16:47.992

3 = Enterprise Performance Dashboard DEV Cloud Replication

4 = N

5 = N

6 = N

7 = Y

8 = N

9 = Y

 

 

EXCEPTION CLASS::: com.siebel.etl.database.IllegalSQLQueryException

 

 

com.siebel.etl.database.DBUtils.batchUpdate(DBUtils.java:2759)

com.siebel.etl.gui.util.UncommitUpdateHelper.executeUpdate(UncommitUpdateHelper.java:98)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.performCreate(UpdatableDataObject.java:386)

com.siebel.analytics.etl.client.data.dataobject.DACObject.performCreate(DACObject.java:105)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.create(UpdatableDataObject.java:352)

com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.create(BaseDACObject.java:577)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:211)

com.siebel.analytics.etl.client.data.dataobject.DACObject.createUpdate(DACObject.java:214)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:198)

com.siebel.analytics.etl.client.data.model.ResultSetParser.insertNewRecord(ResultSetParser.java:227)

com.siebel.analytics.etl.client.data.model.UpdatableDataTableModel.insertNewRecord(UpdatableDataTableModel.java:122)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:377)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:360)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:389)

com.siebel.analytics.etl.api.object.DefnObject.persist(DefnObject.java:425)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:298)

com.oracle.metadata.creation.MetadataObjectHelper.createEP(MetadataObjectHelper.java:806)

com.oracle.metadata.creation.MetadataObjectHelper.createMetadata(MetadataObjectHelper.java:547)

com.oracle.metadata.creation.MetadataUtils.createMetadataOfTableSources(MetadataUtils.java:129)

com.siebel.analytics.etl.client.view.table.BasicTable.doOperation(BasicTable.java:1256)

com.siebel.analytics.etl.client.view.table.TableTabTable.doOperation(TableTabTable.java:234)

com.siebel.analytics.etl.client.view.table.BasicTabTable.doOperation(BasicTabTable.java:147)

com.siebel.analytics.etl.client.view.table.BasicSourceTable.doOperation(BasicSourceTable.java:81)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:46)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:61)

java.lang.Thread.run(Thread.java:745)

 

 

::: CAUSE :::

MESSAGE:::A truncation error was encountered trying to shrink VARCHAR 'Enterprise Performance Dashboard DEV Cloud Replication' to length 50.

EXCEPTION CLASS::: java.sql.SQLDataException

 

 

org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)

org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)

org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)

com.siebel.etl.database.cancellable.CancellablePreparedStatement.executeUpdate(CancellablePreparedStatement.java:91)

com.siebel.etl.database.DBUtils.batchUpdate(DBUtils.java:2755)

com.siebel.etl.gui.util.UncommitUpdateHelper.executeUpdate(UncommitUpdateHelper.java:98)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.performCreate(UpdatableDataObject.java:386)

com.siebel.analytics.etl.client.data.dataobject.DACObject.performCreate(DACObject.java:105)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.create(UpdatableDataObject.java:352)

com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.create(BaseDACObject.java:577)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:211)

com.siebel.analytics.etl.client.data.dataobject.DACObject.createUpdate(DACObject.java:214)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:198)

com.siebel.analytics.etl.client.data.model.ResultSetParser.insertNewRecord(ResultSetParser.java:227)

com.siebel.analytics.etl.client.data.model.UpdatableDataTableModel.insertNewRecord(UpdatableDataTableModel.java:122)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:377)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:360)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:389)

com.siebel.analytics.etl.api.object.DefnObject.persist(DefnObject.java:425)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:298)

com.oracle.metadata.creation.MetadataObjectHelper.createEP(MetadataObjectHelper.java:806)

com.oracle.metadata.creation.MetadataObjectHelper.createMetadata(MetadataObjectHelper.java:547)

com.oracle.metadata.creation.MetadataUtils.createMetadataOfTableSources(MetadataUtils.java:129)

com.siebel.analytics.etl.client.view.table.BasicTable.doOperation(BasicTable.java:1256)

com.siebel.analytics.etl.client.view.table.TableTabTable.doOperation(TableTabTable.java:234)

com.siebel.analytics.etl.client.view.table.BasicTabTable.doOperation(BasicTabTable.java:147)

com.siebel.analytics.etl.client.view.table.BasicSourceTable.doOperation(BasicSourceTable.java:81)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:46)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:61)

java.lang.Thread.run(Thread.java:745)

 

 

::: CAUSE :::

MESSAGE:::A truncation error was encountered trying to shrink VARCHAR 'Enterprise Performance Dashboard DEV Cloud Replication' to length 50.

EXCEPTION CLASS::: org.apache.derby.client.am.SqlException

 

 

org.apache.derby.client.am.Statement.completeExecute(Unknown Source)

org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)

org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)

org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)

org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)

org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)

org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)

org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source)

org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)

com.siebel.etl.database.cancellable.CancellablePreparedStatement.executeUpdate(CancellablePreparedStatement.java:91)

com.siebel.etl.database.DBUtils.batchUpdate(DBUtils.java:2755)

com.siebel.etl.gui.util.UncommitUpdateHelper.executeUpdate(UncommitUpdateHelper.java:98)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.performCreate(UpdatableDataObject.java:386)

com.siebel.analytics.etl.client.data.dataobject.DACObject.performCreate(DACObject.java:105)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.create(UpdatableDataObject.java:352)

com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.create(BaseDACObject.java:577)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:211)

com.siebel.analytics.etl.client.data.dataobject.DACObject.createUpdate(DACObject.java:214)

com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:198)

com.siebel.analytics.etl.client.data.model.ResultSetParser.insertNewRecord(ResultSetParser.java:227)

com.siebel.analytics.etl.client.data.model.UpdatableDataTableModel.insertNewRecord(UpdatableDataTableModel.java:122)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:377)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:360)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:389)

com.siebel.analytics.etl.api.object.DefnObject.persist(DefnObject.java:425)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:298)

com.oracle.metadata.creation.MetadataObjectHelper.createEP(MetadataObjectHelper.java:806)

com.oracle.metadata.creation.MetadataObjectHelper.createMetadata(MetadataObjectHelper.java:547)

com.oracle.metadata.creation.MetadataUtils.createMetadataOfTableSources(MetadataUtils.java:129)

com.siebel.analytics.etl.client.view.table.BasicTable.doOperation(BasicTable.java:1256)

com.siebel.analytics.etl.client.view.table.TableTabTable.doOperation(TableTabTable.java:234)

com.siebel.analytics.etl.client.view.table.BasicTabTable.doOperation(BasicTabTable.java:147)

com.siebel.analytics.etl.client.view.table.BasicSourceTable.doOperation(BasicSourceTable.java:81)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:46)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:61)

java.lang.Thread.run(Thread.java:745)Error while inserting a record!

EXCEPTION CLASS::: com.siebel.analytics.etl.api.exception.BaseAPIException

 

 

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:418)

com.siebel.analytics.etl.api.object.DefnObject.persist(DefnObject.java:425)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:298)

com.oracle.metadata.creation.MetadataObjectHelper.createEP(MetadataObjectHelper.java:806)

com.oracle.metadata.creation.MetadataObjectHelper.createMetadata(MetadataObjectHelper.java:547)

com.oracle.metadata.creation.MetadataUtils.createMetadataOfTableSources(MetadataUtils.java:129)

com.siebel.analytics.etl.client.view.table.BasicTable.doOperation(BasicTable.java:1256)

com.siebel.analytics.etl.client.view.table.TableTabTable.doOperation(TableTabTable.java:234)

com.siebel.analytics.etl.client.view.table.BasicTabTable.doOperation(BasicTabTable.java:147)

com.siebel.analytics.etl.client.view.table.BasicSourceTable.doOperation(BasicSourceTable.java:81)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:46)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:61)

java.lang.Thread.run(Thread.java:745)

 

 

::: CAUSE :::

MESSAGE:::Error while inserting a record!

EXCEPTION CLASS::: com.siebel.etl.gui.core.RecordManipulationException

 

 

com.siebel.analytics.etl.client.core.DACMessage.convertToRME(DACMessage.java:31)

com.siebel.analytics.etl.client.data.model.UpdatableDataTableModel.insertNewRecord(UpdatableDataTableModel.java:124)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:377)

com.siebel.analytics.etl.client.data.model.DACTableModel.insertNewRecord(DACTableModel.java:360)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:389)

com.siebel.analytics.etl.api.object.DefnObject.persist(DefnObject.java:425)

com.siebel.analytics.etl.api.object.BaseAPIObject.persist(BaseAPIObject.java:298)

com.oracle.metadata.creation.MetadataObjectHelper.createEP(MetadataObjectHelper.java:806)

com.oracle.metadata.creation.MetadataObjectHelper.createMetadata(MetadataObjectHelper.java:547)

com.oracle.metadata.creation.MetadataUtils.createMetadataOfTableSources(MetadataUtils.java:129)

com.siebel.analytics.etl.client.view.table.BasicTable.doOperation(BasicTable.java:1256)

com.siebel.analytics.etl.client.view.table.TableTabTable.doOperation(TableTabTable.java:234)

com.siebel.analytics.etl.client.view.table.BasicTabTable.doOperation(BasicTabTable.java:147)

com.siebel.analytics.etl.client.view.table.BasicSourceTable.doOperation(BasicSourceTable.java:81)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:46)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:61)

java.lang.Thread.run(Thread.java:745)

Answers