Hi All, It would be great if the following issues can be fixed before we build the next APIM pack.
[1] - https://wso2.org/jira/browse/APIMANAGER-3042 [2] - https://wso2.org/jira/browse/APIMANAGER-2116 [3] - https://wso2.org/jira/browse/APIMANAGER-3022 [4] - https://wso2.org/jira/browse/APIMANAGER-3051 Regards, Evanthika On Wed, Oct 29, 2014 at 9:41 AM, Uvindra Dias Jayasinha <[email protected]> wrote: > We made this change to fix[1], we changed all the DB scripts so that they > would be consistent, but looks like now Oracle has an issue with this :( > > So we will revert it back on the other scripts to CURRENT_TIMESTAMP as > default(which was what existed previously) and only have a 0 as default for > the MySQL DB script since there is no way of maintaining consistency across > all scripts for this case anymore. > > > > [1] - https://wso2.org/jira/browse/APIMANAGER-2981 > > On 28 October 2014 16:23, Evanthika Amarasiri <[email protected]> wrote: > >> Hi Uvindra, >> >> The Oracle DB script of the latest API-M pack (27th Oct) fails due to the >> following of the AM_WORKFLOWS table. >> >> *WF_CREATED_TIME TIMESTAMP DEFAULT 0,* >> >> Since testing on the setup was blocked from this issue, we updated the >> script as below. >> >> *WF_CREATED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP* >> >> Jira reported at [1] >> >> [1] - https://wso2.org/jira/browse/APIMANAGER-3021 >> >> Regards, >> Evanthika >> >> On Wed, Oct 22, 2014 at 3:22 PM, Yasassri Ratnayake <[email protected]> >> wrote: >> >>> Thanks, We will be using the provided scripts for time being. >>> >>> On Wed, Oct 22, 2014 at 2:52 PM, Uvindra Dias Jayasinha < >>> [email protected]> wrote: >>> >>>> Ticket has been resolved and the updated scripts can be obtained from >>>> here till a new pack is issued, >>>> >>>> >>>> https://svn.wso2.org/repos/wso2/carbon/platform/branches/turing/products/apimgt/1.8.0/modules/distribution/resources/sql/ >>>> >>>> You can use these scripts instead of the ones in the 20 October pack >>>> to create databases for your testing >>>> >>>> On 22 October 2014 10:02, Uvindra Dias Jayasinha <[email protected]> >>>> wrote: >>>> >>>>> Yes you can use the scripts from the previous pack to continue but >>>>> refrain from testing any *work flow* related functionality until we >>>>> resolve this for the moment. >>>>> >>>>> We will change this so that it is backward compatible. >>>>> >>>>> On 22 October 2014 09:59, Yasassri Ratnayake <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi Uvindra, >>>>>> >>>>>> I'm using *mysql 5.5.40*. Till you fix this issue is it OK if we use >>>>>> the scripts from the 6th October pack since this issue is blocking us. >>>>>> >>>>>> With regards, >>>>>> >>>>>> On Wed, Oct 22, 2014 at 9:50 AM, Uvindra Dias Jayasinha < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> The change to the script was introduced via the resolution of this >>>>>>> ticket, >>>>>>> >>>>>>> https://wso2.org/jira/browse/APIMANAGER-2536 >>>>>>> >>>>>>> This issue is MySQL version dependent and does not occur on version >>>>>>> 5.6.5 and above. Most probably this was tested on a newer version of >>>>>>> MySQL >>>>>>> during development and therefore did not cause any issues. >>>>>>> >>>>>>> On 22 October 2014 09:41, Uvindra Dias Jayasinha <[email protected]> >>>>>>> wrote: >>>>>>> >>>>>>>> I am looking into this, the script has been changed recently >>>>>>>> >>>>>>>> On 22 October 2014 07:53, Yasassri Ratnayake <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hi All, >>>>>>>>> >>>>>>>>> There seems to be an Syntax error in the mysql DB scripts(apim >>>>>>>>> scripts), and due to this some of the tables do not get created. I >>>>>>>>> have >>>>>>>>> reported this at [1]. Since this is a blocking issue pls provide a fix >>>>>>>>> ASAP. >>>>>>>>> >>>>>>>>> When the server is started with -Dsetup parameter the server >>>>>>>>> doesn't even throw an error indicating that the DB scripts haven't >>>>>>>>> executed >>>>>>>>> properly. Isn't this another concern? >>>>>>>>> >>>>>>>>> [1] - https://wso2.org/jira/browse/APIMANAGER-2981 >>>>>>>>> -- >>>>>>>>> Yasassri Ratnayake >>>>>>>>> Software Engineer - QA >>>>>>>>> WSO2 Inc ; http://wso2.com >>>>>>>>> lean.enterprise.middleware >>>>>>>>> *Mobile : +94715933168 <%2B94715933168>* >>>>>>>>> *Blog : http://yasassriratnayake.blogspot.com/ >>>>>>>>> <http://yasassriratnayake.blogspot.com/>* >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Regards, >>>>>>>> Uvindra >>>>>>>> >>>>>>>> Mobile: 777733962 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards, >>>>>>> Uvindra >>>>>>> >>>>>>> Mobile: 777733962 >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Yasassri Ratnayake >>>>>> Software Engineer - QA >>>>>> WSO2 Inc ; http://wso2.com >>>>>> lean.enterprise.middleware >>>>>> *Mobile : +94715933168 <%2B94715933168>* >>>>>> *Blog : http://yasassriratnayake.blogspot.com/ >>>>>> <http://yasassriratnayake.blogspot.com/>* >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Uvindra >>>>> >>>>> Mobile: 777733962 >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> Uvindra >>>> >>>> Mobile: 777733962 >>>> >>> >>> >>> >>> -- >>> Yasassri Ratnayake >>> Software Engineer - QA >>> WSO2 Inc ; http://wso2.com >>> lean.enterprise.middleware >>> *Mobile : +94715933168 <%2B94715933168>* >>> *Blog : http://yasassriratnayake.blogspot.com/ >>> <http://yasassriratnayake.blogspot.com/>* >>> >> >> > > > -- > Regards, > Uvindra > > Mobile: 777733962 >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
