ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to edit the ITAM connection: CS Unable to connect to the InfoStore network layer is not available.(DAC0002)

book

Article ID: 8636

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Unable to access ITAM BOXI reports

<Please see attached file for image>

connection2012.jpg

Cause

 

 

 

 

Environment

Business Objects 4.1 SP3 Database: 2012

Resolution

Step 1 : Install SQL Server Native client on the BOXI server.

Step 2:  Login to Universe Designer -> tools->connections->New connection

a.  Provide a Connection Name.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKCiAAO" alt="screen1.jpg" width="374" height="338">

b. Select Microsoft -> MS SQL Server 2012->OLE DB Provider.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKCjAAO" alt="screen2.jpg" width="404" height="362">

 

c. Provide the valide user name, Password, Database server name, Name of the Database(ex:MDB)

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKCkAAO" alt="screen3.jpg" width="411" height="244">

d. Connection PoolMode: "Select Disconnect After Each transaction"

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKClAAO" alt="screen4.jpg" width="491" height="248">

e. Click finish to finish the process.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKCmAAO" alt="screen5.jpg" width="352" height="320">

 

Step 3 :  File -> Import -> CA IT Asset Manager.

Step 4:   File -> Paramater -> Connection:  Select the connection which is created under Step 2.

              Click on Edit and complete the wizar as per Step2.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKCnAAO" alt="screen6.jpg" width="414" height="192">

Step 5 : File -> Save.

Step 6 : File -> Export.

 

 

 

 

Attachments

1558700517992000008636_sktwi1f5rjvs16p3h.jpeg get_app
1558700516062000008636_sktwi1f5rjvs16p3g.jpeg get_app
1558700514127000008636_sktwi1f5rjvs16p3f.jpeg get_app
1558700512366000008636_sktwi1f5rjvs16p3e.jpeg get_app
1558700510570000008636_sktwi1f5rjvs16p3d.jpeg get_app
1558700508655000008636_sktwi1f5rjvs16p3c.jpeg get_app
1558700506594000008636_sktwi1f5rjvs16p3b.jpeg get_app