Error 'Sync Role' publishing crystal report from Content Mgm RPTADMIN

[Former Member]

Hello, I have some errors using Content Administration Workbench.

I have successfully excecute the following steps:

1) I installed Business Object Enterprise XI 3.0 and BOE FIX 2.0 on the same server running BI 7.0;

2) I installed BusinessObjects XI 3.0 Integration for SAP and Fix 2.0;

3) I configured a SAP (BW) entitlement system after setting SAP JCO.

4) I imported SAP users and roles into BOE CMC and set the folder for the contents (SAP/2.0/)

5) I logon to BO using user and password of BW system;

6) I created RFC link to service BW plublisher via Registered Program and check with success the system;

7) With transaction /CRYSTAL/RPTADMIN, I configured a new BOE system, in all the configuration tabs. Then I try to publish a report crystal, I received the following error: '00002: Error during the synchronization of hierarchy folders for the role: TEST_CE' (the original error message was in italian language although I'm logon in english: 'Si è verificato un errore durante la sincronizzazione della gerarchia di cartelle per il ruolo: TEST_CE'.) In BOE, the folder /SAP/2.0/ID4CLNT100, the user, that have Publisher role, is set to Administrator.

Another error is the setting about the http configuration of BOE system:

On the HTTP tab, in the field 'Path' the Installation Guide shows to insert the value 'SAP' as vitual Path. It's correct? Trying to launch the report (mouse right-button on report -> view report) from the Content Administrator Workbench, the Internet Explorer URL is set to http://server01:8080/SAP/reportView.do?bw_id=D41HOMGVWE4MA8378E0JORA5S&sap_sysid=ID4&sap_client=100&..., but nothing appears.

Any ideas about these issues?

Thank you in advance.

Giovanni Caglioni

[Former Member · Accepted solution]

Hi Ingo,

I will answer to your questions:

you using the BW Publishing service ? yes, service bwcepubsvc run on Windows 2003 server If so make sure all the entries are correct and using the full

qualified names

you created a TCP/IP destination in transaction sm59 for the publishing service and it works ? yes, the configuration is set via Registered Program and test is ok

in transaction /crystal/rptadmin :

- you created a BOE Server Entry and added the roles that you want to use for publishing to the role tab yes I added roles as suggest into Installation guide (BOE_SYSTEMS_ADMINISTRATOR, BOE_PUBLISHER, BOE_CONTENT)

- you also did add the entry from transaction SM59 for the service yes

- what happens when you test the system definition on the second tab with the TCP/IP destination ? green status: Successfully connected to the target system

you also went to the management console and did configure the SAP authentication and imported the roles from the SAP server ? yes I imported roles: all roles like 'BOE*' and user role which contains the folder and report crystal. those roles need to match the BOE Server definition roles

you did add those roles to the adminsitrator group - just now for testing purposes ? yes

The root folder named 'FOLDER1' as already said is creating into CMC; but the publishing action does'nt finish and no report is publishing.

Giovanni

[IngoH · Accepted solution]

Hi Giovanni,

in the registry under the key :

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\SAP

You should also find an entry for the Publishing Service and for the BW Publishing. Both have a value "Trace" which you can set to "Yes".

directly under the key SAP you will find a value "TraceDir" where you can set the folder for all the logfiles.

Please run the publishing again and attach the logfiles here in the forum

Ingo

[Former Member · Accepted solution]

I am facing the same issue right now. did this ever get resolved?

[Former Member · Accepted solution]

I am running the /crystal/rptadmin in the GRC Process Control system. and its taking forever when i try to publish them.

[IngoH · Accepted solution]

Hi Shaik,

I would suggest that you post a new entry and describe your problem in more details.

Ingo

[Former Member]

Hi Ingo, I attach the log file of bw publisher service.

***********************

Timestamp ProcessID ThreadID Message

[Thu Sep 25 12:36:27 2008] 10528 13704 Entering CPubReqPing::Process(1)

[Thu Sep 25 12:36:27 2008] 10528 13704 Logging on to Crystal Enterprise

[Thu Sep 25 12:36:28 2008] 10528 13704 Logged on to CMS "spsv00ye.saipem.pri" as user "ID4~100/BOEADMIN" with id 5555

[Thu Sep 25 12:36:28 2008] 10528 13704 Leaving CPubReqPing::Process(1)

[Thu Sep 25 12:36:28 2008] 10528 13704 Dispatch returned with code 0 and message [See RFC trace file or SAP system log for more details]

[Thu Sep 25 12:36:28 2008] 10528 13704 Entering CPubReqPublishRoles::Process(1)

[Thu Sep 25 12:36:28 2008] 10528 13704 Entering CPubBWConnector::GetQueryLocation()

[Thu Sep 25 12:36:28 2008] 10528 13704 SAP Publisher BW Binding: 1 roles returned. Deduced active system id to be 00001 from the first row [role: FOLDER1]

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: base_folder Value /SAP/2.0/

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_aps_nam Value spsv00ye.saipem.pri

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_lang_list Value D E F I

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_path_pr Value SAP

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_protcl Value http

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_server Value spsv00ye.saipem.pri:8080

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: ce_viewer Value reportView.do

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: folder_policy Value VOD

[Thu Sep 25 12:36:28 2008] 10528 13704 System 00001: Name: report_policy Value VIW

[Thu Sep 25 12:36:28 2008] 10528 13704 Running job synchronously

[Thu Sep 25 12:36:28 2008] 10528 13704 Entering job processor CPubJobGetRoleMetaData(FOLDER1)

[Thu Sep 25 12:36:28 2008] 10528 13704 Entering CopyRfcHandle(1)

[Thu Sep 25 12:36:28 2008] 10528 13704 Starting up callback server at 10.131.150.42 sapgw00 with prog-id SEGID2A96830AA13704

[Thu Sep 25 12:36:28 2008] 10528 13704 GetRfcHandle() returned with handle 2

[Thu Sep 25 12:36:28 2008] 10528 13704 Leaving job processor CPubJobGetRoleMetaData(FOLDER1)

[Thu Sep 25 12:36:28 2008] 10528 13704 Logging on to Crystal Enterprise

[Thu Sep 25 12:36:29 2008] 10528 13704 Logged on to CMS "spsv00ye.saipem.pri" as user "ID4~100/BOEADMIN" with id 5555

[Thu Sep 25 12:36:29 2008] 10528 13704 Generating Enterprise token "spsv00ye.saipem.pri:6400@6721Jjz7Tt49213hiU366719JJB87ylsoUuA6kbj" for use with repository linked reports.

[Thu Sep 25 12:36:29 2008] 10528 13704 Worker thread created. Placing in active queue.

[Thu Sep 25 12:36:29 2008] 10528 13352 Entering job processor CPubJobCompositeReport

[Thu Sep 25 12:36:29 2008] 10528 13704 Base folder hierarchy: /SAP/2.0/ID4CLNT100

[Thu Sep 25 12:36:29 2008] 10528 13704 FindFolder Query: SELECT SI_ID, SI_PATH FROM CI_INFOOBJECTS WHERE SI_NAME='ID4CLNT100' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Sep 25 12:36:29 2008] 10528 13352 Running job synchronously

