Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase IQ 15.4 Express Edition - license expires after 30 days?

5 posts in General Discussion Last posting was on 2012-05-25 03:21:56.0Z
Peter S Posted on 2012-05-17 17:15:29.0Z
Sender: 63f8.4fb52fb1.1804289383@sybase.com
From: Peter S
Newsgroups: sybase.public.iq
Subject: Sybase IQ 15.4 Express Edition - license expires after 30 days?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fb53231.644d.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 May 2012 10:15:29 -0700
X-Trace: forums-1-dub 1337274929 172.20.134.41 (17 May 2012 10:15:29 -0700)
X-Original-Trace: 17 May 2012 10:15:29 -0700, 172.20.134.41
Lines: 173
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4505
Article PK: 246649

I'm using it to develop an in-database analytics application
but after 30 days I cannot start IQ. Below IQ logs on dates
before and after the expiration date. Express edition should
not have expiration date, the restriction is 5GB.


5/15 log:

I. 05/15 15:21:46. 0000000000 Warning: Using default value
for -iqmc or -iqtc is insufficient for most applications

I. 05/15 15:21:46. 0000000000 OpenDatabase Completed
I. 05/15 15:21:46. 0000000000 IQ cmd line srv opts:
I. 05/15 15:21:46. 0000000000 IQ full cmd line: -n
John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all -gl
all -gm 10 -gp 4096 -zr all -zo o.log -o message.log -sf
-inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
-hn0,3028:120
I. 05/15 15:21:46. 0000000000 DB: r/w, Main 63MB Buffs=510,
Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
I. 05/15 15:21:46. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
03/18/1999)
I. 05/15 15:21:46. 0000000000 DB: Versn:
15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
01:34:35
I. 05/15 15:21:46. 0000000000 DB: Name:
C:\SybaseIQ\MyiqDemo\iqdemo.db
I. 05/15 15:21:46. 0000000000 DB: Txn ID Seq: 86004
I. 05/15 15:21:46. 0000000000 DB: DBID Blk: 2594
I. 05/15 15:21:46. 0000000000 DB: IQ Server John-PC_iqdemo,
PID 4692, LOGIN John
I. 05/15 15:21:46. 0000000000 DB: Database encryption is
OFF.
I. 05/15 15:21:46. 0000000000 Mem: 155mb/M155
Main Blks: U7747/30%, Buffers: U6/L0
Temporary Blks: U65/2%, Buffers: U4/L0
Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
I. 05/15 15:21:46. 0000000000 Collation ISO_BINENG, Case
Ignore, Blank Padding On, Comparisons are Conditioned
I. 05/15 15:21:47. 0000000000 RcvyCmpl
I. 05/15 15:21:47. 0000000000 Chk
I. 05/15 15:21:47. 0000000000 ChkDone [NumTxnCP: 0]
I. 05/15 15:21:48. 0000000000 PostChk
I. 05/15 15:21:48. 0000000000 CloseDatabase
I. 05/15 15:21:48. 0000000000 Warning: Using default value
for -iqmc or -iqtc is insufficient for most applications

I. 05/15 15:21:48. 0000000000 Using licenses from:
C:\flexlm\license.dat
I. 05/15 15:21:48. 0000000000 Checked out graced license for
1 IQ_CORE (2011.1107) will expire Wed May 16 01:00:00 2012.
I. 05/15 15:21:48. 0000000000 Failed to obtain license(s)
for IQ_CORE feature from license file(s) or server(s).
I. 05/15 15:21:48. 0000000000 Cannot find license file.
I. 05/15 15:21:48. 0000000000 The license files (or license
server system network addresses) attempted are listed below.
I. 05/15 15:21:48. 0000000000 License feature name: IQ_CORE
I. 05/15 15:21:48. 0000000000 License filename:
C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo
I. 05/15 15:21:48. 0000000000 License search path:
C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo
I. 05/15 15:21:48. 0000000000 FLEXnet Licensing
error:-1,359. System Error: 2 "No such file or directory"
I. 05/15 15:21:48. 0000000000 For further information, refer
to the Sybase Software Asset Management website at
http://www.sybase.com/sysam
I. 05/15 15:21:48. 0000000000 WARNING: IQ functionality that
requires the IQ_CORE license will be disabled on Wed May 16
01:00:00 2012, unless a suitable IQ_CORE license is obtained
before that date.
I. 05/15 15:21:48. 0000000000 This product is licensed to:

