Hi All
We are installing Sourcing 7.0 on NWCE 7.1 EHP1, and in doing so, when running the dbimport.sh script we get the following error
2012-01-19 01:01:51.505 ERROR DBFWK com.sap.odp.common.platform.search.DB2TextIndexManager createTextIndex DbGuiImporter.InstallThread system-40 #system# system database error executing: CALL SYSPROC.SYSTS_CREATE('<%CURRENT_SCHEMA%>', 'ODP_ODP_10000100_XML', '<%SCHEMA>ODP_ODP_DOC_TXT_SEARCH(SOURCE_XML)', 'LANGUAGE AUTO FORMAT XML', 'en_US', ?). Detail: DB2 SQL Error: SQLCODE=-20427, SQLSTATE=38H14, SQLERRMC=CIE00318 Object "sapes1"."ODP_ODP_DOC_TXT_SEARCH" does not exist. , DRIVER=3.62.56
2012-01-19 01:01:51.506 ERROR DBFWK DbSetupEngine execute() DbGuiImporter.InstallThread system-40 #system# system action failed
2012-01-19 01:01:51.507 ERROR DBFWK DbSetupEngine execute() DbGuiImporter.InstallThread system-40 #system# system error in critical
section, cancelling
I have checked the authorisations of the db2es1 user, and I have looked at the database on schema sapes1 and found that table sapes1.ODP_ODP_DOC_TXT_SEARCH does exist, although it does not contain any records at the moment.
As an experiment I logged into a DB2 CLP session and ran the following statement:
create db2 text index
CALL SYSPROC.SYSTS_CREATE('SAPES1DB', 'ODP_ODP_10000100_XML', 'SAPES1.ODP_ODP_DOC_TXT_SEARCH(SOURCE_XML)', 'LANGUAGE AUTO FORMAT XML', 'en_US', ?)
This worked without issue.
Even after this - when I ran dbimport.sh script again, it still complianed that 'SAPES1.ODP_ODP_DOC_TXT_SEARCH' was missing.
I look forward to your responses. Thanks.
Gary Micallef