Database error during company workbook upload for :Document Security Templates

[Former Member]

Dear experts,

I am getting a database error during the company workbook upload for the "document security template".

error is "Database error: SAP DBTech JDBC:[260]: invalid name: Name_MSDEFAULT:Line 1 col 494 (at pos 493)"

The same error is coming during the manual creation as well.

Weird thing is, the error did not show up when I have uploaded the enterprise workbook.

Regards,

Akshay

[Former Member]

Thanks Erik.

CLM version: CLM 11 SP4 Patch 1

Database version : 2.00.023.00.1513691289 (fa/hana2sp02).

logs: # Failed: object 1: The object referenced in column DEF_REP could not be found.

The value of the column is Finance.

I have checked, the value is present in system.

Below are the logs, hopefully, you may help me based on them.

#2.0 #2018 05 03 11:56:40:339#+0700#Error#/Applications/E-Sourcing/eso# ##sap.com/E-Sourcing-Server#C0000A36B025007E000000090000682E#128815450000000004#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.app.portal.db.PortalPageDocDb.findDefaultPageTemplate#ACN57#1##55FADA614E8E11E8A555000007AD915A#5693aa634e8e11e8b8e6000007ad915a##0#Thread[HTTP Worker [@438741995],5,Dedicated_Application_Thread]#Plain## Facility=local4;sessionid=cd3e22ffbf144b71a4b8b238a03bb067bb8c5fe;tenantid=\#enterprise\#;exception=com.sap.odp.api.common.exception.ApplicationException: Database error: SAP DBTech JDBC: [260]: invalid column name: NAME_MSDEFAULT: line 1 col 494 (at pos 493). Contact your system administrator.;stacktrace=AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.ApplicationException: Database error: SAP DBTech JDBC: [260]: invalid column name: NAME_MSDEFAULT: line 1 col 494 (at pos 493). Contact your system administrator. AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.DatabaseException: Database error: SAP DBTech JDBC: [260]: invalid column name: NAME_MSDEFAULT: line 1 col 494 (at pos 493). Contact your system administrator.

[former_member13619]

Akshay,

The error is actually telling that in the workbook there is a reference to a column name which does not exist but does not necessarily means this is the root cause. It is difficult to know which column is causing this issue with only an extract of the error message, did you already look in the logs (with debug) if there is more elaborated message?

You should also mention which version of SAP Sourcing you are using.