Hello CA Guys,
We performed a SQL Server Version Upgrade, from SQL Server 2012 Standard to Enterprise.
STARTING TEST ...Provider=SQLOLEDBInitial Catalog=CA_UIM_8Data Source=10.55.166.70,1433Network Library=dbmssocn;Language=us_englishUser ID=saPassword=******
Contacting data_engine probe...Executed async test_connection on /Core-Cauim/Core/BR1OIMCNMNMS001/data_engine, please wait...Waiting...test connection DONE - result:Connected: yesPing: yesDB Version: Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)data_engine schema version: 8.50(0)
We did this upgrade to be able to configrue the 'Partition Data Tables'' from Data_Engine. The checkbox is allow now, but no save the configuration after restart of the data_engine probe.
If we check the option 'Partition Data Tables, then restart the probe, the configuration is lost.
Please, could anyone help us with this case? It is very important to us allow this configuration.
SQL Server 2012 Enterprise
Windows Server 2012 R2
Data_Engine version 8.50
Have you tried making that change via Raw Configure?
That would eliminate the GUI from the configuration process which would then determine if the configuration is being lost by the UI or the probe itself.
Before you do perform this (enabling partitioning) I would advise reviewing the following knowledge document as it might be necessary to manually partition the largest RN_QOS_DATA_XXXX tables as this may take a long time and the
data_engine might not be able to finish partitioning the tables in a timely manner.
KB000034658 - Manually partitioning the UIM database for Microsoft SQL Server
Manually partitioning the UIM database for Microso - CA Knowledge
Can you also try enabling partitioning from the Admin Console Gui