Knowledge Base & Discussion Forum

MS SQL Backup with 7.7

Discuss technical questions on AhsayCBS release

Moderator: Support Team

MS SQL Backup with 7.7

Postby FireLite » Thu May 12, 2016 7:56 pm

I'm trying to set up an MS SQL backup with the new 7.7 client, but after selecting the SQL server instance and providing login credentials it just hangs with "Please wait" and nothing else happens.

Anyone else seen this?

PS! It's SQL Server 2014 on Windows Server 2012 R2
FireLite
 
Posts: 9
Joined: Thu Mar 17, 2016 5:08 pm

Re: MS SQL Backup with 7.7

Postby Nelson » Fri May 13, 2016 2:13 pm

Hi FireLite,

We would like to collect more information on your case.

- Please enable the debug mode in your AhsayOBM. You can find the instruction in this forum article.
https://forum.ahsay.com/viewtopic.php?f=117&t=10377

- Post the screen capture for reference.
Nelson
 

Re: MS SQL Backup with 7.7

Postby FireLite » Fri May 13, 2016 4:31 pm

Hi Nelson, thank's for your reply.

The debug don't really show anything while I add the Backup-Set, however this is what it show up till that moment:

Code: Select all
Adding file:/C:/Program%20Files/OBM/jvm/lib/charsets.jar to classpath ... O
K
Adding file:/C:/Program%20Files/OBM/jvm/lib/deploy.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/javaws.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/jce.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/jfr.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/jfxrt.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/jsse.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/management-agent.jar to classpa
th ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/plugin.jar to classpath ... OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/resources.jar to classpath ...
OK
Adding file:/C:/Program%20Files/OBM/jvm/lib/rt.jar to classpath ... OK
JComFlashPlayer failed to start. Please update your Flash player and try again
log4j:WARN No appenders could be found for logger (org.apache.http.impl.conn.Poo
lingClientConnectionManager).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more in
fo.
Debug: [GetUserProfile] Login: ClientName
Debug: [SetUserProfile] Login: ClientName
Debug: [SetUserProfile] Login: ClientName
Debug: [GetUserPolicy] Login: ClientName
FireLite
 
Posts: 9
Joined: Thu Mar 17, 2016 5:08 pm

Re: MS SQL Backup with 7.7

Postby david@lucidsystems.co.uk » Fri May 13, 2016 8:36 pm

Reinstall OBM on the SQL server

It's something to do with it not calling for admin privileges properly after being updated through AUA.

We had this on 6.27.0.0 -> 7.5
david@lucidsystems.co.uk
 
Posts: 115
Joined: Wed Feb 10, 2010 6:15 am

Re: MS SQL Backup with 7.7

Postby rebecca223 » Sat May 14, 2016 6:06 pm

Try reinstalling OBM on your server.
Before you go at Brett Eldredge concert you might have Brett Eldredge tickets!
rebecca223
 
Posts: 1
Joined: Fri May 06, 2016 2:27 am

Re: MS SQL Backup with 7.7

Postby FireLite » Fri May 20, 2016 1:28 am

Will try to reinstall, thanks for the feedback guys.
FireLite
 
Posts: 9
Joined: Thu Mar 17, 2016 5:08 pm

Re: MS SQL Backup with 7.7

Postby NoOption » Wed Aug 03, 2016 10:29 pm

Did you ever get this working? I'm having the exact same issue with 7.7. I put in the SQL ID and pass hit next and it just hangs.
NoOption
 
Posts: 11
Joined: Wed Aug 09, 2006 10:28 pm

Re: MS SQL Backup with 7.7

Postby SINC_dmack » Sat Aug 13, 2016 5:01 am

I feel like I had this issue on one of our OBMs, and I think I fixed it by either:
--making sure that the SQL database had mixed authentication enabled so it would respond to Windows credentials in the OBM or
--used the sa credentials when authenticating in the OBM

It's been a couple months and I didn't document it in my notes. Hope this helps.
SINC_dmack
 
Posts: 77
Joined: Thu Mar 31, 2011 2:57 am

Re: MS SQL Backup with 7.7

Postby ronnie.chan » Mon Aug 15, 2016 6:30 pm

Thanks SINC_dmack for the solution :D
User avatar
ronnie.chan
 
Posts: 40
Joined: Wed Sep 19, 2007 9:31 am

