Error during Relation-Update

Pulse Pulse Questions
1

Hi,

I started the Documentation and got every time the following messages in the log-file:

2022-12-29 17:43:41	INFO 	Documenter	Relationships documentation started for: servername\instancename
2022-12-29 17:43:41	INFO 	RelationshipDocumenter	servername Current version of Relationships for instancename is: 6.1.3
2022-12-29 17:43:41	INFO 	RelationshipDocumenter	servername Relationships for instancename are currently in the last version
2022-12-29 17:43:45	ERROR	RelationshipDocumenter	Unable to update relationships
org.jooq.exception.DataAccessException: SQL [insert into "PUBLIC"."Relation" ("ServerName", "ServiceName", "SourceName", "SourceType", "TargetName", "TargetType", "CubeGets", "Feeders", "CubePuts", "AttributeGets", "AttributePuts", "IsDeleted", "DeleteDate", "UpdateStamp") values (cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as boolean), cast(? as timestamp), cast(? as timestamp))]; Wert zu gross / lang für Feld """TargetName"" VARCHAR_IGNORECASE(250)": "CAST('S_ProzessInfo'';nProcessStartTime=Now();nProcessFinishTime=0;nMetaDataRecordCount=0;nDataRecordCount=0;nActualMetaDataReco... (257)"
Value too long for column """TargetName"" VARCHAR_IGNORECASE(250)": "CAST('S_ProzessInfo'';nProcessStartTime=Now();nProcessFinishTime=0;nMetaDataRecordCount=0;nDataRecordCount=0;nActualMetaDataReco... (257)"; SQL statement:
insert into "PUBLIC"."Relation" ("ServerName", "ServiceName", "SourceName", "SourceType", "TargetName", "TargetType", "CubeGets", "Feeders", "CubePuts", "AttributeGets", "AttributePuts", "IsDeleted", "DeleteDate", "UpdateStamp") values (cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as boolean), cast(? as timestamp), cast(? as timestamp)) [22001-177]
	at org.jooq.impl.Utils.translate(Utils.java:1078) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.UpdatableRecordImpl.storeInsert(UpdatableRecordImpl.java:172) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:135) ~[jooq-3.1.0.jar:?]
	at com.cubewise.D.a(SourceFile:169) ~[pulse.jar:6.1.3]
	at com.cubewise.D.a(SourceFile:74) ~[pulse.jar:6.1.3]
	at com.cubewise.t.a(SourceFile:230) ~[pulse.jar:6.1.3]
	at com.cubewise.w.run(SourceFile:1093) ~[pulse.jar:6.1.3]
	at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_342]
Caused by: org.h2.jdbc.JdbcSQLException: Wert zu gross / lang für Feld """TargetName"" VARCHAR_IGNORECASE(250)": "CAST('S_ProzessInfo'';nProcessStartTime=Now();nProcessFinishTime=0;nMetaDataRecordCount=0;nDataRecordCount=0;nActualMetaDataReco... (257)"
Value too long for column """TargetName"" VARCHAR_IGNORECASE(250)": "CAST('S_ProzessInfo'';nProcessStartTime=Now();nProcessFinishTime=0;nMetaDataRecordCount=0;nDataRecordCount=0;nActualMetaDataReco... (257)"; SQL statement:
insert into "PUBLIC"."Relation" ("ServerName", "ServiceName", "SourceName", "SourceType", "TargetName", "TargetType", "CubeGets", "Feeders", "CubePuts", "AttributeGets", "AttributePuts", "IsDeleted", "DeleteDate", "UpdateStamp") values (cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as boolean), cast(? as timestamp), cast(? as timestamp)) [22001-177]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.message.DbException.get(DbException.java:178) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.table.Column.validateConvertUpdateSequence(Column.java:332) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.command.dml.Insert.insertRows(Insert.java:152) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.command.dml.Insert.update(Insert.java:115) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.command.CommandContainer.update(CommandContainer.java:79) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.command.Command.executeUpdate(Command.java:254) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158) ~[h2-1.3.177.jar:1.3.177]
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144) ~[h2-1.3.177.jar:1.3.177]
	at org.jooq.tools.jdbc.DefaultPreparedStatement.executeUpdate(DefaultPreparedStatement.java:83) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:295) ~[jooq-3.1.0.jar:?]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:298) ~[jooq-3.1.0.jar:?]
	... 7 more
2022-12-29 17:43:45	INFO 	Documenter	Relationships done for: servername\instancename after 4476ms

Bit I cannot fin wich field is too small (or wich content is too large). Or is it possible to extend the fields?

BR

2

Hi @Willi,

The column involve is TargetName. From the looks above, it was not able to properly pickup a TM1 object’s name and was trying to insert what seems like a long formula instead.

Could you check first the state of that TI? Are they all in valid state? This section of that TI in particular,

CAST(‘S_ProzessInfo’';

If they are in valid state. can you please help create a ticket here? Please include the TI above. If you are not sure which TI, please include all TIs that has these lines,

nProcessStartTime=Now();nProcessFinishTime=0;nMetaDataRecordCount=0;nDataRecordCount=0;nActualMetaDataReco…

We will have to investigate further.

Thanks!

Paul

3

Hi @plim,

I’ve done as requested.

BR