Change site link giving internal error for SITE_ADMIN user

[i053166]

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/me_{ear) 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/me}earxml|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.

[sergiy_katerinich]

Sameel,

I have just tried SITE_ADMIN with * default site and with empty default site on ME 6.0.2.1 on SQL Server, and it works fine in both cases. So, I would double check the config following SAP ME Installation Guide, and then try to upgrade to the latest.

Regards,

Sergiy

[i053166]

Sergiy ,

As per the installation guide, after creating the SITE_ADMIN user with required roles, the ME logon should work.

Is there any template wizard to be executed in NWA to associate SITE_ADMIN user to * SITE ?

[sergiy_katerinich]

Sameel,

No wizzard. This is to be done manually. The procedure is described in SAP ME 6.0 Security Guide @ SMP.

Regards,

Sergiy

[Former Member]

Hello,

I believe you haven't specified the correct locale during creation of database as specified in installation guide. Your current locale makes database case sensitive and it will lead to all kinds of errors.

There are ways to change locale of SQL Server database, so please google for them.

Thanks,

Bakhtiyar

[i053166]

Hi Bakhtiyar ,

The collation was set to Latin1_General_CI_AI during database installation. All other database settings have been compared with installation guide and I cannot find any aberrations.

Is there any other setting besides collation that can influence database case sensitivity?

I patched to ME 6.0.2.2 counter 12 but still get the same issue.

Regards,

Sameel.

[sergiy_katerinich]

Hi,

Please confirm if, for example, SITE column of SITE table has the same Latin1_General_CI_AI collation.

Regards,

Sergiy

[i053166]

Hi Serigy,

SITE column collation is Latin1_General_100_CS_AI. I tried to change it to Latin1_General_CI_AI using below query :

ALTER TABLE [WIP].[dbo].[SITE] ALTER COLUMN SITE

varchar(6)COLLATE Latin1_General_CI_AS NOT NULL

The query fails with error that one or more objects access this column.

Can you suggest a query to modify the collation of SITE column?

Regards,

Sameel.

[sergiy_katerinich]

That is your problem! So, the collation was NOT "set to Latin1_General_CI_AI during database installation" but rather tried to change collation to Latin1_General_CI_AS afterwards. This does not resolve your issue. You have to create a database once again and follow all instructions from Installation Guide this time.

Regards,

Sergiy

[i053166]

Thanks Serigy for all the help.