Skip to Content
0

Database error during company workbook upload for :Document Security Templates

May 07 at 05:03 AM

45

avatar image

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

db-error.jpg (17.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Akshay Lath May 07 at 07:13 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Erik Rahm
May 07 at 05:10 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded