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
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
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.