[Thu Sep 25 12:36:29 2008] 10528 13352 Entering job processor CPubJobDownloadReport(D41HOMGVWE4MA8378E0JORA5S)

[Thu Sep 25 12:36:29 2008] 10528 13352 Reused connection 2

[Thu Sep 25 12:36:29 2008] 10528 13704 FindFolder returned 2 items from query SELECT SI_ID, SI_PATH FROM CI_INFOOBJECTS WHERE SI_NAME='ID4CLNT100' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Sep 25 12:36:29 2008] 10528 13704 Base folder id is 6692

[Thu Sep 25 12:36:29 2008] 10528 13704 Worker thread created. Placing in active queue.

[Thu Sep 25 12:36:29 2008] 10528 13704 CPubReqPublishRoles::s_force_publish=()

[Thu Sep 25 12:36:29 2008] 10528 13136 Entering job processor CPubJobCEFolders(FOLDER1)

[Thu Sep 25 12:36:29 2008] 10528 13704 About to start publishing reports to CE. Waiting for folders and report metadata.

[Thu Sep 25 12:36:29 2008] 10528 13136 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[FOLDER1]

[Thu Sep 25 12:36:29 2008] 10528 13136 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[Reports Crystal]

[Thu Sep 25 12:36:29 2008] 10528 13136 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[SAIPEM]

[Thu Sep 25 12:36:29 2008] 10528 13136 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[testportale]

[Thu Sep 25 12:36:29 2008] 10528 13136 CPubLocFolderHierarchy::ParseRoleFolderInfo:l_sText:[REPORTCETEST]

[Thu Sep 25 12:36:29 2008] 10528 13136 FindObjects query: SELECT SI_NAME, SI_LOC_NAMES, SI_LOC_ORIGINAL_LOCALE FROM CI_INFOOBJECTS WHERE SI_PROGID='CrystalEnterprise.Folder' AND SI_PARENT_FOLDER='6692' AND SI_SAP_FOLDER_ID='FOLDER1 0000000000'

[Thu Sep 25 12:36:29 2008] 10528 13136 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='6692' AND SI_SAP_FOLDER_ID='FOLDER1 0000000000'

[Thu Sep 25 12:36:29 2008] 10528 13136 FindObjects query: SELECT SI_PATH FROM CI_INFOOBJECTS WHERE SI_ID='6693' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Sep 25 12:36:29 2008] 10528 13136 FindObjects returned 1 items from query SELECT SI_PATH FROM CI_INFOOBJECTS WHERE SI_ID='6693' AND SI_PROGID='CrystalEnterprise.Folder'

[Thu Sep 25 12:36:29 2008] 10528 13136 FindObjects query: SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='ID4~100@FOLDER1'

[Thu Sep 25 12:36:29 2008] 10528 13136 FindObjects returned 0 items from query SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='ID4~100@FOLDER1'

[Thu Sep 25 12:36:29 2008] 10528 13136 ERROR: \Titan_FP_RTM_REL\src\Partner\Sap\src\ce_folder_hierarchy.cpp [318]: E_NOINTERFACE failed with return code l_hr = -2147467262

[Thu Sep 25 12:36:29 2008] 10528 13136 COM Exception caught in CCEFolderHierarchy::RelateFolderToUserGroup. HRESULT = -2147467262

[Thu Sep 25 12:36:29 2008] 10528 13136 ERROR: .\ce_folders.cpp [226]: m_objBaseHierarchy.RelateFolderToUserGroup(l_sFullUserGroupName, l_nRoleRootFolderId) failed with return code l_hr = -2147467262

[Thu Sep 25 12:36:29 2008] 10528 13136 Leaving job processor CPubJobCEFolders(FOLDER1)

[Thu Sep 25 12:36:29 2008] 10528 13352 Downloaded report D41HOMGVWE4MA8378E0JORA5S with master langugage E in the following languages: D E F I

[Thu Sep 25 12:36:29 2008] 10528 13352 Adjusted language list for report D41HOMGVWE4MA8378E0JORA5S is "E"

[Thu Sep 25 12:36:29 2008] 10528 13352 Leaving job processor CPubJobDownloadReport(D41HOMGVWE4MA8378E0JORA5S)

[Thu Sep 25 12:36:29 2008] 10528 13352 Running job synchronously

[Thu Sep 25 12:36:29 2008] 10528 13704 error happened when synchronizing role folder

[Thu Sep 25 12:36:29 2008] 10528 13352 Entering job processor CPubJobDownloadReport(D40SYD1Z6OCU3BPKH1WFUKBAO)

[Thu Sep 25 12:36:29 2008] 10528 13704 Committing main info object collection.

[Thu Sep 25 12:36:29 2008] 10528 13352 Reused connection 2

[Thu Sep 25 12:36:29 2008] 10528 13704 Executing InfoStore query: SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='ID4~100@FOLDER1'

[Thu Sep 25 12:36:29 2008] 10528 13704 0 objects returned by query SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_NAME='ID4~100@FOLDER1'. Return code: 1

[Thu Sep 25 12:36:29 2008] 10528 13352 Downloaded report D40SYD1Z6OCU3BPKH1WFUKBAO with master langugage E in the following languages: D E F I

[Thu Sep 25 12:36:29 2008] 10528 13352 Adjusted language list for report D40SYD1Z6OCU3BPKH1WFUKBAO is "E"

[Thu Sep 25 12:36:29 2008] 10528 13352 Leaving job processor CPubJobDownloadReport(D40SYD1Z6OCU3BPKH1WFUKBAO)

[Thu Sep 25 12:36:29 2008] 10528 13352 Running job synchronously

[Thu Sep 25 12:36:29 2008] 10528 13352 Entering job processor CPubJobProcessReport

[Thu Sep 25 12:36:29 2008] 10528 13352 Reused connection 2

[Thu Sep 25 12:36:30 2008] 10528 13352 Content marker: 0

[Thu Sep 25 12:36:30 2008] 10528 13352 Entering CopyRfcHandle(1)

[Thu Sep 25 12:36:30 2008] 10528 13352 Starting up callback server at 10.131.150.42 sapgw00 with prog-id SEGID2A96830AA13352

[Thu Sep 25 12:36:30 2008] 10528 13352 GetRfcHandle() returned with handle 3

[Thu Sep 25 12:36:30 2008] 10528 13352 Creating a BW Query report wrapper.

[Thu Sep 25 12:36:30 2008] 10528 13352 Creating a BW MDX Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW MDX Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 master language:[E]

[Thu Sep 25 12:36:31 2008] 10528 13352 report title for Lang [E] is [testportale]

[Thu Sep 25 12:36:31 2008] 10528 13352 Setting location for report D41HOMGVWE4MA8378E0JORA5S to: Server: spsv00ye.saipem.pri, logon string "CLIENT=100 LANG=EN ASHOST="spsv00ye.saipem.pri" SYSNR=00 R3NAME=ID4 TRACE=X"

[Thu Sep 25 12:36:31 2008] 10528 13352 RFC connection 2 died during operation. Message See RFC trace file or SAP system log for more details

[Thu Sep 25 12:36:31 2008] 10528 13352 Leaving job processor CPubJobProcessReport

[Thu Sep 25 12:36:31 2008] 10528 13352 Running job synchronously

[Thu Sep 25 12:36:31 2008] 10528 13352 Entering job processor CPubJobProcessReport

[Thu Sep 25 12:36:31 2008] 10528 13352 Reused connection 3

[Thu Sep 25 12:36:31 2008] 10528 13352 Content marker: 0

[Thu Sep 25 12:36:31 2008] 10528 13352 Entering CopyRfcHandle(1)

[Thu Sep 25 12:36:31 2008] 10528 13352 Starting up callback server at 10.131.150.42 sapgw00 with prog-id SEGID2A96830AA13352

[Thu Sep 25 12:36:31 2008] 10528 13352 GetRfcHandle() returned with handle 4

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW MDX Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 Creating a BW MDX Query report wrapper.

[Thu Sep 25 12:36:31 2008] 10528 13352 master language:[E]

[Thu Sep 25 12:36:31 2008] 10528 13352 report title for Lang [E] is [REPORTCETEST]

[Thu Sep 25 12:36:31 2008] 10528 13352 Setting location for report D40SYD1Z6OCU3BPKH1WFUKBAO to: Server: spsv00ye.saipem.pri, logon string "CLIENT=100 LANG=EN ASHOST="spsv00ye.saipem.pri" SYSNR=00 R3NAME=ID4 TRACE=X"

[Thu Sep 25 12:36:32 2008] 10528 13352 RFC connection 3 died during operation. Message See RFC trace file or SAP system log for more details

[Thu Sep 25 12:36:32 2008] 10528 13352 Leaving job processor CPubJobProcessReport

[Thu Sep 25 12:36:32 2008] 10528 13352 Leaving job processor CPubJobCompositeReport

************************************

Giovanni

[IngoH]

hi Giovannie,

couple of questions:

- Did you ensure the base folder created in the CMC and in the transaction /Crystal/rptadmin are identical ?

- did you assign the necessary rights for the roles in the BOE system ?

Ingo

[Former Member]

Looking at your log file, it appears that the publisher user is having trouble updating the Folder1(Content Role Folder). There are multiple reasons why this can happen. Please verify the following items to resolve your issue.

1-Make sure Folder1 role contains a Unique description in the language that the report is created in. This is done in tcode PFCG

2-Make sure Folder1 role is imported into CMC > SAP authentication

3-Make sure publisher user has appropriate rights on CMC (BOE). This seems confirmed already.

4-Make sure Folder role is added to the Enterprise system in Role tab within /crystal/rptadmin or that the system is check as the default system

5-Make sure your SAP user is configured/created with the right Lincese type. This can be confirmed in CMC by verifying the type of lincense configured on your BOE system (Named/concurrent). Then under User and Group administration, check the properties of your user to validate its lincense type. They must match to proceed

[IngoH]

Hi Giovanni,

has this been sorted out ?

thanks

ingo

[Former Member]

Hi,

I have a problem with BW_publisher setting.

I don´t get Roles in:

I´ve posted complete explanation in

and

Could you help me please ?

regards

[Former Member]

Hi Ingo, I set trace log, restart service.

Here's the log:

Timestamp ProcessID ThreadID Message

[Thu Sep 18 10:50:39 2008] 12464 6016 SAP bwcepubsvc: Tracing is enabled.

