Update ASE using saphostctrl

[matus_petrek2]

Hi all,

I am trying to update SAP ASE 16.00.01 to 16.00.02 on Windows 2012 R2 using sapdbctrl (following note 1982469).

Using latest PL191 of saphostagent.

Now, running the first command (saphostctrl without force option) starts but it was actually hanging on following:

[PID 4296] switch to user: [domain]\sybsmp

[PID 4296] Error: 5, Access is denied.[PID 4296] CreateProcessAsUser failed

[PID 4296] Updating ASE software failed. Check logfile F:\sybase\SMP\log\ASE_Suite.log for errors.

After turning off the UAC, I was able to restart the process (this time with force option), but it cancels agains on following (after 5 minutes approx):

[PID 3516] errors occured during ASE setup.

[PID 3516] LiveUpdateOption update ASE software failed

[PID 3516] *** ERROR => 'Database live update' failed: errors occured during ASE setup.

There is no more details. This is log from dev_sabdbctrl from work directory. Last entry in ASEcommon (runtime) log is that DB was shut down There is another log file - ASE_Suite.log and everything looks like finished successfully. I tried to execute syb_update_db.txt manually and it finishes successfully as well.

Checking DB it has patch level PL 02 (sql @@version), everything looks fine but I cannot be sure that it is truth.

I tried with sapdbctrl directly but it is complaining about securestore even though the entry is there and password is correct. (oh and I think force option for sapdbctrl is having typo in SAP note, somehow there appears "IDS" instead of <SAPSID>).

ERROR: Database user authentication failed: No access to SecureStore or DB_CONNECT/SYB/SADB_USER or DB_CONNECT/SYB/SADB_PASSWORD is missing in SecureStore or password is incorrect. Provide credentials for user sapsa via command input or provide access to SecureStore.

rsecssfs list (I have added SAUPDDB_USER as per note)

| DB_CONNECT/DEFAULT_DB_PASSWORD  | Encrypted          | 2014-10-13  10:49:52  UTC |

| DB_CONNECT/DEFAULT_DB_USER      | Plaintext          | 2014-10-13  10:49:50  UTC |

| DB_CONNECT/SYB/SADB_PASSWORD    | Encrypted          | 2014-10-13  14:17:41  UTC |

| DB_CONNECT/SYB/SADB_USER        | Plaintext          | 2014-10-13  14:17:34  UTC |

| DB_CONNECT/SYB/SAUPDDB_PASSWORD | Encrypted          | 2014-10-13  14:09:59  UTC |

| DB_CONNECT/SYB/SAUPDDB_USER     | Plaintext          | 2014-10-13  14:09:51  UTC |

| DB_CONNECT/SYB/SSODB_PASSWORD   | Encrypted          | 2014-10-13  10:50:01  UTC |

| DB_CONNECT/SYB/SSODB_USER       | Plaintext          | 2014-10-13  10:49:58  UTC |

| DB_CONNECT/SYB/SYBSID_PASSWORD  | Encrypted          | 2014-10-13  10:50:05  UTC |

| DB_CONNECT/SYB/SYBSID_USER      | Plaintext          | 2014-10-13  10:50:02  UTC |

It is domain installation, central installation on 1 host.

Logs in work\SMP folder looks also fine.

Any ideas?

Thank you.

[Former Member]

Hello,

I am increase space in sybmgmtdb base

# resize sybmgmtdb db

   use master

   go

   disk resize name = 'sybmgmtdev', size = '100M'

   go

   alter database sybmgmtdb on sybmgmtdev = '100M'

   go

and it's helped me.

[dominik_kastner]

Hello Matus,

i had the same problem (same environment). I had to open an oss incident for this problem.

They found that this is problem in "sapdbctrl", which detects some irrelevant registry errors in the logs an cancels the update-process. They are working on a fix this.

There is a dirty workaround, but i dont wanna share it, because its not supported by SAP

Best regards,

Dominik Kastner

[matus_petrek2]

Hello Dominik,

thank you. In the end I deciced to get back to PL01 (as it was new installation, I started from scratch) and left DB without patching.

I tried to do some tests on other environment (Windows 2008 R2 with SAP ASE 15.7 SP121), and I even get third type of error, complaining about ASE_Suite.log.

Info: saphostcontrol: Executing LiveDatabaseUpdate

Error: sapdbctrl: readLiveUpdateParamFile: Could not open file 'F:\sybase\AS6\log\ASE_Suite.log'.

Error: saphostcontrol: LiveDatabaseUpdate failed (sapdbctrl exit code = 1)

The file doesn't exist, it doesn't look like permission problem (UAC is also turned off).

It seems that ASE update on Windows is just not working well, let's see if they release some fix.

Regards,

[matus_petrek2]

Hello all,

solution for error "ASE_Suite.log not found" is to apply SAP note 2005254 - although in my case I had to install Microsoft Visual C++ 2008 SP 1 Redistributable Package, not version 2005.

Hope it helps.

Regards,