Publishing issue with BOE XI 3.1 and SAP IK

[Former Member]

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

[Former Member]

Thank you Ingo.

This step:

you then need to assign a principal to the user group in BOE (CMC > Users and Groups > select the group > add principal) and assign the same rights

was what I missed.

Now it works.

Stephan

[IngoH]

Hi,

- the user that is supposed to publish a report needs to be part of a role that has been imported

- that role needs to have the rights to view, edit, add, modify object as part of the role folder (or higher in the folder structure like the SAP system ID Folder).

detailed list of rights :

 Add objects to the folder that the user owns

 Add objects to the folder

 Copy objects to another folder that the user owns

 Copy objects to another folder

 Delete objects that the user owns

 Delete objects

 Edit objects

 Edit objects that the user owns

 Modify the rights users have to objects

 View objects

 View objects that the user owns

- you then need to assign a principal to the user group in BOE (CMC > Users and Groups > select the group > add principal) and assign the same rights

- then go to the Access Levels and use the Manage > user security option and give the role the following rights :

 View objects

 View objects that the user owns

 Edit Objects

 Edit objects that the user owns

 Use Access level for security assignment

Ingo