Several error when trying to index CRM Opportunities

[Former Member]

Hi Enterpise Search Experts,

I was able to successfully index Accounts, CRM Activities, Contacts, Employees and Products. But when I try to index also CRM Opportunities, the extract from the CRM Backend system finished successfully. The output of the batch program is:

Start indexing for:

Object type name:CRM_BUS2000111

Connection GUID:DF31CA31AA7077F1BD4C0022195FBABB

Logical system:SYSCLNT002

Execute initial indexing

Object connector SYS002_{CRM_BUS2000111}: New status: 07

Indexing ended with error

Indexing of ESH:SYS002_SYS002CRM_BUS2000111~BTOPPORTH has returned subrc 1, error code 0, and error text

Extraction request of template CRM_BUS2000111, requesting 9.156 entities

Parallel data extraction started at *01.07.2010 19:46:01,371000 with 92 tasks

Parallel data extraction finished at *01.07.2010 20:06:31,503000, returning 9.156 entities

Indexing of ESH:SYS002_SYS002CRM_BUS2000111~BTOPPORTH has returned subrc 1, error code 0, and error text

Object connector SYS002_{CRM_BUS2000111}: New status: 93

The indexer trace file from TREX contains this:

[8844] 2010-07-01 21:44:21.749 e SERVER_TRACE TRexApiAdmin.cpp(03539) : clearIndex for joinIndex not implemented:

esh:sys002_sys002crm_product~~crm_product

[5240] 2010-07-01 21:45:36.356 e SERVER_TRACE TRexApiAdmin.cpp(03539) : clearIndex for joinIndex not implemented:

esh:sys002_sys002crm_bus2000111~~crm_bus2000111

[10192] 2010-07-01 21:48:10.335 e TREX_C_STORE FilerFactory.cpp(00357) : ERROR: writer already open in

'D:\usr\sap\CTX\TRX03\index\esh\sys002_sys002user_authority_data~auth_auth_value\en\$delta_1$'

[10192] 2010-07-01 21:48:10.335 e TrexCabinet Stapler.cpp(00179) : ERROR:failed to create filer

dir=I|esh|sys002_sys002user_authority_data~auth_auth_value||en|||D|name=$delta_1$ mode=1

[10192] 2010-07-01 21:48:10.335 e TrexCabinet Stapler.cpp(01821) : ERROR: failed to create jacket!!!

[10192] 2010-07-01 21:48:10.335 e TrexCabinet Stapler.cpp(01822) : TrexCabinetException in Stapler.cpp(180): 'failed to create filer!!!'

[10192] 2010-07-01 21:48:10.335 e TREX_C_STORE FilerFactory.cpp(00453) : ERROR: createSexyFilerObject: TrexCabinetException in Stapler.cpp(279): 'failed to create master-Jacket!!!'

[10192] 2010-07-01 21:48:10.335 e MemWatch MemWatch.cpp(00442) : catch ... in MergeThread

The TREX Version is 7.10.36.00, Build 710.36.198211.

Hope that anyone can help with this problem.

Best regards

Gregor

[Former Member]

Update: We just installed the newest version of the TREX Search Engine (Revision 7.10.42.00). The Error-messages are gone and indexing works fine now.

[Former Member]

Hi,

i solved this issue (including message: failed to create jacket)

by applying the solution in following link

No update was necessary

SAP trex writer already open failed to create jacket filer CabinetException in Stapler.cpp | Weltinf...

[Former Member]

Hello Geoff,

We are seeing the same thing but for Leads.

Can you provide steps on how you set up your search to work for Activities? We are trying to use Embedded Search for the Activities.

Have you come up with any solution for your issue?

Thanks,

Justin

[gregorw]

Hi Justin,

we're running an OSS Message to solve this problem. Yesterday we've upgraded our TREX to the latest available version but that did not solve the problem. I will provide the description as soon as it was solved.

In our case the indexing for Activities worked like a charm. How many do you want to index? What is the error message on the Activities?

Best regards

Gregor

[gregorw]

Just an update to the current status:

On a System with this support packages:

SAP_ABA	701	0006
SAP_BASIS	701	0006
PI_BASIS	701	0006
ST-PI	2008_1_700	0002
SAP_BS_FND	701	0006
SAP_BW	701	0006
SAP_AP	700	0019
WEBCUIF	700	0006
BBPCRM	700	0006
ST-A/PI	01M_CRM570	0000

And TREX Revision 7.10.40.00 I was able to index some Opportunities. Unfortunately only 3500 Opportunities from a total of aprox 75.000 Opportunities are indexed. I've opened another OSS Message on this issue.

[gregorw]

Another Update to this topic:

SAP provided Note 1527457 which unfortunately doesn't solved the problem completely. We're now investigating a Oracle database issue and still running the message 684357 / 2010 started August 21st 2010.

[Former Member]

Hi, we got exactly the same problem. Indexing is not possible.And the alert-protokoll in SES_ADMIN creates gigabytes of errors.

We will now try to update the TREX version. Hope that will solve the problem. I send an update if it works..

Our actual Trex Version is 7.10.37.00.

Edited by: Christian Dsen on Jan 4, 2011 1:15 PM

[gregorw]

We're also running 864174 / 2010 where we try to find a way to index Attachments of CRM OneOrder Objects (in our case Opportunity Attachments). Today we where advised to update our TREX 7.10 to Revision 42.

The problem that not all Opportunities where index seems to be caused by a null value in the TEMPLATE_TYPE_IX column of table CRMD_ORDER_INDEX. OSS advised us to follow that steps:

create table <owner>."CRMD_ORDER_INDEX_BCK" as
select * from <owner>."CRMD_ORDER_INDEX";

-> Replace the null values currently in the template column with the default value of char fields:

update <owner>."CRMD_ORDER_INDEX"
set TEMPLATE_TYPE_IX = ' ' where TEMPLATE_TYPE_IX is null;
commit;

-> Add the NOT NULL constraint to the table:

alter table <owner>."CRMD_ORDER_INDEX"
modify TEMPLATE_TYPE_IX not null;

Wasn't able to test if that works as we do the TREX Update first.