$U Reporter Issues

[Pothen Verghese]

Dear All,

We are trying to get the $U Reporter work, but so far no success. We have done the below:

- Installed the Reporter Server on a Windows 12 machine with sqljdbc42.jar
- Ran the sqlcmd to populate the database tables
- Stopped and started the Reporter service

But we can't see the Reporter server node within the Console. The fact is the install process nowhere asks the UVMS details so how will it connect?

Similarly the install process doesn't ask the Reporter Database details. So when it starts we can see the error message that "The required JDBC database driver is missing......" The problem here again is that the actual Database details are not taken during install process and it defaults to oracle. In our case it is MS SQL Server.

All the post install configuration assumes that one can see the Reporter on UVMS, which is not in this case.

So far we have tried manually setting "default.load.xml" with the correct database. But we are not sure what is value/keyword for MSSQL Server? We have tried few random words like MSSQL, but then the error message at startup says "The load target parameters are invalid. Database couldn't be reached".

We have also tried uvmslist.xml file with UVMS server details but that has not helped and we still are unable to view the Reporter Server under UVMS. There are password fields in both xml files. Are these passwords supposed to be in clear text?

Can someone please advise on the above problems? Especially what is the keyword for DBtype in case it is MSSQL? And are we supposed to use password in cleartext?

Also the install process and documentation for Reporter needs improvement. Hope the PM will take a look and fix this.

Regards
Pothen

[Pothen Verghese]

Dear All,

After trying different terms for dbType, we have hit a new problem as below:

19 Nov 2020 10:38:33 [main] com.orsyp.reppub.server.util.CryptoUtility - Error decrypting the password.
com.orsyp.crypto.StringEncrypter$EncryptionException: javax.crypto.IllegalBlockSizeException: Input length must be multiple of 8 when decrypting with padded cipher

Any ideas if there is any tool within $U to encrypt a password? I am assuming if the above error is because of the clear text password for db user! 

Regards
Pothen

[Pothen Verghese]

Found unicryptpasswd.bat under univiewer and encrypted the DB User's password. Now we are hitting the below error:

[ERROR] 19 Nov 2020 17:00:32 [main] com.orsyp.reppub.server.util.CryptoUtility - Error decrypting the password.
com.orsyp.crypto.StringEncrypter$EncryptionException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
at com.orsyp.crypto.StringEncrypter.decrypt(StringEncrypter.java:148)
at com.orsyp.reppub.server.util.CryptoUtility.decryptServerPassword(CryptoUtility.java:83)
at com.orsyp.reppub.server.manager.db.DatabaseManager.getMSSqlServerConnection(DatabaseManager.java:478)
at com.orsyp.reppub.server.manager.db.DatabaseManager.checkDatabaseConnectivity(DatabaseManager.java:599)
at com.orsyp.reppub.server.process.RepDBChecker.startDBCheckStatuses(RepDBChecker.java:220)
at com.orsyp.reppub.server.ReporterStartup.main(ReporterStartup.java:195)
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
at com.sun.crypto.provider.CipherCore.unpad(CipherCore.java:975)
at com.sun.crypto.provider.CipherCore.fillOutputBuffer(CipherCore.java:1056)
at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:853)
at com.sun.crypto.provider.DESedeCipher.engineDoFinal(DESedeCipher.java:294)
at javax.crypto.Cipher.doFinal(Cipher.java:2168)
at com.orsyp.crypto.StringEncrypter.decrypt(StringEncrypter.java:142)
... 5 more
[INFO ] 19 Nov 2020 17:00:32 [main] com.orsyp.reppub.server.process.RepDBChecker - The load target parameters are invalid. Database couldn't be reached

The encrypted password looks like

af9593c48f976faedaf10bf63c516a10MLRGGb0m74LCNnbwN3yUig==

[Pothen Verghese]

Hi,

Can someone please suggest on how to integrate reporter with UVMS? The Broadcom documentation supplied doesnot cover that at all. We have the reporter service running but have the below problems:

a) The password is not getting decrypted and we see the below error in server.log

[INFO ] 23 Nov 2020 06:43:54 [main] com.orsyp.reppub.server.communication.ServerStartUp - Reporter Version 6.10.51 Server Build 12 Date 20200930 11/19/2020 8:25:43
[ERROR] 23 Nov 2020 06:43:54 [main] com.orsyp.reppub.server.util.CryptoUtility - Error decrypting the password.
com.orsyp.crypto.StringEncrypter$EncryptionException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.

