ERROR [08001] After restore IQ DB 15.3 on 15.4 server

[Former Member]

After exec statement in Interactive SQL:

RESTORE DATABASE 'E:\Data\test_DWH_IQ.db'

FROM '\\server\IQ_DWH_BackUp\IQ_DWH_INC20140804'

rename  ...

I Get message:

ERROR [08001] [Sybase][ODBC Driver][Sybase IQ]Unable to start specified database: unable to start database "E:\Data\test_DWH_IQ.db"

Note: I not start IQ Server. Only exec statement in Interactive SQL.

BackUP from 15.3 version server.

Restore on 15.4 server.

This is warning or db is corrupt?

Why restore statement trying start Sybase IQ after execution?

[saroj_bagai]

can you send us your exact steps?

1. First you will need to start utility server with the same memory configuration which was used to backup database.

2. connect to utllity_db and restore database

dbisql -c 'uid=DBA;pwd=sql;eng=<myserver>;dbn=utility_db' -host myhost -port 8999 -nogui restore.sql

3. stop server

4. start server normally.

[Former Member]

1. start utllity_db

2. connect to utllity_db with Interactive SQL

3. Run statement Restore....

4. After statement execute error message appears.

[saroj_bagai]

Are you running restore cmd on command line,  

dbisql -c 'uid=DBA;pwd=sql;eng=<myserver>;dbn=utility_db' -host myhost -port 8999 -nogui restore.sql

can you post complete .stderr, .srvlog and .iqmsg .

[Former Member]

[Former Member]

The error basically means the utility_db instance is not running.  You should just have to start the utility_db instance and run the restore via dbisql

jason

[Former Member]

if utility_db instance is not running. I have not connected to it.

I connected, backup restored, but after trying to start the database

[saroj_bagai]

<<connected, backup restored, but after trying to start the database>>

may be  I am missing something, does it means  your database have been restored. But according to error msg you posted it is failing even before restoring the database. Can you post your .srvlog and .stderr and  backup.syb

Thanks

[harpreet_chaudhary]

Can you also upload the contents of restore.sql

[Former Member]

.srvlog is empty.

.stderr - not in folder

and  backup.syb - i do not know what this file

restore.sql:

RESTORE DATABASE 'E:\Data\test_DWH_IQ.db'

                        FROM '\\dwhsrv\n$\IQ_DWH_BackUp\IQ_DWH_INC20140811'

                        rename IQ_SYSTEM_MAIN to 'E:\Data\DWH.iq'

                        rename sysmain2 to 'E:\Data\sysmain2.iq'

                        rename IQ_SYSTEM_TEMP to 'E:\Data\DWH.iqtmp'

                        rename temp01 to 'E:\Data\temp01.iqtmp'

                        rename temp02 to 'E:\Data\temp02.iqtmp'

                        rename temp03 to 'E:\Data\temp03.iqtmp'

                        rename temp04 to 'E:\Data\temp04.iqtmp'

                        rename temp05 to 'E:\Data\temp05.iqtmp'

                        rename temp06 to 'E:\Data\temp06.iqtmp'

                        rename temp07 to 'E:\Data\temp07.iqtmp'

                        rename temp08 to 'E:\Data\temp08.iqtmp'

                        rename temp09 to 'E:\Data\temp09.iqtmp'

                        rename temp10 to 'E:\Data\temp10.iqtmp'

                        rename temp11 to 'E:\Data\temp11.iqtmp'

                        rename temp12 to 'E:\Data\temp12.iqtmp'

                        rename temp13 to 'E:\Data\temp13.iqtmp'

                        rename temp14 to 'E:\Data\temp14.iqtmp'

                        rename temp15 to 'E:\Data\temp15.iqtmp'

                        rename temp16 to 'E:\Data\temp16.iqtmp'

                        rename temp17 to 'E:\Data\temp17.iqtmp'

                        rename IQ_SYSTEM_MSG to 'E:\Data\DWH.iqmsg'

                        rename dwh01 to 'E:\Data\dwh01.iq'

                        rename dwh03 to 'E:\Data\dwh03.iq'

                        rename dwh02 to 'E:\Data\dwh02.iq'

                        rename dwh05 to 'E:\Data\dwh5.iq'

                        rename dwh04 to 'E:\Data\dwh04.iq'

                        rename dwh06 to 'E:\Data\dwh06.iq'

                        rename dwh07 to 'E:\Data\dwh07.iq'

                        rename dwh08 to 'E:\Data\dwh08.iq'

                        rename dwh09 to 'E:\Data\dwh09.iq'

                        rename dwh10 to 'E:\Data\dwh10.iq'

                        rename dwh11 to 'E:\Data\dwh11.iq'

                        rename dwh12 to 'E:\Data\dwh12.iq'

                        rename dwh13 to 'E:\Data\dwh13.iq'

                        rename dwh14 to 'E:\Data\dwh14.iq'

                        rename dwh15 to 'E:\Data\dwh15.iq'

                        rename dwh16 to 'E:\Data\dwh16.iq'

                        rename dwh17 to 'E:\Data\dwh17.iq'

[harpreet_chaudhary]

Hi Oleg,

You will find backup.syb in the same directory as the srvlog (in my case on my windows box it is inC:\ProgramData\SybaseIQ\logfiles). You have to look for a .srvlog with the same name you started your utility db which in your case would be dwhsrv1.XXX.srvlog.

