CA Service Management

Expand all | Collapse all

AHD03117 Error while publishing

  • 1.  AHD03117 Error while publishing

    Posted Mar 31, 2017 09:12 AM

    Hi Team,

     

    We have followed the swing box approach to upgrade the system from r12.6 to r14.1. Post upgrading the swing box, we restored the swingbox dB to our UAT Environment. We did a pdm_publish as well. We moved the majic(.spl codes) as well from SwingBox(SB) to uat environment.

    Now when we run pdm_wsp command we get 2 errors(not sure why):

     

    1. HTMPL not found

    AHD04407:CA Service Desk Manager html generation error. Could not find or process 'wspmain.htmpl'.

    AHD04714:Unable to open file wspmain.htmpl at ?: No such file or directory (2) userid=Servicedesk

     

    2.  Below is the error which I'm getting:

    web:wsp     1044 ERROR     wsp_backend.c     6482 Error in checkin_done in Wsp_Column     orgx.z_org_num:1: INVALID AHD03117: Your current role does not have UPDATE_GLOBAL authorization,  so you cannot update public object Web Screen Painter Column z_org_num

    I found a KB article as well

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec592854.html

    but it is not clear, what needs to be done here. As we have moved the mdb from SB system, the multi tenancy Is already enabled. The ServiceDesk is also present.

     

    Please suggest what needs to be done. Its critical.

     

    Thanks



  • 2.  Re: AHD03117 Error while publishing

    Broadcom Employee
    Posted Mar 31, 2017 10:40 AM


  • 3.  Re: AHD03117 Error while publishing

    Posted Mar 31, 2017 11:26 AM

    hi paul, thanks for the reply... but it already has the analyst value set..and issue persists.

    I have also tried compatibility settings and used google chrome..but still the same issue.



  • 4.  Re: AHD03117 Error while publishing

    Broadcom Employee
    Posted Mar 31, 2017 03:02 PM

    Are you using the default ServiceDesk administrator account?

     

    If SDM is installed on a Windows OS, is the ServiceDesk account a member of the local OS Administrator group?



  • 5.  Re: AHD03117 Error while publishing

    Posted Mar 31, 2017 11:43 PM

    Hi Paul..we had checked that as well.. we can see that the user is "member of" administrators.

    Is there anything else that we can check..

     

    Also do you have any idea on the second issue?



  • 6.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:16 AM

    Hey Johnny,

     

    By any chance do you have multi-tenancy environment?

    If yes then see that the user with which your running pdm_publish must me part of service provider tenant.

     

    Thanks

    Junaid



  • 7.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:20 AM

    hi Junaid,

     

    yes multi-tenancy is installed in our Env... and ServiceDesk user is part of the service provider tenant



  • 8.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:20 AM

    I would also recommend you to refer the following technical document:

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec604807.html 



  • 9.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:25 AM

    Hi Junaid,

     

    I have already checked this tecdoc  , this didn't help



  • 10.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:39 AM

    The first error some how got resolved:

    1. Set the default browser to chrome.

    2. Took SD restart.

    3. Opened WSP and the page was visible properly.

     

    but the second issue persists..please help.



  • 11.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 01:48 AM

    Can you also check if mdbadmin user had the create table permission granted correctly.I feel like create table permissions been revoked for the mdbadmin user in DB.
    Also try to drop the newly created column z_org_num and then re-add and then check again.



  • 12.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 02:08 AM

    We are using ServiceDesk user to login to WSP and it has below rights;

     

    Owned schema: ServiceDesk

    Membership: amsgroup,ams_group,db_ddladmin,db_securityadmin,reg_admin,service_desk_admin_group,service_desk_d_painter_group,service_desk_ro_group,workflow_admin_group.

     

    mdbadmin also has same rights.

     

    Dropping the new column wont be possible as it contains data.



  • 13.  Re: AHD03117 Error while publishing
    Best Answer

    Broadcom Employee
    Posted Apr 01, 2017 04:39 AM

    Issue resolved by editing the Tenant access and Tenant write access to Single Tenant from All Tenants for given Role and after that we rolled back to All Tenants. Customer was able to save and publish using wsp.



  • 14.  Re: AHD03117 Error while publishing

    Posted Apr 01, 2017 06:02 AM

    thanks Anil for the timely support!



  • 15.  Re: AHD03117 Error while publishing

    Posted Apr 22, 2017 05:32 AM

    Hi Anil,

    we are facing the same issue on our production setup, and we performed the same steps but the issue persists.

    Thanks



  • 16.  Re: AHD03117 Error while publishing

    Posted Apr 22, 2017 07:21 AM

    Hi Anil,

     

    We are facing wsp publish issue with the servicedesk user, we tried with other user who has admin access and we were able to publish the schema. Please let me know if any1 has faced similar issue.

     

    Thanks



  • 17.  Re: AHD03117 Error while publishing

    Posted Apr 24, 2017 11:12 PM

    tks for sharing, i Documented:

    CA SDM - CA Service Desk - AHD Codes - Error