Publication migration issue

[Former Member]

Hello,

  We are trying to migrate the publications from BOXI 3.1 to BI4.0 environment. But we are getting this error for some of the publications

"CE SDK Exception occurred : 'Not a valid query. (FWB

00025)' (FWM 04002) Not a valid query. (FWB 00025)The server supplied

the following details: OCA_Abuse exception 7683 at [.\InfoStore.cpp :

2991] 48163 {} ...Error generating parse treeSELECT SI_ID, SI_CUID

FROM CI_INFOOBJECTS,CI_SYSTEMOBJECTS,CI_APPOBJECTS WHERE

SI_HIDDEN_OBJECT IN (0,1) AND SI_ID IN(-1)"

We are on BI4.0 Sp2 patch13, windows 2008 server.  Any insight on this is greatly appreciated.

Thanks,

[Former Member · Accepted solution]

Hi Rakesh,

This error message could occur due to multiple causes. Kindly let us know how are you migrating the publications - import wizard or BIAR file. Also confirm if you are able to run the publication successfully in BOE 3.1 environment.

This error message could occur when the metadata of the publication gets corrupted, so, would suggest to check the properties of the "Source Document, Dynamic recipients report and the Profile Values " used in the publication. Re-adding and re-creating any one of this might solve the issue.

Kindly also refer SAP Note 1699608.

Regards,

Nakul Mehta

[Former Member · Accepted solution]

Thanks for the reply Nakul. We are using Upgrade management tool in BI4.0 to migrate the content. We checked the source, dynamic recepients and all the properties of publication everything looks good and they are working fine in source environment. We are getting the same error message that is mentioned in SAP notes 1699608, but re-creation is not the best option as we have so many publications. Any other ideas/workarounds? Thanks,