Former Member

Nov 20, 2008 at 08:35 PM

Publishing issue with BOE XI 3.1 and SAP IK

31 Views

Hi There,

this issue has been posted a few times before and I see other people are running into it as well. Nonetheless I have not found a satisfying answer in the Forum.

I have the problem that I can only publish a Crystal Report based on SAP BI if the publishing role is an Admin in BOE. that is not how it is supposed to work.

I followed all the guidelines and required settings and as soon as the publisher is no administrator I get an error. Publishing to BI works fine.

The error I get is:

An error occurred while saving and/or publishing. The return code 1 was returned from the server. An error occurred when synchronizing folder hierarchy for role:......

Here is the publishing log:

essage

[Thu Nov 20 10:06:33 2008] 2664 1688 Entering CPubReqPublishReport::Process(1)

[Thu Nov 20 10:06:33 2008] 2664 1688 Entering CPubBWConnector::GetQueryLocation()

[Thu Nov 20 10:06:33 2008] 2664 1688 SAP_LANGUAGE set to EN (got from rfc handle)

[Thu Nov 20 10:06:33 2008] 2664 1688 SAP Publisher BW Binding: 1 roles returned. Deduced active system id to be 00001 from the first row [role: Y:BI_PROG_MGR]

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: base_folder Value /SAP/2.0/

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_aps_nam Value cepvsabob81:6400

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_lang_list Value D E

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_path_pr Value SAP

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_protcl Value http

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_server Value cepvsabob81.gov.edmonton.ab.gov:8080

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: ce_viewer Value reportView.do

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: folder_policy Value FCT

[Thu Nov 20 10:06:33 2008] 2664 1688 System 00001: Name: report_policy Value FCT

[Thu Nov 20 10:06:33 2008] 2664 1688 Running job synchronously

[Thu Nov 20 10:06:33 2008] 2664 1688 Entering job processor CPubJobGetRoleMetaData(Y:BI_PROG_MGR)

[Thu Nov 20 10:06:33 2008] 2664 1688 Entering CopyRfcHandle(1)

[Thu Nov 20 10:06:33 2008] 2664 1688 Starting up callback server at 162.106.114.62 sapgw16 with prog-id SEGIDDC806AA2A01688

[Thu Nov 20 10:06:33 2008] 2664 1688 GetRfcHandle() returned with handle 2

[Thu Nov 20 10:06:33 2008] 2664 1688 Leaving job processor CPubJobGetRoleMetaData(Y:BI_PROG_MGR)

[Thu Nov 20 10:06:33 2008] 2664 1688 Logging on to Crystal Enterprise

[Thu Nov 20 10:06:35 2008] 2664 1688 Logged on to CMS "cepvsabob81:6400" as user "BIX~001/DUMMY" with id 1815

[Thu Nov 20 10:06:35 2008] 2664 1688 Generating Enterprise token "cepvsabob81.COE.ADS:6400@1897JkHE9ilGJ2Hgcinp1895JceHlHlYrNTzUBPQ" for use with repository linked reports.

[Thu Nov 20 10:06:35 2008] 2664 1688 Worker thread created. Placing in active queue.

[Thu Nov 20 10:06:35 2008] 2664 1688 Base folder hierarchy: /SAP/2.0/BIXCLNT001

[Thu Nov 20 10:06:35 2008] 2664 1688 FindFolder Query: SELECT SI_ID, SI_PATH FROM CI_INFOOBJECTS WHERE SI_NAME='BIXCLNT001' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Nov 20 10:06:35 2008] 2664 6784 Entering job processor CPubJobCompositeReport

[Thu Nov 20 10:06:35 2008] 2664 6784 Running job synchronously

[Thu Nov 20 10:06:35 2008] 2664 6784 Entering job processor CPubJobDownloadReport(4BW89NXFO63ORDK4YMDSU0GN2)

[Thu Nov 20 10:06:35 2008] 2664 6784 Reused connection 2

[Thu Nov 20 10:06:36 2008] 2664 1688 FindFolder returned 1 items from query SELECT SI_ID, SI_PATH FROM CI_INFOOBJECTS WHERE SI_NAME='BIXCLNT001' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Nov 20 10:06:36 2008] 2664 1688 Base folder id is 1465

