Skip to Content
0
Dec 12, 2011 at 09:41 AM

Change site link giving internal error for SITE_ADMIN user

77 Views

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.