Your restore.sql  looks ok. I did a test at my end and seemed to work fine. I even tried with a similar sharename n$ scenario to see if causes an issue, but worked fine.

As part of the restore process IQ will shutdown and restart the utlity database, the contents of the srvlog should look like this

I. 08/13 13:15:43. (64bit mode)
I. 08/13 13:15:43. Copyright 1992-2012 by Sybase, Inc. All rights reserved
I. 08/13 13:15:43. Copyright © 2001-2012, Sybase, Inc.
I. 08/13 13:15:43. Portions copyright © 1988-2012, iAnywhere Solutions, Inc. All rights reserved.
I. 08/13 13:15:43. Use of this software is governed by the Sybase License Agreement.
I. 08/13 13:15:43. Refer to http://www.sybase.com/softwarelicenses.
I. 08/13 13:15:43.

I. 08/13 13:15:43. Processors detected: 1 (containing 4 logical processors)
I. 08/13 13:15:43. Maximum number of physical processors the server will use: 1
I. 08/13 13:15:43. Running Windows 7 Build 7601 Service Pack 1 on X86_64
I. 08/13 13:15:43. Server built for X86_64 processor architecture
I. 08/13 13:15:43. 49152K of memory used for caching
I. 08/13 13:15:43. Minimum cache size: 49152K, maximum cache size: 262144K
I. 08/13 13:15:43. Using a maximum page size of 4096 bytes
I. 08/13 13:15:43. Database server started at Wed Aug 13 2014 13:15
I. 08/13 13:15:43. Trying to start SharedMemory link ...
I. 08/13 13:15:43.     SharedMemory link started successfully
I. 08/13 13:15:43. Trying to start TCPIP link ...
I. 08/13 13:15:43. Starting on port 2638
I. 08/13 13:15:48.     TCPIP link started successfully
I. 08/13 13:15:48. Now accepting requests
I. 08/13 13:23:46. Starting database "utility_db" (utility_db) at Wed Aug 13 2014 13:23
I. 08/13 13:23:46. Database "utility_db" (utility_db) started at Wed Aug 13 2014 13:23
I. 08/13 13:24:00. Starting database "a_restore" (c:\temp\restore\iqdemo.db) at Wed Aug 13 2014 13:24
I. 08/13 13:24:00. Performance warning: Database file "c:\temp\restore\iqdemo.db" consists of 56 disk fragments
I. 08/13 13:24:00. Opening dbspace 'catalogdb1' in file 'catalogdb1.db' for database 'a_restore'
I. 08/13 13:30:10. Starting database "a_restore" (c:\temp\restore\iqdemo.db) at Wed Aug 13 2014 13:30
I. 08/13 13:30:10. Performance warning: Database file "c:\temp\restore\iqdemo.db" consists of 58 disk fragments
I. 08/13 13:30:10. Opening dbspace 'catalogdb1' in file 'catalogdb1.db' for database 'a_restore'
I. 08/13 13:30:10. Database recovery in progress
I. 08/13 13:30:10.     Last checkpoint at Wed Aug 13 2014 13:24
I. 08/13 13:30:10.     Rollback log...
I. 08/13 13:30:10.     Checkpointing...
I. 08/13 13:30:10. Recovery complete
I. 08/13 13:30:10. Database "a_restore" (iqdemo.db) started at Wed Aug 13 2014 13:30
I. 08/13 13:30:10. Database "a_restore" (iqdemo.db) stopped at Wed Aug 13 2014 13:30
I. 08/13 13:30:10. Starting database "a_restore" (c:\temp\restore\iqdemo.db) at Wed Aug 13 2014 13:30
I. 08/13 13:30:10. Performance warning: Database file "c:\temp\restore\iqdemo.db" consists of 60 disk fragments
I. 08/13 13:30:10. Opening dbspace 'catalogdb1' in file 'catalogdb1.db' for database 'a_restore'
I. 08/13 13:30:19. Database "a_restore" (iqdemo.db) started at Wed Aug 13 2014 13:30
I. 08/13 13:30:19. IQ Server iqdemo.
I. 08/13 13:30:19. Database "a_restore" (iqdemo.db) stopped at Wed Aug 13 2014 13:30
I. 08/13 13:30:19. Database "utility_db" (utility_db) stopped at Wed Aug 13 2014 13:30
I. 08/13 16:07:29. Database server shutdown requested via server console
W. 08/13 16:07:29. TCPIP listener on IP address (::):2638 is exiting
W. 08/13 16:07:29. TCPIP listener on IP address 0.0.0.0:2638 is exiting
I. 08/13 16:07:30. Database server stopped at Wed Aug 13 2014 16:07

As Jason mentioned earlier it seems to be an issue with utlity not being able to start. Can you try using the same cfg settings when starting the utility db just as you had in your IQ 15.3 production environment from where you took this backup. Sometimes for a big database the default cfg settings are not enough for the server to do the restore process.

[Former Member]

Found in log:

Failed to obtain license(s) for IQ_CORE feature from license file(s) or server(s).

1. I. 08/14 16:03:36. 0000000000 Licenses exist for IQ, but a license containing the configured (PE=EE;LT=SF) attributes could not be obtained.

Verify that IQ is configured to use the correct type of license, and either reconfigure; or generate and deploy the desired license from the Sybase Product Download Center.

The error was related to the license file, it was broken, the replacement file has helped restore the database without any problems