Re: MS SQL Backup with 7.7

Postby lej333 » Fri Feb 01, 2019 8:32 pm

Hi,

I've same issue by now, after login in a newly created MSSQL backup, he will hang on Please wait... for a couple of hours until he shows an empty message.

- I've reinstalled AhsayOBM already
- I'm using AhsayOBM version 7.15.2.2
- I'm using MSSQL 2017 Developer edition on Windows 2016 Standard

The debugger shows the following:
Code: Select all
C:\Program Files\AhsayOBM\bin>..\jvm\bin\java.exe -Djava.library.path=..\bin -cp ..\bin;..\bin\cb.jar -Xms128m -Xmx2048m -XX:MaxDirectMemorySize=1024m -Dsun.java2d.noddraw -Dsun.nio.PageAlignDirectMemory=true Gui "--debug" .. ""
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/asm-3.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/bcmail-jdk15on-1.51.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/bcpkix-jdk15on-1.51.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/bcprov-jdk15on-151.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/commons-codec-1.6.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/commons-io-2.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/commons-logging-1.1.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/commons-net-3.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/dom4j-1.6.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/dropbox-core-sdk-1.7.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/dropbox-core-sdk-3.0.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/fluent-hc-4.3.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/forms-1.3.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-api-client-1.19.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-api-client-jackson2-1.19.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-api-services-drive-v2-rev158-1.19.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-http-client-1.19.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-http-client-jackson2-1.19.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/google-oauth-client-1.19.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/httpclient-4.3.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/httpclient-cache-4.3.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/httpcore-4.3.2.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/httpmime-4.3.5.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-annotations-2.2.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-annotations-2.7.4.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-core-2.2.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-core-2.7.4.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-core-asl-1.9.13.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-databind-2.2.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-databind-2.7.4.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-jaxrs-1.9.2.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-mapper-asl-1.9.13.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jackson-xc-1.9.2.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/java-xmlbuilder-0.4.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/javax.mail.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jcifs-1.3.18.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jdokan-20170627.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jdom-1.1.3.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jersey-apache-client4-1.18.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jersey-bundle-1.18.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jersey-multipart-1.18.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jettison-1.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jsch-0.1.50.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/json_simple-1.1.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/jsr305-1.3.9.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/log4j-1.2.17.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/microsoft-windowsazure-api-0.4.6.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/microsoft-windowsazure-storage-sdk-1.0.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/microsoft-windowsazure-storage-sdk-6.0.0.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/mysql-connector-java-5.0.8-bin.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/ojdbc6.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/org.json-20150730.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/servlet-api.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/sinetfactory.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/bin/../bin/yavijava.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/alt-rt.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/charsets.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/deploy.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/javaws.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/jce.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/jfr.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/jfxrt.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/jsse.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/management-agent.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/plugin.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/resources.jar to classpath ... OK
Adding file:/C:/Program%20Files/AhsayOBM/jvm/lib/rt.jar to classpath ... OK
JComFlashPlayer failed to start. Please update your Flash player and try again
Debug: [GetUserPolicy] Login: DEVELOP2
log4j:WARN No appenders could be found for logger (org.apache.http.impl.conn.PoolingClientConnectionManager).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Debug: [GetUserProfile] Login: DEVELOP2
Debug: [GetUserProfile] Login: DEVELOP2


In the errorlog i found the following:
Code: Select all
Volume Shadow Copy Service error: Unexpected error querying for the IVssWriterCallback interface.  hr = 0x80070005, Access is denied.
. This is often caused by incorrect security settings in either the writer or requestor process.


And checked all permissions in register and it's OK

Someone found a solution for this?
lej333
 
Posts: 12
Joined: Thu May 30, 2013 8:35 pm

Re: MS SQL Backup with 7.7

Postby lej333 » Fri Feb 01, 2019 10:12 pm

Fixed by upgrade CBS and OBM to 8.1.0.25
lej333
 
Posts: 12
Joined: Thu May 30, 2013 8:35 pm


Return to AhsayCBS v7

Who is online

Users browsing this forum: No registered users and 14 guests

Looking for Rbackup Alternative | Vembu Alternative | Novastor Alternative | Asigra Alternative | BackupAgent Alternative? Try our product.


A wholly owned subsidiary of Ahsay Backup Software Development Company Limited  [HKEx Stock Code: 8290]