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
Marco Bianchetti on
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