on 12-03-2011 11:15 AM
Dear Experts
When I see the Databases list in RSP under Configuration -> Databases -> Databases tab,
it shows me already not existing and old version databases.
I did an upgrade from SBO 2004.2B PL75 ,an old fashioned version to 8.81 PL09.
When I see in SBO's company selection screen, there is only one database (ex: AA) with version 881317.
But when I see in RSP, it shows AA with version 730277 and other old databases which are already deleted from SQL Server.
Because of this problem, I cannot do run the "System Data Service" in RSP. it shows compatible as X.
It seems the old database information comes from SBO-COMMON.
My customer is using SQL Server 2005 std.
Do someone know how to solve this problem?
Regards
Gen Okazaki
Additional information
RSP version is 2.3 PL04
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I created a massage to SAP ,get the answer and it has fixed.
For other who has a same problem I'll attach the advice from SAP below.
We would like to inform you that in order to try to resolve reported issue please do following:
1. back up the SBO-COMMON database before running the fix
2. DELETE [SBO-COMMON].dbo.SRGC
3. EXEC TmSp_RefreshCompList
4.SELECT dbName,cmpName,versStr FROM [SBO-COMMON].dbo.SRGC
5. Check in RSP, if the issue still exists please kindly attach the related Service log file.
Itu2019s under the RSP install folder,
C:\Program Files (x86)\SAP\Remote support platform for SAP Business One\Service\Logs in case of a 64bit Operating System (OS)
or
C:\Program Files\SAP\Remote support platform for SAP Business One\Service\Logs in case of a 32bit OS
As soon as you provide us the above we will continue investigating this issue.
Your cooperation is much appreciated
Hi,
In the solution there is a slight typo, which has an important effect:
2. DELETE [SBO-COMMON].dbo.SRGC would delete the whole SRGC table with the effect that when executing step 3 the table SRGC cannot be found.
CORRECTED SOLUTION:
1. back up the SBO-COMMON database before running the fix
2. DELETE from [SBO-COMMON].dbo.SRGC
3. EXEC TmSp_RefreshCompList
4. SELECT dbName,cmpName,versStr FROM [SBO-COMMON].dbo.SRGC
5. Check in RSP, if the issue still exists please kindly attach the related Service log file.
Best regards
Mario Schoenberg
SAP Business One Product Support
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.