[Thu Sep 18 10:50:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 0, nInit: 0, nReady: 0, nBusy: 0

[Thu Sep 18 10:50:39 2008] 12464 13008 SAP BW PubSvc: Created publisher process with PID: 11328

[Thu Sep 18 10:51:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:51:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:52:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:52:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:53:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:53:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:54:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 1, nBusy: 0

[Thu Sep 18 10:54:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 1, nInit: 0, nReady: 0, nBusy: 1

[Thu Sep 18 10:54:39 2008] 12464 13008 SAP BW PubSvc: Created publisher process with PID: 13460

[Thu Sep 18 10:55:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 2, nBusy: 0

[Thu Sep 18 10:55:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:56:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:56:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:57:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:57:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:58:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:58:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:59:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 10:59:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:00:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:00:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:01:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:01:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:02:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:02:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:03:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:03:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:04:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:04:39 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:05:09 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:05:41 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:06:11 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:06:41 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:07:11 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:07:41 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:08:11 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

[Thu Sep 18 11:08:41 2008] 12464 13008 SAP BW PubSvc: RfcCheckRegisterServer returned nTotal: 2, nInit: 0, nReady: 1, nBusy: 1

Meanwhile the publish action still running...

Giovanni

[IngoH]

Hi Giovanni,

we would need the logfile for the publishing service and the actual publishing. You should be able to find both entries in the registry.

You can also attach a file here in the forum.

Ingo

[Former Member]

Hi Ingo,

We are having the same issue with the same SAP/BOBJ environment as Giovanni... I will follow the thread up to here and also generate the trace log files...

Thanks

Jacques

[IngoH]

Hi,

what exactly is the issue you have ?

ingo

[Former Member]

Hi Ingo,

From /crystal/rptadmin.... '00002: Error during the synchronization of hierarchy folders for the role.

I am setting everything up and will post in about 1 hour...

[Former Member]

Hi Ingo,

Ok... It seems that this error has been resolved by adding the ADMIN and PUBLISHER roles to the BOE Adminstrators group.. I will clean this up...

But, then I don't know where the next issue is coming from...

From /crystal/rptadmin I can publish the report. The report is published to BOE in the following path... Public Folders --> BWPCLNT333 --> the remaing role folder structure as in BW... is this structure not supposed to be created un SAP --> 2.0 --> BWPCLNT333 --> the remaining role folder structure as in BW ??? Why I ask is that when I try to run the report from the GUI or the Portal... I get the following

Service cannot be reached

What has happened?
URL http://<sapbwservername>:8000/(ce_path_pr)/viewreport.csp call was terminated because the corresponding service is not available.
  
Note

The termination occurred in system BWP with error code 404 and for the reason Not found. 
The selected virtual host was 0 . 
  

What can I do?
Please select a valid URL. 
If you do not yet have a user ID, contact your system administrator. 

ErrorCode:ICF-NF-http-c:000-u:SAPSYS-l:E-i:CENTSAP26_BWP_00-v:0-s:404-r:Notfound

HTTP 404 - Not found

Your SAP Internet Communication Framework Team

What do I need to check config wise?

Thanks

Jacques

[Former Member]

Ok, this has also been sorted...

In transaction SICF there were 2 HTTP request handlers set up for ce_url... the redundant handler was removed and everything is working fine now.

[IngoH]

Hi,

take a look at the 3 blogs I created recently outlining all required steps for the publishing configuration.

Publishing part 1

Publishing part 2

Publishing part 3

You will also find the items with the URL configuration (transaction SICF, HTTP Request) in there

ingo

[Former Member]

Thanks Ingo.

I applied your suggestion and in BOE I added Roles and User SAP into Administrator group. But publishing action does'nt work.

Then, to folder 'SAP' in CMC, to the security management I added directly the group named ID4_{100@BOE_SYSTEM_ADMINISTRATORS and also the user ID4}100/BOEADMIN.

Then logging in BW with user BOEADMIN (role BOE_SYSTEM_ADMINISTRATORS), running /CRYSTAL/RPTADMIN transaction, and publishing again a role/folder, the sync error message doesn't appear. Good.

But unfortunately, the publishing action remain active (with hourglass for many minutes); in SM50 the work process dialog is in Hold Status; I checked in SMGW the status of connection to crystal publisher: it's 'Connected' starus.

On server BOE (Windows 2003 Server), task manager has two process 'bwcepub.exe', but CPU usage is 0%.

I checked in CMC and now I find a new folder called like the role I published under path SAP\2.0\ID4CLNT100; the created date/hour is after the publising action, but I don't find any reports.

How I can trace the comunication from BW and BOE Publish service?

Is there a security problem again?

Giovanni

[IngoH]

Hi Giovanni,

lets go through the items to make sure the configuration is all correct:

- you using the BW Publishing service ? If so make sure all the entries are correct and using the full

qualified names

- you created a TCP/IP destination in transaction sm59 for the publishing service and it works ?

- in transaction /crystal/rptadmin :

- you created a BOE Server Entry and added the roles that you want to use for publishing to the role tab

- you also did add the entry from transaction SM59 for the service

- what happens when you test the system definition on the second tab with the TCP/IP destination ?

- you also went to the management console and did configure the SAP authentication and imported the roles from the SAP server ? those roles need to match the BOE Server definition roles

- you did add those roles to the adminsitrator group - just now for testing purposes ?

thanks

Ingo

[IngoH]

Hi Giovanni,

the second issue is most likely based on the situation that you haven't been able to publish a report.

You mentioned that you imported the roles from the SAP System. Did you also assign the necessary BusinessObjects Enterprise rights to those roles so that those roles have the right to actually create content on the BusinessObjects Enterprise system ? You could easily test that by adding those roles to the Administrator role from BusinessObjects.

thanks

ingo