CA Service Management

  • Private Community
 View Only

  • 1.  AHD12008 error while running reports from webi

    Posted Nov 28, 2014 06:02 AM

    Hello Team,

     

    We have created few reports long back and scheduled to run every day till yesturday they were wroking fine.

     

    but today we received a errors  like  " A database error occured: The database error text is [datadirect][ODBC open access SDK driver] [OpenAccess SDK SQL engine] AHD12008:attribute owing_survey_question-rest referenced by majic sql query not found in objects(S) svy_ans at.owning_survey_question_text.(WIS 10901)"

     

    the above error message for survey report like every report we received different attibutes are not found  and all these attributes are created in attribute aliases.

     

    Could you Please suggest us what we need to check ?

     

    Thank you,

     

    Regards,

     

    Santoshi



  • 2.  Re: AHD12008 error while running reports from webi

    Broadcom Employee
    Posted Nov 28, 2014 09:54 AM

    Is this an offline reporting architecture?

     

    Have any recent changes been made, specifically regarding the MDB schema (i.e. pdm_publish)?

     

    Try running the following command on the SD Primary server and see if it helps

     

    pdm_cache_refresh –t attr_alias

     

    Paul Coccimiglio

    Principal Support Engineer



  • 3.  Re: AHD12008 error while running reports from webi

    Posted Nov 28, 2014 10:12 AM

    Hi Paul,

     

    Thank you for the reply,

     

    yesturday we have intiatied the Publication on MDB server but due to heavy load on CA SDM we stopped the Publication after Processing 10% of tables.

     

    but it was running background then kill the replication process which was setup.

     

    then restarted the CA services.

     

    so today morning out of 10 reports only 2 reports are executed.

     

    by the way i ran the comman which you have provided pdm_cache_refresh -t attr_alias but its showing as pdm_cache_refresh: No table names specified

     

    Thank you,

     

    Regards

    santoshi.P



  • 4.  Re: AHD12008 error while running reports from webi

    Broadcom Employee
    Posted Nov 28, 2014 10:14 AM

    Does the attr_alias table have any data?

     

    Paul Coccimiglio

    Principal Support Engineer



  • 5.  Re: AHD12008 error while running reports from webi

    Posted Nov 28, 2014 10:17 AM

    Yes, data is there



  • 6.  Re: AHD12008 error while running reports from webi
    Best Answer

    Broadcom Employee
    Posted Dec 02, 2014 04:23 PM

    Have you attempted to restart the SD Service on the primary server?



  • 7.  Re: AHD12008 error while running reports from webi

    Posted Dec 03, 2014 02:36 AM

    Hi Paul,

     

    We have restarted the services on our primary server on last saturday then its started working now,

     

    thank you for your support.

     

    Thank you..

     

    Regards,

    santoshi.P