| |
Results |
|
"sqlerrm = ORA-20000: Unable to set values for index [index name]" errors during Data Pump import.
|
When users import Dimensions CM data into an Oracle 19 database via IMPDP, it may return the following messages: Processing object type DATABASE_EXPORT/STATISTICS/MARKER [index name] : sqlerrm = ORA-20000: Unable to set values for index [index name]: does not exist or insufficient privileges
|
|
|
|
KM-Dim7: Error: Index [] out of range on migration wizard upload
|
During a Data Migration Wizard upload script generation the error: ' Index [] out of range' may be recieved. This means one of the item types specified is invalid, i.e. it does not exist in the database being uploaded to.
|
|
|
|
OLEDB call gives error "Index (zero based) must be greater than or equal to zero"
|
The follow error occurs when using data services. This error occurs after upgrading to Mariner 2008 from Mariner 6.2.
|
|
|
|
KM-Dim7: Moving Database Indexes to a separate Tablespace
|
It is sometimes desirable to place the base database tables and indexes into separate tablespaces. Sometimes this is desirable as a minor performance improvement if the corresponding datafiles are located on different physical disk drives.Separating the data from the indexes also provides an aid in keeping fragmentation down. When the indexes are periodically rebuilt, their entire tablespace can be taken offline, dropped and recreated.
|
|
|
|
KM-Dim7: ORA-00060: Deadlock detected. More info in file trace file>
|
Check for missing indices
|
|
|
|
How do you use the "SPGetResourceDemand" stored procedure? Get Index(zero) .. error when using syntax in 6.2 data access guide.
|
SPGetResourceDemand SPGetResourceDemand returns resource demand information for resources allocated to the investment specified in InvestmentId and its descendents, for allocations whose start dates or end dates fall inside the range specified by StartDate and EndDate. SPGetResourceDemand parameters
|
|
|
|
Improving Keyword Searching Performance In SBM Using Full-Text Indexes
|
Keyword searching options in report search specifications Value Find searching on forms for Single Relational and Multi-Relational fields, if the value display format for the relational field table contains a Text field You can enable full-text searching on a table-by-table basis by creating full-text indexes in your database and then enabling the index in SBM System Administrator. For optimal use, enable full-text searching on heavily used tables that contain large amounts of data .
|
|
|
|
Smart Search indexing for Work Center searches is looping/starting over and not completing
|
If you would like to have Tomcat running Common Services to be on multiple servers, you will need to make sure they are clustered behind a load balancer. More information about how the Work Center search works in a clustered environment can be found in KB solution S143075 .
|
|
|
|
PDS#471Z Edit not allowed on a data base index or using a secondary index
|
Command ===> Scroll == ********************************* Top of Data ************************** * DATA SET KTTT200A AT LEVEL 002 AS OF 06/13/97
|
|
|
|
Dim10: VM2DIM: Warning:8019:Exception while converting string to seconds:
|
The console parses this text output to generate a number of seconds for the current task so that the console can calculate, estimate, and display total progress and time remaining for various tasks and for the migration process as a whole. If this warning occurs, progress indicators (progress bars and status text) may reflect inaccurate timing statistics. This will not affect the data migration itself in any way.
|
|
|
