Set Schema DDL statement: set schema 'SYSTEM'

[former_member708565]

Hi,

I have created a scripted view in SAP HANA Studio with Eclipse.

The default schema is set to SYSTEM.

However I get this error when I try to import it to our target system.

Activating the repository objects in 1 imported requests:

| | | HANA activation ID: 12125, HANA return code: 40136

| | | HANA Message: Repository: Activation failed for at least one object;At least one runtime reported an error during activation

| | | . Please see CheckResults for details

| | | XXX.calculationview (xx.xx.xx.xxxxxx) activation failed [BW]

| | | Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: invalid

| | | schema name: SAPXXX: line 16 col 6 (at pos 404)

| | | Set Schema DDL statement: set schema 'SYSTEM'

| | | Type DDL: create type '_SYS_BIC'.'xx.xx.xx.xxxxxx/CV_XXXXXXX/proc/tabletype/VAR_OUT' as table ('EBELN' NVARCHAR(10), 'EBEL

| | | P' NVARCHAR(5), 'TAEL' INTEGER)

| | | Procedure DDL: create procedure '_SYS_BIC'.'xx.xx.xx.xxxxx/CV_XXXXX/proc' ( OUT var_out '_SYS_BIC'.'xx.xx.xx.xxxxxx/CV

| | | XXXX/proc/tabletype/VAR_OUT' ) language sqlscript sql security definer reads sql data as

[CharlesFeng]

Hi Carsten Pold,

The error is saying "invalid | | | schema name: SAPXXX", have you tried execute " set schema 'SAPXXX'" ?

Best regards,

Charles