fatal error during ppmimport

dario borsotti on November 23, 2009

I found a fatal error during ppmimport, during a standard import process.

This is the first time I have this kind of error message

I tried to clear the cache and restarted the client services, but I still find the fatal error in ppmimport.

The logfile says:

[SRV] Filling caches...

[IMP] The component/s "Keyindicator: KeyindicatorCalculation, KeyindicatorCoreConfig, UserAdmin" has/have been unlocked by user SYSTEM.

[IMP] Fatal error calculating KPIs. 7500 process instance(s) had to be reset.

Database error writing buffered process instances.

Dimension-Cache-Error (commit) (1000)

DB-Error: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated. (1006) [8152/22001]

Could anyone gimme some suggestion to solve this situation?

Further information:

· PPM version used: 4.12 (build 5822)

· Database: SQL Server 2000

· OS: Windows Server 2000

Tags: #ppm

Notify Moderator

2 Replies

Marco Bianchetti on November 24, 2009

Hi Dario,

the error message concerns the parameter

STRING_TYPE_LENGTH=100

in configuration file “Database_Settings.properties”

Values and descriptions of text based dimensions are limited to 100 characters

You can handle the behaviour by configuring the following parameters

TRUNCATE_DIMENSION_STRINGS:

# Possible Values: TRUE | FALSE | MARK

# Default: FALSE

# If "TRUE", Values and Descriptions of String based Dimensions are truncated to STRING_TYPE_LENGTH

# if "MARK", Values and Descriptions exceeding STRING_TYPE_LENGTH are replaced by the fix

# String defined in "TRUNCATE_DIMENSION_MARK"

TRUNCATE_DIMENSION_STRINGS=FALSE

# if TRUNCATE_DIMENSION_STRINGS is set to "MARK" the substitution value for

# Dimension-Values containing to many characters

TRUNCATE_DIMENSION_MARK=#Error: Too many Characters.

Set the variable

TRUNCATE_DIMENSION_STRINGS=FALSE

and run the ppmimport again.

Regards

Marco

Like

Sign in
or register to reply.

Notify Moderator
FR

Facundo Ravinale on January 20, 2017 as Reply to Marco Bianchetti

Marco,

I have the same issue reported by Dario. After the ppmimport my log shows the following:

I: 20/01/17 12:51:53 [EIM] Importing EPCs...

I: 20/01/17 12:52:22 [IMP] The component/s "EpkImporter" has/have been unlocked by user SYSTEM.

I: 20/01/17 12:52:22 [IMP] The component/s "Merger: MergerConfigManager, ServerInfo" has/have been unlocked by user SYSTEM.

I: 20/01/17 12:52:22 [IMP] The component/s "Keyindicator: KeyindicatorCalculation, KeyindicatorCoreConfig, UserAdmin" has/have been unlocked by user SYSTEM.

I: 20/01/17 12:52:22 [IMP] The component/s "PIKIDataManager: KeyindicatorCoreConfig, UserAdmin" has/have been unlocked by user SYSTEM.

F: 20/01/17 12:52:22 [IMP] Error importing data from import table.

DB-Error: String or binary data would be truncated. (1006) [8152/22001]

String or binary data would be truncated.

com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

   at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)

   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)

   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)

   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)

   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)

   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)

   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.doAddBatch(ZPreparedStatementExecuter.java:303)

   at com.idsscheer.ppm.db.prochier.impl.ZDbProcessHierarchy$NewReprKeyIdInserter.executeStmts(ZDbProcessHierarchy.java:723)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.executeSinglePSNonClose(ZPreparedStatementExecuter.java:1137)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.executePS(ZPreparedStatementExecuter.java:1120)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter$ExecutePS.doOperation(ZPreparedStatementExecuter.java:1223)

   at com.idsscheer.ppm.server.db.misc.ZDbSafeOperation.doDBOperation(ZDbSafeOperation.java:43)

   at com.idsscheer.ppm.server.db.internal.impl.ZDbDML.callDBOperation(ZDbDML.java:104)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.execute(ZPreparedStatementExecuter.java:263)

   at com.idsscheer.ppm.db.prochier.impl.ZDbProcessHierarchy.getAndSetMappingByKey(ZDbProcessHierarchy.java:421)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZHierarchyBuffer.flush(ZHierarchyBuffer.java:68)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZHierarchyBuffer.add(ZHierarchyBuffer.java:141)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZEpkImporter.importFragment(ZEpkImporter.java:386)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZEpkImporter$EpkImporter.insert(ZEpkImporter.java:576)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZEpkImporter.treatEntries(ZEpkImporter.java:286)

   at com.idsscheer.ppm.db.merger.impl.ZDbEpkImportTable$ZDataEpkImportEntryAsStreamIteratorVisitor.doSomething(ZDbEpkImportTable.java:316)

   at com.idsscheer.ppm.server.db.ZADbIteratorVisitor.add(ZADbIteratorVisitor.java:50)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.doQuery(ZPreparedStatementExecuter.java:379)

   at com.idsscheer.ppm.server.db.misc.ZDefaultPreparedStatementExecuter.executeStmts(ZDefaultPreparedStatementExecuter.java:206)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.executeSinglePSNonClose(ZPreparedStatementExecuter.java:1137)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.executePS(ZPreparedStatementExecuter.java:1120)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter$ExecutePS.doOperation(ZPreparedStatementExecuter.java:1223)

   at com.idsscheer.ppm.server.db.misc.ZDbSafeOperation.doDBOperation(ZDbSafeOperation.java:43)

   at com.idsscheer.ppm.server.db.internal.impl.ZDbDML.callDBOperation(ZDbDML.java:104)

   at com.idsscheer.ppm.server.db.misc.ZPreparedStatementExecuter.execute(ZPreparedStatementExecuter.java:263)

   at com.idsscheer.ppm.db.merger.impl.ZDbEpkImportTable.treatEntriesWithEpkAsStream(ZDbEpkImportTable.java:158)

   at com.idsscheer.ppm.server.merger.epkimporter.impl.ZEpkImporter.doImportEpks(ZEpkImporter.java:153)

   at com.idsscheer.ppm.importing.ZEpkImporterCheckoutModule.execute(ZEpkImporterCheckoutModule.java:76)

   at com.idsscheer.ppm.importing.ZAbstractMultiCheckoutModule.execute(ZAbstractMultiCheckoutModule.java:220)

   at com.idsscheer.ppm.importing.ZImport.executeCheckoutModule(ZImport.java:383)

   at com.idsscheer.ppm.importing.ZImport.executeCheckoutModules(ZImport.java:373)

   at com.idsscheer.ppm.importing.ZImport.doImport(ZImport.java:189)

   at com.idsscheer.ppm.importing.ZImport.execute(ZImport.java:72)

   at com.idsscheer.ppm.runtools.common.ZABaseRunTool.start(ZABaseRunTool.java:192)

   at com.idsscheer.ppm.importing.ZImport.main(ZImport.java:547)

but my truncate_dimension_strings value is already in false, how can i fix it?.

thanks and best regards.

Facundo.

Like

Sign in
or register to reply.

Notify Moderator

fatal error during ppmimport

2 Replies

ARIS User Group DACH meeting

ARIS Summit 2025 | Kuala Lumpur

ARIS Super User Group Meeting