View FIN_ARPOS_NETDT: Inconsistency between Dictionary and DB or database view was not found

[FabioPagoti]

Hello people who still have the courage to use the new SCN,

I am trying to open some external views in Eclipse but I get an error message.

View FIN_ARPOS_NETDT: Inconsistency between Dictionary and DB or database view was not found

-----

com.sap.adt.communication.resources.ResourceException: Execution of request "GET /sap/bc/adt/ddic/views/fin_arpos_netdt" failed: 500 Internal Server Error View FIN_ARPOS_NETDT: Inconsistency between Dictionary and DB or database view was not found ------------ Request ----------------------- GET /sap/bc/adt/ddic/views/fin_arpos_netdt HTTP/1.1 Cache-Control: no-cache Accept: application/vnd.sap.ddic.view+xml User-Agent: Eclipse/4.6.3.v20170301-0400 (win32; x86_64; Java ) ADT/2.73.1 X-sap-adt-profiling: server-time ------------ Response ---------------------- HTTP/1.1 500 Internal Server Error ~server_protocol: HTTP/1.1 X-sap-adt-profiling: server-time=79648 Content-Type: application/xml <?xml version="1.0" encoding="utf-8"?><exc:exception xmlns:exc="http://www.sap.com/abapxml/types/communicationframework"><namespace id="com.sap.adt"/><type id="ExceptionInternalServerError"/><message lang="EN">View FIN_ARPOS_NETDT: Inconsistency between Dictionary and DB or database view was not found</message><localizedMessage lang="EN">View FIN_ARPOS_NETDT: Inconsistency between Dictionary and DB or database view was not found</localizedMessage><properties/></exc:exception> -------------------------------------------- at com.sap.adt.communication.internal.resources.RestResource.createResultFromResponse(RestResource.java:224) at com.sap.adt.communication.internal.resources.RestResource.invoke(RestResource.java:192) at com.sap.adt.communication.internal.resources.RestResource.get(RestResource.java:75) at com.sap.adt.tools.core.spi.sfs.AdtContentProvider.readAdtResourceInternal(AdtContentProvider.java:1613) at com.sap.adt.tools.core.spi.sfs.AdtContentProvider.synchronizeFileWithRemote(AdtContentProvider.java:1048) at com.sap.adt.tools.core.spi.sfs.AdtContentProvider.synchronizeContentWithRemote(AdtContentProvider.java:983) at org.eclipse.core.internal.resources.semantic.SemanticFileStore.synchronizeContentWithRemote(SemanticFileStore.java:1150) at org.eclipse.core.internal.resources.semantic.SemanticResourceAdapterImpl.synchronizeContentWithRemote(SemanticResourceAdapterImpl.java:318) at com.sap.adt.tools.core.internal.sfs.AdtSfsUtil$2.run(AdtSfsUtil.java:215) at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2240) at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2267) at com.sap.adt.tools.core.internal.sfs.AdtSfsUtil.synchronize(AdtSfsUtil.java:228) at com.sap.adt.tools.core.internal.sfs.SfsUtil.synchronize(SfsUtil.java:802) at com.sap.adt.tools.core.ui.editors.AdtFormEditorService.init(AdtFormEditorService.java:167) at com.sap.adt.tools.core.ui.editors.AdtFormEditor$3.run(AdtFormEditor.java:438) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

-----

This happens for at least the following view:

External View

• FIN_ARPOS_NETDT
• FIN_ARPOS_DSOV
• FIN_ARPOS_TERMS
• FIN_ARPOS_TERMSV

What hasn't solve the problem:

• Run transaction FINS_MIG_REGENERATE
• Run report RUTDDLSACT
• All SE14 stuff (actually when I try to check the view in SE14) I get the following
• OSS Note 0002350429

Request: Delete and recreate View FIN_ARPOS_NETDT (USERNAME/07.05.17/08:46) Process: s4hana1610_29_10220 External View FIN_ARPOS_NETDT: DB view does not (yet) exist. Syn. will not be generated Activation and DDL statements for View FIN_ARPOS_NETDT required sql: DROP SYNONYM 'FIN_ARPOS_NETDT' invalid synonym: FIN_ARPOS_NETDT: line 1 col 14 (at pos 13) DDL time(___1): ........10 milliseconds IN_ARPOS_NETDT could not be removed Statements for View FIN_ARPOS_NETDT could not be executed Request for FIN_ARPOS_NETDT could not be executed

System details:

• S/4 HANA
• S4CORE 101
• SAP_BASIS 751
• SAP_ABA 75B
• Eclipse plugins are up to date

[oliveiraa]

Hello Pagoti,

Did you find a solution for this issue? I'm having exactly the same problem as you for some views of TDF.

Best Regards!

[FabioPagoti]

Hi Andre,

I have not found a solution for this but I haven't search for SAP notes after that.

[raymond_giuseppi]

Did you look for OSS notes suitable at your version like 2189398 - Regeneration of SAP HANA view for due date for net payment calculation or 2350429 - External view with more than 255 fields?