I have ME version 6.0.2.0 Counter 63 newly installed. SITE_ADMIN user login was created but it was giving internal error during logon. The message says - +An internal error occurred; contact technical support+
Finally, the logon worked only after I added default plant as * for SITE_ADMIN.
The Netweaver trace details for this error is given below :
+Cannot process an HTTP request to servlet [jsp] in [manufacturing] web application.+
+For more details on the problem please check traces searching by logId: C0000A7317500C8C000000000000132C#+
+500 Internal Server Error is returned for HTTP request [http://localhost.sap.com:50000/manufacturing/index.jsp]:+
+component [jsp],+
+web module [manufacturing],+
+application [sap.com/me~ear],+
+DC name [sap.com/me~ear],+
+CSN component[],+
+problem categorization [com.sap.ASJ.web.000137],+
+internal categorization [1141368710].+
+[EXCEPTION]+
+com.sap.me.frame.dao.DataAccessSystemException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'site'.+
+at com.sap.me.frame.dao.PersistentObjectCollection.initialize(PersistentObjectCollection.java:156)+
+at com.sap.me.frame.dao.PersistentObjectCollection.iterator(PersistentObjectCollection.java:91)+
+at com.sap.me.user.impl.UserConfigurationService.getUserSiteConfigurationsByUserId(UserConfigurationService.java:89)+
+at com.sap.me.user.impl.UserConfigurationService.findUserSiteConfigurationsByUserId(UserConfigurationService.java:83)+
+at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)+
+at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)+
Is this correct behaviour?
Now, I created a new site 1000 for SAPMEINT integration. I tried to acces this site 1000 via change site after logging into site * but getting internal error. The Netweaver trace details for this error is given below :
System exception
[EXCEPTION]
javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/meear) Exception raised from invocation of public com.sap.me.system.base.ApplicationVO com.sap.me.user.ChangeSiteApplicationBean.clear(com.sap.me.system.base.ApplicationVO) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.user.ChangeSiteApplicationBean@651c3a9c for bean sap.com/meearxml|me.user.ejb-6.0.2.0.jarxml|ChangeSiteApplication in application sap.com/me~ear.; nested exception is: com.sap.me.frame.dao.DataAccessSystemException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'site'.
com.sap.me.frame.dao.DataAccessSystemException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'site'.
Only if I assign default site as 1000, SITE_ADMIN is able to access the site. If I leave default site empty for SITE_ADMIN, i'm not able to logon to ME at all.
What could be the cause?
Regards,
Sameel.