Oct 022012

I had an issue in my environment where some network device’s configuration backups were failing most of the time.
It would come up with an error saying “Unable to write to the device. Either the device is not responding or the set SNMP community string is not correct”

When I did a Wireshark cap of the SNMP traffic, I noticed that the switch was still returning responses after the backup had failed already.
Increasing the DCM Timeout under CA Spectrum Modeling Information resolved the issue as it gave Spectrum more time to receive the reponses before it decided to time out.

Aug 032012

One of the other issues I’ve had with integrating OneClick with Business Objects is this error :

Error importing SRM content: Required dependencies not found on target system : [AQuGhZ2EfP1NkSXoQTUcKz0, AQck.q67O5dHtfsJTBBtsU0]

To fix this error, I had to set a system variable for JAVA_HOME via System Properties -> Advanced Tab -> Environment Variables. The JAVA_HOME variable should be pointing to the built in JDK, normally the path is C:\Program Files\SC\CommonReporting3\javasdk but this will need to suit your environment.

Once the variable has been set, you will need the install media to run the biconfig.bat file.
The file is located in the directory Disk1\cabi\biconfig on the install media.

Once you have changed into that directory, run this command replacing the parameters with one suited to your environment.
biconfig.bat -h “BOXI hostname" -u "Administrator" -p “admin password" -f “CABI install media directory\Disk1\cabi\content\cabi_default_groups.xml" -if “CABI install media directory\Disk1\cabi\content\ CABI_DefaultGroups.biar”

After this has been run, the integration should now work.

Jul 312012

I was having some issues trying to integrate CA Spectrum with CA Business Intelligence after I removed it and re-installed it onto my server.
I was getting an issue similar to this –

Error importing SRM Content: Unable to find servers with kind fileserver

Error importing SRM Content: Unable to find servers with kind fileserver

After having a look around, it seemed that after I reinstalled CA Business Intelligence, the servers within Business Objects were not enabled.
The server responsible for the Integration was the Input File Repository Server. When that was disabled, the Integration did not work. After that was enabled, I was able to integrate Spectrum with Business Objects.

To enable the servers, you need to access the BusinessObjects Central Management Console (CMC), click on Servers under the Organize heading, and make sure the servers are enabled there.

Jul 132012

I was trying to integrate CA Spectrum with CA NetQOS/NPC and it kept failing with a Bind Failure message when I tried to add Spectrum as a data source.
The error was that I was missing the netqos_integ.interface_addresses table.

Turns out that the integration did not work as it was supposed to, and I had to drop the 4 tables that was in the netqos_integ database, restart the OneClick services on the OneClick server, and then do the integration again. After I did that, I was able to add in Spectrum as a data source.

To check to see if the table really is missing or not, you can login to the MySQL instance on the OneClick server by running these commands on the OneClick server

cd $specroot\mysql\bin
./mysql -uroot -proot netqos_integ
show tables;

This will spit out a list of tables, of which interface_addresses should be one.
If it’s not there, then you may have the option of fixing it if the format file is around.
To do that, quit the MySQL command line client first, and then find your way to the data directory.

cd $specroot\mysql\data\netqos_integ

If there is a filed called interface_addresses.MYD or a couple of files called interface_addresses.MYI and .FRM then you can run this command in the MySQL command line client to repair the table

repair table interface_addresses USE_FRM;

Otherwise, if there’s no format file, then drop the tables, and then do the integration again.

drop tables;

Then restart the OneClick services via services.msc and try again.

Hope this helps someone out there !