HANA: View refactoring failed due to error 'NullPointerException'

最新推荐文章于 2022-05-13 15:39:01 发布

SAPmatinal

最新推荐文章于 2022-05-13 15:39:01 发布

阅读量434

点赞数

CC 4.0 BY-SA版权

分类专栏： HANA进阶学习文章标签： HANA

本文链接：https://blog.youkuaiyun.com/SAPmatinal/article/details/54379037

HANA进阶学习专栏收录该内容

194 篇文章

订阅专栏

本文介绍了解决HANA Studio中进行视图重构时出现的错误问题，包括错误的具体表现、产生的原因及如何通过SQL命令清除系统残留的无效条目来解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

If you ignore the prompt and continue the refactoring, the following error information will popup:

Error occured during the refactoring of <view_name>java.lang.NullPointerException   
at com.sap.ndb.studio.modeler.job.type.copymodels.MoveModelsHandler.updateReferences(MoveModelsHandler.java)   
at com.sap.ndb.studio.modeler.job.type.copymodels.MoveModelsHandler.moveModels(MoveModelsHandler.java)   
at com.sap.ndb.studio.modeler.job.type.copymodels.RefactorModelsJob.moveModels(RefactorModelsJob.java)   
at com.sap.ndb.studio.modeler.job.type.copymodels.RefactorModelsJob.refactor(RefactorModelsJob.java)   
at com.sap.ndb.studio.modeler.job.type.copymodels.RefactorModelsJob.run(RefactorModelsJob.java)   
at org.eclipse.core.internal.jobs.Worker.run(Worker.java)

Environment

HANA database 1.0 all releases

Reproducing the Issue

On HANA Studio, find out your view, Right click it -> Refactor -> Move, in popup window, choose the target package that you would move to, then click "Next".

Cause

This problem is usually caused by one of the following reasons:

When you deleted the referential view, something went wrong, so this object was not permanently deleted from HANA database, but only was marked for deletion and can't be shown in Navigator anymore.
When you deleted the referencing relationship, something went wrong, so this relationship was not permanently deleted from HANA database and can't be shown in Modeler perspective.

Resolution

If you make sure that the referential view won't be used anymore, you need firstly check if the referential view or the referencing relationship is still existing in system views. You can use the following SQL statements for checking:

SELECT * FROM "_SYS_REPO"."INACTIVE_OBJECT" WHERE package_id = '<package name>' AND object_name = '<referential view>';

SELECT * FROM "_SYS_REPO"."INACTIVE_OBJECTCROSSREF" WHERE from_package_id = '<package name>' AND from_object_name = '<referential view>';

Delete the unwanted entries using SQL commands:

DELETE FROM "_SYS_REPO"."INACTIVE_OBJECT" WHERE package_id = '<package name>' AND object_name = '<referential view>';

DELETE FROM "_SYS_REPO"."INACTIVE_OBJECTCROSSREF" WHERE from_package_id = '<package name>' AND from_object_name = '<referential view>';

Then you can retry to refactor the primary view.