The database
import script may indicate (check the logfile) that values had to be truncated
during import. This means that the column width in the event table is too small
for the values it needs to store. This should only apply to string (varchar)
type of values. To change :
1.Obtain the ProactivePack database credentials, the name of the
ProactivePack database (by default “EVENTDB”) and the name of the events table
(by default EVENT_REP_MAIN)
2.Run the following command
(assuming the DBUser is “PpackUser” and service name is MyDB) sqlplus –u
PpackUse@MyDB
3.Enter the ProactivePack user
password
Within the prompt, type in a statement as follows
alter table event_rep_main
modify (<slotname> varchar2(<new width>) ;
<slotname> is the name of the new slot
<new width> is the numerical value of the column width (e.g.
256)
4.Edit (using a text editor) the file
$PRODUCT_HOME/config/custom/QuickQueries.conf
a.In the last section of the file ( [SQLImportParameters]), add a row
for your new slot like follows :
Philippe Plomteux
The database import script may indicate (check the logfile) that values had to be truncated during import. This means that the column width in the event table is too small for the values it needs to store. This should only apply to string (varchar) type of values. To change :
1. Obtain the ProactivePack database credentials, the name of the ProactivePack database (by default “EVENTDB”) and the name of the events table (by default EVENT_REP_MAIN)
2. Run the following command (assuming the DBUser is “PpackUser” and service name is MyDB)
sqlplus –u PpackUse@MyDB
3. Enter the ProactivePack user password
Within the prompt, type in a statement as follows
alter table event_rep_main
modify (<slotname> varchar2(<new width>) ;
<slotname> is the name of the new slot
<new width> is the numerical value of the column width (e.g. 256)
4. Edit (using a text editor) the file $PRODUCT_HOME/config/custom/QuickQueries.conf
a. In the last section of the file ( [SQLImportParameters]), add a row for your new slot like follows :
length_<slotname>=<new width>
Example :
sqlplus BMC_PAP@DB_PPACK.proactivepack.com
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 21 11:27:32 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Wed Sep 21 2016 11:15:41 +02:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options
SQL> alter table EVENT_REP_MAIN modify
(
mc_priority varchar2(14),
mc_original_priority varchar2(14),
mc_parameter_value varchar2(1024)
);
Table altered.