I. 05/15 15:21:48. 0000000000 OpenDatabase Completed
I. 05/15 15:21:48. 0000000000 IQ cmd line srv opts:
I. 05/15 15:21:48. 0000000000 IQ full cmd line: -n
John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all -gl
all -gm 10 -gp 4096 -zr all -zo o.log -o message.log -sf
-inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
-hn0,3028:120
I. 05/15 15:21:48. 0000000000 DB: r/w, Main 63MB Buffs=510,
Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
I. 05/15 15:21:48. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
03/18/1999)
I. 05/15 15:21:48. 0000000000 DB: Versn:
15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
01:34:35
I. 05/15 15:21:48. 0000000000 DB: Name:
C:\SybaseIQ\MyiqDemo\iqdemo.db
I. 05/15 15:21:48. 0000000000 DB: Txn ID Seq: 86005
I. 05/15 15:21:48. 0000000000 DB: DBID Blk: 2610
I. 05/15 15:21:48. 0000000000 DB: IQ Server John-PC_iqdemo,
PID 4692, LOGIN John
I. 05/15 15:21:48. 0000000000 DB: Database encryption is
OFF.
I. 05/15 15:21:48. 0000000000 Mem: 155mb/M155
Main Blks: U7747/30%, Buffers: U6/L0
Temporary Blks: U65/2%, Buffers: U4/L0
Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
I. 05/15 15:21:49. 0000000003 Txn 86005 0 86005



5/17 log:


I. 05/17 11:39:30. 0000000000 Warning: Using default value
for -iqmc or -iqtc is insufficient for most applications

I. 05/17 11:39:30. 0000000000 OpenDatabase Completed
I. 05/17 11:39:30. 0000000000 IQ cmd line srv opts:
I. 05/17 11:39:30. 0000000000 IQ full cmd line: -n
John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all -gl
all -gm 10 -gp 4096 -zr all -zo o.log -o message.log -sf
-inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
-hn0,3344:120
I. 05/17 11:39:30. 0000000000 DB: r/w, Main 63MB Buffs=510,
Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
I. 05/17 11:39:30. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
03/18/1999)
I. 05/17 11:39:30. 0000000000 DB: Versn:
15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
01:34:35
I. 05/17 11:39:30. 0000000000 DB: Name:
C:\SybaseIQ\MyiqDemo\iqdemo.db
I. 05/17 11:39:30. 0000000000 DB: Txn ID Seq: 86316
I. 05/17 11:39:30. 0000000000 DB: DBID Blk: 2594
I. 05/17 11:39:30. 0000000000 DB: IQ Server John-PC_iqdemo,
PID 4816, LOGIN John
I. 05/17 11:39:30. 0000000000 DB: Database encryption is
OFF.
I. 05/17 11:39:30. 0000000000 Mem: 155mb/M155
Main Blks: U7747/30%, Buffers: U6/L0
Temporary Blks: U65/2%, Buffers: U4/L0
Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
I. 05/17 11:39:30. 0000000000 Collation ISO_BINENG, Case
Ignore, Blank Padding On, Comparisons are Conditioned
I. 05/17 11:39:31. 0000000000 RcvyCmpl
I. 05/17 11:39:31. 0000000000 Chk
I. 05/17 11:39:31. 0000000000 ChkDone [NumTxnCP: 0]
I. 05/17 11:39:31. 0000000000 PostChk
I. 05/17 11:39:32. 0000000000 CloseDatabase
I. 05/17 11:39:32. 0000000000 Warning: Using default value
for -iqmc or -iqtc is insufficient for most applications

I. 05/17 11:39:32. 0000000000 Using licenses from:
C:\flexlm\license.dat
I. 05/17 11:39:32. 0000000000 Failed to obtain license(s)
for IQ_CORE feature from license file(s) or server(s).
I. 05/17 11:39:32. 0000000000 Cannot find license file.
I. 05/17 11:39:32. 0000000000 The license files (or license
server system network addresses) attempted are listed below.
I. 05/17 11:39:32. 0000000000 License feature name: IQ_CORE
I. 05/17 11:39:32. 0000000000 License filename:
C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo
I. 05/17 11:39:32. 0000000000 License search path:
C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo
I. 05/17 11:39:32. 0000000000 FLEXnet Licensing
error:-1,359. System Error: 2 "No such file or directory"
I. 05/17 11:39:32. 0000000000 For further information, refer
to the Sybase Software Asset Management website at
http://www.sybase.com/sysam
I. 05/17 11:39:32. 0000000000 License Checkout Failed for
IQ_CORE
I. 05/17 11:39:32. 0000000000 Exception Thrown from
hos_sysam.cxx:881, Err# 0, tid 19 origtid 19
I. 05/17 11:39:32. 0000000000 O/S Err#: 0, ErrID: 549
(hos_sysamException); SQLCode: -1006269, SQLState: 'QBC69',
Severity: 14
I. 05/17 11:39:32. 0000000000 [21161]: No SYSAM License
Available


