on 04-21-2009 4:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.