[BI4.x] - Trending DB - switching from Derby to SQL server

security CMC
1

Has anyone already succeded to switch the 4 trend monitoring tables from the default Derby to another SQL server one ?

I have created the 4 tables in SQL Server, switched in the CMC after having modified the SBO file but no lines appear after in the database tables :frowning:

I think there is an issue with the SBO files as in the official PDF file I find it not very clear. Is someone facing this issue has already found the solution ?

Thank you in advance
Bernard

bernard timbal :fr: (BOB member since 2003-05-26)

2

Did you try exporting the data from the Derby database and into the SQL Server database like the instructions say in the Administrator’s Guide?

Not that this will necessarily help, I’m at the point where I’m trying to restore the CSV file contents to SQL Server but is not working.

3

solved now, thank you for your interest, it was a mistake in my SBO file. It runs fine now. For the imports, it seems that some columns are missing from the CSV files. Never succedded but the historical retrieve from the derby database is not quite important then… never mind as far as I am concerned

bernard timbal :fr: (BOB member since 2003-05-26)

4

Well, this is embarrassing. :oops: It appears that I made my modifications to the sbo file in the backup copy I had made instead of in the actual config file itself. I’ll have to try again.

Edit:
Well, there is still something not working right. The probes are showing errors that they can’t retrieve data from the database and there isn’t anything being writen to the SQL Server database.

Bernard, can you share what the error was in your sbo file?

5

here the end of my sbo file (with sql server 2008 cms and audit database)

    </Defaults>
    <DataBases>
        <DataBase Active="Yes" Name="MS SQL Server 2008">
              <Aliases>
		      <Alias>MS SQL Server</Alias>
               </Aliases>
              <Libraries>
                <Library>dbd_wmssql</Library>
                <Library>dbd_mssql</Library>
            </Libraries>
            <Parameter Name="Extensions">sqlsrv2008,sqlsrv,odbc</Parameter>
            <Parameter Name="CharSet Table" Platform="Unix">datadirect</Parameter>
            <Parameter Name="Driver Name">SQL (Server|Native Client)</Parameter>
            <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>
        </DataBase>
    </DataBases>
</DriverConfiguration>

bernard timbal :fr: (BOB member since 2003-05-26)

6

That’s essentially what I added but we are using SQL Server 2012.

        <!-- Drivers for SQL Server 2012 added to support storing the monitoring trending data in the Audit database -->
        <DataBase Active="Yes" Name="MS SQL Server 2012">
          <Libraries>
            <Library>dbd_wmssql</Library>
            <Library>dbd_mssql</Library>
          </Libraries>
          <Parameter Name="Extensions">sqlsrv2012,sqlsrv,odbc</Parameter>
          <Parameter Name="CharSet Table" Platform="Unix">datadirect</Parameter>
          <Parameter Name="Driver Name">SQL (Server|Native Client)</Parameter>
          <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>
        </DataBase>

I copied it from sqlsrv.sbo so I would think it would be correct.

Are your probes working fine with your setup? When I tried pointing to the SQL Server database, I get errors with the probes that says they can’t retrieve data from the database.

Of course, the Error Guide document isn’t much help on this error. Nothing came up in the SAP Note search either.

Also, after leaving it over night, there still isn’t any data in the tables in the SQL Server database. There’s lots of data in the Audit tables so it shouldn’t be a connection issue.

7

i can’t find the alias line in your sbo file extract. maybe it is why it can’t work. you have to find the right syntax in you sbo and you error message will end.

In the other end, I find the new monitoring application very weak ! For example, on an out-of-the-box empty cms (just after the install), I imported a full LCMBIAR backup and the monitoring application was broken after. Same thing after if you reset your CMS scratching all data in your cms database. your monitoring application will be broken. I have’nt found yet the solution how to reset it and make it just it is after a fresh install. I thing, something is missing here…

bernard timbal :fr: (BOB member since 2003-05-26)

8

You may be right. I redid what I had put in before but I typed in it rather than copy it in. I also added the alias lines and it is working now.

This isn’t good. I’m planning to do this before our final upgrade. Hopefully I will have some time to test this and work with it before we have to do our upgrade.