[Thu Nov 20 10:06:36 2008] 2664 1688 Worker thread created. Placing in active queue.

[Thu Nov 20 10:06:36 2008] 2664 1688 CPubReqPublishReport::force_mode string()

[Thu Nov 20 10:06:36 2008] 2664 6784 Downloaded report 4BW89NXFO63ORDK4YMDSU0GN2 with master langugage E in the following languages: D E

[Thu Nov 20 10:06:36 2008] 2664 1688 CPubReqPublishReport::force_mode_bool(false)

[Thu Nov 20 10:06:36 2008] 2664 6784 Adjusted language list for report 4BW89NXFO63ORDK4YMDSU0GN2 is "E"

[Thu Nov 20 10:06:36 2008] 2664 1688 About to start publishing reports to CE. Waiting for folders and report metadata.

[Thu Nov 20 10:06:36 2008] 2664 6784 Leaving job processor CPubJobDownloadReport(4BW89NXFO63ORDK4YMDSU0GN2)

[Thu Nov 20 10:06:36 2008] 2664 6784 Running job synchronously

[Thu Nov 20 10:06:36 2008] 2664 6784 Entering job processor CPubJobProcessReport

[Thu Nov 20 10:06:36 2008] 2664 6784 Reused connection 2

[Thu Nov 20 10:06:36 2008] 2664 2448 Entering job processor CPubJobCEFolders(Y:BI_PROG_MGR)

[Thu Nov 20 10:06:36 2008] 2664 2448 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[Projektcontroller]

[Thu Nov 20 10:06:36 2008] 2664 2448 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[Program Manager]

[Thu Nov 20 10:06:36 2008] 2664 2448 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[BOBJ_Test_1]

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects query: SELECT SI_NAME, SI_LOC_NAMES, SI_LOC_ORIGINAL_LOCALE FROM CI_INFOOBJECTS WHERE SI_PROGID='CrystalEnterprise.Folder' AND SI_PARENT_FOLDER='1465' AND SI_SAP_FOLDER_ID='Y:BI_PROG_MGR 0000000000'

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects returned 1 items from query SELECT SI_NAME, SI_LOC_NAMES, SI_LOC_ORIGINAL_LOCALE FROM CI_INFOOBJECTS WHERE SI_PROGID='CrystalEnterprise.Folder' AND SI_PARENT_FOLDER='1465' AND SI_SAP_FOLDER_ID='Y:BI_PROG_MGR 0000000000'

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects query: SELECT SI_PATH FROM CI_INFOOBJECTS WHERE SI_ID='1808' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects returned 1 items from query SELECT SI_PATH FROM CI_INFOOBJECTS WHERE SI_ID='1808' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects query: SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='BIX~001@Y:BI_PROG_MGR'

[Thu Nov 20 10:06:36 2008] 2664 2448 FindObjects returned 0 items from query SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='BIX~001@Y:BI_PROG_MGR'

[Thu Nov 20 10:06:36 2008] 2664 2448 ERROR: ..\..\src\ce_folder_hierarchy.cpp [328]: E_NOINTERFACE failed with return code l_hr = -2147467262

[Thu Nov 20 10:06:36 2008] 2664 2448 COM Exception caught in CCEFolderHierarchy::RelateFolderToUserGroup. HRESULT = -2147467262

[Thu Nov 20 10:06:36 2008] 2664 2448 ERROR: .\ce_folders.cpp [226]: m_objBaseHierarchy.RelateFolderToUserGroup(l_sFullUserGroupName, l_nRoleRootFolderId) failed with return code l_hr = -2147467262

[Thu Nov 20 10:06:36 2008] 2664 2448 Leaving job processor CPubJobCEFolders(Y:BI_PROG_MGR)

[Thu Nov 20 10:06:36 2008] 2664 1688 error happened when synchronizing role folder

[Thu Nov 20 10:06:36 2008] 2664 1688 Leaving CPubReqPublishReport::Process(1)

[Thu Nov 20 10:06:36 2008] 2664 1688 Dispatch returned with code 0 and message [See RFC trace file or SAP system log for more details]

[Thu Nov 20 10:06:36 2008] 2664 6784 Content marker: 0

If someone ran into this issue and fixed it could you please give me your steps so I can check with what I did?

Thanks,

Stephan