Hi Shavantha,

Isn't this a duplication of https://wso2.org/jira/browse/ANLYAPIM-50 ? As
specified there, this will be fixed in RC1.

On Sat, Jul 2, 2016 at 10:51 AM, Shavantha Weerasinghe <shavan...@wso2.com>
wrote:

> Hi All
>
> On starting the analytic server pointed to a separate User/Registry and
> Carbon DBs pointing to a mysql 5.7 on startup  Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default
> value for 'REG_CREATED_TIME' is thrown.
>
> When I grep for REG_CREATED_TIME  within the script, the mysql.sql db
> script seems to have
>
> mysql.sql:            REG_CREATED_TIME    TIMESTAMP NOT NULL DEFAULT 0,
> mysql.sql:            REG_CREATED_TIME    TIMESTAMP NOT NULL,
>
> regards,
> Shavantha Weerasinghe
> Senior Software Engineer QA
> WSO2, Inc.
> lean.enterprise.middleware.
> http://wso2.com
> http://wso2.org
> Tel : 94 11 214 5345
> Fax :94 11 2145300
>
>
> On Fri, Jul 1, 2016 at 9:21 PM, Harsha Kumara <hars...@wso2.com> wrote:
>
>> WSO2 API Manager 2.0.0 BETA2 Released!
>> <https://github.com/wso2/product-apim/releases/tag/v2.0.0-beta2>
>>
>> We are pleased to announce the BETA2 release of WSO2 API Manager 2.0.0.
>>
>> WSO2 API Manager is a complete solution for designing and publishing
>> APIs, securing and routing API traffic in a scalable way, whilst nurturing
>> a developer community around the API ecosystem.
>>
>> This release comes with both the runtime and analytics, providing
>> out-of-the-box support for API usage and performance analysis. You can
>> download these distributions below.
>>
>> Runtime - wso2am-2.0.0-BETA2.zip
>> <https://github.com/wso2/product-apim/releases/download/v2.0.0-beta2/wso2am-2.0.0-BETA2.zip>
>> Analytics - wso2analytics-apim-1.0.0-beta2.zip
>> <https://github.com/wso2/analytics-apim/releases/download/v2.0.0-beta2/wso2analytics-apim-2.0.0-beta2.zip>
>> P2-Repository - p2-repository
>> <https://svn.wso2.org/repos/wso2/scratch/2016/apim-2.0.0/p2-repos/beta2/p2-repo.zip>
>> Improvements and Bug Fixes - WSO2 API Manager - Version 2.0.0-Beta2Bug
>>
>>    - [APIMANAGER-4228 <https://wso2.org/jira/browse/APIMANAGER-4228>] -
>>    When using the publisher REST API is used, internal server error (code 
>> 500)
>>    occurs in following cases
>>    - [APIMANAGER-4963 <https://wso2.org/jira/browse/APIMANAGER-4963>] -
>>    It takes more than 7 minutes to start the APIM server with few errors
>>    - [APIMANAGER-5047 <https://wso2.org/jira/browse/APIMANAGER-5047>] -
>>    [Cluster setup] APIs are not visible in the Store side
>>    - [APIMANAGER-5048 <https://wso2.org/jira/browse/APIMANAGER-5048>] -
>>    Exceptions thrown when starting the server with -Dsetup by pointing API
>>    Manager database to Mysql 5.7
>>    - [APIMANAGER-5066 <https://wso2.org/jira/browse/APIMANAGER-5066>] -
>>    'There is already an object named 'APPLICATION_NAME_CONSTRAINT' in the
>>    database' error occurs when executing MSSQL script given for AM DB.
>>    - [APIMANAGER-5067 <https://wso2.org/jira/browse/APIMANAGER-5067>] -
>>    Read me and release notes files in APIM 2.0.0 pack aren't up to date
>>    - [APIMANAGER-5078 <https://wso2.org/jira/browse/APIMANAGER-5078>] -
>>    Statistics are not displayed in Publisher and Store dashboards when 
>> connect
>>    to an analytics cluster
>>    - [APIMANAGER-5081 <https://wso2.org/jira/browse/APIMANAGER-5081>] -
>>    go to overview option via add new API throws an exception
>>    - [APIMANAGER-5097 <https://wso2.org/jira/browse/APIMANAGER-5097>] -
>>    Application throttled out response body showing a 'No Content' when
>>    enabling analytics
>>    - [APIMANAGER-5105 <https://wso2.org/jira/browse/APIMANAGER-5105>] -
>>    Case Sensitive tags are displayed as same in capital letters
>>    - [APIMANAGER-5108 <https://wso2.org/jira/browse/APIMANAGER-5108>] -
>>    No statistics displayed for subscribers other than admin in Published APIs
>>    over time
>>    - [APIMANAGER-5109 <https://wso2.org/jira/browse/APIMANAGER-5109>] -
>>    Dropdown should rename as 'API subscribed by' in Publish APIs over time
>>    Statistics
>>    - [APIMANAGER-5110 <https://wso2.org/jira/browse/APIMANAGER-5110>] -
>>    Other tenant subscribers aren't displayed in 'API subscribed by' drop down
>>    in Published APIs Over Time Statistics
>>    - [APIMANAGER-5111 <https://wso2.org/jira/browse/APIMANAGER-5111>] -
>>    Cannot Delete subscriptions when API or provider name contains "-" from 
>> CXF
>>    Store REST API
>>    - [APIMANAGER-5116 <https://wso2.org/jira/browse/APIMANAGER-5116>] -
>>    No Statistics displayed for API Usage Across Usage Agent Statistics
>>    - [APIMANAGER-5117 <https://wso2.org/jira/browse/APIMANAGER-5117>] -
>>    [Tiers API]tierPlan returns null eventhough there is a tier plan set to a
>>    API tier
>>    - [APIMANAGER-5118 <https://wso2.org/jira/browse/APIMANAGER-5118>] -
>>    [Tiers API]Attributes are returned as blank eventhough there are set of
>>    attributes defined for an API level tier
>>    - [APIMANAGER-5120 <https://wso2.org/jira/browse/APIMANAGER-5120>] -
>>    Faulty invocations aren't listed in Faulty Invocations Statistics
>>    - [APIMANAGER-5122 <https://wso2.org/jira/browse/APIMANAGER-5122>] -
>>    No Statistics displayed in API Latency Statitsics according to the
>>    invocations
>>    - [APIMANAGER-5123 <https://wso2.org/jira/browse/APIMANAGER-5123>] -
>>    No Drop downs available in Developer Signups Over Time Statistics
>>    - [APIMANAGER-5135 <https://wso2.org/jira/browse/APIMANAGER-5135>] -
>>    FileNotFoundException for metrics and mb-store scripts when DB is MySQL 
>> 5.7
>>    and server started with -Dsetup
>>    - [APIMANAGER-5141 <https://wso2.org/jira/browse/APIMANAGER-5141>] -
>>    Client-side SDK for Java: Compilation failure with Java 8
>>
>> Improvement
>>
>>    - [APIMANAGER-5084 <https://wso2.org/jira/browse/APIMANAGER-5084>] -
>>    APIM 1.10 Publisher: forward slash in API version will break the platform
>>
>> New Feature
>>
>>    - [APIMANAGER-5112 <https://wso2.org/jira/browse/APIMANAGER-5112>] -
>>    New REST API for Admin-Dashboard Related functionality including new
>>    Throttling Implementation
>>
>> Improvements and Bug Fixes - Analytics-apim - Version 2.0.0-Beta2Bug
>>
>>    - [ANLYAPIM-51 <https://wso2.org/jira/browse/ANLYAPIM-51>] -
>>    Statistics became unavailable when switching between time picker in
>>    Application Errors in Log Analyzer
>>    - [ANLYAPIM-53 <https://wso2.org/jira/browse/ANLYAPIM-53>] -
>>    Navigation buttons not visible in Custom Time picker in Log Analyzer
>>    - [ANLYAPIM-55 <https://wso2.org/jira/browse/ANLYAPIM-55>] -
>>    Different Color code shows in Login Errors Bar chart compares to the 
>> legend
>>    in Log Analyzer
>>    - [ANLYAPIM-61 <https://wso2.org/jira/browse/ANLYAPIM-61>] -
>>    Cause:org.apache.axis2.AxisFault error is thrown when attempting to save
>>    MarkovStateClassifier
>>    - [ANLYAPIM-64 <https://wso2.org/jira/browse/ANLYAPIM-64>] - Login
>>    Errors Statistics unavailable for Last year in Log Analyzer
>>    - [ANLYAPIM-67 <https://wso2.org/jira/browse/ANLYAPIM-67>] -
>>    Exception in execution tasks
>>    - [ANLYAPIM-68 <https://wso2.org/jira/browse/ANLYAPIM-68>] - [Log
>>    Analyzer -UX] Rename yesterday label
>>    - [ANLYAPIM-71 <https://wso2.org/jira/browse/ANLYAPIM-71>] -
>>    Exception thrown for an Error while saving data to the table
>>    API_EXE_TME_DAY_SUMMARY
>>    - [ANLYAPIM-73 <https://wso2.org/jira/browse/ANLYAPIM-73>] -
>>    Execution manager templateconfigs format is incorrect
>>    - [ANLYAPIM-74 <https://wso2.org/jira/browse/ANLYAPIM-74>] - NPE was
>>    observed after 5 minutes of server start-up
>>    - [ANLYAPIM-80 <https://wso2.org/jira/browse/ANLYAPIM-80>] - when an
>>    api is invoked continuously the same alert are generated with different
>>    severity
>>
>> Improvement
>>
>>    - [ANLYAPIM-66 <https://wso2.org/jira/browse/ANLYAPIM-66>] -
>>    Restructure integration tests for new execution manager version
>>    - [ANLYAPIM-70 <https://wso2.org/jira/browse/ANLYAPIM-70>] - Spark
>>    UDF errors printing during integration tests
>>    - [ANLYAPIM-72 <https://wso2.org/jira/browse/ANLYAPIM-72>] - Remove
>>    db scripts
>>    - [ANLYAPIM-82 <https://wso2.org/jira/browse/ANLYAPIM-82>] - Change
>>    the request/response stream persistence frequency to a minute
>>
>> Known Issues
>>
>> Runtime - https://wso2.org/jira/issues/?filter=13005
>> Analytics - https://wso2.org/jira/issues/?filter=13094
>>
>> --
>> Harsha Kumara
>> Software Engineer, WSO2 Inc.
>> Mobile: +94775505618
>> Blog:harshcreationz.blogspot.com
>>
>> _______________________________________________
>> Architecture mailing list
>> architect...@wso2.org
>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
>>
>>
>


-- 

Thanks & regards,
Nirmal

Team Lead - WSO2 Machine Learner
Associate Technical Lead - Data Technologies Team, WSO2 Inc.
Mobile: +94715779733
Blog: http://nirmalfdo.blogspot.com/
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to