Unable to run BOXI report. Error : The Database SQL Generation parameter file could not be loaded (<Server Name>, OLEDB) . (Error:INF)

Document ID : KB000056652
Last Modified Date : 14/02/2018
Show Technical Document Details

OLEDB Error.png

Steps to Recreate NEW OLE DB Connection.

Step 1 :  Go To BOXI Server.

Step 2 :  Login to Designer

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

 Import-Universe.png

Step 4 : Tools-> Connection-> Select "ITAM"

 Connection wizard.png

Step 5 :  Edit " ITAM  Connection"

connectionwizard2.png

User Name: BOXI User Which is used for connect to Database.

Password :  Password of BOXI User to connect to Database.

Server : tcp:<Database Server which host MDB>,1433

Database: MDB.

Note: You may Click Test Connection button to check connectivity. Message should be " The  Server is Responding".

Click "NEXT".

Step 6 : Set the connection Pool Mode: " Disconnect After Each transaction".

connectionwizard3.png

Click Next and Finish the Wizard.

Step 7 :  File -> Parameter.

parameter1.png

Note: Make Sure ITAM is Selected under Connection Field.

Step 8 :  File ->  Export . (This would Save the changes made to Universe, Gets Successfully Uploaded to CMS Database).

filesave.png

Click OK to complete the steps.

Now you may run Reports.