b) The reporter node is not visible under Nodes on the Console. We have updated the uvmsList.xml file with the required details. The server.log gives the below

[INFO ] 23 Nov 2020 06:43:54 [main] com.orsyp.reppub.server.process.RepDBChecker - RepDBChecker process won't execute
[INFO ] 23 Nov 2020 06:43:54 [main] com.orsyp.reppub.server.communication.NetAcceptor - ServerStartUp started succesfully to 10630 port...
[INFO ] 23 Nov 2020 06:49:42 [pool-3-thread-1] com.orsyp.reppub.server.command.Command - Command:<GetReporterServerStatus> received from :[User=autadm; Node=SQLSVR12; OS=W32; Domain=SQLSVR12; Locale=en]; proxy user = admin
[INFO ] 23 Nov 2020 06:49:54 [pool-3-thread-2] com.orsyp.reppub.server.command.Command - Command:<GetReporterServerInfo> received from :[User=autadm; Node=SQLSVR12; OS=W32; Domain=SQLSVR12; Locale=en]; proxy user = admin
[INFO ] 23 Nov 2020 06:49:54 [pool-3-thread-3] com.orsyp.reppub.server.command.Command - Command:<GetUvmsList> received from :[User=autadm; Node=SQLSVR12; OS=W32; Domain=SQLSVR12; Locale=en]; proxy user = admin


But the reporter node is not listed under UVMS. The settings in uvmsList.xml file are as below:

<?xml version="1.0" encoding="UTF-8"?>

<UVMS_LIST>
<UVMS name="sqlsvr12_MgtSvr" host="sqlsvr12" port="4184" login="admin" password="21232f297a57a5a743894a0e4a801fc3icLLdpgNrdY=" group="name" priority="1" automaticCluster="false"/>
</UVMS_LIST>


Any ideas on how to fix these??

Regards
Pothen

[Eric Delawoevre]

Hi Pothen

First, modifying xml files is quite touchy, particularly if you are not confortable with Univiewer and sub products

For the reporter installation, hope that it is installed well. Be sure that you are on a Product directory that is not ...Program files... It may caus some issues on this (this suggestion is the same for all Universe Products)

As the Service is Up, YOU MUST ADD the reporter into you UVMS console mannualy (Indeed it will appear not only into an XML file, but also into the UVMS DB

Now, If appear, perhaps roles are not there but if you are "admins" you can have when you relogin to the console a new feature on the Administration left panel
(extraction purge)
BUT, the goal first is to link the Reporter to your Database (Whatever SQLS or ORA)
--> Right  click on the Reporter you added mannualy to the console then "Node settings")

Note that the Database need to be prepared by a reporter DB structure (provided into the reporter sub directories). Some HowTo/Readme is also provided

Tell me if this is ok first...

All the best
Eric

[Pothen Verghese]

Hi Eric,

Thanks. Had no clue that the Reporter node had to be added manually from the console. Anyway after adding Reporter, it was immediately listed as connected and we could complete the DB and UVMS setting and validate them too successfully. Now on the console we  

Why is the name of Management Server not visible in case of Reporter? Should it appear?

Thank again.

Regards
Pothen

[SupportAutomation AptaSolutions]

Hi @Pothen Verghese

Reporter can be configured to connect to multiple UVMS. This may be the reason why a Management Server does not appear in the UVC GUI.
See here for some additional details for the architecture of Reporter:
https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#REP_adm/Architectural%20Components.htm%3FTocPath%3DReporter%2520Administration%2520Guide%7CConcepts%2520and%2520Architecture%7C_____2

I hope that helps!
​​

------------------------------
Cordialement,
Support Automation Apta
------------------------------

[Eric Delawoevre]

#dollaruniverse
Good ! Welcome to reporter :-)
See "Apta" answer regarding your last question .

One thing : Beware of your Node Name AND your server name for the reporter
I explain:
* The UVMS Node setting you should designate the DUAS that will be the "scheduler" for you report generations and extractions
* Install The reporter Client on this DUAS : It only files (java content) into DUAS subdir that the DUAS will launch for any reporter command
* UVMS --> DUAS : schedule the diffèrent commands : extractions, reports
* DUAS --> Reporter : The java command request the reporter to interrogate the NodeView DUAS of your technical scope
* Reporter --> DUASs : Extractions , and Report generation

Now you understand that the name of your reporter need to be an network alias for any confortable use
Onto Universe v6+, server names are considered as a key.

Congratulation
Eric







------------------------------
Main director
SynApps
------------------------------