Skip to Content
0
Former Member
Apr 21, 2009 at 03:43 PM

Solutions could not be retrieved from Diagnostics DB

32 Views

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