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