Abhijit Jadhav Posted on 2012-05-22 20:55:46.0Z
Sender: 1302.4fbbeab1.1804289383@sybase.com
From: Abhijit Jadhav
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ 15.4 Express Edition - license expires after 30 days?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fbbfd52.1752.1681692777@sybase.com>
References: <4fb53231.644d.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 22 May 2012 13:55:46 -0700
X-Trace: forums-1-dub 1337720146 172.20.134.41 (22 May 2012 13:55:46 -0700)
X-Original-Trace: 22 May 2012 13:55:46 -0700, 172.20.134.41
Lines: 190
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4508
Article PK: 246647

Peter,

From logs it seems to be incorrect edition installed on your
machine. The IQ sever should be looking for IQ_XE license
instead of IQ_CORE license.

While installing what edition you choose? It should be
Express Edition. If this option was chosen then could you
please post installation log.

Regards,
Abhijit

> I'm using it to develop an in-database analytics
> application but after 30 days I cannot start IQ. Below IQ
> logs on dates before and after the expiration date.
> Express edition should not have expiration date, the
> restriction is 5GB.
>
>
> 5/15 log:
>
> I. 05/15 15:21:46. 0000000000 Warning: Using default value
> for -iqmc or -iqtc is insufficient for most applications
>
> I. 05/15 15:21:46. 0000000000 OpenDatabase Completed
> I. 05/15 15:21:46. 0000000000 IQ cmd line srv opts:
> I. 05/15 15:21:46. 0000000000 IQ full cmd line: -n
> John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
> -hn0,3028:120
> I. 05/15 15:21:46. 0000000000 DB: r/w, Main 63MB Buffs=510
> , Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
> I. 05/15 15:21:46. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
> 03/18/1999)
> I. 05/15 15:21:46. 0000000000 DB: Versn:
> 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> 01:34:35
> I. 05/15 15:21:46. 0000000000 DB: Name:
> C:\SybaseIQ\MyiqDemo\iqdemo.db
> I. 05/15 15:21:46. 0000000000 DB: Txn ID Seq: 86004
> I. 05/15 15:21:46. 0000000000 DB: DBID Blk: 2594
> I. 05/15 15:21:46. 0000000000 DB: IQ Server John-PC_iqdemo
> , PID 4692, LOGIN John
> I. 05/15 15:21:46. 0000000000 DB: Database encryption is
> OFF.
> I. 05/15 15:21:46. 0000000000 Mem:
> 155mb/M155
> Main Blks: U7747/30%, Buffers: U6/L0
> Temporary Blks: U65/2%, Buffers: U4/L0
> Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> I. 05/15 15:21:46. 0000000000 Collation ISO_BINENG, Case
> Ignore, Blank Padding On, Comparisons are Conditioned
> I. 05/15 15:21:47. 0000000000 RcvyCmpl
> I. 05/15 15:21:47. 0000000000 Chk
> I. 05/15 15:21:47. 0000000000 ChkDone [NumTxnCP: 0]
> I. 05/15 15:21:48. 0000000000 PostChk
> I. 05/15 15:21:48. 0000000000 CloseDatabase
> I. 05/15 15:21:48. 0000000000 Warning: Using default value
> for -iqmc or -iqtc is insufficient for most applications
>
> I. 05/15 15:21:48. 0000000000 Using licenses from:
> C:\flexlm\license.dat
> I. 05/15 15:21:48. 0000000000 Checked out graced license
> for 1 IQ_CORE (2011.1107) will expire Wed May 16 01:00:00
> 2012. I. 05/15 15:21:48. 0000000000 Failed to obtain
> license(s) for IQ_CORE feature from license file(s) or
> server(s). I. 05/15 15:21:48. 0000000000 Cannot find
> license file. I. 05/15 15:21:48. 0000000000 The license
> files (or license server system network addresses)
> attempted are listed below. I. 05/15 15:21:48. 0000000000
> License feature name: IQ_CORE I. 05/15 15:21:48.
> 0000000000 License filename:
> C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo I.
> 05/15 15:21:48. 0000000000 License search path:
> C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo I.
> 05/15 15:21:48. 0000000000 FLEXnet Licensing error:-1,359.
> System Error: 2 "No such file or directory" I. 05/15
> 15:21:48. 0000000000 For further information, refer to the
> Sybase Software Asset Management website at
> http://www.sybase.com/sysam I. 05/15 15:21:48. 0000000000
> WARNING: IQ functionality that requires the IQ_CORE
> license will be disabled on Wed May 16 01:00:00 2012,
> unless a suitable IQ_CORE license is obtained before that
> date. I. 05/15 15:21:48. 0000000000 This product is
> licensed to:
>
> I. 05/15 15:21:48. 0000000000 OpenDatabase Completed
> I. 05/15 15:21:48. 0000000000 IQ cmd line srv opts:
> I. 05/15 15:21:48. 0000000000 IQ full cmd line: -n
> John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
> -hn0,3028:120
> I. 05/15 15:21:48. 0000000000 DB: r/w, Main 63MB Buffs=510
> , Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
> I. 05/15 15:21:48. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
> 03/18/1999)
> I. 05/15 15:21:48. 0000000000 DB: Versn:
> 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> 01:34:35
> I. 05/15 15:21:48. 0000000000 DB: Name:
> C:\SybaseIQ\MyiqDemo\iqdemo.db
> I. 05/15 15:21:48. 0000000000 DB: Txn ID Seq: 86005
> I. 05/15 15:21:48. 0000000000 DB: DBID Blk: 2610
> I. 05/15 15:21:48. 0000000000 DB: IQ Server John-PC_iqdemo
> , PID 4692, LOGIN John
> I. 05/15 15:21:48. 0000000000 DB: Database encryption is
> OFF.
> I. 05/15 15:21:48. 0000000000 Mem:
> 155mb/M155
> Main Blks: U7747/30%, Buffers: U6/L0
> Temporary Blks: U65/2%, Buffers: U4/L0
> Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> I. 05/15 15:21:49. 0000000003 Txn 86005 0 86005
>
>
>
> 5/17 log:
>
>
> I. 05/17 11:39:30. 0000000000 Warning: Using default value
> for -iqmc or -iqtc is insufficient for most applications
>
> I. 05/17 11:39:30. 0000000000 OpenDatabase Completed
> I. 05/17 11:39:30. 0000000000 IQ cmd line srv opts:
> I. 05/17 11:39:30. 0000000000 IQ full cmd line: -n
> John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn 25
> -hn0,3344:120
> I. 05/17 11:39:30. 0000000000 DB: r/w, Main 63MB Buffs=510
> , Temp 63MB Buffs=510, Pgsz=131072/8192blksz/16bpc, BP=2
> I. 05/17 11:39:30. 0000000000 DB: Frmt#: 23F/2T/1P (FF:
> 03/18/1999)
> I. 05/17 11:39:30. 0000000000 DB: Versn:
> 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> 01:34:35
> I. 05/17 11:39:30. 0000000000 DB: Name:
> C:\SybaseIQ\MyiqDemo\iqdemo.db
> I. 05/17 11:39:30. 0000000000 DB: Txn ID Seq: 86316
> I. 05/17 11:39:30. 0000000000 DB: DBID Blk: 2594
> I. 05/17 11:39:30. 0000000000 DB: IQ Server John-PC_iqdemo
> , PID 4816, LOGIN John
> I. 05/17 11:39:30. 0000000000 DB: Database encryption is
> OFF.
> I. 05/17 11:39:30. 0000000000 Mem:
> 155mb/M155
> Main Blks: U7747/30%, Buffers: U6/L0
> Temporary Blks: U65/2%, Buffers: U4/L0
> Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> I. 05/17 11:39:30. 0000000000 Collation ISO_BINENG, Case
> Ignore, Blank Padding On, Comparisons are Conditioned
> I. 05/17 11:39:31. 0000000000 RcvyCmpl
> I. 05/17 11:39:31. 0000000000 Chk
> I. 05/17 11:39:31. 0000000000 ChkDone [NumTxnCP: 0]
> I. 05/17 11:39:31. 0000000000 PostChk
> I. 05/17 11:39:32. 0000000000 CloseDatabase
> I. 05/17 11:39:32. 0000000000 Warning: Using default value
> for -iqmc or -iqtc is insufficient for most applications
>
> I. 05/17 11:39:32. 0000000000 Using licenses from:
> C:\flexlm\license.dat
> I. 05/17 11:39:32. 0000000000 Failed to obtain license(s)
> for IQ_CORE feature from license file(s) or server(s).
> I. 05/17 11:39:32. 0000000000 Cannot find license file.
> I. 05/17 11:39:32. 0000000000 The license files (or
> license server system network addresses) attempted are
> listed below. I. 05/17 11:39:32. 0000000000 License
> feature name: IQ_CORE I. 05/17 11:39:32. 0000000000
> License filename: C:\SybaseIQ\SYSAM-2_0\licenses
> ;C:\SybaseIQ\MyiqDemo I. 05/17 11:39:32. 0000000000
> License search path: C:\SybaseIQ\SYSAM-2_0\licenses
> ;C:\SybaseIQ\MyiqDemo I. 05/17 11:39:32. 0000000000
> FLEXnet Licensing error:-1,359. System Error: 2 "No such
> file or directory" I. 05/17 11:39:32. 0000000000 For
> further information, refer to the Sybase Software Asset
> Management website at http://www.sybase.com/sysam
> I. 05/17 11:39:32. 0000000000 License Checkout Failed for
> IQ_CORE
> I. 05/17 11:39:32. 0000000000 Exception Thrown from
> hos_sysam.cxx:881, Err# 0, tid 19 origtid 19
> I. 05/17 11:39:32. 0000000000 O/S Err#: 0, ErrID: 549
> (hos_sysamException); SQLCode: -1006269, SQLState: 'QBC69'
> , Severity: 14
> I. 05/17 11:39:32. 0000000000 [21161]: No SYSAM License
> Available


