cancel
Showing results for 
Search instead for 
Did you mean: 

Database list in rsp database setting configuration

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Additional information

RSP version is 2.3 PL04

Former Member
0 Kudos

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

mario_schoenberg
Contributor
0 Kudos

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

former_member186095
Active Contributor
0 Kudos

HI Mario,

I hope there is a SAP note to record your solution. Tks

Rgds,

JimM

mario_schoenberg
Contributor
0 Kudos

Hi Jimmy,

Yes we did create note 1711729.

Kind regards

Mario