on 10-06-2015 9:19 PM
Hi,
I recently upgraded our solution manager from 7.0 to 7.1. AS a part of solman_setup I am trying to sync local sld with LMDB. Ideally full sync shouldn't take more than few hours but it's been 3 days and my sync shows just 5%. I cancelled the job and started again but its still same. I see follwoing in the job log:
10/06/2015 10:48:15 Skipped class SAP_CIMData (already processed before abort)
10/06/2015 10:48:15 Skipped class SAP_InstalledSoftwareFeature (already processed before abort)
10/06/2015 10:48:15 Skipped class SAP_Supplier (already processed before abort)
10/06/2015 10:48:15 Skipped class SAP_SoftwareComponent (already processed before abort)
10/06/2015 10:48:15 Starting full synchronization of class SAP_SupportPackage...
10/06/2015 10:53:39 Data fetched: 76,246 source instances in 197,067 ms, 29,084 target instances in 126,470 ms
Content synchronization from SLD to LMDB is not finished (progress 5%)
Regards,
SJ
The problem was surely already solved, but maybe this tip helps other users.
I've observed the same issue on a SolMan system after upgrade from 7.0 to 7.1 (SP12). It was solved by stopping the sync job, recreating the Oracle database statistics (schedule by periodic job in DB13), and afterwards restarting the sync job.
Runtime before: 3 days (~40%)
Runtime after: 4-5 hours (complete)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Initial Sync for LMDB usually takes more than 3 days in Oracle .. i have seen that this happens faster if your DB is Sybase or MaxDB . But in oracle you have to wait for sync to complete ..
This is normal.
Regards
Bhupesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
You can monitor the procedure with standard transactions.
Transaction SM37 monitors jobs. The job log tells you, for example, the progress of a complete
synchronization, or any problems. The name of the synchronization job for the target namespace
is SAP_LMDB_LDB_<namespace ID>, for example: SAP_LMDB_LDB_0000000001.
Transaction SLG1 (Display Logs) for the object AI_LMDB, shows synchronization errors by
default. You can extend the analysis, and for example, also show warnings. Extending can impair
performance, so only do so if necessary.
Last, search for hanging LMDB locks in transaction SM12.
Table name: LMDB*
User: *
If the time of the lock is more than one day, you can safely delete this lock.
Best,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bobby
I am doing initial sync between SLD and LMDB and every 1% finish takes 2-3 hours. I am using SolMam 7.1 SP14 with local SLD. I have updated CIM Model and CR Content to the latest values.
In SM37 job log (SAP_LMDB_LDB_0000000001), i see below value even after 3.5 hours. There is no progress shown here:
=====================================================================
.......
=====================================================================
TCode SLG1 does not show any meaningful data.
There are no hanging locks in SM12 against table LMDB*.
Background JOB is running for passt 3.5 hrs and shows below information:
The value for Sequential Read is increasing by 3 per sec. Insert value is updating randomly. Can you please suggest if this progress is normal? I have updated table stastics in DB using BRTOOLS but it did not bring any benefit. Can you please suggest what else can i do to improve the sync performance?
Regards,
Tapan
Did you import the latest CR CONTENT into your upgraded SLD?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.