Peter S Posted on 2012-05-23 01:02:27.0Z
Sender: 207f.4fbc363b.1804289383@sybase.com
From: Peter S
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ 15.4 Express Edition - license expires after 30 days?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fbc3723.20b1.1681692777@sybase.com>
References: <4fbbfd52.1752.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4fbc3723"
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 22 May 2012 18:02:27 -0700
X-Trace: forums-1-dub 1337734947 172.20.134.41 (22 May 2012 18:02:27 -0700)
X-Original-Trace: 22 May 2012 18:02:27 -0700, 172.20.134.41
Lines: 1582
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4509
Article PK: 246651

Thanks, attached the installation logs; I'm positive I've
installed Express Edition though.

> Peter,
>
> From logs it seems to be incorrect edition installed on
> your machine. The IQ sever should be looking for IQ_XE
> license instead of IQ_CORE license.
>
> While installing what edition you choose? It should be
> Express Edition. If this option was chosen then could you
> please post installation log.
>
> Regards,
> Abhijit
> > I'm using it to develop an in-database analytics
> > application but after 30 days I cannot start IQ. Below
> > IQ logs on dates before and after the expiration date.
> > Express edition should not have expiration date, the
> > restriction is 5GB.
> >
> >
> > 5/15 log:
> >
> > I. 05/15 15:21:46. 0000000000 Warning: Using default
> > value for -iqmc or -iqtc is insufficient for most
> applications >
> > I. 05/15 15:21:46. 0000000000 OpenDatabase Completed
> > I. 05/15 15:21:46. 0000000000 IQ cmd line srv opts:
> > I. 05/15 15:21:46. 0000000000 IQ full cmd line: -n
> > John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> > -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> > -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn
> > 25 -hn0,3028:120
> > I. 05/15 15:21:46. 0000000000 DB: r/w, Main 63MB
> > Buffs=510 , Temp 63MB Buffs=510,
> > Pgsz=131072/8192blksz/16bpc, BP=2 I. 05/15 15:21:46.
> > 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
> > I. 05/15 15:21:46. 0000000000 DB: Versn:
> > 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> > 01:34:35
> > I. 05/15 15:21:46. 0000000000 DB: Name:
> > C:\SybaseIQ\MyiqDemo\iqdemo.db
> > I. 05/15 15:21:46. 0000000000 DB: Txn ID Seq: 86004
> > I. 05/15 15:21:46. 0000000000 DB: DBID Blk: 2594
> > I. 05/15 15:21:46. 0000000000 DB: IQ Server
> > John-PC_iqdemo , PID 4692, LOGIN John
> > I. 05/15 15:21:46. 0000000000 DB: Database encryption is
> > OFF.
> > I. 05/15 15:21:46. 0000000000 Mem:
> > 155mb/M155
> > Main Blks: U7747/30%, Buffers: U6/L0
> > Temporary Blks: U65/2%, Buffers: U4/L0
> > Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> > Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> > I. 05/15 15:21:46. 0000000000 Collation ISO_BINENG, Case
> > Ignore, Blank Padding On, Comparisons are Conditioned
> > I. 05/15 15:21:47. 0000000000 RcvyCmpl
> > I. 05/15 15:21:47. 0000000000 Chk
> > I. 05/15 15:21:47. 0000000000 ChkDone [NumTxnCP: 0]
> > I. 05/15 15:21:48. 0000000000 PostChk
> > I. 05/15 15:21:48. 0000000000 CloseDatabase
> > I. 05/15 15:21:48. 0000000000 Warning: Using default
> > value for -iqmc or -iqtc is insufficient for most
> applications >
> > I. 05/15 15:21:48. 0000000000 Using licenses from:
> > C:\flexlm\license.dat
> > I. 05/15 15:21:48. 0000000000 Checked out graced license
> > for 1 IQ_CORE (2011.1107) will expire Wed May 16
> > 01:00:00 2012. I. 05/15 15:21:48. 0000000000 Failed to
> > obtain license(s) for IQ_CORE feature from license
> > file(s) or server(s). I. 05/15 15:21:48. 0000000000
> > Cannot find license file. I. 05/15 15:21:48. 0000000000
> > The license files (or license server system network
> > addresses) attempted are listed below. I. 05/15
> > 15:21:48. 0000000000 License feature name: IQ_CORE I.
> > 05/15 15:21:48. 0000000000 License filename:
> > C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo I.
> > 05/15 15:21:48. 0000000000 License search path:
> > C:\SybaseIQ\SYSAM-2_0\licenses;C:\SybaseIQ\MyiqDemo I.
> > 05/15 15:21:48. 0000000000 FLEXnet Licensing
> > error:-1,359. System Error: 2 "No such file or
> > directory" I. 05/15 15:21:48. 0000000000 For further
> > information, refer to the Sybase Software Asset
> > Management website at http://www.sybase.com/sysam I.
> > 05/15 15:21:48. 0000000000 WARNING: IQ functionality
> > that requires the IQ_CORE license will be disabled on
> > Wed May 16 01:00:00 2012, unless a suitable IQ_CORE
> > license is obtained before that date. I. 05/15 15:21:48.
> > 0000000000 This product is licensed to:
> >
> > I. 05/15 15:21:48. 0000000000 OpenDatabase Completed
> > I. 05/15 15:21:48. 0000000000 IQ cmd line srv opts:
> > I. 05/15 15:21:48. 0000000000 IQ full cmd line: -n
> > John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> > -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> > -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn
> > 25 -hn0,3028:120
> > I. 05/15 15:21:48. 0000000000 DB: r/w, Main 63MB
> > Buffs=510 , Temp 63MB Buffs=510,
> > Pgsz=131072/8192blksz/16bpc, BP=2 I. 05/15 15:21:48.
> > 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
> > I. 05/15 15:21:48. 0000000000 DB: Versn:
> > 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> > 01:34:35
> > I. 05/15 15:21:48. 0000000000 DB: Name:
> > C:\SybaseIQ\MyiqDemo\iqdemo.db
> > I. 05/15 15:21:48. 0000000000 DB: Txn ID Seq: 86005
> > I. 05/15 15:21:48. 0000000000 DB: DBID Blk: 2610
> > I. 05/15 15:21:48. 0000000000 DB: IQ Server
> > John-PC_iqdemo , PID 4692, LOGIN John
> > I. 05/15 15:21:48. 0000000000 DB: Database encryption is
> > OFF.
> > I. 05/15 15:21:48. 0000000000 Mem:
> > 155mb/M155
> > Main Blks: U7747/30%, Buffers: U6/L0
> > Temporary Blks: U65/2%, Buffers: U4/L0
> > Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> > Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> > I. 05/15 15:21:49. 0000000003 Txn 86005 0 86005
> >
> >
> >
> > 5/17 log:
> >
> >
> > I. 05/17 11:39:30. 0000000000 Warning: Using default
> > value for -iqmc or -iqtc is insufficient for most
> applications >
> > I. 05/17 11:39:30. 0000000000 OpenDatabase Completed
> > I. 05/17 11:39:30. 0000000000 IQ cmd line srv opts:
> > I. 05/17 11:39:30. 0000000000 IQ full cmd line: -n
> > John-PC_iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all
> > -gl all -gm 10 -gp 4096 -zr all -zo o.log -o message.log
> > -sf -inmemory_external_procedure iqdemo.db -ti 4400 -gn
> > 25 -hn0,3344:120
> > I. 05/17 11:39:30. 0000000000 DB: r/w, Main 63MB
> > Buffs=510 , Temp 63MB Buffs=510,
> > Pgsz=131072/8192blksz/16bpc, BP=2 I. 05/17 11:39:30.
> > 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
> > I. 05/17 11:39:30. 0000000000 DB: Versn:
> > 15.4.0.6567/111107/P/GA/MS/Windows 2003/64bit/2011-11-07
> > 01:34:35
> > I. 05/17 11:39:30. 0000000000 DB: Name:
> > C:\SybaseIQ\MyiqDemo\iqdemo.db
> > I. 05/17 11:39:30. 0000000000 DB: Txn ID Seq: 86316
> > I. 05/17 11:39:30. 0000000000 DB: DBID Blk: 2594
> > I. 05/17 11:39:30. 0000000000 DB: IQ Server
> > John-PC_iqdemo , PID 4816, LOGIN John
> > I. 05/17 11:39:30. 0000000000 DB: Database encryption is
> > OFF.
> > I. 05/17 11:39:30. 0000000000 Mem:
> > 155mb/M155
> > Main Blks: U7747/30%, Buffers: U6/L0
> > Temporary Blks: U65/2%, Buffers: U4/L0
> > Main I: L43/P3 O: C3/D3/P0 D:0 C:100.0
> > Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
> > I. 05/17 11:39:30. 0000000000 Collation ISO_BINENG, Case
> > Ignore, Blank Padding On, Comparisons are Conditioned
> > I. 05/17 11:39:31. 0000000000 RcvyCmpl
> > I. 05/17 11:39:31. 0000000000 Chk
> > I. 05/17 11:39:31. 0000000000 ChkDone [NumTxnCP: 0]
> > I. 05/17 11:39:31. 0000000000 PostChk
> > I. 05/17 11:39:32. 0000000000 CloseDatabase
> > I. 05/17 11:39:32. 0000000000 Warning: Using default
> > value for -iqmc or -iqtc is insufficient for most
> applications >
> > I. 05/17 11:39:32. 0000000000 Using licenses from:
> > C:\flexlm\license.dat
> > I. 05/17 11:39:32. 0000000000 Failed to obtain
> > license(s) for IQ_CORE feature from license file(s) or
> > server(s). I. 05/17 11:39:32. 0000000000 Cannot find
> > license file. I. 05/17 11:39:32. 0000000000 The license
> > files (or license server system network addresses)
> > attempted are listed below. I. 05/17 11:39:32.
> > 0000000000 License feature name: IQ_CORE I. 05/17
> > 11:39:32. 0000000000 License filename:
> > C:\SybaseIQ\SYSAM-2_0\licenses ;C:\SybaseIQ\MyiqDemo I.
> > 05/17 11:39:32. 0000000000 License search path:
> > C:\SybaseIQ\SYSAM-2_0\licenses ;C:\SybaseIQ\MyiqDemo I.
> > 05/17 11:39:32. 0000000000 FLEXnet Licensing
> > error:-1,359. System Error: 2 "No such file or
> > directory" I. 05/17 11:39:32. 0000000000 For further
> > information, refer to the Sybase Software Asset
> > Management website at http://www.sybase.com/sysam I.
> > 05/17 11:39:32. 0000000000 License Checkout Failed for
> > IQ_CORE I. 05/17 11:39:32. 0000000000 Exception Thrown
> > from hos_sysam.cxx:881, Err# 0, tid 19 origtid 19
> > I. 05/17 11:39:32. 0000000000 O/S Err#: 0, ErrID: 549
> > (hos_sysamException); SQLCode: -1006269, SQLState:
> > 'QBC69' , Severity: 14
> > I. 05/17 11:39:32. 0000000000 [21161]: No SYSAM License
> > Available