cancel
Showing results for 
Search instead for 
Did you mean: 

Solutions could not be retrieved from Diagnostics DB

Former Member
0 Kudos

Hello,

I am getting the error message below when running the Managed systems

setup wizard for smd:

"Solutions could not be retrieved from Diagnostics DB

(Cannot retrieve the system list of the product '[IProduct:

key=1217278071139106, name=SAP NETWEAVER 04,

ppmsId=01200314690900000192, creation=Mon Jul 28 16:47:49 GMT-04:00

2008]'!(cause=com.sap.sql.l

og.OpenSQLException The SQL

statement "SELECT "SYS_KEY","SYS_INSTALL_NR","SYS_SID","SYS_LONG_SID","SYS_CREATION","P_KEY" FROM "BC_WA_SYST" WHERE "SYS_CREATION" <= ?

AND "P_KEY" = ? ORDER BY "SYS_SID",

"SYS_INSTALL_NR"" contains the semantics error[s]: - 1:39 - the column

>>SYS_LONG_SID<< is undefined in the current scope

))"

Looking at the table "BC_WA_SYST", I have found that the

columns "SYS_KEY","SYS_INSTALL_NR","SYS_SID","SYS_CREATION" and "P_KEY"

exist. The column "SYS_LONG_SID" on the other hand does not exist. Is

it safe to create this column manually or is there another solution.

Please assist.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Julie

I think, this problem is related to longSID usage in Solution manager. we did implement a Note for this but really couldn't re-collect what was the number

however, following may help you

http://www.scribd.com/doc/3344299/Sap-Solution-Manager-Guide-to-Plug-System-using-LongSID

Note 1096323 - SMD Agent DataCollector Application - Common errors

Note 970611 - Long SID is not always transferred to Solution

Note 1065285 - Problem when you (de)activate long SIDs in System Monitoring

Note 824443 - SID in setup service level reporting longer than 3 places

Note 1156474 - Error in system administration reporting

Note 1079125 - EWA GCA Task of Solution Manager Diagnostics

thanks

Bhudev