cancel
Showing results for 
Search instead for 
Did you mean: 

Erro ao importar dados

DominusTech
Explorer
0 Kudos

Caros,

Estou fazendo este import:

IMPORT “XXXXXYYYYYY”.”*” FROM ‘/usr/sap/HDB/HDB00/work/ARquivoXXXXXYYYYYY’ WITH RENAME SCHEMA XXXXXYYYYYY TO XXXXXKKZZZZZZ NO DEPENDENCIES REPLACE

Estou obtendo o seguinte erro:

Could not execute ‘IMPORT “XXXXXYYYYYY”.”*” FROM ‘/usr/sap/HDB/HDB00/work/XXXXXKKZZZZZZ’ WITH RENAME SCHEMA …’ in 3:43.389 minutes .
SAP DBTech JDBC: [2048]: column store error: table import failed: [30111] Import failed (could not execute create statement);object=XXXXXKKZZZZZZ:TransNoticeNfseen,invalid table name: Could not find table/view SettingEntityEnv in schema XXXXXKKZZZZZZ: line 237 col 7 (at pos 6533) at /sapmnt/ld745272xdf/a/HDB/jenkins_prod/workspace/8uyie4556gvl/s/ptime/query/catalog/catalog.cc:6030

Já dei as permissões que estão nas notas: 2252941_E_20220202, 2467280_E_20220202 e 2554385_E_20220202 não deu certo.

Alguém pode me ajudar?

Grato,

View Entire Topic
wojciech_wozniak
Participant
0 Kudos

Are you sure you have the correct magazine in line 237 col 7

DominusTech
Explorer
0 Kudos

--I made the export with the following command
EXPORT "XXXXXYYYYYY"."*" INTO '/usr/sap/HDB/HDB00/work/ARquivoXXXXXYYYYYY' WITH REPLACE

--I imported with the following command
IMPORT "XXXXXYYYYYY"."*" FROM '/usr/sap/HDB/HDB00/work/ARquivoXXXXXYYYYYY' WITH RENAME SCHEMA XXXXXYYYYYY TO XXXXXKKZZZZZZ NO DEPENDENCIES REPLACE

Could not execute 'IMPORT "XXXXXYYYYYY"."*" FROM '/usr/sap/HDB/HDB00/work/XXXXXKKZZZZZZ' WITH RENAME SCHEMA ...' in 3:43.389 minutes .
SAP DBTech JDBC: [2048]: column store error: table import failed: [30111] Import failed (could not execute create statement);object=XXXXXKKZZZZZZ:TransNoticeNfseen,invalid table name: Could not find table/view SettingEntityEnv in schema XXXXXKKZZZZZZ: line 237 col 7 (at pos 6533) at /sapmnt/ld745272xdf/a/HDB/jenkins_prod/workspace/8uyie4556gvl/s/ptime/query/catalog/catalog.cc:6030