SAP HANA-SQL error “SQL code: 339” occurred while accessing table

原因:hana版本太低,有bug.
Before the load you executed the report RSDU_PSA_PARTNO_CHECK in “repair” mode for the related PSA table.

The report RSDU_PSA_PARTNO_CHECK initializes the value of the field PARTNO of an PSA (persistent staging area table) in a way that for performance reasons the whole column gets dropped and added again at the end of the table, in other words it changes the sequence of fields in the table, hence the data base object gets changed, while the dictionary definition as well as its runtime object stays untouched.

This change is not reflected in the SQL statement cache of a work process. When the prepared statement gets called, it tries to insert the data in wrong sequence.

Due to data type conflicts the operation cancels with the afore-mentioned dump.

解决方案:
最根本的方案:升级hana,This problem will be fixed with HANA Revision 112.05 and 122.
次优方案:As work around you can either restart application server workprocess by setting the parameter “rdisp/wp_auto_restart” to a small value immediately after you have executed the report RSDU_PSA_PARTNO_CHECK in repair mode. After you can be sure that each process got restarted, reset the parameter back to its old value. This ensures that the SQL cache entries get recreated with the correct sequence. Please refer to SAP note 101717 regarding the parameter rdisp/wp_auto_restart.

A restart of the application server does have the same effect, but is not required.
第三个方案:尝试在SE11中将表的技术设置中的属性设置为传统的行存储试试看。

本文作者: GavinDong

版权属于: GavinDong博客

文章链接: https://gavindong.com/1683.html

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(0)

发表回复

登录后才能评论